> ## Documentation Index
> Fetch the complete documentation index at: https://developers.scrunch.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Looker Studio Legacy Single-Brand Connector

> Configure the legacy single-brand Scrunch Looker Studio Community Connector to build dashboards and blend brand visibility metrics with GA4 and other sources.

# Looker Studio Connector (Legacy)

<Note>
  This is the legacy single-brand connector. For multi-brand support, agent traffic data, and comparison fields, use the [Data Studio Connector](/integrations/data-studio-connector) (formerly Looker Studio v2)
</Note>

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.

<img src="https://mintcdn.com/scrunchai/67YuQjB0mGKJxVaT/images/hero.png?fit=max&auto=format&n=67YuQjB0mGKJxVaT&q=85&s=9603c3e505bf69578b6bf79b6ea8c584" alt="Hero Pn" width="1178" height="804" data-path="images/hero.png" />

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:

<Card title="Install Connector" icon="arrow-up-right-from-square" href="https://lookerstudio.google.com/datasources/create?connectorId=AKfycbzRRK2rRqh1_ujHS313hitMb5PopzgNUS5m5ih6ohI">
  Open the Scrunch AI Looker Studio Connector
</Card>

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**
>
> <Note>
>   A single API key may be scoped to one or many brands. Use narrow scoping when integrating with client-facing dashboards.
> </Note>

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.
>
> <Note>
>   If you need multi-brand dashboards, reach out to Scrunch. We are collecting feedback for expanded multibrand support.
> </Note>

## Supported Dimensions and Metrics

### Dimensions

The connector aligns with the Scrunch Query API.

| Name                         | Data Type | Semantic Type    | Notes                                                  |
| ---------------------------- | --------- | ---------------- | ------------------------------------------------------ |
| `prompt_id`                  | NUMBER    | NUMBER           |                                                        |
| `prompt`                     | STRING    | TEXT             |                                                        |
| `date_month`                 | STRING    | YEAR\_MONTH      | Last 90 days of data                                   |
| `date_week`                  | STRING    | YEAR\_WEEK       | Last 90 days, keep filters week-aligned                |
| `date`                       | STRING    | YEAR\_MONTH\_DAY | 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 | Notes                         |
| -------------------------------- | --------- | ------------- | ----------------------------- |
| `responses`                      | NUMBER    | NUMBER        | Count                         |
| `brand_presence_percentage`      | NUMBER    | PERCENT       |                               |
| `brand_position_score`           | NUMBER    | NUMBER        | Range: 1–100                  |
| `brand_sentiment_score`          | NUMBER    | NUMBER        | Range: 1–100                  |
| `competitor_presence_percentage` | NUMBER    | PERCENT       | Requires competitor dimension |

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.

<Steps>
  <Step title="Open the template">
    Click the template link.

    <Card title="Scrunch Looker Studio Template" icon="pager" href="https://lookerstudio.google.com/reporting/c16759f5-d47e-49a0-a43a-9211b721c300" cta="View template" />
  </Step>

  <Step title="Make a copy">
    In the top-right corner, click the **three dots** → **Make a copy**.

    <Note>
      Be sure to add install the [Scrunch Looker Studio Connector](https://lookerstudio.google.com/datasources/create?connectorId=AKfycbzRRK2rRqh1_ujHS313hitMb5PopzgNUS5m5ih6ohI) prior to copying.
    </Note>

    <img src="https://mintcdn.com/scrunchai/67YuQjB0mGKJxVaT/images/copy.png?fit=max&auto=format&n=67YuQjB0mGKJxVaT&q=85&s=19b1ebd95e3912331f0dc9c5d4601048" alt="Copy Pn" width="924" height="564" data-path="images/copy.png" />
  </Step>

  <Step title="Connect your Scrunch data source">
    When prompted, select the Scrunch AI Looker Studio connector you configured earlier.

    <img src="https://mintcdn.com/scrunchai/67YuQjB0mGKJxVaT/images/data.png?fit=max&auto=format&n=67YuQjB0mGKJxVaT&q=85&s=a708648d040a50b094756a9d4aab4508" alt="Data Pn" width="2778" height="1400" data-path="images/data.png" />
  </Step>

  <Step title="Customize your dashboard">
    You can now modify charts, add filters, or blend additional sources like GA4, CRM data, paid media, and more.
  </Step>
</Steps>

## 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:
>
> ```text theme={null}
> 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:
>
> ```text theme={null}
> 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
>
> <Note>
>   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.
> </Note>
>
> <img src="https://mintcdn.com/scrunchai/67YuQjB0mGKJxVaT/images/alt-chart.png?fit=max&auto=format&n=67YuQjB0mGKJxVaT&q=85&s=d85796133f4e3e78f2dc1017a0fd0700" alt="Alt Chart Pn" width="2880" height="1538" data-path="images/alt-chart.png" />

## Resetting Your Connector (If Needed)

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

<Steps>
  <Step title="Open Looker Studio Admin">
    Visit: [https://lookerstudio.google.com/navigation/reporting](https://lookerstudio.google.com/navigation/reporting)
  </Step>

  <Step title="Open Data Sources">
    Click Data Sources in the top navigation.
  </Step>

  <Step title="Remove the Scrunch data source">
    Find your Scrunch connector → ⋮ → Remove <img src="https://mintcdn.com/scrunchai/67YuQjB0mGKJxVaT/images/data-source.png?fit=max&auto=format&n=67YuQjB0mGKJxVaT&q=85&s=9a015d42e3b561c5a976d789bf838ea4" alt="Data Source Pn" width="2880" height="1556" data-path="images/data-source.png" />

    <Tip>
      This could be named "**AI Data Connector**."
    </Tip>
  </Step>

  <Step title="Now remove the connector">
    Click + Create → Data source → Partner Connectors → Scrunch AI Then ⋮ → Revoke <img src="https://mintcdn.com/scrunchai/67YuQjB0mGKJxVaT/images/delete.png?fit=max&auto=format&n=67YuQjB0mGKJxVaT&q=85&s=bd74b7960778ca4ed8f48adb9722b882" alt="Delete Pn" width="2880" height="1554" data-path="images/delete.png" />
  </Step>

  <Step title="Reinstall the connector">
    Use the connector link again: [https://lookerstudio.google.com/datasources/create?connectorId=AKfycbzRRK2rRqh1\_ujHS313hitMb5PopzgNUS5m5ih6ohI](https://lookerstudio.google.com/datasources/create?connectorId=AKfycbzRRK2rRqh1_ujHS313hitMb5PopzgNUS5m5ih6ohI)
  </Step>

  <Step title="Re-enter your API key and brand ID">
    You now have a clean state.
  </Step>
</Steps>

## Summary

<CardGroup cols={3}>
  <Card title="Flexible Reporting" icon="chart-line">
    Build dashboards for brand trends, sentiment, competitors, and platform performance.
  </Card>

  <Card title="Blend with GA4" icon="database">
    Unify Scrunch visibility metrics with site traffic and conversion data.
  </Card>

  <Card title="Template-Ready" icon="gauge">
    Use our prebuilt Looker Studio template to jumpstart reporting.
  </Card>
</CardGroup>