Analytics Data Feed Documentation

[skatofiabah]

Hi,

Are there any resources that would show how to calculate in SQL basic web metrics or any metrics for that matter on the Analytics Data Feed Downstream Data? I have this Data Column Reference that sort of helps, but I know every row is every hit. I was wondering if there is anything out there for it to get it to align with what we have in the Adobe Workspace UI.

Thanks!

[fhusain · Accepted solution]

Hey @skatofiabah This should help - https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-blogs/sample-sql-queries-to-query-a...

You can also check this one too - https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/d...

[skatofiabah]

Hi @fhusain,

Thank you for the quick response. The first link I noticed is an older blog and the "2.  To count the number of visits" query to count visits I think is wrong. It needs to be a select distinct of the concat like it says here: https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/d...

[fhusain]

Hey @skatofiabah Yes, we need to use DISTINCT - SELECT count(distinct(concat(post_visid_high , post_visid_low , visit_num))) as visit