Looker Studio Connector
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.
Ready-made templates (fastest way)
You don't have to build anything: there are two ready-made dashboards. Both use the same connector and the same API key.
In AI Rankia go to MCPs โ API & Looker Studio (or open app.airankia.com โบ MCPs), click Create my Looker key, then Create
my dashboard on the template you want. Looker asks you to authorize the AI Rankia connector: paste your key, click Save
and share, and the dashboard is yours with your data.
1. AI Visibility report
How AI engines talk about your brand: visibility, citations and fan-out across 7 engines (ChatGPT, Gemini, Claude,
Perplexity, Grok, Google AI Mode and AI Overviews). See the live demo.
Overview โ KPIs, AI share of voice, your visibility per AI engine and the brand ranking.
AI Visibility report ยท Overview
Trends โ visibility per day and the Market Demand quadrant (Google brand searches vs AI visibility).
AI Visibility report ยท Trends
Citations โ the domains and URLs AI cites, with their share, split by engine.
AI Visibility report ยท Citations
Fan-out โ the searches each AI runs behind your prompts.
AI Visibility report ยท Fan-out
2. Content report
Your AI Rankia Content work and its results: articles published, Semantic Score, schema, Google indexing, topical map
and Search Console clicks and impressions. Every article title is a link that opens the article inside AI Rankia. Search
Console must be connected in Content for clicks and impressions. See the live demo.
Overview โ articles published, average Semantic Score, clicks, impressions, words written, schema, indexing and average
Google position.
Content report ยท Overview
Articles โ every article with its Semantic Score, schema, Google indexing and Search Console results, plus Semantic
Score vs impressions.
Content report ยท Articles
Results โ average impressions and clicks per article by week since publishing, top articles and the Google searches that
bring traffic.
Content report ยท Results
Schema & technical โ structured data added per page and the Google indexing status of each article (problems first).
Content report ยท Schema & technical
Topical map โ coverage of your topical map by pillar and a log of everything done.
Content report ยท Topical map
Build your own (blank report)
Quick start
Step 1 โ Get your API key
1. Log in to your AI Rankia dashboard at app.airankia.com
2. Go to MCPs โ API & Looker Studio
3. Click Create my Looker key
4. Copy the key (it starts with airk_)
Step 2 โ Connect to Looker Studio
1. Click this link to add the connector: Add AI Rankia to Looker Studio
2. Click Authorize and grant permissions
3. Paste your API key when prompted
4. Choose a Dataset (see descriptions below)
5. Optionally set a date range
6. Click Connect โ you'll see the available fields
7. 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 AI visibility datasets and 6 Content 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.
Content ยท Articles
One row per article: status, publish date, words, pillar and cluster, Semantic Score (the same number the app shows, %
of the SERP leader) and its change since the first analysis, schema, Google indexing, Search Console clicks, impressions
and average position, and Open in AI Rankia / Article (link) to open the article in the platform.
Content ยท Article Performance
Search Console per article per day, with days and weeks since publishing. Use it for trends and before/after publishing
charts.
Content ยท Article Queries
The Google searches each article appears for, with clicks, impressions, CTR and average position.
Content ยท Schema Report
One row per page: structured data types before and after, new types added, issues fixed and validation results.
Content ยท Activity Log
Everything done and when: articles written and published, semantic analyses, schema fixes and Autopilot actions.
Content ยท Topical Map
Your topical map: pillar, cluster, topic, keyword, search volume and coverage (planned, covered, published by us).
Avg. Position and CTR are calculated fields weighted by impressions, like Search Console. Fields without data (e.g. the
Semantic Score of an article never analyzed) are empty, not 0.
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