Publications by randyzwitch.com
Adobe: Give Credit. You DID NOT Write RSiteCatalyst.
EDIT 5/10/2016 1:30pm: Several folks from Adobe Analytics/Adobe Marketing Cloud have contacted me, and everything is resolved. I can’t untweet other people’s retweets/shares or delete comments on LinkedIn, but if everyone could stop sharing any more that would be great. ? As an author of several open-source software projects, I’ve taken fo...
4184 sym 6 img
Adobe Analytics Clickstream Data Feed: Calculations and Outlier Analysis
In a previous post, I outlined how to load daily Adobe Analytics Clickstream data feeds into a PostgreSQL database. While this isn’t a long-term scalable solution for large e-commerce companies doing millions of page views per day, for exploratory analysis a relational database structure can work well until a more robust solution is put into pl...
3551 sym R (3562 sym/2 pcs)
Bulk Downloading Adobe Analytics Data
This blog post also serves as release notes for RSiteCatalyst v1.4.9, as only one feature was added (batch report request and download). But it’s a feature big enough for its own post! Recently, I was asked how I would approach replicating the market basket analysis blog post I wrote for 33 Sticks, but using a lot more data. Like, months and mo...
3641 sym R (1207 sym/2 pcs)
RSiteCatalyst Version 1.4.10 Release Notes
Version 1.4.10 of RSiteCatalyst brings a handful of new Get* methods, QueueDatawarehouse and a couple of bugs fixes/low-level code improvements. QueueDatawarehouse The most useful user-facing change IMO is the addition of the QueueDatawarehouse method, which allows for submitting (and sometimes retrieving) Data Warehouse requests via R. This shou...
3358 sym R (885 sym/1 pcs)
Self-Service Adobe Analytics Data Feeds!
I’ve written several posts about the Adobe Analytics Analytics (née Clickstream) Data Feed (links: 1,2,3) over the past several years. The Analytics Data Feed is an invaluable tool for moving beyond aggregate-level reporting information about your customers to really in-depth, customer-level analytics. While the Analytics Data Feed is nowhere ...
5608 sym R (288 sym/1 pcs) 10 img
RSiteCatalyst Version 1.4.12 (and 1.4.11) Release Notes
I released version 1.4.12 of RSiteCatalyst before I wrote the release notes for version 1.4.11, so this blog post will treat both releases as one. Users should upgrade directly to version 1.4.12 as the releases are cumulative in nature. Get* method additions Two Get* methods were added in this release: GetClickMapReporting and GetPreviousServerCa...
2232 sym
RSiteCatalyst Version 1.4.13 Release Notes
This blog post will be fairly short, given the minor nature of the update. Several users complained about OAUTH2 authentication not working, which I didn’t know because I usually use the legacy authentication method! Luckily, GitHub user leocwlau reported the issue AND provided the solution. No other bug fixes were made, nor was any additional ...
1697 sym
RSiteCatalyst Version 1.4.14 Release Notes
Like the last several updates, this blog post will be fairly short, given only a single bug fix was added. Thanks again to GitHub user leocwlau who reported that the GetReportSuiteGroups function added an additional field AND provided the solution. No other bug fixes were made, nor was any additional functionality added. Version 1.4.14 of RSiteCa...
1526 sym
Using RSiteCatalyst With Microsoft PowerBI Desktop
With pretty regular frequency I get emails asking if RSiteCatalyst can be used with Microsoft Power BI. While admittedly I’m not a frequent user of the Windows operating system (nor dashboarding tools like Tableau or Power BI), I am pleased to report that it is fact possible to call the Adobe Analytics API with Power BI via RSiteCatalyst! Step ...
3146 sym 8 img
Creating a MapD ODBC Connection in RStudio Server
In my post Installing MapD on Microsoft Azure, I showed how to install MapD Community Edition on Microsoft Azure, using Ubuntu 16.04 LTS as the base image. One thing I glossed over during the firewall/security section was that I opened ports for Jupyter Notebook and other data science tools, but I didn’t actually show how to install any of thos...
4152 sym R (1106 sym/7 pcs) 4 img