Can Ads API search result transform to pandas with correctly type ?

[Jayce Li]

I want to try move data from Google Ads API to bigquery by myself,  but I find out I have a big issue about data schema.

When I through GoogleAdsService to get GoogleAdsRow, then use google.protobuf.json_format.MessageToJson to create json to batch load into bigquery.
All integer would become string and date become string...

Any suggestion?

[googleadsapi...@google.com]

Hello Jayce,

If you take the entire googleAdsRow, it will result everything into the string format. If you use functions like googleAdsRow.getCampaign().getId().getValue() to get individual elements you will get the actual primitive types instead.

Regards,
Sai Teja, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/