Pageview Count Downstream - Align with Adobe Analytics Workspace

Question

Hi All,

I am trying to align pageviews for a given URL for July 2024 in our org. Here is the SQL query I have in the downstream environment attached below. I'm wondering why I am coming up 3K pageviews short compared to what we have in adobe workspace for the same URL and time frame. I apply the filters and recommendations for metrics and dimensions based on the URLs I have listed below too along with the screenshot. Can anybody assist with this and see whether I'm over-filtering or under-filtering or missing a step.

Thanks!

https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-reference

https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-page-event

https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-calculate

https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-blogs/sample-sql-queries-to-query-adobe-analytics-data-feeds/ba-p/588992

FarazHusain · Answer

Hey @skatofiabah, In Adobe Workspace, we don't have any out-of-the-box dimension that shows the page URLs. Hence, I'm assuming you must be using an eVar or Prop to check the same in the workspace.

If that is the case, can you try checking the same in your downstream data and check if it returns the same numbers?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded