Why I could not find the new metrics in the keywords performance report?

2018-11-14 Thread yliu
Hello All, Based on the notice (https://ads-developers.googleblog.com/) Starting *November 12, 2018*, the fields below will be available in AdWords API and Google Ads scripts reports. Absolute top metrics: - AbsoluteTopImpressionPercentage - SearchAbsoluteTopImpressionShare - Searc

Why I get unexpected values from the KEYWORDS_PERFORMANCE_REPORT report

2018-11-20 Thread yliu
Hello All, New to google adwords, now I am trying to fetch the data from keyword performance report. The following code is an example, based on the document (https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report ), I want to fetch some values from attri

Re: Why I could not find the new metrics in the keywords performance report?

2018-11-20 Thread yliu
The new attributes are available now. Thanks Yang On Thursday, November 15, 2018 at 9:35:04 AM UTC-6, Dannison Yao (AdWords API Team) wrote: > > Hi Yang, > > The team is currently checking on these fields. I will provide you with an > update once available. > > Regards, > Dannison > AdWords AP

Re: Why I get unexpected values from the KEYWORDS_PERFORMANCE_REPORT report

2018-11-21 Thread yliu
Hi, I think I found the reason, I parsed the returned CSV incorrectly. Sorry Yang On Tuesday, November 20, 2018 at 4:53:13 PM UTC-6, Dannison Yao (AdWords API Team) wrote: > > Hi Yang, > > Could you provide me the clientCustomerId you used so I could further > check this? You may provide them

Labels return empty in keywords performance report

2018-11-21 Thread yliu
report_downloader = client.GetReportDownloader(version='v201809') # Create report query. report_query = (adwords.ReportQueryBuilder() .Select('Labels') .From('KEYWORDS_PERFORMANCE_REPORT') .Where('CampaignStatus').In('ENABLED', 'PAUSED')

How could I custom a daterange in this script?

2018-11-21 Thread yliu
report_downloader = client.GetReportDownloader(version='v201809') # Create report query. report_query = (adwords.ReportQueryBuilder() .Select('Id,Date') .From('KEYWORDS_PERFORMANCE_REPORT') .Where('CampaignStatus').In('ENABLED', 'PAUSED')

keywords performance report, labels and lableids are empty for some records

2019-01-15 Thread yliu
Hello All, I am not sure if this is an issue: After I fetched records of keywords performance report through API, some records have values in labels and lableids fields and some don't. The business side insist that every record should have a value in labels and lableids. Can someone explain to

Python 2 for google adwords API

2019-04-05 Thread yliu
We are using python 2.7 script to fetch from various google ad reports. The current version of API is V201809. My question is if we still using this API version, do we still need to upgrade python 2 to python 3? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: h

Could not find _DATA_DATE and _LATEST_DATE columns in any reports, where are they?

2019-04-05 Thread yliu
Hello All, Our BI team is trying to add google adwords data in Looker data block, based on the document (https://github.com/llooker/google_adwords), each table (report) should have _DATA_DATE and _LATEST_DATE columns. But I could not find them. Such as Account Performance Report, I could fetch

Is AdWords API still available after deprecated?

2019-04-12 Thread yliu
I am using a Python(3.6) script to fetch google adwords reports through Adwords API (v201809). I know Adwords API will be depreciated soon. I would like to confirm if Adwords API will still be available. Thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog:

sqlite3 module is required for the SqliteCache error when run in AWS Lambda

2019-04-24 Thread yliu
A Python script used to download google adwords report. Which runs without any issue locally. The script is something like: client = adwords.AdWordsClient.LoadFromStorage('googleads.yaml') report_downloader = client.GetReportDownloader(version='v201809') However, when I deploy this in AWS lambd

Based on Customer ID, can we know which account it belongs to?

2018-03-13 Thread yliu
In google adwords, Manager account has controlled a few accounts. Its only provides a customer ID. Is there anyway we could figure out this customer ID belongs to? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot