Google Looker Studio Integration

What is Looker Studio?

For users who may not be familiar with it: Google Looker Studio (formerly Data Studio) is a free tool by Google that lets you create interactive dashboards and reports from your data. With the Tedi integration, you can visualize your AI Brand Monitor tool data - like brand visibility, sentiment, top sources, and more - in beautiful, shareable reports for your customers, executives, or team.

Prerequisites

Before you start, make sure you have:

A Tedi account

You need an active account on dashboard.evergreens.ai.

At least one project

You should have at least one AI Brand Monitor project set up in your Tedi Dashboard, or admin access.

A Google account

The same Google account you’ll use for Looker Studio.

Step 1: Connect Google Looker Studio in Tedi Dashboard

First, you need to connect your Google account to Tedi so Looker Studio can access your data.

Please consider: Tedi uses a centralized component system for all integrations. You first connect third-party services (like Google Looker Studio) globally in the Integrations component. Then, within each tool - such as AI Brand Monitor - you configure the specific settings and data you want to pull. This keeps your connections organized and reusable across the entire Tedi Ecosystem.For example, once connected, you can access Looker Studio data from both Tedi Chat and AI Brand Monitor - our goal is to provide you with the best user experience possible and a scalable architecture for the future.

Open the Integrations page

Go to dashboard.evergreens.ai/integrations/google-looker-studio.

Click Connect

Click the Connect button.

A Google sign-in window will appear. Sign in with the same Google account you use for Looker Studio.

Grant permissions

Allow Tedi to access your account. This is needed so Looker Studio can identify you.

Done!

You should see a success message. Your Google account is now linked.

If you use multiple Google accounts, make sure you connect the same account you’ll use in Looker Studio.

Step 2: Open the Tedi Connector in Looker Studio

Now you can add Tedi as a data source in Looker Studio.

Open the Project Settings

Go to your project settings in the AI Brand Monitor tool at dashboard.evergreens.ai/tools/peec-ai/settings.

Navigate to Data Aggregation

Scroll down to find the “Data Aggregation” section on the settings page.

Want more data connectors? We’re actively working on adding support for Microsoft Power BI, Tableau, and other platforms. Let us know which connectors you’d like to see next - your feedback helps shape our roadmap! Contact Adnan or reach out via Slack.

Connect Google Looker Studio

In the “Google Looker Studio” area, click the “Connect” button. This will open the Tedi connector in Looker Studio.

Authorize the connector

Looker Studio will show the Tedi connector by Evergreen Media. Click “Authorise” to allow the connector to access your data.

If you see a warning that the connector “has not been verified”, this is normal for internal company connectors. Click “Authorise” to continue.

Grant Google permissions

A second authorization window may appear asking for permissions. Click “Allow” to continue.

Step 3: Select Your Project and Data Type

After authorization, you’ll see the connector configuration screen.

Select a Project

Open the Project dropdown and choose the AI Brand Monitor project you want to visualize.

Select a Data Type

Open the Data Type dropdown and choose what kind of data you want:

Data Type	What it shows
Brand Performance	Per-day, per-brand, per-topic, per-tag breakdown. Best for flexible exploration with Topic/Tag dimensions. Percentages are pre-computed per bucket and aggregated via `AVG` in Looker may differ from the Tedi dashboard by a few percentage points.
Brand Visibility Daily	Per-day, per-brand, per-topic, per-platform raw numerator / denominator counters. Build percentages as `SUM(num) / SUM(den)` calculated fields to reproduce the Tedi Overview dashboard EXACTLY (1:1 parity). No Tag breakdown.
Top Sources (legacy)	Per-day source rows with URL, domain, topic and citation counts
Top Domains	Domain-level table matching the dashboard Sources > Domains view (Retrieved %, Retrieval Rate, Citation Rate)
Top URLs	URL-level table matching the dashboard Sources > URLs view (Retrievals, Citation Rate, Brand Mentioned)
Prompts Metrics	Performance data for each tracked prompt/question

Click CONNECT

Click the blue “CONNECT” button in the top right corner.

You can add multiple data sources to the same report. For example, add Brand Performance for charts and Top Sources for a table - all in one dashboard.

Step 4: Create Your Report

After connecting, Looker Studio will show you the available data fields.

Review the fields

You’ll see a list of dimensions (like Brand, Date, Source) and metrics (like Visibility, Chats, Citations). These are the data points you can use in your charts.

Click Create Report

Click “Create Report” to start building your dashboard. Or click “Explore” to quickly browse your data.

Add charts and tables

Use Looker Studio’s drag-and-drop editor to add charts, tables, scorecards, and filters. Some ideas:

Line chart: Brand visibility over time (X = Date, Y = Visibility %, Breakdown = Brand)
Bar chart / Table: Top brand rankings (Dimension = Brand, Metric = Visibility %, sorted descending)
Bar chart: Top sources by citations
Scorecard: Total chats this month
Table: All prompts with Visibility, Sentiment, Position
Pie chart: Share of voice across brands

Add Filter controls for Topic and Tags so viewers can slice the dashboard.

Available Data Fields

Brand Performance

Used for the Visibility line chart and Brand Rankings views.

Field	Type	Description
Date	Dimension	Date of the data point
Project Name	Dimension	Name of your Tedi project
Brand	Dimension	The brand being tracked
Topic	Dimension	Topic of the prompt (e.g. `Branded`, `Non-Branded`). `null` if the prompt has no topic.
Tag	Dimension	Tag of the prompt. Prompts with multiple tags appear once per tag; prompts without tags have `Tag = null`.
Visibility %	Metric	% of AI chats mentioning the brand (0–100), recomputed per (Topic, Tag) bucket
Visibility Δ	Metric	Change in visibility vs. previous day (same Topic, Tag)
Share of Voice %	Metric	Brand’s share of mentions among all tracked brands (0–100), recomputed per (Topic, Tag) bucket
Share of Voice Δ	Metric	Change in share of voice vs. previous day (same Topic, Tag)
Sentiment	Metric	Sentiment score (0–100, higher is more positive)
Sentiment Δ	Metric	Change in sentiment vs. previous day (same Topic, Tag)
Average Position	Metric	Average position in AI responses (lower is better)
Position Δ	Metric	Change in position vs. previous day (same Topic, Tag)
Mention Count	Metric	Number of times the brand was mentioned
Chats	Metric	Number of AI chats/responses analyzed

Each row is per (Date, Brand, Topic, Tag). Visibility, Share of Voice, Sentiment and Position are recomputed inside each (Topic, Tag) bucket matching exactly what the Tedi dashboard shows when you apply the same Topic/Tag filter. Add Topic and Tag to the Filter section of your chart, bind them to filter controls on the canvas, or drop them straight into Dimensions for full breakdowns.

Visibility / SOV / Sentiment / Position default to AVG aggregation, so when you drop them into a chart Looker automatically averages across the multiplied tag rows multi-tag prompts no longer inflate the numbers. You can switch the aggregation in the chart’s Metric badge (AVG → MAX, MIN, SUM, …) if you need a different view.

Multi-tag prompts duplicate the underlying Chats / Mention Count. Those two metrics default to SUM, so a prompt tagged with three tags contributes its chats three times when Tag is in Dimensions.

For correct project-wide chat totals: remove Tag from Dimensions (group by Brand only) each prompt is then counted once.
Or set the Metric badge to COUNT_DISTINCT / AVG if appropriate.
Visibility / SOV / Sentiment / Position are safe (default AVG).

For exact daily values matching the Tedi dashboard: add both Date and Brand as dimensions in your table. Looker then shows the raw daily values with no re-aggregation. If you only group by Brand (no Date), Looker averages the daily ratios across the period the result will be very close to but not byte-identical with the dashboard’s period KPI (typically within 0.5%).

Delta fields (Visibility Δ, Sentiment Δ, …) are day-over-day, not period-over-period. They will not match the percentage arrows in the Tedi dashboard (which compare the selected period vs. the previous period). For a matching period-over-period column in Looker:

Add the base metric (e.g. Visibility %) without the delta.
In the chart’s right panel, set “Vergleichsdatumsbereich” / “Comparison date range” to “Vorheriger Zeitraum” / “Previous period”.
Looker auto-renders a % Δ column matching the dashboard logic.

Brand Visibility Daily (matches Tedi Dashboard 1:1)

Use this data source whenever you need a KPI scorecard that must match the Tedi Overview dashboard exactly. It returns raw integer counters instead of pre-computed percentages, so Looker can re-aggregate them correctly when you slice by date, topic or platform.

Field	Type	Description
Date	Dimension	Date of the data point
Project Name	Dimension	Name of your Tedi project
Brand	Dimension	The tracked brand. Every chart MUST filter to one brand.
Topic	Dimension	Topic of the prompt (e.g. `Branded`, `Non-Branded`). `null` if no topic.
Platform	Dimension	AI platform / model that ran the chat (e.g. `chatgpt`, `ai-mode`)
Chats With Brand	Metric	Numerator for Visibility chats in the bucket where the brand was mentioned
Total Chats	Metric	Denominator for Visibility total successful chats in the bucket (repeats per brand row)
Brand Mentions	Metric	Numerator for Share of Voice brand-mention rows for this brand
Total Mentions	Metric	Denominator for Share of Voice mention rows across all brands (repeats per brand row)
Sentiment Sum	Metric	Sum of sentiment scores for this brand’s mentions
Sentiment Count	Metric	Count of non-null sentiment scores
Position Sum	Metric	Sum of per-chat `MIN(position)` for this brand
Position Count	Metric	Count of per-chat positions contributing to Position Sum

Calculated fields copy/paste into Looker Studio

Create these as Berechnete Felder on the data source. They reproduce the Tedi dashboard math exactly (chat-weighted ratio over the period). Visibility %

SUM(chats_with_brand) / SUM(total_chats) * 100

Share of Voice %

SUM(brand_mentions) / SUM(total_mentions) * 100

Sentiment (0–100, higher = more positive)

SUM(sentiment_sum) / SUM(sentiment_n)

Avg Position (lower = better)

SUM(position_sum) / SUM(position_n)

Total Chats and Total Mentions REPEAT across brand rows for the same (Date, Topic, Platform) bucket. If you forget to filter to one brand, the denominator inflates by the number of brands and Visibility falls to approximately 1 / num_brands (e.g. ~9 % with 11 brands).Fix: every chart using these calculated fields must have a Brand filter (chart-level or page-level), or the brand baked into the formula:

SUM(CASE WHEN brand = "Livv" THEN chats_with_brand ELSE 0 END)
/
SUM(CASE WHEN brand = "Livv" THEN total_chats ELSE 0 END)
* 100

or just use filters..

No Tag dimension here. Tags are many-to-many with prompts; adding them as a row dimension would explode the denominator and break SUM/SUM math. For tag-level breakdowns use Brand Performance instead (accepting that its percentages aggregate via AVG and may differ by a few percentage points).

Recommended layout: put a Brand Visibility Daily scorecard with Visibility % at the top of your report (one per KPI) for the headline number that matches Tedi exactly. Below that, use Brand Performance charts for trends and Topic / Tag breakdowns.

Top Sources (legacy)

Field	Type	Description
Date	Dimension	Date of the data point
Project Name	Dimension	Name of your Tedi project
URL	Dimension	Full URL of the source
Source: Domain	Dimension	Domain name of the source (e.g. `example.com`)
Source Type	Dimension	Type of source (news, repository, social, …)
Topic	Dimension	Topic associated with this source
Tags	Dimension	Comma-separated list of tags
AI Platforms	Dimension	AI platforms that cited this source
Citations	Metric	Number of distinct chats that cited this source (safe to SUM)
Used in % of Chats	Metric	% of all AI chats in the period that cited this domain/URL (0–100)
Avg. Citations per Appearance	Metric	Average `citation_count` when this source appears in a chat

Top Sources is a legacy data type. Use Top Domains and Top URLs instead for 1:1 parity with the dashboard Sources page.

Top Domains

Mirrors the Sources → Domains table in the Tedi dashboard exactly. Each row is one domain aggregated over the selected date range.

Field	Type	Description
Project Name	Dimension	Name of your Tedi project
Domain	Dimension	Domain name (e.g. `reddit.com`)
Domain Type	Dimension	Source classification: `UGC`, `Editorial`, `Corporate`, `You`, `Competitor`, …
Retrieved %	Metric	% of all AI chats where this domain appeared matches dashboard Retrieved %
Retrieval Rate	Metric	Avg. unique URLs from this domain per chat (> 1 = AI pulls multiple pages)
Citation Rate	Metric	Avg. citations per chat that used this domain matches dashboard Citation Rate
Total Retrievals	Metric	Total number of chats that cited this domain (safe to SUM)
Total Citations	Metric	Total `citation_count` across all appearances (safe to SUM)

Retrieved %, Retrieval Rate and Citation Rate are averages never sums. If you group by Domain only (no sub-dimensions), these fields are already correctly aggregated per row, so no re-aggregation is needed. If Looker shows a SUM badge next to one of them, change it to AVG.

Top 10 Domains table: dimension = Domain, metrics = Retrieved % + Retrieval Rate + Citation Rate, sort by Retrieved % descending, rows per page = 10. This matches the dashboard Sources Domains view exactly.

Top URLs

Mirrors the Sources → URLs table in the Tedi dashboard exactly. Each row is one URL aggregated over the selected date range.

Field	Type	Description
Project Name	Dimension	Name of your Tedi project
URL	Dimension	Full URL of the source
Page Title	Dimension	Title of the page
Domain	Dimension	Domain extracted from the URL
Domain Type	Dimension	Domain classification: `UGC`, `Editorial`, `Corporate`, …
URL Type	Dimension	URL classification: `Listicle`, `Article`, `Forum`, …
Own Brand Mentioned	Dimension	`Yes` / `No` whether your own brand appears in chats that cite this URL
Retrievals	Metric	Number of chats that cited this URL matches dashboard Retrievals (safe to SUM)
Citation Rate	Metric	Avg. citations per chat that used this URL matches dashboard Citation Rate

Citation Rate is an average not a sum. If Looker shows SUM next to it, change it to AVG.

Top 10 URLs table: dimension = URL (optionally also Domain + Own Brand Mentioned), metric = Retrievals (SUM), sort descending, rows per page = 10.

Prompts Metrics

Used for the Prompts table view, shows per-prompt performance for the tracked own brand.

Field	Type	Description
Date	Dimension	Date of the data point
Project Name	Dimension	Name of your Tedi project
Prompt	Dimension	Full prompt/question text
Brand	Dimension	The own brand being tracked for this prompt
Topic	Dimension	Topic assigned to the prompt (e.g. `Branded`, `Non-Branded`)
Tags	Dimension	Comma-separated list of tags assigned to the prompt
Status	Dimension	Prompt status (`active`, `paused`, …)
AI Platform	Dimension	AI platform (ChatGPT, Perplexity, Gemini, …)
Visibility %	Metric	Visibility score for this prompt (0–100)
Sentiment	Metric	Sentiment score for this prompt (0–100)
Average Position	Metric	Average brand position for this prompt
Response Volume	Metric	Number of AI responses for this prompt

Adding Date Filters

The Tedi connector supports date range filtering. To add a date filter to your report:

Click “Add a control” in the Looker Studio toolbar
Select “Date range control”
Place it on your report
Now report viewers can filter all charts by date range

Filtering by Topic, Tag & Platform

Topic, Tag and Platform are exposed as real dimensions (depending on the data source), so all native Looker Studio filter UX works out of the box.

Field	Brand Performance	Brand Visibility Daily
`Topic`	✅	✅
`Tag`	✅	❌ (would break SUM/SUM math)
`Platform`	❌	✅

Use case	What to do
Break down a table	Drag `Topic` / `Tag` / `Platform` into the chart’s Dimension section
Filter one chart	Chart properties → Filter → + Add a filter → field = `Topic` / `Tag` / `Platform` / `Brand`, condition = `Equal to (=)`, value = the exact name
Page-level filter dropdown	Toolbar → Add a control → Drop-down list → bind it to the field viewers can then pick values themselves
Page-level filter input box	Toolbar → Add a control → Input box useful for free-text matches

Names are case-sensitive and must match exactly what you see in your Tedi project (Topics page / Prompt Tags). Selecting multiple values in a drop-down acts as OR (e.g. Payroll, HR → rows tagged with either).

Visibility, SOV, Sentiment and Position are recomputed per (Topic, Tag) bucket. Whatever Topic/Tag combination you filter to in Looker will produce metrics that match the Tedi dashboard’s own Topic/Tag filter denominators are scoped to the filtered prompt set.

Multi-tag prompts can double-count in Chats / Mention Count. A prompt with three tags appears in three rows. Summing across tag rows over-counts the chats. To get exact project totals, remove Tag from your chart’s Dimensions (or switch the metric to AVG).

Once your dashboard is ready, you can share it with your team:

Click the “Share” button (top right)
Add email addresses of people you want to share with
Choose “Viewer” or “Editor” access
Click “Send”

People you share with do not need a Tedi account to view the report. They only need a Google account.

Refreshing Data

Looker Studio automatically refreshes data when the report is opened. You can also:

Click the refresh icon in the toolbar to manually refresh
Set up scheduled email delivery to automatically send report snapshots

Data is cached for 5 minutes for performance. If you just made changes in Tedi Dashboard, wait a few minutes and refresh.

Troubleshooting

I see 'Could not load projects' error

This means your Google account is not connected in Tedi Dashboard.Fix: Go to dashboard.evergreens.ai/integrations/google-looker-studio and connect your Google account.

I see 'No projects found' error

This means your Tedi account doesn’t have any AI Brand Monitor projects yet.Fix: Create a project in your Tedi Dashboard first, then try again.

The Project dropdown is empty

I get 'Bad Request Error 400' when authorizing

This can happen if you’re signed into multiple Google accounts.Fix: Open the connector link in an Incognito/Private window and sign in with only your work Google account.

I get redirect loops or 'too many redirects'

This is caused by multiple Google accounts conflicting.Fix: Open an Incognito/Private window, sign in with just one Google account, and try again.

My data looks outdated

To protect our infrastructure and ensure fast performance, data is cached for 5 minutes. Click the refresh icon in Looker Studio’s toolbar or wait a few minutes.

My Brand Visibility Daily scorecard shows ~9 % or ~23 % instead of the real number

This is the denominator-inflation bug the most common Brand Visibility Daily mistake.Cause: Total Chats and Total Mentions REPEAT across every brand row for the same (Date, Topic, Platform) bucket. If your chart doesn’t filter to one specific brand, the denominator sums across all tracked brands and your percentage falls to roughly 1 / num_brands (e.g. ~9 % with 11 brands).Fix pick one of these:

Chart-level filter: chart properties → Filter section → add Brand = Livv (exact spelling, case-sensitive). Verify the filter chip appears after saving it sometimes silently fails to attach.
Page-level filter control: toolbar → Add a control → Drop-down list → bind to Brand, set default = your brand name.

Bake the brand into the formula (immune to forgotten filters):

SUM(CASE WHEN brand = "Livv" THEN chats_with_brand ELSE 0 END)
/
SUM(CASE WHEN brand = "Livv" THEN total_chats ELSE 0 END)
* 100

Verify: drag a temporary Table onto the canvas with Dimension = Brand and Metric = Visibility %. Every row should show that brand’s correct percentage. If they all show ~9 %, the formula or aggregation is set wrong; if your brand’s row shows the right number, the original scorecard just needs the filter applied.

My Topic / Tag filter returns no data

Topic and Tag values are matched exactly (case-sensitive). Common causes:

Typo or wrong casing. branded ≠ Branded. Copy the name from the Tedi dashboard (Topics page or Prompt Tags) to be safe.
Stale cache after editing. Data is cached for 5 minutes change the filter, click the refresh icon, and wait up to a minute.
Wrong project selected. The names exist in a different project than the one you connected.
Looking at null? Prompts with no topic (or no tag) produce rows with Topic = null / Tag = null. Filter to null to see only those, or exclude null to hide them.

My `Chats` total is too high after adding `Tag`

Prompts with multiple tags appear once per tag so summing Chats or Mention Count across tag rows double-counts those prompts.Fix: remove Tag from the chart Dimensions (group by Brand only) to get the correct project-wide total. Visibility / SOV / Sentiment / Position are unaffected they’re recomputed inside each bucket.

I need help

Contact Adnan at adnan.ali@evergreen.media and we’ll help you get set up, or write Adnan a message in Slack.

Documentation Index

​What is Looker Studio?

​Prerequisites

​Step 1: Connect Google Looker Studio in Tedi Dashboard

​Step 2: Open the Tedi Connector in Looker Studio

​Step 3: Select Your Project and Data Type

​Step 4: Create Your Report

​Available Data Fields

​Brand Performance

​Brand Visibility Daily (matches Tedi Dashboard 1:1)

​Calculated fields copy/paste into Looker Studio

​Top Sources (legacy)

​Top Domains

​Top URLs

​Prompts Metrics

​Adding Date Filters

​Filtering by Topic, Tag & Platform

​Sharing Your Report

​Refreshing Data

​Troubleshooting

What is Looker Studio?

Prerequisites

Step 1: Connect Google Looker Studio in Tedi Dashboard

Step 2: Open the Tedi Connector in Looker Studio

Step 3: Select Your Project and Data Type

Step 4: Create Your Report

Available Data Fields

Brand Performance

Brand Visibility Daily (matches Tedi Dashboard 1:1)

Calculated fields copy/paste into Looker Studio

Top Sources (legacy)

Top Domains

Top URLs

Prompts Metrics

Adding Date Filters

Filtering by Topic, Tag & Platform

Sharing Your Report

Refreshing Data

Troubleshooting