Expand my Community achievements bar.

Attention: Experience League Community will undergo scheduled maintenance on Tuesday, August 20th between 10-11 PM PDT. During this time, the Community and its content will not be accessible. We apologize for any inconvenience this may cause.
SOLVED

detail in report does not match total

Avatar

Level 1

I am trying to run reports out of Adobe Analytics and I currently have an issue where the detail shown on the report does not match the total, I have attached a screen shot of an example from a Time Spent per Visit  report where the number of unique visitors in the Total is 68,557 yet the detail only adds up to 30,235.  If someone could point me in the direction of someone who can assist with this that would be greatly appreciated.

Tyler Fish - tyler.fish@hickoryfarms.com

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi Tyler,

The bolded report total should match the overall report suite site totals (you can verify on your side by checking against the base Unique Visitors reports in the same report suite). The individual line items do not add up to the bolded sum in this case as the Time Spent Per Visit report only reports on those visits and visitors for which it can calculate a value.

Reference Link: https://marketing.adobe.com/resources/help/en_US/reference/reports_time_spent_per_visit.html

General Properties of the Report

  • This report is automatically populated based on the timestamp of the first and last image request of a visit.
  • This report requires at least two image requests per visit in order to populate data. Visits with a single image request are not included in this report. Meaning, this report will not match the visits report for the same time period.
  • Only nine line items can be displayed in this report:
    • Less than 1 minute
    • 1-5 minutes
    • 5-10 minutes
    • 10-30 minutes
    • 30-60 minutes
    • 1-2 hours
    • 2-5 hours
    • 5-10 hours
    • 10-15 hours
    • There cannot be buckets higher than this, because a visit expires after 12 hours of activity.
  • The following metrics can be used in this report (depending on organization and report suite settings):
    • Visits (Report Specific)
    • All standard eCommerce metrics: Revenue, Orders, Units, Carts, Cart Views, Checkouts, Cart Additions, Cart Removals.
    • All custom events: Events 1-80, and Events 81-100 if on H22 code or higher
  • This report can be viewed in trended and ranked formats.

Best,

Brian

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

Hi Tyler,

The bolded report total should match the overall report suite site totals (you can verify on your side by checking against the base Unique Visitors reports in the same report suite). The individual line items do not add up to the bolded sum in this case as the Time Spent Per Visit report only reports on those visits and visitors for which it can calculate a value.

Reference Link: https://marketing.adobe.com/resources/help/en_US/reference/reports_time_spent_per_visit.html

General Properties of the Report

  • This report is automatically populated based on the timestamp of the first and last image request of a visit.
  • This report requires at least two image requests per visit in order to populate data. Visits with a single image request are not included in this report. Meaning, this report will not match the visits report for the same time period.
  • Only nine line items can be displayed in this report:
    • Less than 1 minute
    • 1-5 minutes
    • 5-10 minutes
    • 10-30 minutes
    • 30-60 minutes
    • 1-2 hours
    • 2-5 hours
    • 5-10 hours
    • 10-15 hours
    • There cannot be buckets higher than this, because a visit expires after 12 hours of activity.
  • The following metrics can be used in this report (depending on organization and report suite settings):
    • Visits (Report Specific)
    • All standard eCommerce metrics: Revenue, Orders, Units, Carts, Cart Views, Checkouts, Cart Additions, Cart Removals.
    • All custom events: Events 1-80, and Events 81-100 if on H22 code or higher
  • This report can be viewed in trended and ranked formats.

Best,

Brian