​

Looker Studio Documentation and Template

Connect Scrunch to Google Looker Studio using our private Community Connector. This allows you to build dashboards, analyze historical performance, and blend Scrunch metrics with other data sources such as GA4. The connector exposes all standard Scrunch Query API fields, including:

• Brand presence, position, and sentiment
• Competitor presence metrics
• Date, platform, persona, tag, and source dimensions

Once connected, you can create fully custom dashboards or use our pre-built Scrunch Looker Studio template.

​

Install the Scrunch Looker Studio Connector

The connector is not yet in the public gallery. Install it directly using the link below:

Install Connector

Open the Scrunch AI Looker Studio Connector

This installs the Scrunch AI data source inside Looker Studio for your Google account.

​

Authenticate With Your Scrunch API Key

During setup, Looker Studio will prompt you for:

1. Your API key

You can provision a Query-scoped API key from: Scrunch → Organization → Settings → API Keys

A single API key may be scoped to one or many brands. Use narrow scoping when integrating with client-facing dashboards.

2. Your Brand ID

The connector loads data for one brand at a time. To find your brand ID: Open the brand’s dashboard in Scrunch Look at the URL: https://app.scrunchai.com/org/.../b/1234/dashboard Here, 1234 is your Brand ID.

If you need multi-brand dashboards, reach out to Scrunch. We are collecting feedback for expanded multibrand support.

​

Supported Dimensions and Metrics

​

Dimensions

The connector aligns with the Scrunch Query API.

​

Metrics

There is currently no singular metric that recreates the Scrunch Competitive Benchmark visualization. You may create side-by-side charts or blend data sources to approximate the view.

​

Using the Scrunch Looker Studio Template

To accelerate setup and reporting, Scrunch provides a pre-built template.

​

FAQs

How do I compare last week vs. previous week?

Create custom metrics inside Looker Studio using conditional date filters. Example:

• Last 7 days
• Same 7 days previous period
• Month-to-date vs prior month-to-date

Looker Studio supports calculated fields using functions like:

Copy

Ask AI

CASE
WHEN DATE_DIFF(CURRENT_DATE(), date, DAY) < 7 THEN brand_presence_percentage
END

Are there limits to dashboard size?

Yes. Looker Studio allows a maximum of 30 concurrent Community Connector queries. Dashboards with more than ~15 Scrunch-powered charts may hit this limit depending on complexity.

How do I recreate the Brand Presence + Competitor Presence chart from the Scrunch dashboard?

A version of this combined view is already included in the Scrunch Looker Studio template. When you make a copy of the template, zoom out on the canvas—you’ll see a hidden chart that mimics the dual-line Brand vs. Competitor Presence visualization from the Scrunch dashboard. Looker Studio does not natively blend these metrics into a single field, so the chart requires custom-calculated metrics under the hood. Each competitor’s presence must be defined using a conditional formula, such as:

Copy

Ask AI

CASE WHEN competitor_name = "Competitor A" THEN competitor_presence_percentage END

To customize the benchmark view for your own competitive set:

1. Open the hidden chart in your copied template
2. Edit each metric formula
3. Replace the competitor names with the ones relevant to your brand

There is no universal “competitive benchmark” metric available from the API. The Looker Studio template replicates this view by combining multiple calculated fields inside one chart.

​

Resetting Your Connector (If Needed)

If the connector was set up incorrectly, here’s how to completely reset it:

​

Summary