Datawarehouse csv empty data

Avatar

Avatar
Validate 10
Level 3
zhengquanz32073
Level 3

Likes

20 likes

Total Posts

51 posts

Correct reply

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

Avatar
Validate 10
Level 3
zhengquanz32073
Level 3

Likes

20 likes

Total Posts

51 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
zhengquanz32073
Level 3

11-01-2018

Hi guys,

I have some questions with the csv data aggregate format from datawarehouse:

1. when I select "Mobile Device Type, Operation System Type, Browser Type" and "Page Views", the output format is like this:

1393224_pastedImage_3.png

We can see that there list what we want.

2. However, when I add "Pages" as another break down, I get format like follows:

1393225_pastedImage_4.png

We can see that there is a row with no content, does that mean "the page view number for device=gaming console, os=null, browser=google, pages=null is 0"?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

315 likes

Total Posts

871 posts

Correct reply

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

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

315 likes

Total Posts

871 posts

Correct reply

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

11-01-2018

Dear Zhen,

If Page Views = 0, then it is from s.tl() call i.e. Download link, external link, custom link etc.

Thank You!

Arun

Answers (3)

Answers (3)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

19-01-2018

Arun is spot on here. You can validate this by adding another metric besides page views, such as visits. Custom link calls do not collect pagename, nor do they count towards page views. The data still technically exists though, and it needs a row to display that data.

Avatar

Avatar
Validate 10
Level 3
zhengquanz32073
Level 3

Likes

20 likes

Total Posts

51 posts

Correct reply

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

Avatar
Validate 10
Level 3
zhengquanz32073
Level 3

Likes

20 likes

Total Posts

51 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
zhengquanz32073
Level 3

14-01-2018

TanmayM

could you please check this one? I'm really wondering why sometimes there would be "0" pageview row with empty "Pages".

Avatar

Avatar
Validate 10
Level 3
zhengquanz32073
Level 3

Likes

20 likes

Total Posts

51 posts

Correct reply

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

Avatar
Validate 10
Level 3
zhengquanz32073
Level 3

Likes

20 likes

Total Posts

51 posts

Correct reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
zhengquanz32073
Level 3

14-01-2018

thanks for your answer, but I'm still wondering what's the true meaning for my question.

Best,

Zhen