Extracting data from Adobe Analytics using Report Builder | Community
Skip to main content
E
ElinaMirin
Level 2
May 23, 2023
Solved

Extracting data from Adobe Analytics using Report Builder

  • May 23, 2023
  • 1 reply
  • 1058 views

Hello! I am using Report Builder to extract data from Adobe Analytics and when I validate the numbers, I can see some difference in counts for Visits and Unique Visitors. For Page Views metric the count is the same in Report Builder as in Adobe Analytics. 

I have 3 dimensions: month, marketing channel and url. When I’m extracting the totals (only with month dimension) I get aprox the same numbers. But when I add more dimensions/breakdowns, the counts for Visits and Unique Visitor are higher in Report Builder than in Adobe Analytics Workspace.  

 

Are there duplicates when applying more dimensions or what?

Any advices on how can I get the same numbers in Report Builder as in Adobe Analytics? 

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 Josh Stephens

Are your Report Builder visit and unique visitor counts higher than what you're seeing in Workspace?

 

I haven't worked with Report Builder much, but if they're higher, I'd suspect that Report Builder is totaling up the values in each of the breakout lines while by default Workspace deduplicates total values.

 

For example, if you have one unique visitor who has 3 visits and sees a total of 10 page views.  In Workspace if you breakout these metrics by page, you might see something like this

 

Page.    Unique visitor      Visits     Page views

TOTALS.    1                       3              10

Page A       1                       1                3

Page B.      1                      2                4

Page C      1.                     2                3

 

Overall, there were 3 visits, but adding up the values for each row is higher because more than 1 page was seen on some visits.  Same with unique visitor.  There's only one total unique visitor, but they viewed 3 pages.

 

Perhaps report builder might show the totals in this simple scenario as 3 unique visitors and 5 visits, but those are just totaling the values.  It's an extra step, if that's the case, but to get the real totals for that period, you'd have to do another query without breaking it out by dimensions that might have overlap. 

 

(You may see similar things on a smaller basis. with time dimensions such as hours, days, weeks, for visits that cross from one to another.)

 

Hope this helps

1 reply

Josh Stephens
Community Advisor
Josh StephensCommunity AdvisorAccepted solution
Community Advisor
May 25, 2023

Are your Report Builder visit and unique visitor counts higher than what you're seeing in Workspace?

 

I haven't worked with Report Builder much, but if they're higher, I'd suspect that Report Builder is totaling up the values in each of the breakout lines while by default Workspace deduplicates total values.

 

For example, if you have one unique visitor who has 3 visits and sees a total of 10 page views.  In Workspace if you breakout these metrics by page, you might see something like this

 

Page.    Unique visitor      Visits     Page views

TOTALS.    1                       3              10

Page A       1                       1                3

Page B.      1                      2                4

Page C      1.                     2                3

 

Overall, there were 3 visits, but adding up the values for each row is higher because more than 1 page was seen on some visits.  Same with unique visitor.  There's only one total unique visitor, but they viewed 3 pages.

 

Perhaps report builder might show the totals in this simple scenario as 3 unique visitors and 5 visits, but those are just totaling the values.  It's an extra step, if that's the case, but to get the real totals for that period, you'd have to do another query without breaking it out by dimensions that might have overlap. 

 

(You may see similar things on a smaller basis. with time dimensions such as hours, days, weeks, for visits that cross from one to another.)

 

Hope this helps

    Terms & ConditionsAccessibility statement

    Loading footer...