Could you please help me get that via a Select statement?
I am looking for summary output as shown here, am I doing something wrong?
https://prnt.sc/oG7ms7tOdVfH
Do I need to get location based report? I am unsure how to get that via API.
On Wed, Jun 8, 2022, 7:01 PM Google Ads API Forum Adviso
Hi Darren,
Thanks for reaching out to the Google Ads API Forum.
You may need to perform a separate request for the geo_target_constant report
after pulling segments.geo_target_state from geographic_view report in order
to get the name of those states. There is no way to combine two GAQL togeth
I am using ads API for getting the spends based on state names of USA.
The below query gives segments.geo_target_state will be returned as an ID
instead of name How can I combine this query with SELECT
geo_target_constant.name, geo_target_constant.canonical_name FROM
geo_target_constant WHERE