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
On Wednesday, October 16, 2024 at 4:20:21 AM UTC-4
manuel.rodrig...@crealytics.com wrote:
> 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,,,,,,,
> ```
> On Thursday, October 3, 2024 at 5:57:59 PM UTC+2 Google Ads API Forum
> Advisor wrote:
>
>> 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.
>>
>>
>> This message is in relation to case
>> "ref:!00D1U01174p.!5004Q02vF9oA:ref" (ADR-00264006)
>>
>> Thanks,
>>
>> [image: Google Logo]
>> 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 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/a20dbfca-ac84-4b31-b826-860e40e36066n%40googlegroups.com.
