Follow @trevorwithdata When I was a kid, my favorite TV gameshow was “The Price Is Right” – it’s flashy, fun, and to this day I still love watching it – that is except for one thing: the ads. I still find it obnoxious to be bombarded by annoying (and sometimes gross) TV ads about hemorrhoid […]
Month: May 2017
Using Adobe Analytics Data Feeds and SQL for Basic Reporting
Three DB SQL’s walk into a NOSQL bar. A little while later… they all walked out, because they couldn’t find a TABLE… Joking aside, online marketers frequently use analytics tools like Adobe Analytics, but find that the granularity and accessibility of the data in the tool doesn’t meet their needs. A few examples: Loading Adobe Analytics […]
Parsing Products and Events in ClickStream Data Feeds
A lot of companies that I’ve worked with are initially confused when processing Adobe Analytics Data Feeds. The data comes out of Adobe Analytics in TSV format and you’d naturally expect that the data is ‘flat’ (meaning just rows and columns). Unfortunately, this isn’t the case. Columns like ‘post_product_list’ and ‘event_list’ are lists of data that […]