MetroCriteriaId - Geo Performance Report Issue
Hello, I am using google ads api and downloading GEO performance report. I am downloading data from geographic_view as suggested in google ads documents. In column metroCriteriaId I am getting kind of these values - geoTargetConstants/200522 which is fine.But I need metro location name corresponding to this IDs. How can I get names.. please suggest. Thanks Jayant Meshram -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/0d3263ad-b54e-4d03-a3b1-dfd14ec3f798n%40googlegroups.com.
LocationCriterionService not working in Airflow
Hello, When I am running below code in mu local it is running fine and returning proper result but when I am running same code in Airflow it is giving me error for version. *Airflow Error :-* b"googleads.errors.GoogleAdsValueError: Unrecognized version for the AdWords API. Given: v201809 Supported: ['v201609', 'v201702', 'v201705', 'v201708']\n" *Code:-* #!/usr/bin/env python # # Copyright 2016 Google Inc. All Rights Reserved. # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. """This example gets all campaigns. To add a campaign, run add_campaign.py. The LoadFromStorage method is pulling credentials and properties from a "googleads.yaml" file. By default, it looks for this file in your home directory. For more information, see the "Caching authentication information" section of our README. """ from googleads import adwords PAGE_SIZE = 100 def main(metro_criteria_id): # Initialize appropriate service. location_criterion_service = adwords_client.GetService( 'LocationCriterionService', version='v201809') location_names_metro = metro_criteria_id # Create the selector. selector = { 'fields': ['Id', 'LocationName', 'DisplayType', 'CanonicalName', 'ParentLocations', 'Reach', 'TargetingStatus'], 'predicates': [{ 'field': 'Id', 'operator': 'IN', 'values': location_names_metro }, { 'field': 'Locale', 'operator': 'EQUALS', 'values': ['en'] }] } # Make the get request. location_criteria = location_criterion_service.get(selector) print(f'location criteria{location_criteria}') if __name__ == '__main__': adwords_credentials = gen_api_credentials() global adwords_client adwords_client = adwords.AdWordsClient.LoadFromString(adwords_credentials) print('start') main(20652) *Result:* start location criteria[{ 'location': { 'id': 20652, 'type': None, 'Criterion.Type': 'Location', 'locationName': 'Nara', 'displayType': 'Prefecture', 'targetingStatus': 'ACTIVE', 'parentLocations': [ { 'id': 9073778, 'type': None, 'Criterion.Type': 'Location', 'locationName': 'JP_KINKI', 'displayType': 'DMA Region', 'targetingStatus': 'ACTIVE', 'parentLocations': [] }, { 'id': 2392, 'type': None, 'Criterion.Type': 'Location', 'locationName': 'Japan', 'displayType': 'Country', 'targetingStatus': 'ACTIVE', 'parentLocations': [] } ] }, 'canonicalName': 'Nara,Japan', 'reach': 123, 'locale': None, 'searchTerm': None, 'countryCode': None }] Process finished with exit code 0 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/82cf1b68-1071-4de8-a430-275fd3efaedan%40googlegroups.com.
Re: Metro Criteria ID and its location name csv file
Hello, Thanks for your reply. Is there any report like campaign performance Geo performance where I can get a metro criteria id with its location name(metro area name). If there is any table which has a metro criteria id with its location name it can also help. Thanks Jayant Meshram On Thu, Dec 23, 2021 at 10:43 AM Google Ads API Forum Advisor wrote: > Hi Jayant, > > Thank you for posting your concern. > > You can use the geo_target_constant > <https://developers.google.com/google-ads/api/fields/v9/geo_target_constant> > to get the geo related information. However, I am afraid that downloading > reports in a CSV file is currently not supported in the Google Ads API. The > API does not support formatting or file output so you will need to create a > process on your end instead that will import the data into a CSV file. With > this, I would suggest to follow this example in Ruby > <https://github.com/googleads/google-ads-ruby/blob/4b4c78d96f8e25ce7d6da1ea153f781a3684837b/examples/reporting/campaign_report_to_csv.rb> > that > shows how you can implement CSV formatting in your client library. > > However, our team has already raised a feature request for this, subject > for review. Please follow our blog > <https://ads-developers.googleblog.com/search/label/google_ads_api> as we > will post there relevant updates when it becomes supported. > > Regards, > [image: Google Logo] > Ernie John Blanca Tacata > Google Ads API Team > > > ref:_00D1U1174p._5004Q2TOlTR: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 "AdWords API and Google Ads 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/CAOUR7G3hLMb0Cs%3Dc%3DXX0P80A%3Df28ifUQTnPOJQVTdqB9P7L-pg%40mail.gmail.com.
Metro Criteria ID and its location name csv file
Hello, Can I get metro criteria id and its metro name in csv format like geotargets sheet. Thanks Jayant Meshram -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/a7bc4495-36ba-49a7-915c-397466b650a3n%40googlegroups.com.
Campaign Status
Hello, I am getting campaign.status values as 2 in response to query. campaign.status values are enable paused and removed in campaign table. So my question what value 2 signifies , enabled paused or removed? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/80cb4709-c6e6-44cd-ac95-14f5c17f9b63n%40googlegroups.com.
Need all rows and not aggregated data.
Hello, I need all rows for particular customer id and not aggregated rows. Lets say for example I am querying campaign table and I am getting aggregated rows respective to customer (account) ids and I need all rows. Aggregation I can do on my own. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/5e8db451-efc1-4234-a165-2df8b069bd45n%40googlegroups.com.