Difficulty in matching figures and i'm not sure why

Avatar

Avatar
Ignite 1
Level 2
angelad64963316
Level 2

Like

1 like

Total Posts

43 posts

Correct reply

1 solution
Top badges earned
Ignite 1
Validate 10
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Ignite 1
Level 2
angelad64963316
Level 2

Like

1 like

Total Posts

43 posts

Correct reply

1 solution
Top badges earned
Ignite 1
Validate 10
Validate 1
Boost 1
Applaud 5
View profile
angelad64963316
Level 2

04-12-2017

Hello people

i'm building a dashboard in Tableau.

This dashboard will show a line graph of visits, a line graph of visitors, a stacked breakdown of visits split by traffic type, e.g, direct, email, etc.  It will also show top pages and i need to be able to split by country.  The country will be extracted from two letters of the url, e,g, en or de.

When i first designed this, i used DW to extract this information and i selected the following dimensions:

Referrer

Referring Domains

Referrer type

Pages

And the following metrics

Visits

Visitors

Other items will be on the dashboard but i have to extract them separately through SiteCatalyst - bounces/entries.

My problem as you probably have deduced is that if i were to look at my visits in SiteCatalyst, they wouldn't match what is in my DW extract and i'm thinking its because of the dimensions i'm pulling alongside?

Any advice?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

04-12-2017

Dear Angela,

You cannot sum up Visits or Unique Visitors to get the total numbers. It will deduplicate!

Consider you entered a site through a referrer google.com.my/page and visited 5 pages in a single visit. Below is how the Data Warehouse table will look like.

       

ReferrerReferring DomainReferrer TypePagePage ViewsVisitsUnique Visitors
Google.com.my/pageGoogle.comNatural SearchA111
Google.com.my/pageGoogle.comNatural SearchB111
Google.com.my/pageGoogle.comNatural SearchC111
Google.com.my/pageGoogle.comNatural SearchD111
Google.com.my/pageGoogle.comNatural SearchE111

In Tableau, if you select the overall numbers, Page Views = 5, Visit = 5 and Unique Visitors = 5. Because it works like pivot and subtotal everything.

In Adobe Analytics, Page Views = 5, Visit = 1 and Unique Visitors = 1.

Only Page Views will/should match.

So, you cannot compare these! If you need accurate report when you club the dimensions, please generate exact Dimension from the Data Warehouse rather than subtotaling it using Tableau.

Thank You!

Arun

Answers (3)

Answers (3)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

314 likes

Total Posts

866 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

05-12-2017

Hello Angela,

For Summary in Tableau, rather than subtotaling the metrics from the Data Warehouse file you have(More Dimensions), use another file with only one dimension.

Example : For Referrer Summary, download another Data Warehouse file with the dimension Referrer and metrics Visits & Unique Visitors.

Thank You!

Arun

Avatar

Avatar
Give Back 3
Level 1
cristinafoit
Level 1

Likes

3 likes

Total Posts

63 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Boost 3
Boost 1
View profile

Avatar
Give Back 3
Level 1
cristinafoit
Level 1

Likes

3 likes

Total Posts

63 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Boost 3
Boost 1
View profile
cristinafoit
Level 1

21-04-2021

@angelad64963316 @PratheepArunRaj 

If you need to import Adobe analytics data in Tableau, Daexus built a free web data connector.

  • no sign-up required
  • no download 
  • ultra secure as data doesn't go through external server - from Adobe Analytics straight to your computer.

To access it, paste the link in Tableau and start brining your data.

cristinafoit_0-1619045604304.png

The paid version enables date expressions and automated data imports.

Access the link on their website 

Avatar

Avatar
Ignite 1
Level 2
angelad64963316
Level 2

Like

1 like

Total Posts

43 posts

Correct reply

1 solution
Top badges earned
Ignite 1
Validate 10
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Ignite 1
Level 2
angelad64963316
Level 2

Like

1 like

Total Posts

43 posts

Correct reply

1 solution
Top badges earned
Ignite 1
Validate 10
Validate 1
Boost 1
Applaud 5
View profile
angelad64963316
Level 2

05-12-2017

HI Arun

Thanks for your response.  I understand what you are saying with regard to how Adobe dedupes the stats.

The only part I misunderstood in your message was

So, you cannot compare these! If you need accurate report when you club the dimensions, please generate exact Dimension from the Data Warehouse rather than subtotaling it using Tableau.

What do you mean by exact dimension?

Angela