Pinterest Ads has no native Looker Studio connector. Getting the data into a dashboard follows the same routes as Meta or TikTok — but Pinterest behaves differently from other social platforms in one fundamental way. People don’t scroll Pinterest to be entertained; they use it to plan future purchases. That changes which metrics matter, and it hides a click-counting trap that inflates most Pinterest reports.

This guide covers the connection methods, the metrics worth pulling, and how to read Pinterest data without over- or under-valuing it.

Connection methods

Third-party connectors

Windsor.ai, Supermetrics, Porter Metrics, Dataslayer and similar offer Pinterest Ads connectors authenticating through the Pinterest API, with automatic refresh. Entry pricing runs roughly $20-40/month.

Before paying, verify that the connector distinguishes pin clicks from outbound clicks (see below) and exposes saves as a separate metric. A connector that only gives you a generic “clicks” field will make your Pinterest reporting misleading from day one.

Manual export

Pinterest Ads Manager exports reports as CSV for Google Sheets. Free and workable for monthly reporting if Pinterest is a small, stable part of your mix.

Pinterest API into BigQuery

The robust route, following the same multi-source architecture as our Looker Studio dashboard guide: Pinterest data lands in BigQuery and joins with Shopify orders and GA4 sessions in SQL.

The pin click vs outbound click trap

This is the single most important thing to get right in Pinterest reporting.

Pinterest counts two very different kinds of clicks:

  • Pin clicks — the user taps the pin and it opens in close-up view. They’re still on Pinterest.
  • Outbound clicks — the user clicks through to your website.

Only outbound clicks bring anyone to your store. Yet many reports — and some connectors by default — show a total “clicks” figure combining both. The result: a CTR and a CPC that look excellent, and a gap you can’t explain when GA4 shows far fewer Pinterest sessions than the click count suggests.

Build your Pinterest reporting on outbound clicks. Calculate CTR and CPC on outbound clicks only, and keep pin clicks as a separate engagement metric.

The metrics that matter

Outbound clicks, outbound CTR, and CPC on outbound clicks — the real traffic metrics, as above.

Saves — the most underrated Pinterest metric for e-commerce. A save means someone bookmarked your product for later: it’s a direct signal of purchase intent, and saved pins keep circulating organically after the campaign ends. A creative with a high save rate is often worth more than its immediate conversions suggest.

Conversions and ROAS — read against your breakeven ROAS as always, but with the timing caveat below.

Catalog performance — if you run shopping campaigns from your product catalog (Shopify can sync your catalog to Pinterest), break performance down by product, the same way you would for Google Shopping.

The timing problem: Pinterest is slow by design

Because Pinterest is a planning platform, the gap between seeing an ad and buying is often weeks rather than days — someone pins a sofa in March and buys it in May.

Two consequences for your reporting:

Short attribution windows undervalue Pinterest. Pinterest’s own default windows are relatively long for this reason, which makes its numbers hard to compare with platforms using shorter ones — and GA4, which only credits trackable clicks within its own logic, will attribute little to Pinterest. We cover why these gaps are structural in our attribution guide.

Short tests produce false negatives. A two-week Pinterest test that “didn’t work” often just didn’t run long enough for the purchases to land. Judge Pinterest on a longer horizon than your other paid channels.

Structuring the Pinterest page

Header: spend, outbound clicks, conversions, ROAS — with outbound clicks, not total clicks, as the traffic figure.

Engagement vs traffic: pin clicks and saves on one side, outbound clicks on the other, so the gap between them is visible rather than hidden.

Creative and product performance: saves and outbound CTR per pin, and ROAS per product for catalog campaigns.

Longer time window: default this page to 60 or 90 days rather than 7 or 28, to reflect Pinterest’s actual purchase cycle.

FAQ

Is there a free Pinterest Ads connector for Looker Studio? No free, automatic connector exists. Pinterest has no native Looker Studio integration, so you need a third-party connector, a manual CSV export into Google Sheets, or the Pinterest API into BigQuery.

What’s the difference between pin clicks and outbound clicks? A pin click opens the pin in close-up view, still inside Pinterest. An outbound click sends the user to your website. Only outbound clicks bring traffic to your store, so CTR and CPC calculated on total clicks will look far better than the reality of your site traffic.

Why does Pinterest take so long to show results? Pinterest is a planning platform: users save ideas for purchases they’ll make weeks later. That long consideration cycle means conversions often land well after the ad interaction, and short attribution windows or short test periods systematically undervalue the platform.

Want a dashboard that puts Pinterest next to your other paid channels and real Shopify revenue? Check out our Shopify Dashboards offer or book a free 30-minute call.