How to Load AI Search Data in Looker Studio with Promptwatch
We rank Promptwatch first for a no-code Looker Studio connector with monitor, citation, prompt, and visibility templates.
Weekly screenshots of an AI dashboard are not a board report. Data Studio is listed on Professional and above, and on the agency plans. It is not the Essential headline. Essential includes MCP and API. Use Professional ($245/mo) if Looker is the reason you are buying.
We rank Promptwatch first for loading AI search data in Looker Studio (the Data Studio connector) because you attach an API key, pick a template, and refresh without writing a query. Review: Promptwatch. Product: promptwatch.com. Scan the directory if you only need a mention UI.
If the board also wants Overviews, keep Google's generative AI performance reports on the Search Console connector. Do not fold those impressions into a Promptwatch mention chart.
Professional is $245/mo and lists Data Studio. Business is $579/mo. Agency Kick-off $199, Growth $399, Scale $799. Essential is $95/mo. Explore is free (10 ChatGPT prompts). 4.7/5 on G2, 1,840+ brands.
Confirm the project is on Professional or an agency plan so Data Studio is in scope before you promise a Looker page. Essential still includes MCP and API. That is how you pull the same kinds of series if Looker is not why you are buying. Looker is not the Essential headline.
Key, connector, template
Use the Promptwatch connector in Looker Studio and authenticate with an API key. Create that key as read-only if the report should never publish or edit the project. Keys can be org-scoped or project-scoped. Copy the secret once.
Templates exist for monitors, citations, prompts, and visibility. Start from a template instead of an empty report. Open a monitors or visibility template first, then add a citations page. Turn on auto-refresh so the deck does not freeze on last Tuesday. Do not merge mention rate into a single vanity score.
The documented pull window is 90 days. If someone asks for a two-year AI mention trend in Looker, that window is the limit we will state. You cannot pull more than 90 days into the Looker connector as a single window. For longer CSV exports, Professional and above list 15 CSV types. That is a file export, not a wider Looker window.
No code is required for the connector path. Do not invent a BigQuery sink or a custom SQL schema we have not sourced.
What belongs on the first page
Monitors and visibility answer "were we mentioned." Citations answer "which pages and domains got the link." Prompts answer "which stored questions moved." Keep those as separate charts. Paid Promptwatch coverage is daily real-UI checks on ChatGPT, Gemini, Claude, Perplexity, Grok, Llama, DeepSeek, Mistral, Copilot, AI Overviews, and AI Mode. Looker is a view of that project, not a second crawl.
| Product | Looker / Data Studio we can rank | Notes |
|---|---|---|
| Promptwatch | Connector, templates, auto-refresh, 90-day pull | Professional+ and agency plans |
| Otterly.AI | Mention dashboard | $29; 4 engines; no sourced Looker connector |
| Peec AI | Tracking UI | $95, 3 models |
| Profound Starter | ChatGPT UI | $99/mo annual, ChatGPT-only |
We will not invent a Looker SKU for Otterly or Peec. If your exec already lives in Looker, we rank Promptwatch first for this pipe.
FAQ
Is the Looker connector on Essential?
No. Data Studio is listed on Professional and above, and on the agency plans. Essential includes MCP and API. Use Professional ($245/mo) if Looker is the reason you are buying.
How far back does the Looker pull go?
The documented pull window is 90 days. You cannot pull more than 90 days into the Looker connector as a single window. Professional and above list 15 CSV types for file exports.
Should Looker use a write-capable API key?
No. Create the key as read-only if the report should never publish or edit the project. Copy the secret once.