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