Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

Return Frequency

Avatar

Level 1

I ran a standard Return Frquency report.  Can someone explain in plain english why the Total is so much high than the individual line item?  I do not understand the explanation found here.

[img]Screen Shot 2015-08-05 at 3.01.55 PM.png[/img]

1 Accepted Solution

Avatar

Correct answer by
Employee

In the example screenshot below the totals by Referrer Type are referenced in the orange highlighted area. Then your noted Page Views Per Visit total discrepancy has to do with how the Ad Hoc Analysis inline totals are calculated for within the Return Frequency dimension total (red box highlighted area).

The area highlighted in red is where you are referencing and this is due to how Page Views is derived the overall total for the Referrer Type for all Visits, but the Visits count is only the sum of the Return Frequency Line items (area highlighted in blue). Therefore the inline Page Views per Visit count is inflated because the calculation is off (All Referrer Type Page Views DIVIDED BY Return Frequency Line Item Sum Visits).

If you want to get a true calculated total for return visits I would run a return visit segment against the base Referrer Type report. Or you could do the calculation manually by totaling the actual line items to derive a true return visit page views count (i.e.Return Frequency Line Item Sum Page Views).

Best,

Brian

[img]2015-08-05_15-50-36.png[/img]

View solution in original post

2 Replies

Avatar

Correct answer by
Employee

In the example screenshot below the totals by Referrer Type are referenced in the orange highlighted area. Then your noted Page Views Per Visit total discrepancy has to do with how the Ad Hoc Analysis inline totals are calculated for within the Return Frequency dimension total (red box highlighted area).

The area highlighted in red is where you are referencing and this is due to how Page Views is derived the overall total for the Referrer Type for all Visits, but the Visits count is only the sum of the Return Frequency Line items (area highlighted in blue). Therefore the inline Page Views per Visit count is inflated because the calculation is off (All Referrer Type Page Views DIVIDED BY Return Frequency Line Item Sum Visits).

If you want to get a true calculated total for return visits I would run a return visit segment against the base Referrer Type report. Or you could do the calculation manually by totaling the actual line items to derive a true return visit page views count (i.e.Return Frequency Line Item Sum Page Views).

Best,

Brian

[img]2015-08-05_15-50-36.png[/img]

Avatar

Level 3

For some reason the pageviews from the first visit of first time visitors are included in the total pageviews; hence the inflation of the pageviews per visit.

You can make a segment which excludes visits with visit nr = 1; that should do the trick.

 

I don't know what you want to do with the result but keep in mind that you are strictly talking about visits here. Not visitors. In one report the same visitor can be in all the return frequency periods and in all the referrer types as well. He can have a return frequency of longer than 1 month from the Search Engine but visit the site on a daily basis from a bookmark. Hope this helps.