Looker Studio Integration
Plug Rank.ai data
into Looker Studio
Pull national rank, geo-grid, AI Rank, reviews, and citations into any Looker Studio dashboard. Built for agencies that hand a fresh report to every client, every week.
What you get
A live, read-only data pipe from Rank.ai into the reporting tool your clients already trust.
Five Datasets, One Connector
National rank, geo-grid, AI Rank, reviews, and citations — every metric you track inside Rank.ai surfaces as a tidy Looker Studio data source.
Built for Agency Reporting
Drop the connector into a templated client report, hand the link to your account team, and stop hand-screenshotting dashboards every Friday.
Read-Only API Keys
Each integration gets its own scoped looker:read key. Revoke any key with one click — your write-tier MCP credentials stay untouched.
Live, Not Exported
Looker Studio refreshes hit our API directly. No CSV exports, no stale snapshots — every dashboard reflects the same data your team sees in-app.
Setup in four steps
Allow about ten minutes the first time. Subsequent clients are a copy-paste of the deployment ID.
Step 1
Mint a Looker Studio API key
Sign in to Rank.ai and create a read-only key scoped to the looker:read permission.
- Open Account → API Keys → Connect Looker Studio in the Rank.ai dashboard.
- Give the key a label (we suggest 'Looker Studio — Q1 2026 reports') and click Generate.
- Copy the rnk_live_… token shown on the next screen — Rank.ai never displays it again.
Step 2
Deploy the Apps Script connector
Create a new Apps Script project, paste in our Code.gs file, and deploy it as a Looker Studio Community Connector.
- Go to script.google.com → New project. Name it 'Rank.ai Looker Connector'.
- Paste the contents of Code.gs from our GitHub repo into the editor and add an appsscript.json manifest pointing at /api/v1/looker.
- Choose Deploy → New deployment → Looker Studio community connector and copy the Deployment ID.
Step 3
Add the connector to a Looker Studio report
Inside Looker Studio, paste your Deployment ID, authorize the connector, and pick the dataset you want to chart.
- In Looker Studio click Create → Data source and search 'Build with developer ID'.
- Paste your Deployment ID and authorize the connector to call rank.ai on your behalf.
- Select the dataset (national_rank, geo_grid, ai_rank, reviews, or citations) and hit Connect.
Step 4
Build dashboards your clients love
Drag fields onto a canvas, add filters, share the report with your client. Refreshes hit Rank.ai live — no manual exports.
- Each dataset returns a flat row shape, so any chart type — time-series, geo map, scorecard, table — works out of the box.
- Use Looker Studio's date-range control to scope a chart to 'Last 30 days', 'Last quarter', or any custom window up to 365 days.
- Share with stakeholders the same way you share any Looker Studio report; the API key stays inside the connector.
The Apps Script source lives in our GitHub repo at docs/integrations/looker-studio/Code.gs.
FAQ
Which datasets are available?
Five today: national_rank (daily SERP positions), geo_grid (per-cell ranks for each scan), ai_rank (one row per provider × prompt × sample), reviews (per-review sentiment + topics), and citations (current per-directory listing state).
Is the connector listed in the Looker Studio gallery?
Not yet — Phase 1 ships the backend API and the open-source Apps Script. Phase 2 publishes the connector to Google's Community Connector gallery so it's a one-click add.
What permissions does the API key have?
looker:read only. The key cannot trigger audits, write articles, or modify any data — it's strictly read-only to the org you minted it from.
Are there rate limits?
Yes — 200 requests per hour per key, 365-day max date range per request, and 10,000 rows per page (paginate via the next_offset field). Most agency dashboards never approach these caps.
Can I share a connector across team members?
Yes. Looker Studio reports are shared per-report, and the API key lives inside the connector. We recommend one key per agency client, labeled accordingly.
Ready to Improve
Your Rankings?
Use our free tools to get instant insights into your SEO performance and discover opportunities to rank higher