AI Visibility Data in Looker Studio

Connect your AI visibility data to Google Looker Studio for custom dashboards and reports.

TL;DR

Generate a personal API key in your account settings, set up the Looker Studio Community Connector (or use the JSON connector), and enter your API key. Your AI visibility data — including visibility scores, mention counts, and sentiment analysis from ChatGPT, Gemini, Perplexity, and Claude — will be available as a Looker Studio data source for custom dashboards.

Table of Contents
  1. What is the Looker Studio Integration?
  2. Prerequisites
  3. Step-by-Step Guide
    1. Generate an API Key
    2. Set up the Connector
    3. Connect your Data
  4. Available Data Fields
  5. API Reference
  6. Connector Script Download
  7. FAQ

What is the Looker Studio Integration?

The Looker Studio integration lets you import your AI visibility monitoring data into Google Looker Studio (formerly Google Data Studio). This enables you to:

  • Build custom dashboards tailored to your reporting needs
  • Combine AI visibility data with other marketing data sources
  • Share interactive reports with your team or clients
  • Set up automated email reports with scheduled delivery
  • Visualize trends across different AI platforms over time

Each user accesses only their own data through a personal API key. Your data is never shared with other users.

Prerequisites

  • An active AI Visibility Tool account (any plan)
  • At least one topic area with completed analysis results
  • A Google account with access to Looker Studio

Step-by-Step Guide

Step 1: Generate an API Key

  1. Log in to your AI Visibility Tool account.
  2. Click on your email address in the top-right menu.
  3. Select "API Keys" from the dropdown menu under "Integrations".
  4. Click "Create API Key" and give it a descriptive name (e.g. "Looker Studio").
  5. Copy the API key immediately — it will only be shown once.
Important: The API key is displayed only once after creation. Store it securely. If you lose it, you will need to create a new key.

Your API key starts with the prefix avt_ followed by 48 characters. You can have up to 3 active API keys at the same time.

Step 2: Set up the Connector

There are two ways to connect your data to Looker Studio:

Option A: Community Connector (Recommended)
  1. Download the Connector Script (see below).
  2. Go to script.google.com and create a new project.
  3. Paste the connector script code into the editor.
  4. Update the API_BASE_URL variable to your deployment URL.
  5. Deploy the script: Click "Deploy" → "New deployment" → Type: "Add-on" → Deploy.
  6. Copy the deployment ID for use in Looker Studio.
Option B: JSON Connector (No Script Required)
  1. Open Looker Studio and click "Create" → "Data Source".
  2. Search for the "JSON" or "Custom JSON/CSV" connector.
  3. Enter the API URL: https://your-domain.com/api/v1/looker/data
  4. Add the Authorization header: Authorization: Bearer YOUR_API_KEY
  5. Configure date parameters as needed.

Step 3: Connect your Data

  1. In Looker Studio, click "Create" → "Data Source".
  2. Select your connector (Community Connector or JSON connector).
  3. Enter your API key when prompted.
  4. Click "Connect" — the available fields will be loaded automatically.
  5. Click "Create Report" to start building your dashboard.
Tip: Start with a date range chart and a table showing visibility scores by AI system to get a quick overview of your data.

Available Data Fields

The following dimensions and metrics are available in Looker Studio:

Dimensions

Field Type Description
date Date The date when the analysis was performed (YYYY-MM-DD)
topic_area Text Name of the topic area (selection) being monitored
prompt Text The prompt text sent to the AI system
category Text Category assigned to the prompt
funnel_stage Text Marketing funnel stage (e.g. Awareness, Consideration, Decision)
ai_system Text The AI platform queried (e.g. ChatGPT, Gemini, Perplexity, Claude)
brand Text The brand being tracked for mentions

Metrics

Field Type Description
visibility_score Number Overall visibility score (0–100) for the brand in the AI response
mention_count Number Number of times the brand was mentioned in the AI response
position_score Number Position ranking score — higher values indicate earlier mentions
sentiment_score Number Sentiment score from -1 (negative) to +1 (positive)
web_search_used Boolean Whether the AI system used web search to generate the response

API Reference

The REST API uses your personal API key for authentication. All endpoints return JSON.

Authentication

Include your API key in every request using one of these methods:

  • Header (recommended): Authorization: Bearer avt_your_key_here
  • Query parameter: ?api_key=avt_your_key_here

Endpoints

GET /api/v1/looker/schema

Returns the schema (field definitions) for the data source.

Example Request:

curl -H "Authorization: Bearer avt_your_key_here" \
  https://your-domain.com/api/v1/looker/schema
GET /api/v1/looker/data

Returns the actual visibility data. Supports filtering and pagination.

Parameters:

Parameter Type Description
date_from String Start date (YYYY-MM-DD)
date_to String End date (YYYY-MM-DD)
selection_id Integer Filter by topic area ID
ai_system String Filter by AI system (e.g. chatgpt, gemini, perplexity, claude)
limit Integer Number of records to return (default: 1000)
offset Integer Number of records to skip (default: 0)

Example Request:

curl -H "Authorization: Bearer avt_your_key_here" \
  "https://your-domain.com/api/v1/looker/data?date_from=2025-01-01&date_to=2025-01-31&limit=500"
GET /api/v1/looker/selections

Returns a list of your topic areas (selections) with their IDs. Use these IDs to filter data requests.

Example Request:

curl -H "Authorization: Bearer avt_your_key_here" \
  https://your-domain.com/api/v1/looker/selections

Rate limit: The API allows up to 100 requests per minute per API key. Looker Studio caches data automatically, so this limit is rarely reached during normal usage.

Connector Script Download

Download the Google Apps Script file for the Community Connector:

Download Connector Script (connector.gs)

After downloading, open the file in a text editor, update the API_BASE_URL, then paste the code into a new Google Apps Script project.

FAQ

The Looker Studio integration is available on all plans, including the free plan. Every user can generate API keys and connect their data to Looker Studio.

No. Each API key is tied to your personal account. The API only returns data from your own topic areas and analysis results. There is no way to access another user's data.

You can have up to 3 active API keys at the same time. You can delete unused keys and create new ones at any time.

API keys are shown only once upon creation for security reasons. If you lose a key, delete it from your API Keys page and create a new one. Then update the key in your Looker Studio data source configuration.

Looker Studio fetches fresh data from the API each time a report is opened or refreshed. You can also configure Looker Studio's data freshness settings. The underlying AI visibility data is updated whenever you run new analyses in the tool.

Make sure your API key is correct and still active. Check the API Keys page in your account to verify the key status. If the key has been deleted or deactivated, create a new one and update it in your Looker Studio connector settings.

Yes. The REST API is a standard JSON API that works with any tool that can send HTTP requests — including Excel, Google Sheets, Power BI, Tableau, Python scripts, and more.
Back to Documentation