Skip to main content

Creating Multiple Client Dashboards in Looker Studio Using One Scrunch API Key

A guide to using a single Scrunch API key to power multiple client dashboards in Looker Studio

Updated yesterday

This article explains how to use a single Scrunch API key to power multiple client dashboards in Looker Studio by controlling access at the API key level and switching brands using a Brand ID parameter inside Looker Studio.

We assume you already know how to connect Scrunch to Looker Studio. If not, start here first:


Overview of how this works

  • One Scrunch API key can access multiple brands

  • Looker Studio passes a Brand ID parameter to Scrunch

  • Each chart can query a different brand using that parameter

  • No additional API keys are required per client

The most common issues come from API key scoping or Brand ID parameters not being enabled in Looker Studio.


Step 1. Confirm your API key can access multiple brands in Scrunch

If your API key is not scoped correctly, Looker Studio will only ever return data for one brand.

How to check API key brand access

  1. In Scrunch, go to Organization → Settings → API Keys

  2. Click the three dot menu next to your API key

  3. Select Edit

  4. Under Brand access, do one of the following:

    • Select multiple brands you want Looker Studio to access, or

    • Deselect all brands to allow access to all brands in the organization

  5. Save changes

This step ensures the API key is allowed to query more than one Brand ID.

If you do not yet have an API key, follow this guide first:


Step 2. Confirm Looker Studio allows Brand ID to be modified in reports

Even if your API key is scoped correctly, Looker Studio must be explicitly told that the Brand ID parameter is editable.

How to enable Brand ID as a report level parameter

  1. Open your report in Looker Studio

  2. Click Resource → Manage added data sources

  3. Click Edit on your Scrunch data source

  4. Click Edit connection

  5. Locate the option labeled
    “Allow ‘Enter Scrunch AI Brand ID (numeric)’ to be modified in report”

  6. Make sure this checkbox is enabled

  7. Save the connection

If this is not checked, charts will not be able to switch brands.


Step 3. Set the Brand ID per chart in Looker Studio

Once the API key and data source are configured correctly, brand switching happens inside each chart.

How to set Brand ID on a chart

  1. Click on a chart in your Looker Studio report

  2. In the right sidebar, open the Setup tab

  3. Scroll to the bottom of the Setup panel

  4. Find the Brand ID parameter field

  5. Enter the numeric Brand ID you want that chart to query

Each chart can reference a different Brand ID, even when using the same Scrunch data source and API key. That said, sure to set the Brand ID parameter for each chart in your report.

If you don't see data right away, try giving Looker Studio a refresh


Common pitfalls to avoid

  • Assuming you need one API key per client

  • Forgetting to enable Brand ID modification in the data source connection

  • Setting the Brand ID only once and expecting all charts to update automatically

  • Copying charts without updating the Brand ID parameter


Summary

To create multiple client dashboards using one Scrunch API key:

  1. Ensure the API key is scoped to multiple brands in Scrunch

  2. Enable Brand ID modification in the Looker Studio data source

  3. Control Brand ID at the chart level inside Looker Studio

This setup is the safest and most scalable way to support agency or multi brand reporting in Looker Studio.

Did this answer your question?