Chartramp - Open source project for Google Ads API

[Majid Khosravi]

I have recently started an open source project called Chartramp which pulls data from different ad networks including Google Adwords API for analysis purposes, In case might be useful:

https://github.com/Chartramp/Chartramp

Currently I have an issue regarding fetching the country code from LocationCriterionService to map daily GEO records per country.

Here is the code:

https://github.com/Chartramp/Chartramp/blob/master/application/src/Service/Network/Google/GoogleAds.php using getCountryCodes function.

Can you guys have a look and let me know if there is a way to get the countryCode from LocationCriterionService? It always returns as null.

Thanks!

[Dannison Yao (AdWords API Team)]

Hi Majid,

It is expected that the value for countryCode will be blank when you retrieve it as this field is generally used for filters. According to the documentation, it is used as a hint or suggestion when you are doing your filtering. For example, you specified CountryCode EQUALS 'US' when calling the API. This means that the results returned by the API is filtered by the countryCode, specifically if it is equal to 'US'.

Hope this helps.

Regards,

Dannison

AdWords API Team

[Majid Khosravi]

Thanks Dannison,

So what would be the best way to get the country codes? In the above example I am using CAMPAIGN_LOCATION_TARGET_REPORT service to pull the result per location and I want to get the country code of each location id as well.

Thanks.

[Dannison Yao (AdWords API Team)]

Hi Majid,

What you can do here is upon retrieving the Id of the Location from CAMPAIGN_LOCATION_TARGET_REPORT, you can map the location ID to the country code using this guide.

Regards,

Dannison

AdWords API Team

[Majid Khosravi]

Thanks but it seems that fusion table is private and I don't have access to it.

[Dannison Yao (AdWords API Team)]

Hi Majid,

The link I sent should be publicly available. Could you send over a screenshot of what you're seeing upon accessing it?

Regards,

Dannison

AdWords API Team

[Majid Khosravi]

Sure. here it is.

[Dannison Yao (AdWords API Team)]

Hi Majid,

Could you access this link and click on the "Open Table" button and see if you have access to it?

Regards,

Dannison

AdWords API Team

[Majid Khosravi]

I had to logout from my gmail account to be able to download it, thank you.