AdWords API Re: creative structure report error : BusinessName, BusinessAddress
Hi Eric Email sent Regards, Jeff On Nov 25, 7:22 am, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Jeff, At this point it probably makes sense for me to look at these two campaigns in more detail. Please email the campaign IDs to adwordsapiadvi...@google.com and update this thread after you have done so. Thanks, - Eric On Nov 23, 10:15 pm, Ayup ehupj...@gmail.com wrote: Hi Eric Confirming that there are no deleted campaigns in the account for which the report was successfully run. Regards, Jeff On Nov 24, 8:22 am, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Jeff, Can you ensure that there are no deleted campaigns in the account that have Mobile or Local Business Ads? I believe that having the ads in a deleted campaign would also allow the column to be validated. As for the general functionality, I understand your concern with the current way column validation works. I will pass this information on to the core engineering team for further consideration. Best, - Eric On Nov 22, 7:01 pm, kc karthik.chandrasekha...@gmail.com wrote: Eric Thanks for your reply last week. Unfortunately, your updated assertion still doesn't seem to be correct. I have an example of an account which has only one campaign that owns 2 text ads and does not have an associated MCC attached to it - yet I AM able to successfully request a Creative Structure report for it with both BusinessName and BusinessAddress included in the request message. However, I have other similar accounts for which the request fails. Re your statement The general rule still applies though, which is that you cannot include a column in a report if the account used to schedule that report doesn't include at least one object that returns that column - can I say that, in my opinion, I consider this to be an inappropriate way to provide support for a report. If a report is capable of returning columns 1 thru X then the requestor should ALWAYS be able to ask for any columns regardless of the data circumstances of a particular account. If a column is inappropriate for a particular circumstance then it would be better to simply return a blank value for the column. The Creative Structure report is a prime example of where this behaviour would be far more appropriate - how and why should the requestor know in advance what type of ads have been defined for an account? Given that this report contains the field CreativeType, the requestor should make use of this field to determine whether other columns in the returned report are appropriate or not. Regards, Jeff On Nov 17, 4:17 am, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Jeff, Thank you for doing such thorough testing and for providing a detailed description of your findings. I wasn't aware that Mobile Ads also used the BusinessName column, so my advice about MCC and Local Business Ads wasn't completely accurate for your circumstance. The general rule still applies though, which is that you cannot include a column in a report if the account used to schedule that report doesn't include at least one object that returns that column. For example, let's take the following account structure: MCC: - Account #1 (Has Mobile Ads) - Account #2 (Has No Mobile Ads) If you try to schedule a report using the BusinessName column you'll have the following results: - As Account #1 = SUCCESS - As Account #2 = ERROR - As MCC using clientEmail header for Account #1 = SUCCESS - As MCC using clientEmail header for Account #2 = ERROR - As MCC using no clientEmail header and using crossClient option = SUCCESS Since Account #1 has at least one Mobile Ad it can include this column, but since Account #2 does not have any it will return an error. Using an MCC account with a clientEmail specified is the same as logging in with the Account directly. Using an MCC account with no clientEmail but using the crossClient option works as long as one of the client accounts of the MCC includes a Mobile Ad. As for how to handle this in your application, there are a few possibilities: 1) When scheduling a report, catch the exception about the BusinessName column try to schedule the report again removing that column. 2) Include a dummy, paused Mobile Ad in every account. 3) Schedule all reports from an MCC account that has at least one account with a Mobile Ad. Let me know if you have any other questions. Best, - Eric On Nov 12, 9:53 pm, Ayup ehupj...@gmail.com wrote: Hi Eric I work with Saurabh and thought I'd chip in with some further commentary on this one... Further to your assertion about
AdWords API Re: creative structure report error : BusinessName, BusinessAddress
Hi Eric Confirming that there are no deleted campaigns in the account for which the report was successfully run. Regards, Jeff On Nov 24, 8:22 am, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Jeff, Can you ensure that there are no deleted campaigns in the account that have Mobile or Local Business Ads? I believe that having the ads in a deleted campaign would also allow the column to be validated. As for the general functionality, I understand your concern with the current way column validation works. I will pass this information on to the core engineering team for further consideration. Best, - Eric On Nov 22, 7:01 pm, kc karthik.chandrasekha...@gmail.com wrote: Eric Thanks for your reply last week. Unfortunately, your updated assertion still doesn't seem to be correct. I have an example of an account which has only one campaign that owns 2 text ads and does not have an associated MCC attached to it - yet I AM able to successfully request a Creative Structure report for it with both BusinessName and BusinessAddress included in the request message. However, I have other similar accounts for which the request fails. Re your statement The general rule still applies though, which is that you cannot include a column in a report if the account used to schedule that report doesn't include at least one object that returns that column - can I say that, in my opinion, I consider this to be an inappropriate way to provide support for a report. If a report is capable of returning columns 1 thru X then the requestor should ALWAYS be able to ask for any columns regardless of the data circumstances of a particular account. If a column is inappropriate for a particular circumstance then it would be better to simply return a blank value for the column. The Creative Structure report is a prime example of where this behaviour would be far more appropriate - how and why should the requestor know in advance what type of ads have been defined for an account? Given that this report contains the field CreativeType, the requestor should make use of this field to determine whether other columns in the returned report are appropriate or not. Regards, Jeff On Nov 17, 4:17 am, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Jeff, Thank you for doing such thorough testing and for providing a detailed description of your findings. I wasn't aware that Mobile Ads also used the BusinessName column, so my advice about MCC and Local Business Ads wasn't completely accurate for your circumstance. The general rule still applies though, which is that you cannot include a column in a report if the account used to schedule that report doesn't include at least one object that returns that column. For example, let's take the following account structure: MCC: - Account #1 (Has Mobile Ads) - Account #2 (Has No Mobile Ads) If you try to schedule a report using the BusinessName column you'll have the following results: - As Account #1 = SUCCESS - As Account #2 = ERROR - As MCC using clientEmail header for Account #1 = SUCCESS - As MCC using clientEmail header for Account #2 = ERROR - As MCC using no clientEmail header and using crossClient option = SUCCESS Since Account #1 has at least one Mobile Ad it can include this column, but since Account #2 does not have any it will return an error. Using an MCC account with a clientEmail specified is the same as logging in with the Account directly. Using an MCC account with no clientEmail but using the crossClient option works as long as one of the client accounts of the MCC includes a Mobile Ad. As for how to handle this in your application, there are a few possibilities: 1) When scheduling a report, catch the exception about the BusinessName column try to schedule the report again removing that column. 2) Include a dummy, paused Mobile Ad in every account. 3) Schedule all reports from an MCC account that has at least one account with a Mobile Ad. Let me know if you have any other questions. Best, - Eric On Nov 12, 9:53 pm, Ayup ehupj...@gmail.com wrote: Hi Eric I work with Saurabh and thought I'd chip in with some further commentary on this one... Further to your assertion about an MCC account being a factor in this issue, I have carried out some investigation against a number of client accounts to determine if I can prove this. However, my findings do not lead to this conclusion. The first point to make is that for ALL of the Creative Structure report requests that I have made via the API, I have only ever made use of the username/password login credentials that belong directly to the client account - i.e. I have NOT submitted any requests using an MCC login. However, in some but not all cases, an MCC login has
AdWords API Re: creative structure report error : BusinessName, BusinessAddress
Hi Eric I work with Saurabh and thought I'd chip in with some further commentary on this one... Further to your assertion about an MCC account being a factor in this issue, I have carried out some investigation against a number of client accounts to determine if I can prove this. However, my findings do not lead to this conclusion. The first point to make is that for ALL of the Creative Structure report requests that I have made via the API, I have only ever made use of the username/password login credentials that belong directly to the client account - i.e. I have NOT submitted any requests using an MCC login. However, in some but not all cases, an MCC login has been granted access to the client account. Secondly, in all cases that I have tested, I am confident that there are no Local Business Ads linked directly to any ad groups belonging to the client accounts. Amongst the tests that I have carried out, I have found cases where there is no MCC login linked to the client account, yet the report request has succeeded. As such, I cannot determine what circumstances lead to the report request being successful or not. Hence, I'd appreciate it if you could provide further insight into this problem. On a broader note, it seems that Google has removed support for Local Business Ads from the Adwords UI and that the V2009 API does not support the creation of these ads. This obviously suggests that you are moving support for these ads away from the Adwords product. As such, this makes working around this issue with the Creative Structure report rather difficult - particularly given that we would like to provide support for Mobile Ads, which make use of the BusinessName field when the click-to-call attribute is defined for the ad. I would hope that this problem will be rectified when reporting functionality is added to the V2009 API. Can you advise how we can workaround this in the meantime? Regards, Jeff On Nov 10, 2:53 am, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Saurabh, I believe that reports using BusinessName will succeed if they are scheduled using an MCC account which has at least one client account that has a Local Business Ad. Are you using a different MCC account when scheduling the failed reports? Best, - Eric On Nov 9, 4:10 am, saurabh purnaye saurabh.purn...@gmail.com wrote: Hi Eric, Thanks for your reply. Here is more explanation about my problem, I am trying to retrieve mobile ads from one of my accounts. When only BusinessName is requested, the report request still fails even though I have found from testing other accounts that BusinessName is used when returning data for mobile ads. There are no Local Business or Mobile ads present for the account for which my Creative Structure report getting requested successfully. Could you please help further here? -- Thanks and Regards Saurabh Purnaye +91-9922071155 skype: sorab_pune yahoo gtalk: saurabh.purnaye msn: psaur...@live.com On Nov 3, 10:20 pm, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi Saurabh, Those columns are only valid for accounts with Local Business Ads. If the account doesn't have any Local Business Ads the columns will be rejected. Best, - Eric Koleda, AdWords API Team On Oct 30, 5:52 am, saurabh purnaye saurabh.purn...@gmail.com wrote: Hi, I have two accounts setup for adwords. I am trying to fetch the creative structure report. This is failing with the issue of The following columns are not supported by the Report Type Structure : [BusinessName, BusinessAddress] I have checked with both of the accounts, the setting seems to be same, but one account fails for the fast fetch while other account works well. This is the request I am sending and getting failed ?xml version=1.0 encoding=UTF-8 ? - SOAP-ENV:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema- instance xmlns:SOAP-ENC=http://schemas.xmlsoap.org/soap/encoding/; xmlns:SOAP-ENV=http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; SOAP- ENV:encodingStyle=http://schemas.xmlsoap.org/soap/encoding/; - SOAP-ENV:Header email xsi:type=xsd:stringX/email password xsi:type=xsd:stringX/password useragent xsi:type=xsd:stringTest user agent/useragent developerToken xsi:type=xsd:stringX/ developerToken applicationToken xsi:type=xsd:stringX/ applicationToken /SOAP-ENV:Header - SOAP-ENV:Body - scheduleReportJob - CustomReportJob xmlns=https://adwords.google.com/api/adwords/v13; xsi:type=DefinedReportJob - selectedColumns xsi:type=SOAP-ENC:Array SOAP- ENC:arrayType=xsd:string[19] item xmlns=https://adwords.google.com/api/adwords/v13; xsi:type=xsd:stringCampaignId/item item xmlns=https://adwords.google.com/api/adwords/v13;