Reporting Interface vs Data feeds - Visits metrics | Community
Skip to main content
Q
quickenloansinc
November 4, 2020
Solved

Reporting Interface vs Data feeds - Visits metrics

  • November 4, 2020
  • 1 reply
  • 821 views

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?

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

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))

1 reply

T
tubabdarAccepted solution
November 4, 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))

    Terms & ConditionsAccessibility statement

    Loading footer...