Hi everyone, I tried to look up in Adobe documentation but didn't find the answer that I need.
We consume the Adobe daily hit_data data feed file and calculated the Visit and Visitor as below.
However, we got NULL for some rows in post_visid_high , post_visid_low, VISIT_PAGE_NUM and VISIT_NUM that it never happened before, I wonder if it is expected or that was issue with the data feed?
reference link : https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/d...
Visits
- Concatenate post_visid_high, post_visid_low, visit_num, and visit_start_time_gmt.
- Count the unique number of values.
Visitors
All methods Adobe uses to identify unique visitors (custom visitor ID, Experience Cloud ID service, etc.) are all ultimately calculated as a value in post_visid_high and post_visid_low. The concatenation of these two columns can be used as the standard of identifying unique visitors regardless of how they were identified as a unique visitor. If you would like to understand which method Adobe used to identify a unique visitor, use the column post_visid_type.
- Concatenate post_visid_high and post_visid_low.
- Count the unique number of values.