FYI to everyone experiencing this issue. I have a temporary workaround, but it is limited - you can only attach up to 50 accounts to the Google Ads data source.
The issue we are all having with our downloaded reports is being caused by the *default Google Ads data control.
If you create a new Google Ads data source (limited to 50 accounts) & then remove that default Google Ads data control from your Looker report, then add a drop-down list control (make it report level & use Account as the control field) then your downloads will work OK.
You can make additional copies to attach to addtl. accounts. I have 1 report that Iāve made 3 copies of to attach to a total of 131 accounts (so far). Itās a pain to have all these copies, but the downloads work as expected.
*Screen shot of problematic default Google Ads data control:
This is completely ridiculous. Looker studio is basically unusable / useless at this point and in our company we had to go back to manual reports, because we canāt just wait for this fixā¦
We have employees seeing the same issue, data shows fine, but is blank once downloaded. It does seem to show manually inputted data, but anything using the default data control doesnāt seem to show in the report
Weāve been experiencing this issue for going on two full months now. It appears Google doesnāt have any desire to fix it and make the reporting functional.
This is about the length of time I had become aware of this issue as well. I am hoping that more people bringing attention to the issue will result in more movement towards a resolution.
I just hope enough collective frustration with this will help them see the impact it is having.
I found a workaround for me. Itās the same thing that Ihana47 wrote, but I donāt think I fully understood her example earlier. Maybe this description will help someone.
I was using two fields: an Account Selector to choose the Google Ads account, and a Drop-down list with the Control Field set to Campaign. I noticed that since the issues started occurring, some campaigns from certain accounts no longer appear in the list.
Iāve now added a new data source from Google Ads, but this time specifying a single account (previously, I had one data source with access to all Google Ads accounts).
If I now assign this new source to both the campaign selection list and all the charts, everything seems to be working correctly.
Note: The names were translated from the Polish interface, so they might not be exact.
The whole point of the drop-down list is to build reports for multiple clients from a single source. What youāre suggesting means duplicating the entire report for each client, which is way more work than just hitting Ctrl+P until Google gets their act together and fixes it.
Weāre now at 5 or 6 months of this issue with no word from anyone @Google with a solution. Please someone fix. This topic has been viewed just short of 3,000 times with 58 comments. Clearly itās a known issue and bug that is not being worked on. Thereās a clear demand for a fix. Do something.
