API connection between Oracle and Adwords

[Ketida]

Hi there

I need your advice because I'm not a technical guy.

We actually use a intern tool to manage our client orders, invoices, etc. The platform is developed in Oracle, Apex, Javascript,.. 

Everything is managed manually which means that every months we input real costs spend in Adwords (via an Agency MCC) by our clients (amount that Google charges us and that we then charge to our client). The objective will then to add more metrics (conversions, CPA,...) but the priority is the media spend (not the costs but well the invoice spend). 

Period time frame : last month.

Is someone have more documentation about the process, which variables we have to call, which repetition, etc ? It will be really appreciate :)

Thanks in advance for your advice/support

K

[Michael Cloonan (AdWords API Team)]

Hello,

You can fetch statistics from the AdWords API using reporting. For example, the Campaign Performance Report has statistics like clicks, impressions, and conversions broken down at the campaign level. Here is a page indexing all of the available report types: https://developers.google.com/adwords/api/docs/appendix/reports

The reporting basics guide, linked above, will go into details on how to filter, for example by last month or a custom time frame. There are also examples of how to run reports in each client library.

Regards,

Mike, AdWords API Team

[KM]

Hi Michael

Thanks for your reply. I had a check, really useful. The field "costs" in the reporting is not really what I need. What we are looking for is to have the billing cost and not the costs mentioned in campaign report. 

Do you see what I means ?

Many thanks

Kevin

[Michael Cloonan (AdWords API Team)]

Hello,

The API doesn't support billing costs. There is no way, for example, to look up transactions or owed amounts. The best you can do is look up costs incurred by specific campaigns, ad groups, etc over a period of time, as you've found.

Regards,

Mike, AdWords API Team