Re: Pulling Data from Resource Fields in Google API Beta Reports

2020-01-09 Thread Drew Lauck
I removed .value from row.ad_group_ad.ad.final_urls.value and the script works but the data comes out as [value: "https://example.com/example]. Is there a way to get just the url without the value and brackets? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: ht

Pulling Data from Resource Fields in Google API Beta Reports

2020-01-09 Thread Drew Lauck
Afternoon, I'm currently having trouble pulling data from the ad_group_ad report (https://developers.google.com/google-ads/api/fields/v2/ad_group_ad). I need to pull the ad_group_ad.ad.final_urls along with all of the headlines. I'm using this query: query = ( 'SELECT campaign.id, ad_group

Re: Python Library Query Question

2020-01-08 Thread Drew Lauck
Understood. Thank you for your help. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API

Re: Python Library Query Question

2020-01-07 Thread Drew Lauck
Thanks for the reply! The query works, most likely a setup issue. Do you have any idea what the error I referenced above means? Is it a timeout issue or a setup issue? I'm used to coding in javascript where error messages are somewhat helpful but I can't really decipher what the problem is from

Re: Handling Error errors_pb2

2020-01-07 Thread Drew Lauck
On Tuesday, January 7, 2020 at 9:27:22 AM UTC-5, Drew Lauck wrote: > > Currently getting the same error, albeit with a different query but the > logic is the same. If I find a solution I'll be sure to let you know. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Al

Re: Handling Error errors_pb2

2020-01-07 Thread Drew Lauck
Currently getting the same error, albeit with a different query but the logic is the same. If I find a solution I'll be sure to let you know. On Tuesday, January 7, 2020 at 8:40:14 AM UTC-5, Lucas Gomide wrote: > > I got the following error when ran this query > > SELECT > campaign.name > FROM ca

Python Library Query Question

2020-01-07 Thread Drew Lauck
WHERE segments.date DURING LAST_30_DAYS ' 'AND campaign.advertising_channel_type = \'SEARCH\' ' 'AND ad_group.status = \'ENABLED\' ' 'AND ad_group_criterion.status IN (\'ENABLED\', \'PAUSED\'

Google Ads API Beta reports to MySQL

2019-12-30 Thread Drew Lauck
Good afternoon, I'm currently using the python google ads library ( https://github.com/googleads/google-ads-python) to pull reporting data. I've made successful calls using this script ( https://github.com/googleads/google-ads-python/blob/master/examples/reporting/get_keyword_stats.py) and am p