Hi @MandyGeorge, I see. So essentially you are saying to filter on those props and evars without aggregating (dates, sums, etc.)? I'm assuming that the query would take a long time or break on the non-aggregated piece since bringing in every hit value/row of data. Then you are saying to aggregate af...

Hi @Jennifer_Dungan, My variance is around 0.5% and I mentioned that earlier in the thread when I do the report suite (without VRS). It's just odd that just adding 2 post_ values throws it all off and that they surge in the fall and onward.

Hi @Jennifer_Dungan, My query screenshots include those filters to count pageviews to try to match to workspace.https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-calculate

Hi @MandyGeorge, I do have those filters for the Post prop and evar in my query above. I also include that concatenated visits and UV string that this recommends downstream: https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-calculate.

Hi @MandyGeorge,Of course. Here is the VRS along with the segments. Both segments are hit level.     

Hi @MandyGeorge, Thanks for this! We saw our UVs and Visits Variance go from average 0.5% from Jan to August, to higher than 2-3% variance Sept and onward. I added this in for our VRS. The VRS just has Prop24 not equal to and eVar75 equal to filters. Any thoughts? Why it would have such a drastic ch...

Hi @MandyGeorge, Yes, so I think my SQL commented out code if I included that would be the mimicking the VRS I think. I commented it out to just compare to the regular report suite and I'm still getting these discrepancies. Also, what bots or IP filters would I need to exclude? My numbers downstream...

Hi, I'm trying to tie out UVs, Visits, and Page Views from Adobe Workspace to Downstream Databricks from the adobe daily web traffic table. Here is my code. I don't know why it's not lining up and I cannot seem to find a good answer. I used the documentation to have certain filters. My page views by...

Hi @juliusonyancha, Assuming this is a calculated metric you made and not adobe out of box? Also, I think it include time stamps where there could be a single page visit because it could include link calls that keep a user on the same page. Plus, this above calculation is time/visit, whereas I need ...

Hi, We are trying to ensure accuracy in our Time Spent/Page Metric. We want to exclude Page Views of a page for single page visits (in other words, only include page views in the denominator that aren't a single page visit. We currently don't have that segment for the numerator (total seconds spent)...