Adthena has a RESTful API service that allows users to programmatically request their account data at scale.
To use the API you will need an API Key, which can be requested by contacting Adthena Support.
Why should I use the API service to request data?
Anyone receiving regular reports will be familiar with the following processes:
a) log into the application, load each of the pages you have bookmarked, export the data, open each CSV and do something with the data
b) set up Scheduled Reports to be emailed to you daily / weekly / monthly, open each CSV and do something with the data
Both options are fine for a handful of standard reports or if you are pulling data monthly. But if you want to do this more regularly or want to pull a large number of reports, then it will quickly become an arduous task. Receiving reports via our API service provides a faster, easier way to migrate data and with greater flexibility, since you're able to further customise the reports.
Use cases / examples:
- You want Market Trends data for a list of 12 (rather than 10) competitors
- You have 20 Search Term Groups, one for each product category (TVs, Mens Clothing, etc. or Compact Cars, Saloon Cars, etc.) and you want to pull a Market Share report every week for every group of terms, and put this data into 20 worksheets in an Excel workbook
- You want to add Market Trends Share of Clicks, Share of Spend, Average Position and Frequency charts to an internal dashboard for non-Adthena users to have visibility
- You want to pull a filtered Market Share report each month, then for each competitor in this report request a monthly Search Term Detail report and aggregate these into one CSV
- You want to see any adverts containing a '$' from a selection of competitors to track over time how your direct competitors are changing offers and prices in their ad copy over time
- You want to pull Search Term Opportunities directly into a Google Sheet so that you can use a Google Script to automatically add them to you Adwords account
This list could literally have an infinite number of other examples. If you have an idea and you are unsure of how it could be accomplished then let us know so that we can discuss it with you.
I am not technical, where do I start?
If you have a developer to work on this with you then the best thing to do is think about what you are trying to achieve and ignore how it would be done. If your end goal is to have a Market Trends widget in Tableau next to you Adwords, Google Analytics and Internal BI data then think about the date range it would show and the different filters you would want applied.
Once you have a clear idea, then show your developer the export from Adthena that matches your requirements along with the Technical API Documentation on how to make calls the the API service.
VBA script to pull data into Excel [External website]