Cost vs. ROAS via the API

2022-08-29 Thread 'EladB' via Google Ads API and AdWords API Forum
I want to call the API to get the (Cost vs. ROAS) forecast. It's visible on GA-FE, but the response object doesn't contain the ROAS or any value metric. GA_FE: https://i.stack.imgur.com/VYweF.png

How to query WHERE cost > X ?

2022-03-05 Thread 'EladB' via Google Ads API and AdWords API Forum
Hi Google Support, I've run into an issue with the Google Ads Query Validator and need some help debugging. * API Version: v10 * Query: "SELECT customer.id, metrics.impressions FROM group_placement_view WHERE group_placement_view.placement_type IN ("YOUTUBE_CHANNEL") AND (metrics.impressi

A compound WHERE clause in GAQL?

2022-02-10 Thread 'EladB' via Google Ads API and AdWords API Forum
Hi Could you please confirm GQAL doesn't support `compound WHERE clause`? ``` FROM group_placement_view\ WHERE\ metrics.impressions >= 1 \ AND (metrics.video_view_rate < 10' OR metrics.average_cpm > 1 ) ``` and not event `OR` as non-compound clause? ``` metrics.average_cp

Set excluded YT placements with google Ads API

2022-01-24 Thread &#x27;EladB&#x27; via Google Ads API and AdWords API Forum
Hi I want to set excluded YT placement in Google Ads automatically. 1) I saw this [API][1]. Which one should I use? setting a `placement` or a `YT video`? Or elsewhere? 2) How can I make sure this cannot be done via ads script? Should it have be under [AdGroupBidding][2]? So if not there - ads