Set up requirements
You’ll need your API key and domain ID, if you don’t have these details reach out to the Adthena Support Team at support@adthena.com.
Each Domain will have a separate API key, so if you have multiple domains or locations please ensure you include this in your request.
To see what kind of reports can be built using the connector, take a look at out Looker Demo Dashboard Overview linked here.
Step-by-step guide
*We recommend setting the data credentials to viewer's rather than owner's for any Adthena API data sources - this can help improve report performance
- Create a new dashboard in Looker, or open an existing one where you’d like to add Adthena data to
- Add a new data source, by using the Adthena connector:
-
Input your Account ID and API Key
-
Select the dataset - which refers to the part of the application you’d like to source data from, like Market Share or Top Ads. In this view, you also need to choose your API endpoint, which narrows down the data. In this example, we’re sourcing Market Trends data for Share of Clicks.
-
Configure your advanced filtering options settings. We recommend ticking the 'Enable advanced filtering options' box to ensure you can filter by search term group, competitor etc. Select default options like total device, Whole Market View, specific search term groups or ad type. Regardless of which default you select, you will still be able to change the filtering later within the parameters, but having an appropriate default will save you time if you’re always interested in a specific set of filters.
- Done! Click on connect, that’s your data source added. Repeat these steps for all datasets you want to use.
-
Now you can simply add charts and graphs, and select your added datasets to build the visualizations:
-
Your dashboard can be filtered by the parameters mentioned before:
Just add the relevant values and hit enter to filter for a specific competitor, group, or any other option:
What data is available?
- Market Trends or Segmented Market Trends
-
- Share of clicks
- Share of spend
- Share of impressions
- Avg. position
- Avg. CPC
- Frequency
- Market Share (all data available in the market share table in-app) or Segmented Market Share
- Market Share for Groups and Locations - returns data available in the market share table in-app for all search term groups and all locations (if applicable)
- Search Term Detail (all data available in search term detail table in-app) or Segmented Search Term Detail
- Search Term Opportunities
-
- All
- Missing brand terms
- New terms
- Missing organic terms
- Low-cost terms
- Not in Google Ads
- Underperforming Google Ads
- Top Ads (all data available in top ads view)
- Google Shopping (all data available in Google Shopping view)
- Infringements (all data available in infringements view in-app)
- Brand Activator - Daily Savings (savings data for Brand Activator, by keyword and date) & Activity Logs (the activity log from the platform)
Segmented Market Share/Trends/Search Term Detail vs Market Share/Trends/Search Term Detail
The Market Trends and Share endpoints provide the same view as in the Adthena platform - you can filter by a search term group or multiple search term groups, and see the data combined for all groups selected.
When you connect these API endpoints, and then input multiple Search Term Groups into the parameter, you will receive aggregated data.
The Segmented API endpoints provide an opportunity to break the data down by group instead - so once you select multiple groups for these endpoints, you will be able to see your market share and other metrics in each group separately, in one view, like below:
The regular Market Trends/Share endpoint data can be filtered by a group or groups, but not segmented by them. The segmented endpoint allows segmentation, but you shouldn't try to create a total/aggregated view from the segments. You can use both endpoints if you'd like to see the totals and the breakdowns in different ways.
Data segmentation & filtering
When considering what’s possible, refer to the view in-app. It might be helpful to visualize your data in a table to consider how it can be used in your dashboard or combined with other data.
Examples of segmentation/aggregation incompatibility:
- If you try to pull in Top Ads as a total device view, it won’t work, as the breakdown in-app is mobile or desktop. You can combine the data for both in Looker after, but when pulling it in you need to keep in mind the segmentation of data in each section you are selecting.
- If you select search term detail and try to segment it by date in Looker, it won’t work, as the search term detail table is segmented by search term.