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_accounts | Ad accounts. |
| campaigns | Campaigns. |
| ad_groups | Ad groups. |
| ads | Ads. |
| campaign_analytics | Spend, impressions and clicks by day and campaign. |
| ad_account_analytics | The same measures at account level. |
| boards | The account's boards; organic (unpaid) measures need a workspace metric of their own. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
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.
| Metric | Definition | Unit |
|---|---|---|
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
| Impressions | Total impressions (or reach) of campaigns by day. | Count |
| Clicks | Total clicks (or engagements that drive traffic) of campaigns by day. | Count |
| Click-through rate (CTR) | Clicks divided by impressions.= Clicks / Impressions | Ratio (%) |
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
Connect Pinterest in 4 steps
- 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
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
Choose streams
Click Test connection, then select campaigns, ad_groups and campaign_analytics.
- 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
Connect Pinterest and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes