Posts tagged with looker-studio

I have a Looker Studio dashboard that was working with no issue before. For the past few months it shows the following error:

Metric results might not be accurate when using Asset level dimensions. Please add "Ad Type" and "Asset ID" fields to get accurate data.

I'm using blended data which is blending Google Sheets with Google Ads. This issue persists even if I add "Ad Type" and "Asset ID" to this data.

How can I either solve or hide this error? (at least hiding it would help getting rid of this annoying error).

I tried adding "Ad Type" and "Asset ID" to this data. Or Event rebuilding the tables joins by adding a new Google Ads to it so I get these fields from the new data source.

I'm trying to find all my accounts with cost == 0.

 var query =    'SELECT AccountDescriptiveName, Cost FROM ACCOUNT_PERFORMANCE_REPORT DURING LAST_7_DAYS WHERE Cost > 0';  var recommendationResult = AdsApp.search(query, { apiVersion: 'v8' });

But I get this exception:

Exception: Could not identify resource for search query "SELECT AccountDescriptiveName, Cost FROM ACCOUNT_PERFORMANCE_REPORT DURING LAST_7_DAYS WHERE Metric.Cost == 0". Double-check your FROM clause. (file Code.gs, line 18)

I wanted to build it from scratch using the Query Builder but I haven't found ACCOUNT_PERFORMANCE_REPORT report (AW API) or it GA API equivalent.

Also, using the GAds connector to data studio. Is there a way to fetch the query behind some table?

I saw a blog where “Segment Conversion Type Name” and “Segment Conversion Category” cannot coexist with non-conversion metrics—such as cost, clicks, or impressions:

https://www.workshopdigital.com/blog/3-google-data-studio-shortcomings-for-ppc-analysts/

I am trying to build us a report that will show the cost per segment conversion category per location but alongside it is I also have the non-conversion metrics. I don't really want to build another table just for the conversions since the data looks messed up.

I want to create such a table:

list of all search keywords of a specific advertiser. And for each column the metric of "absolute top page rate" for a different advertiser.

I have tried to start with a simpler table of keywords x one advertiser rates, but I get an error from data studio.

How can I create the desired table?

Thanks

message: "absolute_top_of_page_rate is prohibited with entities: KeywordGroup. Measures should have explicit segmentation fields if prohibited entities are selected." trigger { string_value: "absolute_top_of_page_rate" } origin: INVALID_REQUEST

  1. 1
  2. 2