Looker Studio Connector
Connect your AI Rankia workspace directly to Google Looker Studio and build interactive dashboards with your AI visibility data — brand rankings, citations, fan-out intelligence, and more.
Quick start
Step 1 — Get your API key
- Log in to your AI Rankia dashboard at app.airankia.com
- Go to Settings → API Keys
- Click Create API Key
- Copy the key (it starts with
airk_)
Step 2 — Connect to Looker Studio
- Click this link to add the connector: Add AI Rankia to Looker Studio
- Click Authorize and grant permissions
- Paste your API key when prompted
- Choose a Dataset (see descriptions below)
- Optionally set a date range
- Click Connect → you'll see the available fields
- Click Create Report to start building
Note: You may see a warning "Google hasn't verified this app." This is normal for community connectors. Click Advanced → Go to AI Rankia (unsafe) to proceed. Your data stays between your browser, Google Apps Script, and the AI Rankia API — nothing is shared with third parties.
Available datasets
The connector offers 6 datasets, each designed for different dashboard use cases:
Brand Rankings (recommended)
Best for scorecards, summary tables, and bar charts. Shows one row per brand per prompt with aggregated visibility scores. Includes rank, coverage percentage, visibility score, total mentions, and which AI models mentioned the brand (GPT-5, Gemini, Claude, Perplexity, Google AI Mode, Google AI Overview, Grok).
Brand Rankings Detail
Same data as Brand Rankings but with one row per brand per prompt per date. Use this for time-series line charts and trend analysis — track how visibility scores change over time. Larger dataset, so use date filters for faster loading.
Brand Project Overview
One row per brand project with aggregated metrics across all that brand's prompts. Great for executive dashboards and brand comparison scorecards. Smallest dataset — loads fastest. Shows average visibility, average coverage, average position, total mentions, and models present.
Citation Domains
Shows which website domains each AI model cites when answering your monitored prompts. Broken down by LLM name. Use for citation analysis dashboards — see which domains are winning in AI search and which models cite them.
Citation URLs
Same as Citation Domains but at the individual URL level with page titles. Use for content performance analysis — find exactly which pages are being cited by AI models and how often.
Fan-Out Intelligence
Shows the sub-queries that each AI model generates internally when processing your monitored prompts. This reveals what the AI is actually searching for behind the scenes. Broken down by LLM name. Use for keyword discovery and content gap analysis.
Field reference
Common fields across datasets
- Prompt — The monitored prompt text
- Target Brand — The brand being tracked
- Country — Country or location of the prompt
- Intent — Prompt intent classification
- First Seen / Last Seen — Date range when the brand appeared in AI results
Metrics
- Rank — Visibility ranking (1 = most visible, ties get same rank)
- Visibility Score — Composite score: 60% coverage + 40% mention share (shown as percentage)
- Coverage — Percentage of AI models that mentioned the brand
- Total Mentions — Raw count of mentions across all models and dates
- Models Present — Number of distinct AI models that mentioned the brand
Per-model columns
Each dataset includes boolean columns for individual AI models: GPT-5 Web Search, Gemini Search, Claude Search, Perplexity Sonar, Google AI Mode, Google AI Overview, and Grok Web Search. These are useful for filtering by specific model in Looker Studio.
Tips for building dashboards
Start with Brand Project Overview if you want a quick executive dashboard — it has the fewest rows and loads instantly.
Use date filters in the connector configuration (Date From / Date To fields) to limit data volume. This dramatically speeds up loading for the Detail, Citation, and Fan-Out datasets.
Data caches for 10 minutes — if you refresh a dashboard multiple times within 10 minutes, it uses cached data instead of hitting the API again. To force a refresh, edit the data source and reconnect.
Combine multiple datasets in one Looker Studio report by adding the AI Rankia connector multiple times, each with a different dataset selected. For example, use Brand Rankings for the overview section and Citation Domains for the citation analysis section.
Filter by your brand using the "Is Target Brand" field (set to TRUE) to focus only on your tracked brand and exclude competitor rows.
Troubleshooting
"Invalid credentials" error Your API key may have expired or been regenerated. Go to app.airankia.com → Settings → API Keys, create a new key, then edit the data source in Looker Studio and re-enter the key.
Dashboard loading slowly Use the Date From / Date To filters to limit the date range. Citation URLs and Brand Rankings Detail are the largest datasets — start with Brand Project Overview or Brand Rankings for faster loading.
"Script exceeded maximum execution time" This can happen with very large workspaces (100K+ rows). The connector will return whatever data it has loaded so far. Use date filters to reduce the data volume.
Data looks stale Data caches for 10 minutes. Wait for the cache to expire, or edit the data source and reconnect to force a fresh pull.
API rate limits and quotas
The connector runs on Google Apps Script, which has the following limits:
- 20,000 API calls per day (gmail.com accounts) / 100,000 per day (Google Workspace accounts)
- 6-minute execution timeout per request — the connector has a built-in safety guard that returns partial data at 4 minutes instead of crashing
- 1,000 simultaneous executions across all users of the connector
- Data caches for 10 minutes to reduce API load
For most workspaces (under 50,000 rows per dataset), these limits are more than sufficient.
Privacy and data handling
AI Rankia is a product of Ideacharge LLC. When you use this connector:
- Your API key is stored securely in Google Apps Script's UserProperties (per-user, encrypted by Google)
- Data flows from the AI Rankia API → Google Apps Script → Looker Studio. No third parties are involved.
- Looker Studio never stores your API key — it only asks the connector if credentials are valid
- We do not access, store, or process your Google account data beyond what's needed to authenticate the connector
- You can revoke access at any time from Looker Studio → Data Sources → Revoke Access
For our full privacy policy, visit airankia.com/privacy-policy.
For terms of service, visit airankia.com/terms-of-service.
Need help?
- Email: [email protected]
- Chat: Use the chat widget at airankia.com
- Dashboard: app.airankia.com