Solved
unique visitor count from data feeds dont match the dashboard
Hi,
i have about 2 years of hit data from adobe, I am trying to match the daily unique visitor count from the hit data with the dashboard. my problem is that some days for the unique visitors count match and others dont, why is this? for example some days they would both be 300,003 unique visitors and other days the hit data would show 300,000 and the dash board would show 300,003.
below is my query to get daily unique visitor count from the hit data:
AS WITH InitialAggregation AS (
SELECT
date_time AS date,
CONCAT(post_visid_high, post_visid_low) AS unique_visitor_id,
FROM
[dbo].[Extracted_Adobe_Data_Test]
WHERE
exclude_hit = 0
AND hit_source NOT IN (5, 7, 8, 9)
GROUP BY
date_time,
CONCAT(post_visid_high, post_visid_low)
)
SELECT
date,
COUNT(unique_visitor_id) AS unique_visitors,
FROM
InitialAggregation
GROUP BY
date;