Datawarehouse csv empty data

Avatar

Avatar

zhengquanz32073

Avatar

zhengquanz32073

zhengquanz32073

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

PratheepArunRaj

Moderator

Avatar

PratheepArunRaj

Moderator

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

Gigazelle

Employee

Total Posts

1.9K

Likes

460

Correct Answer

734

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

460

Correct Answer

734
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

zhengquanz32073

Avatar

zhengquanz32073

zhengquanz32073

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

zhengquanz32073

Avatar

zhengquanz32073

zhengquanz32073

14-01-2018

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

Best,

Zhen