Skip to main content
abehjat
Level 2
March 10, 2022
Question

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

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?

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Adobe Employee
March 12, 2022

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.
Translate