I created a data table in Data Studio. I have to broken down by ad with reach, impressions, link clicks, etc however the reach metric does not show up.
it shows "null" for every ad in the breakdown, but then it shows the total reach in the grand total line. This only happens with reach, no other metric. It's clearly able to pull in the total data, but not the individual ad breakdown. Not sure if this is just happening to me or if this is an issue across the board. See attached.
I recreated the query you gave in the screenshot but was not able to get the same error. So there must be something additional in your query setup that wasn't shown. Are you using any filters - if so, what are the settings for that?
You might also try refreshing the data source, if it's existed for a little while and hasn't had this done. May be some stale code in that case:
There are currently no filters being applied the the table. I refreshed the data source. I even disconnected and reconnected but it's doing the same thing to a couple different reports I have going.
Here are the links to the ones I'm referring to specifically:
Please help! Thanks!
Unfortunately, I don't have edit access to these links so I cannot see the settings being used. Could you please give firstname.lastname@example.org a temporary edit access to the file so I can check your configuration against my test?
I've added email@example.com to the reports.