Analytics Data Feed Documentation | Community
Skip to main content
skatofiabah
skatofiabah
Level 5
Aug 21, 2024 1:51 PM UTC
Solved

Analytics Data Feed Documentation

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

FarazHusain
FarazHusainAccepted solution
Employee
Aug 21, 2024 4:09 PM UTC

Hey @skatofiabah This should help - https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-blogs/sample-sql-queries-to-query-adobe-analytics-data-feeds/ba-p/588992

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

 

 

Translate
skatofiabah
skatofiabahAuthor
Level 5
Aug 29, 2024 3:50 PM UTC

Hi @farazhusain,

 

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/datafeeds-calculate

Translate
FarazHusain
FarazHusain
Employee
Aug 29, 2024 3:57 PM UTC

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

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...