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?