Pinterest

Follow our setup guide to connect Pinterest to QUANTI:

Prebuilt reports and definition

---

Prerequisites

Before connecting Pinterest Ads to QUANTI, ensure you have:

• Pinterest Business Account: A Pinterest Business account with active advertising campaigns

• Ad Account Access: Admin or Analyst access to the Pinterest Ad Account(s) you want to connect

• Active Campaigns: At least one active or historical advertising campaign to retrieve performance data

• API Access: Your Pinterest account must have API access enabled (automatically granted for Business accounts)

---

Setup Instructions

1

Authorize Pinterest Connection

• Click on Connect to Pinterest

• You will be redirected to Pinterest's authorization page

• Log in with your Pinterest Business account credentials

• Review and accept the requested permissions:

  • See all of your advertising data, including ads, ad groups, campaigns etc

  • Afficher vos comptes utilisateurs et vos abonnés

• Click Allow to grant access

2

Connector Information

• Connector Name: Define a unique name for your connector

• Dataset ID: Specify the BigQuery dataset ID where tables will be created

  • The dataset will be created automatically if it doesn't exist

• Click Next

3

Select Account(s)

• Select the account(s) you want to connect to QUANTI

• You can select multiple Ad Accounts to track performance across different accounts

• Click Next

4

Select Queries

• Review the available Prebuilt reports

• All tables are selected by default - you can deselect tables you don't need

• Click Next

5

Attribution Settings (optional)

Configure how Pinterest attributes conversions in your report tables. These three fields are optional — leaving them blank preserves the current behavior (Pinterest API defaults apply).

Field	API parameter	Allowed values	Default
Click Attribution Window	click_window_days	1 / 7 / 30 / 60	30
View Attribution Window	view_window_days	1 / 7 / 30 / 60	1
Conversion Report Time	conversion_report_time	TIME_OF_AD_ACTION / TIME_OF_CONVERSION	TIME_OF_AD_ACTION

View Attribution Window cannot exceed Click Attribution Window. Valid combinations (click, view) are: (60, 60) (60, 30) (60, 7) (60, 1) (30, 30) (30, 7) (30, 1) (7, 7) (7, 1) (1, 1).

Conversion Report Time controls the date used to report conversions:

• TIME_OF_AD_ACTION — conversion is reported on the date the user interacted with the ad (default)

• TIME_OF_CONVERSION — conversion is reported on the date the user completed the conversion

These settings only affect Campaign Report, Ad Group Report, and Pin Promotion Report. History/dimension tables are not impacted.

6

Finish Setup

• Define a sync period and a lookback window

• Click Save

• For the first sync, you have the following options:

  • Activate auto-sync for recurring syncs based on your sync settings by clicking the switch button

  • Launch a historical data recovery by choosing your desired dates in the historical data tab

  • Launch a manual sync immediately by clicking the Sync now button

• Wait for the sync to complete

• Navigate to your data warehouse to verify that tables are populated

• Check the connector dashboard for sync status and any potential errors

---

Prebuilt reports

Dimension tables (append-only)

• Advertiser History: Advertiser account attributes including name, country, currency, permissions, and timestamps

• Campaign History: Campaign configuration and attributes at campaign level including status, budget caps, objectives, and scheduling

• Ad Group History: Ad group configuration including name, status, budget settings, targeting parameters, and optimization goals

• Pin Promotion History: Promoted Pin details including creative specifications, destination URLs, and promotion settings

• Pin History: Editorial and creative attributes of the Pin behind a Pinterest ad — title, description, alt text, dominant color, creative type (REGULAR, VIDEO, CAROUSEL, MAX_VIDEO, SHOPPING, COLLECTION, IDEA), board, and promotion flag. Joins to pin_promotion_history via pin_id.

• Pin Media: Media asset metadata of the Pin — type (image / video / multi_image), cover image URL, video duration (ms), dimensions, and Idea Pin item attributes. One row per Pin.

• Pin Media Image: Available image renditions of the Pin's media, one row per (pin_id, image_size_label). Provides direct image URLs per resolution (150x150, 400x300, 600x, 1200x, originals) for display in dashboards without re-calling the API.

Metric tables (delete-insert on _quanti_date)

Conversion metrics in these tables reflect the attribution window configured at connector level (see Attribution Settings above).

• Campaign Report: Daily performance metrics aggregated at campaign level including impressions, clicks, spend, and conversions

• Ad Group Report: Daily performance metrics aggregated at ad group level with detailed engagement and conversion tracking

• Pin Promotion Report: Daily performance metrics at Pin promotion level including video metrics, web sessions, and ROAS calculations

---

Prebuilt reports and definition

---

conversion_report_time — Which day your conversions are counted on

Pinterest records two dates for each conversion: the day someone engaged with your ad, and the day they completed the purchase or sign-up. This setting decides which of the two days your conversions appear on in your daily reports.

Where to find it

Two options:

• Time of ad action (Pinterest's default): the conversion is counted on the day the person clicked or viewed your ad. Best to judge each day's ads against their spend.

• Time of conversion: the conversion is counted on the day the purchase or sign-up happened. Best to match your site's daily sales.

Example: a click on May 3, a €80 purchase on May 6. Time of ad action shows 1 conversion and €80 on May 3. Time of conversion shows them on May 6. Each conversion is counted once.

Left empty, Pinterest applies Time of ad action.