Adobe Analytics

skatofiabah · 9/20/24

Hi All,

I referred to these articles about trying to calculate visits downstream and align it with workspace:

https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-blogs/sample-sql-queries-to-query-a...

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

Here is my query below. I'm falling short about ~10,000 visits in downstream compared to workspace. I'm trying to figure out why. I'm using the appropriate filters I think based on the articles.

Thanks!

MandyGeorge · 9/20/24

Is the visit count less with the data feeds than what it is in workspace? I would do a few initial validations - did the files load correctly in your data lake? If you're doing hourly files, make sure that none of the hours are missing (query the table and do a count * against hour to make sure no hour is missing).

Are you doing any transformations on the table? Filtering out bots or other traffic you don't want to report on? If so, double check those and see if that is causing the mismatch.

Another thing to check is if you're using a VRS in workspace. If so, then you need to replicate the logic of any segments in your data feed too.

You have a couple of your where conditions blocked out, I'm assuming due to them having info you can't expose publicly. Check those conditions and make sure that whatever they are is applied to your data in workspace too.