API access (and therefore this connector) requires the Growth or Enterprise plan. You will need an active API key from Account / API keys before starting.
What data the connector returns
The connector exposes one grain of data: brand metrics by project, brand, and date. Each row contains:
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
1
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.
2
Open Looker Studio and add a data source
Go to 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.
3
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.
4
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.
5
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.Tips
- Visibility rate: Looker Studio does not compute this automatically. Create a calculated field:
visibility_count / visibility_totaland 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_idas 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.
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.