Re: Get Ad campaign reports based on country and state
Sorry for my poor ability. I actually meant that it's giving me the non state names instead it gives me ids. So if my report gives 200 rows I need to call geo_target_constant 200 times? This is not a good approach I think. Could you help me whether the same can be achieved using location api? https://prnt.sc/oG7ms7tOdVfH as shown like here I wanted to get the spends daily for all states. Any help is greatly appreciated On Wed, Jun 8, 2022, 7:00 PM Google Ads API Forum Advisor wrote: > Hi Darren, > > In addition to above, you may also share privately(for sensitive details) > the API response where you are getting Non-US locations, so it will help in > our investigation. > > Regards, > [image: Google Logo] > Yasar > Google Ads API Team > > > ref:_00D1U1174p._5004Q2bdUx2:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/CAHeo4XjYjYWb6LBxQOnu9BtJdCZU6ZqrcqBZpxzU50d9JeON5Q%40mail.gmail.com.
RE: Get Ad campaign reports based on country and state
Hi Darren, In addition to above, you may also share privately(for sensitive details) the API response where you are getting Non-US locations, so it will help in our investigation. Regards, Yasar Google Ads API Team ref:_00D1U1174p._5004Q2bdUx2:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/p0p4y0RD5UUL00dAZ2VF8YRMOjlJ5uCF7a2A%40sfdc.net.
RE: Get Ad campaign reports based on country and state
Hi Darren, Thanks for reaching out to the Google Ads API Forum. Since you mentioned that your GAQL gives you non US states, could you provide us customer ID so that I can impersonate on my end? With regards to results does not summarize by state names, you may need to perform a separate request for the geo_target_constant report after pulling segments.geo_target_state from geographic_view report. Regards, Yasar Google Ads API Team ref:_00D1U1174p._5004Q2bdUx2:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/X3oq60RD5UM0008Go2d3aBSjCduAr9QGFVHw%40sfdc.net.
Get Ad campaign reports based on country and state
I want to get the report as shown here https://prnt.sc/oG7ms7tOdVfH The input is Country = USA Date from and Date to But this gives non US states and it doesnt summarize the resuly by *state names* Can anyone help me to get the REST API? curl "https://googleads.googleapis.com/v10/customers/${CUSTOMER_ID}/googleAds:searchStream; \ --header "Content-Type: application/json" \ --header "developer-token: ${DEVELOPER_TOKEN}" \ --header "login-customer-id: ${MANAGER_CUSTOMER_ID}" \ --header "Authorization: Bearer ${OAUTH2_ACCESS_TOKEN}" \ --data '{ "query": " SELECT campaign.name, segments.geo_target_state, metrics.cost_micros FROM geographic_view WHERE geographic_view.location_type = LOCATION_OF_PRESENCE AND segments.date BETWEEN 20220101 AND 20220430 " }' -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/6a1d7287-5e9d-42fb-a54f-68aabb6afb06n%40googlegroups.com.