Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 1

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

 

 

Data collected via SQL:

abehjat_1-1646946727346.png

 

Are there specific filters or amendments I need to make to the SQL code to get a near, one-to-one number?

 

1 Reply

Avatar

Level 2

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.