


Hello!
I'm trying to replicate the data from Adobe Workspace based on the data we're ingesting from data feed.
Below is the code I've built:
SELECT days, COUNT(DISTINCT visitor_id) FROM table WHERE cid = 'campaign_code_example' GROUP BY days ORDER BY days ASC
However, despite this, the numbers are different (at least 8% diff) as seen in the images below:
Adobe Workspace data:
Data collected via SQL:
Are there specific filters or amendments I need to make to the SQL code to get a near, one-to-one number?
Views
Replies
Sign in to like this content
Total Likes
Hi @abehjat
You can create a calculated metric within data feed file using post_visid_low and post_visid_high to count the total unique visitors in the following way:
Views
Replies
Sign in to like this content
Total Likes