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)...

Hi @Damonwhall, Yes we do something similar. I just don't understand how we can have a CID exist in adobe for our known Google Search Campaigns for visits, etc.; Yet, there is no GCLID in the URL.

Hi @Damonwhall, Not all of our Raw URLs landing and continuing contain the GCLID in the raw url. We don't store it in an eVar. We have cases where our CID is in the raw url but not the GCLID. It doesn't always have the GCLID and this would probably lead to aggregation issues. Curious as to your thou...

Hi @Damonwhall, We already have the processing rules set up for the CID for the Google Search. How could visits be higher in Adobe than clicks in Google Ads?