Looker Studio integration & configuration guide

Set up requirements

You’ll need your API key and domain ID, if you don’t have these details reach out to 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.

Step by step guide

1. Create a new dashboard in Looker, or open an existing one where you’d like to add Adthena data to 
2. Add a new data source, by using the Adthena connector:

4. Input your Account ID and API Key
5. 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. 
6. 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. 
7. Done! Click on connect, that’s your data source added. Repeat these steps for all datasets you want to use.
8. Now you can simply add charts and graphs, and select your added datasets to build the visualizations:
9. 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?

1. Market Trends

• • Share of clicks
  • Share of spend
  • Share of impressions
  • Avg. position
  • Avg. CPC

2. Market Share (all data available in the market share table in-app 
3. Search Term Detail (all data available in search term detail table in-app)
4. Search Term Ops 

• • All
  • Missing brand terms
  • New terms
  • Missing organic terms
  • Low-cost terms 
  • Not in Google Ads
  • Underperforming Google Ads

5. Top Ads (all data available in top ads view)
6. Google Shopping (coming soon)
7. Infringements (all data available in infringements view in-app)

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: 

1. 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. 
2. 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.