Skip to first unread message
benjamin...@resolutionmedia.com
Jul 30, 2014, 7:32:05 AM7/30/14
to adwor...@googlegroups.com
Hi everyone.
As I am quite new here in the API community it would be great to get your advise or feedback!
We are managing a bunch of client accounts and would like to find a reporting solution that lets us get the required monthly data in the required format at the push of a button. Was hoping to do this via a Excel Macro. Does anyone have experience trying to use Excel Macros for Reporting via Adwords API?
Also I have a few questions to the API in general:
1. Where can find information about the cost related to using the Adwords API. I know there used to be a small fee involved in each action you take with the API. Has this changed?
2. As I understand it the first step is to apply for a Developer Token and this has to be done at the MCC level.
Can anyone tell me if I use the MCC at the top of a MCC hierarchy...does that allow me access to the API for all the MCCs and accounts underneath this top-level MCC?
Would greatly appreciate any assistance from this community!
For the time being the priority is to use the Adwords API for Reporting purposes in Excel (monthly, weekly, last 4 days).
However I am interested in learning as much as possible about what is possible with the API and hopefully be able to do some more advanced manipulations of ads and bids at a later stage. How much programming knowledge is required to use the API for these purposed? I have some coding background (Java, .Net) but it has been a few years since any serious programming.
Looking forward to your answers!
Kind regards from Zurich,
Ben
As I am quite new here in the API community it would be great to get your advise or feedback!
We are managing a bunch of client accounts and would like to find a reporting solution that lets us get the required monthly data in the required format at the push of a button. Was hoping to do this via a Excel Macro. Does anyone have experience trying to use Excel Macros for Reporting via Adwords API?
Also I have a few questions to the API in general:
1. Where can find information about the cost related to using the Adwords API. I know there used to be a small fee involved in each action you take with the API. Has this changed?
2. As I understand it the first step is to apply for a Developer Token and this has to be done at the MCC level.
Can anyone tell me if I use the MCC at the top of a MCC hierarchy...does that allow me access to the API for all the MCCs and accounts underneath this top-level MCC?
Would greatly appreciate any assistance from this community!
For the time being the priority is to use the Adwords API for Reporting purposes in Excel (monthly, weekly, last 4 days).
However I am interested in learning as much as possible about what is possible with the API and hopefully be able to do some more advanced manipulations of ads and bids at a later stage. How much programming knowledge is required to use the API for these purposed? I have some coding background (Java, .Net) but it has been a few years since any serious programming.
Looking forward to your answers!
Kind regards from Zurich,
Ben
Josh Radcliff (AdWords API Team)
Jul 30, 2014, 10:00:21 AM7/30/14
to adwor...@googlegroups.com
Hi Ben,
I'll let others comment on your question about experience using the API with Excel, but I added answers to your other questions below in blue.
In addition, I recommend starting with the following guides to get an overview of the sign up process and the API.
Cheers,
Josh, AdWords API Team
On Wednesday, July 30, 2014 7:32:05 AM UTC-4, benjamin...@resolutionmedia.com wrote:
Hi everyone.
As I am quite new here in the API community it would be great to get your advise or feedback!
We are managing a bunch of client accounts and would like to find a reporting solution that lets us get the required monthly data in the required format at the push of a button. Was hoping to do this via a Excel Macro. Does anyone have experience trying to use Excel Macros for Reporting via Adwords API?
Also I have a few questions to the API in general:
1. Where can find information about the cost related to using the Adwords API. I know there used to be a small fee involved in each action you take with the API. Has this changed?
Indeed, this has changed -- there's no longer a usage cost for the API. Please see the Rate Sheet for details on the different access levels.
2. As I understand it the first step is to apply for a Developer Token and this has to be done at the MCC level.
Can anyone tell me if I use the MCC at the top of a MCC hierarchy...does that allow me access to the API for all the MCCs and accounts underneath this top-level MCC?
The short answer is: it doesn't make any difference. Although a developer token is associated with an MCC, that is more or less for record-keeping purposes. The developer token on a request has no impact whatsoever on which accounts that request is authorized to access. The authorization portion is handled by the OAuth credentials passed on the request.
In fact, you can use an approved developer token to issue an API request against any AdWords account as long as the OAuth credentials on the request give you access to that account.
Our OAuth 2.0 Authentication guide goes into more detail on this topic.
Would greatly appreciate any assistance from this community!
For the time being the priority is to use the Adwords API for Reporting purposes in Excel (monthly, weekly, last 4 days).
However I am interested in learning as much as possible about what is possible with the API and hopefully be able to do some more advanced manipulations of ads and bids at a later stage. How much programming knowledge is required to use the API for these purposed? I have some coding background (Java, .Net) but it has been a few years since any serious programming.
I definitely suggest using one of our client libraries so you won't have to deal with the complexities of constructing, sending, and receiving SOAP messages. In addition, each library has a set of code examples that should give you an idea of the coding involved in making API calls. For example, the .NET examples are located here.
chris h
Jul 30, 2014, 12:00:52 PM7/30/14
to adwor...@googlegroups.com
Hi Ben,
There are several existing solutions for automating Excel reporting, including Tatvic and my company ShufflePoint. These can provide coverage for your reporting needs and give you some breathing room while you investigate using the API directly. Feel free to contact me (chris AT shufflepoint.com) if you'd like to try our report automation solution.
- Chris
There are several existing solutions for automating Excel reporting, including Tatvic and my company ShufflePoint. These can provide coverage for your reporting needs and give you some breathing room while you investigate using the API directly. Feel free to contact me (chris AT shufflepoint.com) if you'd like to try our report automation solution.
- Chris
Reply all
Reply to author
Forward
0 new messages