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:
![abehjat_2-1646946845492.png abehjat_2-1646946845492.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39143i5EB0F07CC0323663/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Data collected via SQL:
![abehjat_1-1646946727346.png abehjat_1-1646946727346.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39142i493A9E6827049082/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Are there specific filters or amendments I need to make to the SQL code to get a near, one-to-one number?