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
BedrockMission!

Learn More

View all

Sign in to view all badges

Reporting Interface vs Data feeds - Visits metrics

Avatar

Avatar
Level 1
quickenloansinc
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
quickenloansinc
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
quickenloansinc
Level 1

04-11-2020

Hello We are noticing inconsistencies when comparing the visits metrics on day level in the reporting interface and visit metrics calculated from data feeds for that day.

 

Day: 2020-11-01

Reporting Interface: 617615 

Data Feeds:  616346 ( for exclude hits = 0)  

 

For data feeds, We used the below query

 

select count(*) from (select distinct post_visid_high,post_visid_low,visit_num,visit_start_time_gmt from adobe_data_feed where datekey='2020-11-01') a

 

How can we match these numbers?

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 1
Level 1
user95087
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
user95087
Level 1

Like

1 like

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
user95087
Level 1

04-11-2020

Hi, this is the code we used and it gave us correct numbers. I see you are missing the exclusion of hit_source 5,7,8&9.

SELECT count(distinct concat(post_vis_id_high,
post_vis_id_low,
CAST(visit_num AS VARCHAR),
CAST(visit_start_time_gmt AS VARCHAR)))Visits, batch_date FROM "adobe_data_feed"
WHERE exclude_hit = 0
AND hit_source NOT IN (5,7,8,9))