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.
Thanks for the reply, @David-123! That's a good catch, since it is
usually best practice to exclude the full list. Hit Source 7 is
"transactionid/customerid data source file". Changing that made no
difference in my results. I am capturing all of the page views for the
target page according to Reports, but my logic labeling "Entered Site"
seems to be incomplete.
I am trying to recreate the Previous Page report using raw data. My
calculations are coming back less than what is shown in Reports. For
example, I am defining "Entered Site" as where the post_pagename is the
target page, and visit_page_num = 1. This leaves me 8 fewer than
expected over my 5 day period. I am capturing all of the Page Views, but
less are being assigned "Entered Site" than what I see in Reports. My
best guess is I am missing site entries that happen in the middle of a
visit, such ...