Hello,
I’m using Looker for Google Ads Performance reporting.
I have a sample report of which I make a copy, then only change the data source to the corresponding Google Ads account(using it for hundreds of different clients) and I would like to keep things as simple as possible.
I have a few tables, where I’m showing stats for the different campaigns/ad groups.
I’m trying to create a filter that excludes paused Google Ads Ad Groups with 0 impressions for a given period from those tables.
But if I select any prior period for which they have impressions, I want them to show, no matter that they are currently paused.
I’ve tried through the filters at the chart level, but they don’t seem to work as I expected.
I’ve also tried to create a calculated field, but I got this error:
“Sorry, calculated fields can’t mix metrics (aggregated values) and dimensions (non-aggregated values). Please check the aggregation types of the fields used in this formula. Learn more.”
To summarize what I’m trying to achieve:
- Select August from the Date Picker:
Ad Group 1(Currently Paused), 0 Impressions for August → Do Not Show in the chart
And then Select July from the Date Picker:
Ad Group 1(Currently Paused), 400 Impressions for July → Show in the chart.
In other words:
If (Ad Group State = paused AND impressions = 0) {DO NOT Show data in the chart}
else if (Ad Group State = paused AND Impressions > 0){Show data in the chart}
As I said, I’m trying to keep things as simple as possible and I’m searching for the easiest solution that won’t require any data blending or creating custom fields for any new data source I add. Is there any way to update only the sample report and this solution to work for any next data source I add?
Any help will be greatly appreciated!