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

  • March 10, 2022
  • 1 reply
  • 601 views

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.