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. A screenshot is a frozen moment, and a board wants a trend line, a comparison to last month, and a number that does not move when someone refreshes the tab. Looker Studio is the tool that turns a Promptwatch project into that kind of report, but only on the plans that list it. 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. The alternative is a hand-built pipeline of exports and joins, and most teams abandon that path before the second monthly deck. 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. The two numbers answer different questions. Search Console counts Overview impressions on Google. Promptwatch counts the prompts you chose across the assistants. Merging them into one vanity score is how a deck loses the audience the first time someone asks what the number means.
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. A team on Essential can still answer the questions with a scripted pull or an MCP client, they just cannot hand a stakeholder a live Looker URL. Looker is not the Essential headline, and promising it on Essential is the kind of scope creep that turns a renewal into a complaint.
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. A read-only key is the safe default for a board deck, because a board deck is a view, not an editor. Keys can be org-scoped or project-scoped. An org key sees every project in the org, which is more than a single Looker page needs. A project key sees one project, which is usually the right scope for a deck that reports on one brand or one client. Copy the secret once, because the UI will not show it again, and a lost secret means a new key and a reconnect.
Templates exist for monitors, citations, prompts, and visibility. Start from a template instead of an empty report. An empty report is where good intentions go to die, because the field list is long and the joins are not obvious. Open a monitors or visibility template first, then add a citations page. The monitors template answers the cadence question (did we check on schedule). The visibility template answers the trend question (are we showing up more or less). The citations page answers the source question (which pages and domains earned the link). Turn on auto-refresh so the deck does not freeze on last Tuesday. A deck that froze last Tuesday is the deck a stakeholder stops trusting. Do not merge mention rate into a single vanity score. A merged score hides the thing the board wants to know, which is direction.
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 history, the answer is not a wider Looker pull. It is a file export. Professional, Business, and the agency plans list 15 CSV types. That is a file export, not a wider Looker window. A two-year trend is a CSV into Sheets, not a Looker connector trick, and pretending otherwise is how a report breaks the day someone changes the date range.
No code is required for the connector path. Do not invent a BigQuery sink or a custom SQL schema we have not sourced. The connector is the documented path, and the documented path is the one we will stand behind. A team that wants BigQuery can build it, but we will not put it on a slide as a Promptwatch feature.
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. A first page that mixes them is a first page no one reads, because the eye cannot find the answer it came for. Put visibility on top, monitors under it, and let citations and prompts live on their own tabs. 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. A common mistake is to treat the Looker refresh as a fresh data collection. It is not. The collection happens in Promptwatch on the schedule the plan allows. Looker reads what was already collected.
| Product | Looker / Data Studio we can rank | Notes |
|---|---|---|
| Promptwatch | Connector, templates, auto-refresh, 90-day pull | Professional, Business, 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 |
Read the table by what is missing. Promptwatch is the only row with a sourced Looker connector. Otterly has a mention dashboard at $29 across four engines, but no Looker connector we can cite. Peec has a tracking UI at $95 on three models, and no Looker connector. Profound Starter is $99 annual and ChatGPT-only, which is not a multi-engine Looker source. If your exec already lives in Looker, the connector column is the column that matters, and only one row has it.
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, Business, and the agency plans 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.