Expand my Community achievements bar.

SOLVED

Analytics Data Feed Documentation

Avatar

Level 5

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!

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor
3 Replies

Avatar

Correct answer by
Employee Advisor

Avatar

Level 5

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/d...

Avatar

Employee Advisor

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