Pinterest is the visual discovery engine for finding ideas like recipes, home and style inspiration, and more. With billions of pins, it is a destination for many and advertisers can take advantage of that audience by creating and running paid campaigns to attract a new audience to their brand.
INTEGRATION OVERVIEW
The Daasity<>Pinterest integration enables merchants to extract key metrics from campaigns on a daily basis to easily track and compare performance across various ad platforms. Data is transformed as part of Daasity's Unified Marketing Schema (UMS) that enables multi-platform reporting in one schema.
This integration is available for Growth & Pro 2.0 Daasity Merchants with an active Daasity subscription.
SUPPORTED ENDPOINTS
Analytics
Users
Resources
PINTEREST ERD
TABLE: ACCOUNT
Data mapping from source JSON to database columns:
Database Column |
JSON Element |
pinterest_id |
Id |
username |
username |
domain_url |
domain_url |
first_name |
first_name |
last_name |
last_name |
location |
location |
gender |
gender |
is_active |
active |
last_pin_like_time |
last_pin_like_time |
last_pin_save_time |
last_pin_save_time |
created_at |
created_at |
Incremental data extraction.
Business Rule |
Value |
Load type |
UPSERT |
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- pinterest_id
ACCOUNT METRICS
Data mapping from source JSON to database columns:
Database Column |
JSON Element |
pinterest_id |
Id |
metric_date |
GETDATE() |
board_count |
board_count |
following_count |
following_count |
user_following_count |
user_following_count |
follower_count |
follower_count |
pins_done_count |
pins_done_count |
profile_reach_count |
profile_reach_count |
like_count |
like_count |
created_at |
created_at |
Incremental data extraction.
Business Rule |
Value |
Load type |
UPSERT |
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- Sync_key is the combination of the pinterest_id and the metric_date
DELIVERY METRICS
Data mapping from source JSON to database columns:
Database Column |
JSON Element |
metric_id |
name |
metric_definition |
definition |
Incremental data extraction.
Business Rule |
Value |
Load type |
UPSERT |
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- metric_id