Expand my Community achievements bar.

SOLVED

Datawarehouse csv empty data

Avatar

Level 4

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"?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Level 4

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

Best,

Zhen

Avatar

Level 4

TanmayM

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

Avatar

Employee Advisor

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.