Re: How to import report data in Power BI?

Thanks Sai - that's the guidance I was after! Cheers, Tom On Tuesday, 28 May 2019 22:25:45 UTC+1, adsapiforumadvisor wrote: > > Hello Tom, > > If you don't want to use the client libraries, you can download the > reports via Ui or can use CURL or SOAP requests to make the APi call as > shown

How to import report data in Power BI?

Hi everyone, I'd like to include data from some basic reports from the AdWords API in a Power BI dashboard. However, I'm not clear if it's possible to query the API directly, without any of the client libraries? Cheers, Tom -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us

Re: Automated Rules In Adwords API

Old thread, but still a worthwhile feature request I think. My main use case is so that I can *disable* automated rules via the API, to make sure those rules don't conflict with the automations I've built using the API. At the moment the only way to do this is to manually check every account...

Re: How to get ACCOUNT_PERFORMANCE_REPORT for manager account?

Hi Dannison, Thanks for explaining the way the ACCOUNT_PERFORMANCE_REPORT works (I understand you could segment the account, but it still seems like funny behaviour to me - most people who want account-level metrics are going to be comparing across accounts, rather than looking for a single

How to get ACCOUNT_PERFORMANCE_REPORT for manager account?

Hi there, I'm trying to pull an account performance report for all the accounts we manage. I'm querying the API using the Python library, using this type of code: def getMyAccounts(client): # Initialize appropriate service. report_downloader =

Re: How to trigger policy violation error?

Thanks Sreelakshmi - that does the trick - exactly what I needed! Cheers, Tom On Tuesday, 20 November 2018 19:37:20 UTC, Sreelakshmi Sasidharan (AdWords API Team) wrote: > > Hi Tom, > > I was able to trigger a policy error while adding "combat knife" as a > keyword in my test account. This

How to trigger policy violation error?

Hi everyone, I'm trying to add some error handling to our scripts for when a policy violation error occurs. I want to trigger such an error so that I can find out how to pull out the various elements of the error message. I've tried to trigger the error by adding a reserved keyword to a test

Handling policy errors

Hi everyone, My script has fallen foul of PolicyViolationError.POLICY_ERROR for attempting to create a new keyword that contained a sensitive word (suggested by the Targeting Idea Service!) In the GUI these trigger words are flagged for you, but then you can 'upload & request exemption'. Is a

Re: How can I get account status?

Hi Luis, We had a number of accounts deactivated by Google over the weekend. I was surprised to find that they continue to be returned by the ManagedCustomerService, although they are not active accounts. I've also found that we've continued to harvest performance reports for those accounts,

Re: How can I get account status?

Thanks Luis, That's reassuring. Just to confirm: is it only accounts inactive in the circumstances described in the blog i.e. no spend for 15 months that would not be returned, or is it the case that ManagedCustomerService will only return active accounts? So any account that's inactive

Re: How can I get account status?

Thanks Luis, That's a shame. What about the ManagedCustomerService? When I query my accounts through e.g. your account hierarchy script ( https://github.com/googleads/googleads-python-lib/blob/master/examples/adwords/v201809/account_management/get_account_hierarchy.py) it seems that all

Re: How can I get account status?

Further to my own question: how does the Keywords Performance Report treat suspended accounts? In my experience it sometimes throws a CUSTOMER_NOT_ACTIVE error - but sometimes accepts the query - and comes back reporting 0 impressions etc. for all campaigns/ad groups/keywords... On Tuesday,

How can I get account status?

Hi everyone, I want to get account status from the API i.e. is it active, or has it been suspended, cancelled etc. It seems that CustomerService or ManagedCustomerService only return active accounts - can anyone confirm if that's the case? Cheers, Tom -- --

Re: Severe rate limiting when running the python example

Hi Cameron, I've raised exactly this issue with the API team before - sometimes I get rate limited before I get *any* results. The only workaround I've found is, as the team have suggested here, by adding error handling logic to wait 30 seconds before retrying and just keep on hitting the API

Re: TargetingIdeaService Request - Python - INVALID SEARCH PARAMETERS

But it looks like you've forgotten to pass googleads.yaml to the script at all. The penultimate line should be adwords_client = adwords.AdWordsClient.LoadFromStorage("googleads.yaml") # or whatever the right path is Let me know if you have any luck with this. I can interface with the

Re: Unable to edit AdWords Express campaigns

Thanks Peter, that's exactly what I needed to know! Cheers and all the best, Tom On Wednesday, 3 October 2018 05:11:01 UTC+1, Peter Oliquino (AdWords API Team) wrote: > > Hi Tom, > > When using the CampaignService >

Re: Unable to edit AdWords Express campaigns

Thanks Peter, How do I flag such campaigns as read only so that my script doesn't try to change them? What attribute do I need to look at to identify AdWords Express campaigns? Is this information available in any of the reports, or is this something I have to record offline somewhere?

Unable to edit AdWords Express campaigns

Hi everyone, For one client of mine, my attempts to change keyword status via the API fail with the error MUTATE_ACTION_NOT_PERMITTED_FOR_CLIENT. Apparently this is because the client's account contains a campaign created with AdWords Express (

Re: Keyword Performance Report missing keywords

Hi Bharani, Apologies for the delay in responding - I've been away - and thanks for your reply. When your guidance says: > The values returned will always reflect the current state of the account, > ignoring the timespan of the report. > I had taken this to mean that if the attribute value

Keyword Performance Report missing keywords

Hi everyone, I am accessing the Keyword Performance Report via the API (in Python3, using the standard libraries) and I'm making two separate requests, one to bring back a list of all my active (/enabled/eligible) keywords, and another to pull performance data for those keywords. I do this

Re: Empty result set from TargetingIdeaService

P.S. in case it's not clear, I'm trying to use the service to generate keyword suggestions (I'm not interested in traffic stats, although I try to pull them as well) On Wednesday, 19 September 2018 18:20:04 UTC+1, tom.wa...@raisingit.com wrote: > > Hi everyone, > > I'm trying to use the

Empty result set from TargetingIdeaService

Hi everyone, I'm trying to use the targeting idea service in Python using a batch of seed keywords. Sometimes, depending on the seed keywords I use, it simply returns an empty result set - it doesn't throw any errors, there simply are no suggestions. *Can anyone explain this behaviour, and

Re: How to change keyword status via the Python libraries

Hi Milind, That's fixed it - works as expected now - thank you! Cheers, Tom On Friday, August 31, 2018 at 9:21:46 PM UTC+1, Milind Sankeshware (AdWords API Team) wrote: > > Hi Tom, > > To change the keyword status, you will need to set the UserStatus >

How to change keyword status via the Python libraries

Hi community, I am struggling to work out how to change keyword status via the Google Ads API using the Python library. I have no problem pausing and enabling AdGroups, or adding new keywords, but there is no exact model for this in the sample code, and my alterations are not working as

Re: URL data missing in response from query to AdGroupAdService

It's okay - found my answer. Thanks for all your help Milind. In case useful for others: *Caution:* Expanded text ads do not use url , displayUrl

Re: URL data missing in response from query to AdGroupAdService

Thanks so much Milind, it worked! Are url and displayUrl deprecated? What circumstances (if any) do they still work in? Cheers, Tom On Monday, 23 July 2018 20:52:32 UTC+1, Milind Sankeshware (AdWords API Team) wrote: > > Hi Tom, > > To get finalUrl >

URL data missing in response from query to AdGroupAdService

Hi everyone, I'm trying to get data on expanded text ads in existing ad groups via an AWQL query to the AdGroupAdService. It successfully pulls back most data: headlines, descriptions etc. but all the URL fields are missing (in the Python library I'm using, that is None or an empty list, []).

Re: How to fix "RateExceededError rateName=RATE_LIMIT" with test API token?

Good stuff - thanks Peter! On Thursday, 19 July 2018 11:25:18 UTC+1, Peter Oliquino (AdWords API Team) wrote: > > Hi Tom, > > Below are my answers to the points you mentioned : > > 1. For this particular scenario, yes, the developerToken access level > would not matter. > 2. Yes, this is across

Re: How to fix "RateExceededError rateName=RATE_LIMIT" with test API token?

Hello Peter, Thanks for your reply on this. Just to confirm my understanding: - the rate limits are the same for the test token as for the production token, so this problem won't solve itself. - the error is triggered by general traffic to that service, not just my account (which

How to fix "RateExceededError rateName=RATE_LIMIT" with test API token?

Hello everyone, I am experimenting with the Adwords API with a test token, using the Python googleads library v201806. I want to test generating keyword ideas with the TargetingIdeaService and I'm using the example code get_keyword_ideas.py from here: