Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Visit Discrepancy

Avatar

Avatar
Level 1
paulr44860813
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
paulr44860813
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
paulr44860813
Level 1

03-09-2019

Hi,

I'm having an issue when pulling data from the Data Warehouse. I am pulling two files, one with visits broken down by week, the other broken down by week and tracking code. In the second file, I am seeing more visits than in the first, even though I'm using the same date range.

Why would this be?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 4
Waqas_Rafiq
Level 4

Likes

30 likes

Total Posts

49 posts

Correct Reply

21 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 4
Waqas_Rafiq
Level 4

Likes

30 likes

Total Posts

49 posts

Correct Reply

21 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Waqas_Rafiq
Level 4

03-09-2019

Hi paulr44860813​,

It makes sense that the visit count is higher when you look break it down by tracking codes. A visit can easily have more than one tracking code. Example:

the user goes to google, searches for product A, find your paid advertisement and click through to your website, the tracking trigger campaign A in AA and registers 1 visit. The user is not interested in the product and goes back to the google search result page and searches again, not another paid ad shows up which has campaign B tracking code. If the user clicks through on this paid ad as well, then you will also have 1 visit registered to that campaign.

In your first data extract (without the campaign tracking code), you will just see 1 visit, because the user had 1 visit within the 30 minute window. When you break it down with campaign code, you will see more visits as there is 1 registered for each campaign code.

Hope the above makes sense.

Answers (3)

Answers (3)

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

76 likes

Total Posts

358 posts

Correct Reply

81 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

76 likes

Total Posts

358 posts

Correct Reply

81 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

03-09-2019

Hi initially looks like it should be good.

I am suspecting the dimension tracking code may be wrong. Double check for a similar named item, Tracking Code (evar1) or something like it depending on number of your tracking code. May just be its the incorrect version selected.

Avatar

Avatar
Level 1
paulr44860813
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
paulr44860813
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
paulr44860813
Level 1

03-09-2019

Columns for pull #1:

Week

Sessions (Visits)

Orders

Revenue

Unique Visits

All Visits

Columns for pull #2:

Week

Tracking Code

Sessions (Visits)

Orders

Revenue

Unique Visits

All Visits

There is a filter being applied to both of these on the tracking code dimension.

Everything about the two pulls is exactly the same except one includes tracking code as a dimension and the other does not

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

76 likes

Total Posts

358 posts

Correct Reply

81 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

76 likes

Total Posts

358 posts

Correct Reply

81 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

03-09-2019

Need a bit more info.

What do column of each data warehouse look like(are metrics the same)?

Is any segment part of the data pulls?