Summary

Scrunch AI offers a Looker Studio Community Connector that existing Scrunch customers can install to access their Scrunch data.

The connector exposes the standard Scrunch metrics: brand presence, position, and sentiment. Additionally, competitor presence metrics are available. Full documentation of the supported dimensions (groupings) and metrics are below.

Once connected, customers can build their own reports & analyses and use the full suite of Looker Studio tools, including blending other data sources such as GA4 for unified reporting.

Connecting Scrunch to Looker Studio

Installation

The connector is not currently available through the public Looker Studio Connector Gallery. Instead, to install the connector, use the following link:

https://lookerstudio.google.com/datasources/create?connectorId=AKfycbzRRK2rRqh1_ujHS313hitMb5PopzgNUS5m5ih6ohI

This will make the "Scrunch AI" data source available in Looker Studio.

Authentication

The Connector is currently authenticated via an API token that Scrunch customer success can securely share with you. For customers or partners with multiple Scrunch brands, a single API key can be configured for access to any or all of your brands. See our API documentation for more information on key-based authentication.

Brand Scoping

For customers & partners with multiple Scrunch brands, we currently only support pulling data into Looker Studio for a single brand at a time. The intention behind this is to make it less likely that one client's data is accidentally exposed to another client.

You will be prompted during the Connector set up process to enter a brand ID.

If you need to blend data for multiple brands in a single Looker Studio report, please let us know. We're actively collecting feedback for future versions of the Connector.

Locating Your Brand ID(s)

You can locate your brand ID from the Scrunch UI by looking at the URL in your web browser. The number after app.scrunchai.com/b/ is the brand ID.

Supported Dimensions

Name	Data Type	Semantic Type	Constraints
prompt_id	NUMBER	NUMBER
prompt	STRING	TEXT
date_month	STRING	YEAR_MONTH	Only last 90 days of data
date_week	STRING	YEAR_WEEK	Only last 90 days of data Recommend keeping filters week-aligned
date	STRING	YEAR_MONTH_DAY	Only last 90 days of data
source_url	STRING	URL
source_type	STRING	TEXT	Brand, Competitor, Other
persona_id	NUMBER	NUMBER
persona_name	STRING	TEXT
competitor_id	NUMBER	NUMBER
competitor_name	STRING	TEXT
ai_platform	STRING	TEXT	ChatGPT, Perplexity, Google AI Overviews, Meta, Claude
ai_platform_search_enabled	BOOLEAN	BOOLEAN
tag	STRING	TEXT
branded	BOOLEAN	BOOLEAN	Whether prompt includes brand name(s)

Metrics

Name	Data Type	Semantic Type	Constraints
responses	NUMBER	NUMBER
brand_presence_percentage	NUMBER	PERCENT
brand_position_score	NUMBER	NUMBER	(1, 100)
brand_sentiment_score	NUMBER	NUMBER	(1, 100)
competitor_presence_percentage	NUMBER	PERCENT

FAQs

How do I visualize prior period performance?

Time series data is available, so out of the box, you can view metrics over time.

To build more "snapshot views" of prior period performance (e.g. to compare current week vs. previous week, or current week vs. last month) you can create custom Metrics in Looker Studio (e.g. "Last 7 Day Brand Presence") using aggregate functions with conditionals.

Templates

Once your Scrunch data source is connected, you can accelerate setup by using our pre-built Looker Studio template. The template provides an out-of-the-box dashboard with key Scrunch metrics already visualized.

To get started:

Make sure you’ve already followed the above steps to connect your API key and created a data source
Open this template and click the three dots in the top-right corner.
Select “Make a Copy.”
When prompted, choose your newly created Scrunch AI Data Connector as the data source for all charts and tables.

From there, you’ll have a working dashboard tailored to your Scrunch data. You can customize it further, blend in other sources like GA4, or create additional visualizations as desired.

Visit our dedicated setup article for help with using templates.

Caveats & Known Issues

There is currently no single dimension / metric you can use to replicate the "Competitive Benchmark" chart on the Scrunch dashboard. You can create side-by-side charts of Brand Presence and Competitor Presence grouped by Competitor Name, or you can use a data blend to combine brand & competitive percentages.
Reports / dashboards with more than ~15 charts using Scrunch data may occasionally fail. This is due to a built-in limit in Looker Studio that limits users to having a maximum of 30 parallel queries from a single Community Connector, and the fact that some chart types require multiple queries.