Guides
Connect Pineprompt to Looker Studio
The Pineprompt connector for Google Looker Studio brings your AI visibility metrics into Looker Studio, where you may chart them over time and report on them alongside the rest of your data. Each data source you create reports on a single metric, so you may build visibility, sentiment, and share-of-voice views from the same account.
Before you begin
You will need three things before you connect.
- An API key
- A Pineprompt API key with the analytics:read ability. You may issue one from the dashboard at Settings → API keys. The connector never needs any other ability.
- An active subscription
- The key must belong to an organization with an active subscription. A key on a lapsed organization will be rejected when the connector validates it.
- A project id
- The numeric id of the project you would like to report on. The connector reports on one project at a time.
If you would like to confirm a key before you start, the authentication reference describes how keys, abilities, and projects fit together.
Connecting
Open the Pineprompt connector in Looker Studio, then work through the connector screens.
- Authenticate. Paste your API key. The connector validates it against your account, so an invalid or unsubscribed key is rejected here rather than later.
- Choose a project. Enter the numeric project id you would like to report on.
- Choose a metric. Select visibility, sentiment, or share of voice. Each data source reports on one metric.
- Choose a brand (optional). Enter a brand id to report on a single brand. If you leave it blank, the connector returns the top brands by mention count for the period.
Looker Studio supplies the date range, so you may change the reporting window from the report itself without reconfiguring the connector.
The metrics you may report on
- Visibility
- The share of analyzed responses that mention the brand, on a 0 to 100 scale.
- Sentiment
- The average sentiment of the brand's mentions, on a 0 to 100 scale. A bucket with no mentions reports no value rather than a zero.
- Share of voice
- Each brand's mentions as a share of the total across the reported brands. The values across the brand set add up to 100% per bucket.
The fields the connector returns
Every data source returns the same three fields. The metric field is named for the metric you selected.
| Field | Type | Description |
|---|---|---|
| Date | date | The day the metric was measured. Looker Studio rolls daily values up to weeks and months for you. |
| Brand | text | The brand the value belongs to. Use it to compare your brand against competitors on the same chart. |
| Value | number | The value of the selected metric for that brand on that day. An empty value means the brand had no mentions in that bucket, which is distinct from a real zero. |
Reporting on more than one metric
Because each data source reports on a single metric, you should add the connector once per metric you care about. To compare visibility and sentiment side by side, add the connector twice and blend the two data sources in Looker Studio on the Date and Brand fields. Looker Studio handles the blend natively, so you do not need to combine the metrics yourself.
Things worth knowing
A few details will help you read your reports correctly.
- The connector pulls daily values and lets Looker Studio roll them up, so a single data source serves daily, weekly, and monthly views.
- When you do not choose a brand, the connector returns the top 50 brands by mention count for the period, and that set may shift between refreshes as mention counts change. Of course, choosing a brand id gives you a single, stable series.
- An empty cell means the brand had no mentions in that bucket. It is not a zero, and Looker Studio renders it as a gap rather than a low point.
- The API is rate limited. Looker Studio calls Pineprompt on every refresh, so a report with many charts and many viewers may occasionally be throttled. The connector caches recent results to soften this.