Zero-value cells

[Soroush]

Hello,

I'm using Google Sheets add-on.
Using dimensions ga:date,ga:eventAction,ga:channelGrouping, for some date there is no data for the metric I chose, so Google sheet API will remove the row completely.
For example the data is like this

Date Event Action Default Channel Grouping Unique Events
2019-06-19 Onlinesuccess Affiliates 2
2019-06-21 Onlinesuccess Affiliates 6

In the above example there is Zero 0 unique events for June 20th.
As I import this report and consolidate it (Using =importrange(...) ), it is very important to have the entry 0 and respective date in order to prevent errors and mismatch.

Is there anyway to force Google Sheets API to report also the Zeros?
To have output data like this:

Date Event Action Default Channel Grouping Unique Events
2019-06-19 Onlinesuccess Affiliates 2
2019-06-20 Onlinesuccess Affiliates 0
2019-06-21 Onlinesuccess Affiliates 6

Thank you in advance for your responses.
Have a good day

[Dimitris L]

Hi Soroush,

I would add one more metric in the report like sessions to force all date rows to be applied.

I hope that helps

[soroush...@gmail.com]

Hi Dimitris,
That was wise. I tested it, but there are no sessions associated to Affiliates channel grouping for that day as well.
I tried other metrics but they don't match with dimensions.

[soroush...@gmail.com]

I found this :

https://groups.google.com/d/msg/google-analytics-spreadsheet-add-on/Ei0x9jNFycE/8L_1-PlJAwAJ

Unhided the rows in Report Configuration, but by either putting FALSE or TRUE, in the row of "Exclude Empty Rows", the rows with zero value did not show up
:\

[eneri81]

Hi, I do have a similar issue - but "exclude emty row" does not help.

My problem is, that rows get excluded if one dimension is empty.

Example:

Metrics for all Reports: ga:users,ga:sessions,ga:sessionDuration,ga:uniquePageviews,ga:timeOnPage,ga:avgTimeOnPage

Report 1

- uses this dimensions: ga:source,ga:medium,ga:country,ga:hostname,ga:pagePath,ga:pageTitle,ga:date,ga:userAgeBracket,ga:userGender

- Results: 345 rows

Report 2

- uses this dimensions: ga:source,ga:medium,ga:country,ga:hostname,ga:pagePath,ga:pageTitle,ga:date,ga:userAgeBracket (no Gender)

- Results: 516 rows

Report 3

- uses this dimensions: ga:source,ga:medium,ga:country,ga:hostname,ga:pagePath,ga:pageTitle,ga:date,ga:userGender (no Age)

- Results: 534 rows

Report 4

- uses these dimensions: ga:source,ga:medium,ga:country,ga:hostname,ga:pagePath,ga:pageTitle,ga:date (no Age and Gender)

- Results: >4800 rows

As I see a row gets excluded if either age or gender is zero - even if there are value in the other dimentions.

If I add more dimensions I should get more rows - not less (eg. Report 4 without "page" returns 4500 rows - wich is fine, cause the granularity is smaler).

An if a value for a dimension is missing it should be summend up as "(not set)" or "null" - wich it does e.g. for "country".

This is a great bug - how do I know, if my report contains all rows?

I do hope that someone has a solution. If not, this Add on is not usable for me. Caus I never know, if it will show all rows.

Blessings,

Irene