Replicating Ad-hoc Analysis Reports through Raw Data feed Columns | Community
Skip to main content
kaustubht340763
March 6, 2019
Solved

Replicating Ad-hoc Analysis Reports through Raw Data feed Columns

  • March 6, 2019
  • 1 reply
  • 1800 views

How can we replicate dimension Entry Page Visits using Raw Data Feeds? I used column 'visits_start_pagname', but then also the entry visits do not sum up to what we see in the adobe analytics reporting interface.Adobe Analytics Analytics - Questions

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 BrianTophamAdobe

Starting with visit_start_pagename should be the right place to start. I believe you'll need to take into account, exclude_hit, page_event, and possible another column or two. I am not sure I remember ever doing this specific comparison; I think I would have to have an example of a days worth of data for a report suite and run some test to see exactly what is needed to get the query to pull Entires from raw data.

1 reply

BrianTophamAdobe
Adobe Employee
BrianTophamAdobeAdobe EmployeeAccepted solution
Adobe Employee
March 8, 2019

Starting with visit_start_pagename should be the right place to start. I believe you'll need to take into account, exclude_hit, page_event, and possible another column or two. I am not sure I remember ever doing this specific comparison; I think I would have to have an example of a days worth of data for a report suite and run some test to see exactly what is needed to get the query to pull Entires from raw data.

Level 2
April 15, 2021
Was this ever figured out? I am trying to recreate the Previous Page report with the raw data, but `visit_page_num` isn't enough to label the same number of hits as Reports does. The raw data is coming back less than the Previous Page report, and I'm not sure what else to use to include the missing hits.