Pinterest Ads
Pinterest Ads is an advertising platform offered by Pinterest, the visual discovery and bookmarking platform. It enables businesses and advertisers to create and manage ad campaigns to reach a highly engaged audience of users interested in discovering new ideas, products, and services.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | |
| Custom data | False | |
| History | False | |
| ReSync | True | Table level |
| Templates | True |
Data Schema
Setup Guide
Step 1 - Create the connection
- In Weld, click Data Sources in the sidebar, then Add Data Source, and choose Pinterest Ads. If the account is already connected, choose Use existing connection and go to Step 2.
- Check the connection Name (1). It's filled in for you, and you can change it.
- Click Authorize (3) and sign in to Pinterest. Approve Weld's access, and you're taken back to the setup.
If someone else owns the Pinterest account, for example a client, click Share Authorization Link (2) instead and send them the link. They sign in and grant access without a Weld login. See Authorization links.
Step 2 - Connection Settings
On Connection Settings, choose:
- Ad Accounts: the Pinterest ad accounts to sync.
Click Next.
Step 3 - Data to sync
Tick the tables you want. Each table shows whether it syncs in full or incrementally, and you can expand it to remove or hash columns. See Tables below for what each kind holds.
Step 4 - Configure sync
Choose how often to sync, check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.
Query your data
When the first sync finishes, the tables are in your warehouse under the destination schema. In Transform, find them under Data Sources in the sidebar, then write a model on top of them or ask Ed to write one. See Data models.
Tables
Objects. How your account is set up:
ad_account,campaign,ad_group,adkeyword,product_grouppin,board
Reports. Performance metrics for each level:
ad_account_report,campaign_report,ad_group_report,ad_report- By country:
ad_account_country_report,campaign_country_report,ad_group_country_report - By hour:
campaign_hourly_report