<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/self-service-adobe-analytics-data-feeds/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://randyzwitch.com/adobe-clickstream-data-feed-self-service-admin-panel/"> randyzwitch.com</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<p>I’ve written several posts about the Adobe Analytics Analytics (née Clickstream) Data Feed (links: <a target="_blank" rel="nofollow" href="http://randyzwitch.com/adobe-analytics-clickstream-raw-data-feed/">1</a>,<a target="_blank" rel="nofollow" href="http://randyzwitch.com/adobe-analytics-clickstream-data-feed-relational-database/">2</a>,<a target="_blank" rel="nofollow" href="http://randyzwitch.com/adobe-analytics-clickstream-data-feed-calculations/">3</a>) over the past several years. The <a target="_blank" rel="nofollow" href="https://marketing.adobe.com/resources/help/en_US/reference/analytics-data-feed.html">Analytics Data Feed</a> is an invaluable tool for moving beyond aggregate-level reporting information about your customers to really in-depth, customer-level analytics.</p>
<p>While the Analytics Data Feed is nowhere as easy to use as the Adobe UI, Report Builder, Analytics Workspace or even <a target="_blank" rel="nofollow" href="http://randyzwitch.com/rsitecatalyst">RSiteCatalyst</a>, the hardest part for me when I was a digital analytics consultant was just obtaining the files in the first place (to say nothing of restarting a failed feed)! Luckily, Adobe has now built an interface accessible by any Adobe Analytics admin, removing the need for ClientCare to set up and maintain feeds.</p>
<p>In this post, I will briefly highlight how to set up an Analytics Data Feed from inside Adobe Analytics and give my impressions of the tool (as it exists at the time of writing). Note this post is not meant to be a substitute to the official documentation; Adobe provides detailed information about the entire process <a target="_blank" rel="nofollow" href="https://marketing.adobe.com/resources/help/en_US/reference/analytics-data-feed.html">in their Help section</a>.</p>
<h2>Landing the Files via FTP/SFTP/S3</h2>
<p>After clicking ‘Admin -> Data Feeds’ in the Adobe Analytics Admin menu/panel, you should see an interface similar to the following:<br>
<img alt="landing page" src="https://i2.wp.com/randyzwitch.com/assets/img/adobe-analytics-data-feed-landing-page.png?w=456" data-recalc-dims="1"></p>
<p>After clicking the “(+) Add” button, you will be brought to a page with three parts: Feed Information, Delivery Location and Data Column Definitions. The top half of the page looks as follows:<br>
<img alt="feed info" src="https://i0.wp.com/randyzwitch.com/assets/img/adobe-analytics-data-feed-ftp.png?w=456" data-recalc-dims="1"></p>
<p>I find these two panels fairly self-explanatory. On the left, you give your data feed a name, choose the report suite(s) you want the data feed for, pick the delivery granularity, then choose the start/end date or choose ‘continuous’ for indefinite future delivery. On the right side, you provide your server information, FTP/SFTP or Amazon S3.</p>
<p>There are several things I love about this setup:</p>
<ul>
<li>
<p>Delivery via SFTP and S3: For the longest time, FTP was the only choice, which disappointed security-minded folks who wanted SFTP. With S3 delivery, you can house your data files and read them into Hadoop directly (assuming you use AWS); this means you don’t necessarily have to do anything with the data until you need it, then you can fire up an EMR job to get your data. Dump the cluster when you’re done. Nice.</p>
</li>
<li>
<p>Multiple Report Suites, same window: I’m so happy to see that this interface supports choosing multiple report suites within the same “feed”. This makes it so much easier than having to create a separate feed instance, when in many cases the settings will stay the same (other than report suite of course).</p>
</li>
</ul>
<p>What I don’t love:</p>
<ul>
<li>Not saving FTP information: When you do choose to create separate feeds, there doesn’t appear to be a way to use the same credentials without typing them in yourself. Not a huge deal if your password is “Mom”, a little more annoying if you auto-generate a password that looks like “aHR0cDovL3JhbmR5endpdGNoLmNvbQ==”</li>
</ul>
<h2>Data Column Definitions</h2>
<p>After choosing the report suites and providing the delivery details, the remaining step is to decide which data fields you want as part of the data feed. Luckily, there are templates that can be chosen, so that the user doesn’t have to remember every single field and the order that they need.</p>
<p><img alt="column structure" src="https://i0.wp.com/randyzwitch.com/assets/img/adobe-analytics-data-feed-definition.png?w=456" data-recalc-dims="1"></p>
<p>My favored practice when working with the data feeds is to have every feed have the same structure, even if certain report suites don’t have nearly the same amount of eVars and props implemented. I’m of the mind that taking all the fields, then letting the ETL process handle what to do with the data is much less error-prone. You can always re-run an ETL process if you forgot something; if you forget a column in your data feed, you need to re-process all of the feeds.</p>
<p>Empty columns are also much less wasteful in the age of distributed computing (such as Hadoop), as <a target="_blank" rel="nofollow" href="http://blog.cloudera.com/blog/2013/03/introducing-parquet-columnar-storage-for-apache-hadoop/">columnar data formats</a>/databases remove much of the performance penalty of empty columns. Using dictionary encoding and columnar data structures, you can represent an entire column of missing values as {NA: </p>
<h2>Save and Repeat</h2>
<p>Once you have your data feed defined, you save your work and that’s it! I’m not sure what SLA might be in place, but it seems like there’s roughly a 48-hour delay between submitting a new feed and having the data start to process. Once the processing starts, your notification inbox will quickly look like this:</p>
<p><img alt="emails" src="https://i2.wp.com/randyzwitch.com/assets/img/adobe-analytics-data-feed-email-notification.png?w=456" data-recalc-dims="1"></p>
<h2>Automated Monitoring with RSiteCatalyst</h2>
<p>If you want to have more control around monitoring than just staring at your inbox, you can use RSiteCatalyst to get the processing status of your feed:</p>
<figure>
<pre><code data-lang="r"><table><tbody><tr><td><pre>1
2
3
4
5
6
7
8
9
10</pre>
</td>
<td>
<pre><span>library</span><span>(</span><span>RSiteCatalyst</span><span>)</span><span>
</span><span>#Authentication (assumes credentials saved in .Renviron)
</span><span>SCAuth</span><span>(</span><span>Sys.getenv</span><span>(</span><span>&quot;USER&quot;</span><span>,</span><span> </span><span>&quot;&quot;</span><span>),</span><span> </span><span>Sys.getenv</span><span>(</span><span>&quot;SECRET&quot;</span><span>,</span><span> </span><span>&quot;&quot;</span><span>))</span><span>
</span><span>#Get full list of report suites
</span><span>rs</span><span> </span><span>&lt;-</span><span> </span><span>GetReportSuites</span><span>()</span><span>
</span><span>#Pass in all non-virtual report suites
</span><span>feedstatus</span><span> </span><span>&lt;-</span><span> </span><span>GetFeeds</span><span>(</span><span>rs</span><span>[</span><span>is.na</span><span>(</span><span>rs</span><span>$</span><span>virtual</span><span>),</span><span> </span><span>]</span><span>$</span><span>rsid</span><span>)</span><span>
</span></pre>
</td>
</tr>
</tbody>
</table>
<p>
<p><code>GetFeeds</code> will return a dataframe that returns the feed information, as well as the processing status:<br>
<img alt="processing status" src="https://i2.wp.com/randyzwitch.com/assets/img/adobe-analytics-data-feed-rsitecatalyst.png?w=456" data-recalc-dims="1"></p>
<p>It’s not hard to imagine what a cronjob would look like, polling the Adobe API every few minutes to see which feeds are complete, then kicking off an ETL process.</p>
<h2>Data, Liberated!</h2>
<p>This blog post has been relatively light on code and analysis, but I hope I’ve highlighted that the barriers to obtaining the most granular data Adobe can provide have been completely removed. With the new Analytics Data Feed interface, the possibility of bespoke customer analytics is only a few button clicks and an FTP away.</p>

<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://randyzwitch.com/adobe-clickstream-data-feed-self-service-admin-panel/"> randyzwitch.com</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a title="The R Project for Statistical Computing" rel="nofollow" href="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/search/data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/search/map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/search/animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/search/sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/search/SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/search/git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/search/hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/search/PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/search/time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/search/trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/3j429Dz9ym4"></a></div></code></pre></figure>