Skip to content

Marketing and ads

Connect Pinterest to DataxLand

The Pinterest connector reads ad accounts, campaigns, ad groups, ads and daily analytics reports, along with the account's boards and pins. Si maps ad analytics to daily marketing spend, so Pinterest spend sits next to your other channels and, once you have real orders, feeds into true ROAS computed on net revenue.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with Pinterest

  • Add Pinterest Ads spend to the store's total ad spend.
  • Compare clicks and CTR by campaign between Pinterest and other channels.
  • Compute true ROAS once Shopify, WooCommerce or an order file is connected.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
ad_accountsAd accounts.
campaignsCampaigns.
ad_groupsAd groups.
adsAds.
campaign_analyticsSpend, impressions and clicks by day and campaign.
ad_account_analyticsThe same measures at account level.
boardsThe account's boards; organic (unpaid) measures need a workspace metric of their own.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Marketing spendTotal cost of marketing campaigns by spend date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber

Connect Pinterest in 4 steps

  1. 1

    Prepare a Pinterest app

    Create an app in Pinterest Developers, get the Client ID and Client Secret, and generate a Refresh Token with ads read access.

  2. 2

    Add the Pinterest source

    In the workspace choose Add source, find Pinterest, and enter the OAuth2.0 credentials, start date and Account ID if you have several accounts.

  3. 3

    Choose streams

    Click Test connection, then select campaigns, ad_groups and campaign_analytics.

  4. 4

    Review and build

    Si proposes a mapping to daily marketing spend; you approve, then build.

Limits and caveats

  • DataxLand does not run the Pinterest sign-in; you create the app and refresh token yourself.
  • Pinterest reports conversions using its own Attribution Window; they are not real revenue.
  • Requires the Starter plan or above. An Airbyte connector (ELv2) run inside DataxLand.

Frequently asked questions

Can I get organic pin data?

There are streams for boards and pins, but the analytics pack has no standard metric for organic engagement yet; define a workspace metric (ws.<name>).

What currency is spend in?

The ad account currency, as Pinterest returns it; DataxLand does not convert exchange rates.

Does it change ads on Pinterest?

No. The connector is read-only.

Dashboard templates that use this source

All data sources →

Connect Pinterest and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes