What is the OtterlyAI Looker Studio Connector?
The OtterlyAI Looker Studio connector lets you pull your AI search visibility data directly into Google Looker Studio. Build custom dashboards, create automated reports, and share AI search performance data with your team or clients, all using the same data you see in OtterlyAI.
Why use it
Connect directly to your OtterlyAI workspace and get live visibility metrics from ChatGPT, Perplexity, Google AI Overviews, AI Mode and more. Create charts and visualizations that match how your team prefers to see data. Share interactive dashboards with stakeholders who don't need an OtterlyAI login.
Before you start
You'll need an active OtterlyAI account with at least one workspace, plus a Google account with access to Looker Studio. The Google Looker Studio Connector is available for Standard, Premium or Custom Enterprise Plans of OtterlyAI.
Setup
Here's a quick video on setting up the Looker Studio Connector with your OtterlyAI account.
Step 1: Access the connector
Head over to your Profile Settings > Integrations. Open the OtterlyAI Looker Studio connector. Make sure you're signed into your Google account.
Step 2: Authorize the connection
Make sure you are logged in to your Google Looker Studio account. You can also create a free account here.
Click "Connect to Looker Studio" in the OtterlyAI integrations tab.
Step 3: Configure your data source
Select which OtterlyAI workspace and Brand Report you want to connect.
Step 4: Connect
Click Connect. The connector will validate your setup and show you the available fields. You do not need to adjust the available fields here. Click Create Report to start with the first Looker Studio report.
Available fields
| Name | Type | Description | Example |
|---|---|---|---|
| Filter Dimensions | |||
| Date | Date (YYYY-MM-DD) | The date for this data point | 2024-01-15 |
| Country | Text | Country code for the data | US, GB, DE |
| Brand Report | Text | Title of the brand report | Q1 Tech Brands |
| Brand Metrics | |||
| Brand Name | Text | Name of the brand being tracked | Nike |
| Brand Coverage | Percent | Percentage of prompts where the brand appeared | 45% |
| Brand Mentions | Number | Total times the brand was mentioned in AI responses | 127 |
| Brand Share of Voice | Percent | Brand share of voice vs competitors | 32% |
| Brand Rank | Number | Average ranking position in AI responses (lower is better) | 2.3 |
| Brand Coverage Rank | Number | Position in the brand coverage leaderboard | 1 |
| Domain Metrics | |||
| Domain Name | Text | Domain associated with the brand | nike.com |
| Domain Coverage | Percent | Percentage of prompts where the domain was cited | 28% |
| Domain Rank | Number | Average ranking position of the domain (lower is better) | 3.5 |
| Citation Metrics | |||
| Citation Name | Text | Domain name being cited in AI responses | wikipedia.org |
| Citations | Number | Number of citations for this domain | 89 |
| Citation Share | Percent | Share of total citations for this domain | 15% |
| Citation Rank | Number | Position in the citation leaderboard | 2 |
| URL Metrics | |||
| Cited URL Name | URL | URL being cited in AI responses | https://example.com/article |
| Cited URL Visits | Number | Number of times this URL was cited | 34 |
Creating your first report
After connecting, click Create Report. Looker Studio opens the editor with your OtterlyAI data ready to use. Add charts, tables, and controls from the toolbar. For visualization options, see Google's chart types documentation.
Looker Studio gives you two options for working with OtterlyAI data. You can build reports from scratch, designing your own visualizations and layouts. You can also add OtterlyAI as a data source to existing reports, combining AI search metrics with your other marketing data.
For a quick start, OtterlyAI includes a pre-built report template. Click "Create Report" after connecting the connector to load the template automatically.
Troubleshooting
Authorization failed: Make sure you're using the correct Google account. Clear your browser cache and try again.
No data appears: Verify you selected the correct workspace. Check that your date range includes dates with tracked data. Loosen any filters you've applied.
Data loading slowly: Reduce your date range or remove unnecessary filters. Large datasets take longer to load.
Wrong workspace data: Double-check your workspace selection in the data source settings. Confirm you have access permissions in OtterlyAI.
Need help?
Email support@otterly.ai with a description of the issue and screenshots if relevant.