Pinterest Extractor Documentation

Pinterest Extractor DocumentationPinterest 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