Looker Studio Connector

The Trakkr Looker Studio connector lets you pull live visibility data into Google Looker Studio. Build dashboards, schedule refreshes, and share reports with stakeholders - all from your existing Trakkr data.

Requirements

Before you start, make sure you have:

• A Scale plan subscription (the connector is gated to Scale)
• A Trakkr API key (generate one from the Looker Studio integration page or API keys settings)
• At least one brand set up in Trakkr
• A Google account with access to Looker Studio

Setup

1. Generate an API key

Each team member connects with their own key. Go to the Looker Studio integration page and click Generate API key. Copy the key immediately - it is only fully visible once.

2. Open the connector

Click Open in Looker Studio from the integration page. This launches the Trakkr connector directly in Looker Studio.

3. Authenticate

Paste your Trakkr API key when prompted. The connector validates it against the Trakkr API. If the key is invalid or expired, you will see an error - generate a new one from the integration page.

4. Choose a brand and dataset

The connector shows a two-step configuration:

1. 1Brand - Select from all brands you have access to in Trakkr
2. 2Dataset - Pick one of the 11 available datasets (see below)

For time-scoped datasets, Looker Studio's native date range picker controls the time window (7 to 365 days).

5. Create your report

Click Create Report to build charts. Looker Studio maps Trakkr fields to dimensions and metrics automatically. You can create multiple data sources (one per dataset) and combine them in a single report.

Available datasets

The connector exposes 11 datasets organized into four groups.

Visibility

Visibility over time - Daily visibility and presence scores for your brand across all tracked AI models.

• Fields: date, visibility score, presence score, average rank, mentions, models mentioned
• Use for: Trend lines, weekly/monthly comparison charts

Visibility by AI model - Scores broken down per AI model (ChatGPT, Perplexity, Gemini, Claude, etc.).

• Fields: model name, visibility score, presence score, trend direction
• Use for: Model comparison bar charts, heatmaps

Visibility by prompt - Scores per individual tracked query.

• Fields: prompt ID, prompt text, visibility score, presence score, average rank
• Use for: Per-query performance tables, worst-performing prompt identification

Citations

Citation list - Every citation URL with metadata.

• Fields: URL, domain, page title, source type, search model, mentions brand, sentiment, appearance count, first seen, last seen, competitors
• Use for: Detailed citation tables, source exploration
• Note: Paginated (up to 5,000 rows)

Citation analytics - Top cited domains and their share.

• Fields: domain, times cited, unique pages, citation share percentage, source type
• Use for: Pie charts, treemaps, domain leaderboards

Citations by AI model - Citation counts broken down per model.

• Fields: model, total citations, brand mentions, unique sources
• Use for: Model-level citation comparison

Competition

Competitive rankings - Competitor leaderboard with visibility scores.

• Fields: rank, competitor name, visibility score, visibility change, is your brand, head-to-head win rate
• Use for: Ranking tables, competitive position charts

Competitor heatmap - Brand-by-model visibility grid.

• Fields: brand name, model, visibility score, average rank, mentions, is your brand
• Use for: Cross-tabulation heatmaps, model-specific competitive analysis

Perception and prompts

Perception metrics - 20+ perception dimension scores over time.

• Fields: date, overall score, trust, reliability, transparency, safety, quality, innovation, value, customer service, sustainability, expertise, accuracy, comprehensiveness, timeliness, objectivity, technical depth, accessibility, thought leadership, data support, uniqueness
• Use for: Perception radar charts, trust/quality trend lines

Model performance - How each AI model performs for your brand.

• Fields: model, total queries, mentions, visibility rate, average position, top-3 rate
• Use for: Model efficiency comparisons, mention rate charts

Prompts - Your tracked search queries and metadata.

• Fields: prompt ID, text, active status, focus area, intent, created date
• Use for: Prompt inventory tables, coverage analysis

Building effective dashboards

Recommended first report

Start with Visibility over time. Add a time series chart with date on the X-axis and visibility score on the Y-axis. This confirms the connector, date handling, and aggregation all work correctly.

Combining datasets

Create separate data sources for each dataset you need, then add them all to one report. For example:

• Page 1: Visibility over time + Visibility by AI model
• Page 2: Citation analytics + Citations by AI model
• Page 3: Competitive rankings + Competitor heatmap
• Page 4: Perception metrics

Date ranges

Time-scoped datasets respect Looker Studio's date range control. Add a date range filter to your report and users can adjust the window dynamically. The connector maps it to a 7-365 day API parameter.

Sharing reports

Looker Studio reports can be shared with anyone who has a Google account. Viewers do not need Trakkr access - the data is fetched through the connector owner's API key.

Managing your connection

Refreshing fields

If the connector is updated with new fields, open your data source in Looker Studio and click Refresh Fields to pick up changes.

Rotating your API key

If you regenerate your API key in Trakkr, existing Looker Studio data sources will stop working. Edit each data source and re-enter the new key.

Teammate access

Each person needs their own API key. Brand access is determined by Trakkr permissions, not by the key. A teammate who can see a brand in Trakkr can see it in the connector.

Troubleshooting

"Access denied" errors - Your API key may be expired or regenerated. Generate a new one in Trakkr and update it in the Looker Studio data source.

Fields look stale or missing - Click Refresh Fields in the data source editor in Looker Studio.

Google shows an unverified app warning - This is expected for community connectors. Click Advanced and continue. The warning is about Google's OAuth review, not your data safety.

Rate limit errors - The API allows 60 requests per minute. If you have many data sources refreshing simultaneously, stagger their schedules or reduce the number of concurrent sources.

Empty data - Check that your brand has active prompts and recent research data. The connector returns what the API returns - if there is no data in Trakkr, there is nothing to show.