Replicating Visitor number in Adobe Workspace with SQL for data coming through Data Feed

[abehjat]

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?

[LoveeshK]

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:

• Concatenate post_visid_high and post_visid_low.
• Count the unique number of values.