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!
Solved! Go to Solution.
Views
Replies
Total Likes
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...
Views
Replies
Total Likes
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...
Views
Replies
Total Likes
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...
Views
Replies
Total Likes
Hey @skatofiabah Yes, we need to use DISTINCT - SELECT count(distinct(concat(post_visid_high , post_visid_low , visit_num))) as visit
Views
Likes
Replies
Views
Likes
Replies