Showing dimensions with empty values

[STRAREXDigital]

Hi all,

I am hoping to find an answer to my question here. I am using Google Search Console data in my Looker Studio report. The account for GSC was only set up in April but I would like to be able to simply display previous months as "0". However, because there is no data and the account is new, I can't go further back than April. It's the same with the Google Ads account.

What's the solution for this?

Thanks in advance!

[ArkadyZagdan]

Hey @STRAREXDigital 

There is but I am nnot sure it's worth chasing.
You can create a new table with previous dates and dimensions. For example Date, Clicks, Impressions. And fill metrics withh 0 values.
Now you can union this table into a new one and theoreticcally it shouls allow you to display 0 values for older months.

Ideally you should be seeking to achieve it using BigQuery as it would be easier to union based on all dimensions like URL or keyword.
In order to push your data into BigQuery you can use GSC integration:

Regards
Arkady Zagdan

[STRAREXDigital]

Thanks a lot @ArkadyZagdan ! Actually worked it out with blending a Google sheet with what you suggested, containing missing dates and 0 values.

[ArkadyZagdan]

@STRAREXDigital 
Happy that it helped! Please mark as resolved solution:)