Pinterest Extractor Documentation

pinterest-logo.pngPinterest 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

 

 

Was this article helpful?
0 out of 0 found this helpful