Geo targets Downlod File 8-13-2024 "Athens International Airport "Eleftherios Venizelos""

[Bob Drzewucki]

Hello Team,

The 2024-08-13 version of the geo targets file (https://developers.google.com/google-ads/api/data/geotargets?hl=en) reintroduced an improperly formatted value for entry 9041231.

The name value includes double quotation marks breaking parsing the record.

2024-07-11 version

"9041231","Eleftherios Venizelos Athens International Airport","Eleftherios Venizelos Athens International Airport,Decentralized Administration of Attica,Greece","9069538","GR","Airport",Active

File version 2024-08-13

"9041231","Athens International Airport "Eleftherios Venizelos"","Eleftherios Venizelos Athens International Airport,Decentralized Administration of Attica,Greece","9069538","GR","Airport",Removal Planned

This is the same problem addressed in the 8-21-2023 file last year and fixed on ticket https://groups.google.com/g/adwords-api/c/gOjT7ILZw5A

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

I would like to inform you that our team is currently working on this issue. One of our teammates will get back to you once we have an update on this. Meanwhile your patience is appreciated.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vF9oA:ref" (ADR-00264006)

Thanks,
 

Google Ads API Team

[Bob Drzewucki]

Hello Google Ads API Team,

Is there any update on the latest geotargets file and this ticket?

Thank you,

Bob

[Google Ads API Forum Advisor]

Hello,

The team is still working on generating the new file. I will let you know when I can confirm that it's ready.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vF9oA:ref" (ADR-00264006)

Thanks,
 

Michael Cloonan Google Ads API Team

[Bob Drzewucki]

Hello Team,

I am being reached out to with some urgency for an update on this ticket, as we are approaching a month out. Any timeline which may be communicated?

Thank you.

[Google Ads API Forum Advisor]

Hello,

No updates yet. I've reached out to the relevant team and will let you know when I have any updates to share.

[Google Ads API Forum Advisor]

Hello,

The file has been regenerated and re-published and the quotes issue should be resolved. It's not clear to me whether this version of the file is fixed, or all future versions of the file are fixed, so I'm going to push back for more information so hopefully this doesn't ever come up again.

[Bob Drzewucki]

Hello Team,

The latest file released 2024-09-26 has a new record utilizing double quotation in the record content, which breaks the ability to parse the record.

"9216974","Karen "C"","Karen "C",Nairobi County,Kenya","9069738","KE","Neighborhood",Active

Please look into this and let me know when it is resolved, so we may use the latest version.

Thank you. 

[Google Ads API Forum Advisor]

Hello,

Thank you for reporting this. I am still working with the team on a long-term solution, so I'll include this example as well. I apologize for the inconvenience. In the meanwhile, you can get all this information programmatically from the API itself using the geo_target_constant report. You may want to look into building your own library if you are unhappy with the reliability of our CSV file.

Please do note, though, that I am trying to get the process for generating the CSV file to be more robust. I just don't know how long it will take.

[Bob Drzewucki]

Hello,

Thank you for your response. Is there going to be an updated file released to correct the current improperly formatted record?

Thank you,

Bob

[Hanzala Hassan]

Lol

On Thu, 3 Oct 2024, 7:03 pm Bob Drzewucki, <bdrzew...@gmail.com> wrote:

Hello,

Thank you for your response. Is there going to be an updated file released to correct the current improperly formatted record?

Thank you,

Bob

On Monday, September 30, 2024 at 9:24:39 AM UTC-4 Google Ads API Forum Advisor wrote:

Hello,

Thank you for reporting this. I am still working with the team on a long-term solution, so I'll include this example as well. I apologize for the inconvenience. In the meanwhile, you can get all this information programmatically from the API itself using the geo_target_constant report. You may want to look into building your own library if you are unhappy with the reliability of our CSV file.

Please do note, though, that I am trying to get the process for generating the CSV file to be more robust. I just don't know how long it will take.

 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vF9oA:ref" (ADR-00264006)

Thanks,
 

Michael Cloonan Google Ads API Team

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/205594f9-1fa5-4d83-af26-1c2d4a7258dfn%40googlegroups.com.

[Google Ads API Forum Advisor]

Hello,

Yes, we published another new version fixing the double quotes for the new entry. I had the team double-check that there won't be any more issues in the new file, and it seems to be good to go now.

Thank you for your patience.

[manuel.rodrig...@crealytics.com]

There is one additional subtle problem with the geotargets-2024-09-26.csv file.

The entry with Criteria ID = 9218901 has Parent ID = 21113, but the corresponding entry with Criteria ID = 21113 is missing. For reference, the following query (using DuckDB) shows all entries for which the parent is not present:

```shell

$ duckdb -csv -c '
  SELECT *
  FROM "geotargets-2024-09-26.csv" AS child
  LEFT JOIN "geotargets-2024-09-26.csv" AS parent
    ON child."Parent ID" = parent."Criteria ID"
  WHERE child."Parent ID" IS NOT null
    AND parent."Criteria ID" IS null;'

```

which results in just the single entry I mentioned:

```

"Criteria ID",Name,"Canonical Name","Parent ID","Country Code","Target Type",Status,"Criteria ID",Name,"Canonical Name","Parent ID","Country Code","Target Type",Status
9218901,84100,"84100,Donetsk Oblast,Ukraine",21113,UA,"Postal Code",Active,,,,,,,

```

[Bob Drzewucki]

Hello Google Team,

I have reviewed the latest geo targets download file 10-10-2024, checking the two records mentioned over this ticket.

"9216974","Karen ""C""","Karen ""C"",Nairobi County,Kenya","9069738","KE","Neighborhood",Active

"9041231","Athens International Airport ""Eleftherios Venizelos""","Athens International Airport ""Eleftherios Venizelos"",Decentralized Administration of Attica,Greece","9069538","GR","Airport",Removal Planned

I see the current file was generated with replacing the use of double quotation marks (") in content values with two double quotation marks (""). 

The ideal change would be to replace the use of double quotation marks in the content with a single quotation mark ('), as was done with the last to versions of the geo target file. 

Example:

"9216974","Karen 'C'","Karen 'C',Nairobi County,Kenya","9069738","KE","Neighborhood",Active

"9041231","Athens International Airport 'Eleftherios Venizelos'","Athens International Airport 'Eleftherios Venizelos',Decentralized Administration of Attica,Greece","9069538","GR","Airport",Removal Planned

Thank you for looking into this.

 
Thank you,

Bob

[Google Ads API Forum Advisor]

Hello,

The double quotation mark is the standard way to escape quotes in CSV files. If you use any standard CSV parser it should handle it fine. The team did this as a permanent fix rather than manually fixing the file as they had in previous iterations.

[Bob Drzewucki]

Hello,

I confirmed the use of two double quotes works fine with our parsing. 

Thank you for your quick response and the change to your file generation process.

Thank you,

Bob

[manuel.rodrig...@crealytics.com]

Just to clarify, the Criteria ID 21113 is still missing in the latest geotargets-2024-10-10.csv file.

[manuel.rodrig...@crealytics.com]

Any update on the "Criteria ID 21113" issue? Will that be fixed in the next version of the geotargets file, to be released hopefully soon-ish?