Sometimes you need your Web data raw and ready to stew. Adobe Data Warehouse is great for that. But sometimes you need to toss other ingredients into this stew and feed the troops at every meal. And at other times your job is to break out the silver and create a work of culinary art. […]
Category Archives: Programmatic Analysis
Remove Adobe Analytics Downloaded Report Comment Header Using Python
This simple Python script allows you to input the path to a downloaded Adobe Analytics report and it returns a cleaned up CSV file that has stripped out the large comment header, leaving you with just the column headers and the corresponding data.
Adding a Sexy UI to RSiteCatalyst using Shiny
Before we begin, it is important to mention that we have long been strong supporters of the work that Randy Zwitch, Willem Paling & Jowanza Joseph have done to create and maintain the extremely powerful Adobe Analytics R Package, RSiteCatalyst. Their dedication to this open-source effort often goes unrecognized which, as the idea of using programmatic analysis for digital analytics data becomes a more accepted practice, we hope will change.
Market Basket Analysis With Adobe Analytics And RSiteCatalyst
Any merchandiser can tell you their top-selling product. If you ask what the top product combination is sold on their website, they might actually know (there’s a lot of sharp people out there!), but you’re also likely hear a guess like “multiple variations of top-selling product.” Obvious, but not very insightful.
Python for Business: Identifying Duplicate Data
Data Preparation is one of those critical tasks that most digital analysts take for granted as many of the analytics platforms we use take care of this task for us or at least we like to believe they do so. With that said, Data Preparation should be a task that every good analyst completes as part of any data investigation.