Getting started with Adobe Analytics and Alteryx

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. Alteryx workflows and Tableau visualizations are powerful tools to have in the kitchen for more complex data assembly and mouth-watering presentation. This post is about giving you the best of both worlds…or at least getting you started. Adobe Analytics provides leading-edge reporting and segmentation tools coupled with the ability to consolidate almost everything under one (Adobe) roof. But if you haven’t built this roof yet or if you need to blend Web data into an internal report or predictive model, the Alteryx Connector to Adobe Analytics (a macro created by Taylor Cox) is a powerful way to pull data from the Adobe API to an existing workflow and Tableau dashboard. Step 1 is simply to download the right connector…it’s the macro by Taylor Cox that looks like this:   In my haste and excitement I ignored the very clear instructions to read the README file first.  This was big mistake.  I know you’re already excited so let me give you a preview of the steps you need to follow to get the Adobe Analytics Connector up and running in no time:   Make sure your Adobe User has Web Services privileges enabled   Find the Username and Shared Secret on your User’s Adobe profile   Download and unzip the Adobe Analytics Connector (Open in...

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.

read more...

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.

read more...

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.

read more...