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

# Looker Studio connector

> Connect Mavel brand visibility data to Looker Studio (formerly Data Studio) for client-facing dashboards and custom reports.

The Mavel community connector for Looker Studio pulls your brand visibility metrics into Google's free dashboard tool. Once connected, you can blend Mavel data with traffic, paid media, or other sources in the same Looker Studio report.

The connector is built as a Google Apps Script community connector. It calls the Mavel REST API using your API key and returns a flat table that Looker Studio can slice, filter, and chart.

<Note>
  API access (and therefore this connector) requires the **Growth or Enterprise plan**. You will need an active API key from [Account / API keys](/account/api-keys) before starting.
</Note>

## What data the connector returns

The connector exposes one grain of data: **brand metrics by project, brand, and date**. Each row contains:

| Field              | Type      | Description                                                  |
| ------------------ | --------- | ------------------------------------------------------------ |
| `project_id`       | Dimension | The Mavel project UUID.                                      |
| `brand_id`         | Dimension | The brand UUID.                                              |
| `display_name`     | Dimension | The brand's display name.                                    |
| `date`             | Dimension | The date of the data point (`YYYYMMDD`).                     |
| `visibility_count` | Metric    | Number of answers where the brand appeared.                  |
| `visibility_total` | Metric    | Total answers checked (the denominator for visibility rate). |
| `mention_count`    | Metric    | Number of times the brand was mentioned across answers.      |

The connector accepts a configurable **lookback window** (default 30 days). You can track multiple projects in one report by entering a comma-separated list of project UUIDs in the connector's configuration.

## Add the connector in Looker Studio

<Steps>
  <Step title="Get your API key">
    In Mavel, go to **Account** and open the **API keys** section. Create a new key and copy it. You will paste it when Looker Studio asks for authorization.
  </Step>

  <Step title="Open Looker Studio and add a data source">
    Go to [datastudio.google.com](https://datastudio.google.com/) and create a new report or open an existing one. Click **Add data** and search for "New Best" in the community connectors gallery.
  </Step>

  <Step title="Authorize with your API key">
    Looker Studio will prompt for your Mavel API key. Paste the key you copied in step 1. The connector stores it securely in Google Apps Script's per-user property store: it is not sent anywhere other than the Mavel API.
  </Step>

  <Step title="Configure the connector">
    Enter your project UUID (or a comma-separated list of UUIDs for multi-project reports) and the number of lookback days. You can find your project UUID in the URL on any Mavel dashboard page, or under **Project settings**.
  </Step>

  <Step title="Build your report">
    Click **Connect** and then **Create report**. Looker Studio loads the field schema. Drag `visibility_count`, `mention_count`, or `visibility_total` into charts; use `brand_id` or `display_name` as the dimension; use `date` for time-series breakdowns.
  </Step>
</Steps>

## Tips

* **Visibility rate**: Looker Studio does not compute this automatically. Create a calculated field: `visibility_count / visibility_total` and format it as a percentage.
* **Multi-project reports**: enter project UUIDs as a comma-separated list in the Project IDs field. The connector fetches each project's rows and concatenates them, so you can use `project_id` as a filter or breakdown dimension in your charts.
* **Date range**: the connector's lookback window is set at connection time, not at query time. To change the window, edit the data source and update the **Lookback days** field.
* **Refresh cadence**: Mavel updates visibility data daily. Looker Studio fetches fresh data each time a report loads or is manually refreshed; there is no additional cache to clear.

<Note>
  Having trouble? Reach us at the email address on your account page and include your project ID. This page is the support home for the connector: [docs.mavel.ai/integrations/looker](https://docs.mavel.ai/integrations/looker).
</Note>