Capabilities
Build custom SEO dashboards in Looker Studio
Rankability tracks rankings across Google, Bing, and AI platforms. Looker Studio turns that data into polished, interactive client reports. Connect them through CSV exports, the Rankability API, or a Google Apps Script connector.
Connection methods
Three ways to connect
CSV export
Export keyword data, GSC Explorer data, and Reporter results as CSV files from Rankability. Upload them to Google Sheets and use Sheets as a Looker Studio data source. Best for teams that want a simple, no-code approach with manual refresh.
API + Apps Script connector
Use the Rankability Agent API with a Google Apps Script to pull data on a schedule. Write a lightweight script that queries the Reporter API for SPI scores and keyword rankings, writes them to a Google Sheet, and Looker Studio auto-refreshes from the sheet. Best for automated, recurring reports.
Direct API queries
For advanced setups, build a Looker Studio Community Connector that calls the Rankability API directly. This provides real-time data without an intermediate spreadsheet. Requires developer effort but offers the most flexibility. Rate limits apply per your plan (15–120 req/min).
Data sources
What data you can report on
SPI scores
The Search Performance Index combines visibility across traditional search, AI mentions, and AI citations into a single 0–100 score. Track SPI trends over time in Looker Studio charts to show clients overall brand health.
Keyword rankings by platform
Reporter tracks keywords across Google, Bing, DuckDuckGo, Brave, ChatGPT, AI Overview, AI Mode, Gemini, Perplexity, Grok, and Claude. Export platform-level rankings to build multi-platform visibility dashboards.
GSC performance data
Clicks, impressions, CTR, and average position from the GSC Explorer — up to 50,000 rows. Filter by query, page, device, or country before exporting. Historical data going back 16+ months.
Content production metrics
Track how many articles have been created, their content scores, and completion status across clients. Report on content velocity and quality trends.
Citation Visibility Score
Show clients how often AI platforms cite their brand as a source, with coverage rate and citation impact metrics.
Dashboard layout
Example dashboard layout
A typical Looker Studio dashboard built with Rankability data might include:
| Section | Visualization |
|---|---|
| Overall SPI trend | Time-series line chart |
| Platform breakdown | Stacked bar chart (Google, Bing, AI platforms) |
| Top movers | Table with position change indicators |
| GSC clicks & impressions | Area chart with date range control |
| Content production | Scorecard (articles created, avg score) |
| AI visibility | Gauge chart for Citation Visibility Score |
Technical setup
How to set up the Apps Script connector
Create a Google Apps Script project
Open Google Apps Script (script.google.com) and create a new project. This script will call the Rankability API and write results to a Google Sheet.
Add your API key
Store your rk_live_ API key in the script's Properties Service (Script Properties) for secure access. Never hardcode API keys in the script body.
Write the fetch function
Use UrlFetchApp.fetch() to call Rankability's Reporter API endpoints. Parse the JSON response and write rows to your target Google Sheet. Example endpoints: GET /api/agent/v1/reporter/projects for the project list, GET /api/agent/v1/reporter/projects/:id for SPI data, and GET /api/agent/v1/reporter/projects/:id/trends for historical trend data.
Set a trigger
Add a time-driven trigger (e.g., daily at 6 AM) so the Sheet updates automatically before your team reviews reports.
Connect Sheet to Looker Studio
In Looker Studio, add the Google Sheet as a data source. Build your charts and tables against the columns populated by the script.
"I've used Rankability for just over a year now, and the results and insights it provides are bar-none like anything else. It's easy to use, and rankings are in fact guaranteed to improve with it."
— Seth L., Small-Business Owner · G2
Turn your SEO data into client-ready dashboards
Rankability gives you the data — SPI scores, keyword rankings, GSC metrics, AI visibility. Looker Studio gives you the presentation. Connect them your way.