Developers
Connect Looker Studio
Copy the read-only RankMeFast connector into Apps Script and map stored SEO data into Looker Studio. Agency feature.
Connect Looker Studio
The community-connector source lets an Agency account read data already stored by its own RankMeFast instance. It does not start a check, call a vendor, or consume a usage metric. The existing per-IP and per-key API limits still apply. See the Public API for the underlying HTTP contract.
Before you begin
Ask your operator to enable PUBLIC_EXPORTS_ENABLED. Create an API key under Account → API keys and copy it when it is shown; RankMeFast stores only its SHA-256 digest afterwards. You also need the HTTPS origin of your instance, without /api/v1.
Install and connect
- Create a Google Apps Script project.
- Copy
tools/looker-connector/Code.gsinto the script editor and copyappsscript.jsoninto the manifest editor. - Create a Community Connector test deployment and open it in Looker Studio.
- Enter the API key in Google's separate Key authentication prompt. Never paste it into connector configuration or source code.
- Enter your instance URL, choose a dataset, and enter a 24-character site ID for rank history, SERP features, or backlink rows. The optional engine filter accepts All, Google, Bing, YouTube, or Amazon.
The instance URL is supplied at setup; the committed connector contains no RankMeFast API origin. Rank history uses X-Next-Cursor pages of 10 keyword groups; keywords, SERP features, and backlink rows use pages of 1,000 rows. All stop at 10,000 rows per Looker refresh, and a repeated cursor stops with an error instead of looping. When Looker supplies a date range, its inclusive dates are forwarded on every rank-history page.
Field mappings
| Dataset | API route | Looker field IDs |
|---|---|---|
| Sites | /api/v1/sites | id, domain, url, paused, created_at |
| Rank history | /api/v1/sites/:siteId/rank-history | keyword_id, phrase, engine, checked_at, position, rank_absolute, source, found_url, ai_overview_present, ai_cited, ai_cited_url |
| Keywords | /api/v1/keywords | id, site_id, phrase, location_code, language_code, device, active, created_at, updated_at, latest_position, previous_position, delta, last_checked_at, ai_overview_present, ai_cited, ai_cited_url, track_local_pack, last_failed_check_at, engine, engine_target |
| SERP features | /api/v1/serp-features?siteId=… | id, site_id, keyword_id, engine, checked_at, source, features_json, top_results_json, created_at, source_kind |
| Backlink rows | /api/v1/backlink-rows?siteId=… | id, review_id, site_id, url, domain, spam_score, rubric_band, rubric_version, first_seen, last_seen, dofollow, is_broken, rationale, rationale_status, captured_at, source_kind |
source_kind=provider_observation means the SERP or backlink row is a stored provider observation, not an estimate. features_json and top_results_json remain JSON text. Formula-like text stays neutralized as text.
Troubleshooting and security
A 401 means the key is missing, revoked, or incorrect; 402 means the account is not Agency; 404 means the site is not on that account; 429 means the normal API bucket is full; and 503 means public exports are disabled. Use HTTPS, revoke exposed keys immediately, and create separate Looker data sources for different sites or datasets.
The artifact follows Google's Community Connector build guide, authentication guide, API reference, and manifest reference, retrieved 2026-08-04. Gallery publication and deployment automation are not included.