Analytics Data Feed Documentation | Community
Skip to main content
skatofiabah
skatofiabah
Level 5
August 21, 2024
Solved

Analytics Data Feed Documentation

  • August 21, 2024
  • 1 reply
  • 875 views

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.

1 reply

FarazHusain
Adobe Employee
FarazHusainAdobe EmployeeAccepted solution
Adobe Employee
August 21, 2024

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

 

 

skatofiabah
skatofiabahAuthor
Level 5
August 29, 2024

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

FarazHusain
Adobe Employee
FarazHusainAdobe Employee
Adobe Employee
August 29, 2024

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

    Terms & ConditionsAccessibility statement

    Loading footer...