Skip to main content

Pinterest Ads API Connector

Updated this week

I will setup and manage your pinterest ad campaigns - Xprexity Freelancers Market Place

Overview

The Pinterest Ads API provides programmatic access to campaign, ad group, and creative-level performance data for paid Pinterest campaigns. It supports Promoted Pins, including image, video, carousel, and shopping ad formats, enabling advertisers to monitor and optimise campaigns at scale.

This connector focuses on paid Pinterest advertising metrics, targeting, and creative performance insights.

Data handled by the integration:

Account & Campaign Data

  • Advertiser accounts (account ID, name, status)

  • Campaigns and ad groups

  • Campaign objectives (traffic, conversions, awareness, engagement)

  • Budget, bidding, and pacing settings

  • Campaign and ad group status

Creative & Ad Data

  • Promoted Pins metadata

    • Pin ID, type (image, video, carousel)

    • Associated campaign and ad group

    • Media URLs, headlines, descriptions

    • Call-to-action types

  • Approval status and policy compliance

Performance Metrics

  • Impressions, clicks, CTR

  • Cost, CPC, CPM, spend

  • Conversions and conversion value

  • Engagement metrics (saves, close-ups, repins, video views)

  • ROAS (for conversion campaigns)

Audience & Targeting

  • Targeting by:

    • Interests and keywords

    • Custom audiences (first-party lists, website visitors)

    • Demographics (age, gender, location)

    • Devices (mobile, tablet, desktop)

  • Retargeting and lookalike audience metrics

Metadata & Reference Tables

  • Account hierarchy

  • Campaign and ad group structure

  • Ad format definitions

  • Conversion action definitions

  • Geographic and demographic mapping

Granularity:

  • Account-level, campaign-level, ad group-level, and ad-level metrics

  • Daily granularity (hourly available for certain metrics)

  • Breakdowns by:

    • Device type

    • Demographics (age, gender)

    • Geography (country, region)

    • Objective / conversion type

Purpose:

  • Monitor Pinterest ad campaign performance

  • Track ad group and creative effectiveness

  • Analyse audience engagement and conversions

  • Optimise bidding, targeting, and creative strategy

  • Build dashboards combining Pinterest Ads with other channels

  • Conduct historical performance audits

Refresh Cadence:

Data is refreshed daily.

Update Modes:

Append (for data table), Refresh (for metadata)

For more information on this integration, please follow the link here.

Jobs

1. Pinterest Ads - Delivery Import

  • Feed: pinterest

  • Status: Active (1)

  • Job Label: Pinterest Ads - Delivery Import

  • Lookback: Last 5 days

  • First Run Hour: 5 AM

  • Poll Frequency: Every 24 hours

  • Lookback Window: 0

Targets:

  • Type: data

  • Table: pinterest_data_delivery

  • Options:

    • level: PIN_PROMOTION (hidden)

  • Priority: 1

  • Description: Pinterest Ads - Delivery Data

  • Update Mode: append

  • Create Target: true

  • Date Column Name: date

2. Pinterest Ads - Meta Refresh

  • Feed: pinterest

  • Status: Active (1)

  • Job Label: Pinterest Ads - Meta Refresh

  • Lookback: Last 1 day

  • First Run Hour: 7 AM

  • Poll Frequency: Every 24 hours

  • Lookback Window: 0

Targets:

  • Campaign Meta

    • Type: lookup

    • Table: pinterest_meta_campaign

    • Priority: 1

    • Description: Pinterest - Campaign Meta

    • Update Mode: refresh

    • Create Target: true

  • AdGroup Meta

    • Type: lookup

    • Table: pinterest_meta_adgroup

    • Priority: 2

    • Description: Pinterest - AdGroup Meta

    • Update Mode: refresh

    • Create Target: true

  • Pin Promotion Meta

    • Type: lookup

    • Table: pinterest_meta_pinpromotion

    • Priority: 3

    • Description: Pinterest - Pin Promotion Meta

    • Update Mode: refresh

    • Create Target: true

Connection Configuration

  • Description: Pinterest Ads Connection

  • Username: (empty)

  • Secret: (empty)

  • Options:

    • pinterest_advertiser_id

      • Type: text

      • Required: true

      • Size: 50

      • Hint: Comma delimited list of advertiser ids

      • Description: Pinterest Ads - Advertiser IDs

    • pinterest_client_id

      • Type: hidden

      • Value: 1460080

    • pinterest_client_secret

      • Type: hidden

      • Value: 9a951ef9e11412397b1f0c49373ce6990abb7285

Dimensions

Name

Result Fields

Campaign [Pinterest]

pinterest_meta_campaign.name

AdGroup [Pinterest]

pinterest_meta_adgroup.name

Pin Promotion [Pinterest]

pinterest_meta_pinpromotion.name

Base Metrics

Name

Formula / Definition

Notes

Spend [Pinterest]

SUM({spend_in_micro_dollar} / 1,000,000)

Spend converted from micro dollars

Impressions [Pinterest]

SUM({impression_1})

Total impressions

Clicks [Pinterest]

SUM({clickthrough_1})

Total clicks

Engagements [Pinterest]

SUM({engagement_1})

Total engagements

Repin [Pinterest]

SUM({repin_1})

Total repins

Video Views [Pinterest]

SUM({total_video_3sec_views})

Video views (3 sec+)

Video Starts [Pinterest]

SUM({video_p0_combined_1})

Video starts

Video Views Quartile - 25%

SUM({video_p25_combined_1})

25% video views

Video Views Quartile - 50%

SUM({video_p50_combined_1})

50% video views

Video Views Quartile - 75%

SUM({video_p75_combined_1})

75% video views

Video Views - 95%

SUM({video_p95_combined_1})

95% video views

Video Completes [Pinterest]

SUM({video_p100_complete_1})

Videos fully watched

Composite Metrics

Name

Formula

Round

Prefix /

Suffix

Notes

CPV [Pinterest]

{Spend [Pinterest]} / {Video Views [Pinterest]}

2

£

Cost per video view

VTR [Pinterest]

{Video Completes [Pinterest]} / {Impressions [Pinterest]} * 100

2

%

View-through rate (completion per impression)

VCR [Pinterest]

{Video Completes [Pinterest]} / {Video Views [Pinterest]} * 100

2

%

View completion rate (completion per view)

CPC [Pinterest]

{Spend [Pinterest]} / {Clicks [Pinterest]}

2

£

Cost per click

Did this answer your question?