Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Entity Relationship Diagram (ERD)
  • Pinterest Schema
  • Ad Accounts
  • Ad Analytics
  • Ad Groups
  • Ads
  • Campaigns

Was this helpful?

  1. Extract
  2. All Integrations
  3. Pinterest

Integration Specifications

This page will help you learn about how Daasity replicates data from Pinterest, the limitations to the data we can extract, and where the data is stored in the Pinterest schema.

PreviousIntegration SetupNextWorkflow Configuration Setup

Last updated 1 year ago

Was this helpful?

Integration Overview

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.

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 that enables multi-platform reporting in one schema.

Only 90 days of history available

Pinterest exposes only the last 90 days of history in their API. We will not be able to extract data for any activity outside of that window.

Integration Availability

This integration is available for:

  • Enterprise

  • Growth

API Endpoints

The Daasity Pinterest extractor is built based on this . The following endpoints are used by Daasity to replicate data from Pinterest:

Entity Relationship Diagram (ERD)

Pinterest Schema

The Daasity Pinterest extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.

Ad Accounts

  • Update Method: UPSERT

  • Table Name: [pinterest.ad_accounts]

JSON Element
Database Column

id

id

name

name

owner::username

owner

country

country

currency

currency

click_window_days

click_window_days

engagement_window_days

__engagement_window_days

view_window_days

__view_window_days

conversion_report_time

__conversion_report_time

MD5(ad_account::id + ad_account::country +ad_account::currency)

__sync_key

Ad Analytics

  • Update Method: UPSERT

  • Table Name: [pinterest.ad_analytics]

JSON Element
Database Column

ad_account_id

ad_account_id

ad_group_id

ad_group_id

ad_id

ad_id

campaign_id

campaign_id

ad_group_entity_status

ad_group_entity_status

campaign_daily_spend_cap

campaign_daily_spend_cap

campaign_entity_status

campaign_entity_status

campaign_name

campaign_name

checkout_roas

checkout_roas

clickthrough_1

clickthrough_1

clickthrough_1_gross

clickthrough_1_gross

clickthrough_1_gross

clickthrough_2

cpc_in_micro_dollar

cpc_in_micro_dollar

cpm_in_dollar

cpm_in_dollar

cpm_in_micro_dollar

cpm_in_micro_dollar

ctr

ctr

ctr_2

ctr_2

date

date

ecpcv_in_dollar

ecpcv_in_dollar

ecpcv_p95_in_dollar

ecpcv_p95_in_dollar

ecpc_in_dollar

ecpc_in_dollar

ecpc_in_micro_dollar

ecpc_in_micro_dollar

ecpe_in_dollar

ecpe_in_dollar

ecpm_in_micro_dollar

ecpm_in_micro_dollar

ecpv_in_dollar

ecpv_in_dollar

ectr

ectr

eengagement_rate

eengagement_rate

engagement_1

engagement_1

engagement_2

engagement_2

engagement_rate

engagement_rate

impression_1

impression_1

impression_1_gross

impression_1_gross

impression_2

impression_2

page_visit_cost_per_action

page_visit_cost_per_action

page_visit_roas

page_visit_roas

page_visit_roas

paid_impression

pin_id

pin_id

repin_1

repin_1

repin_2

repin_2

repin_rate

repin_rate

spend_in_dollar

spend_in_dollar

spend_in_micro_dollar

spend_in_micro_dollar

total_checkout

total_checkout

total_checkout_value_in_micro_dollar

total_checkout_value_in_micro_dollar

total_clickthrough

total_clickthrough

total_click_checkout

total_click_checkout

total_click_checkout

total_click_checkout_value_in_micro_dollar

total_conversions

total_conversions

total_engagement

total_engagement

total_engagement_checkout

total_engagement_checkout

total_engagement_checkout_value_in_micro_dollar

total_engagement_checkout_value_in_micro_dollar

total_engagement_signup

total_engagement_signup

total_engagement_signup_value_in_micro_dollar

total_engagement_signup_value_in_micro_dollar

total_view_checkout

total_view_checkout

total_view_checkout_value_in_micro_dollar

total_view_checkout_value_in_micro_dollar

web_checkout_cost_per_action

web_checkout_cost_per_action

web_checkout_roas

web_checkout_roas

MD5(ad_id + ad_group_id + ad_id + campaign_id + pin_id + date)

__sync_key

Ad Groups

  • Update Method: UPSERT

  • Table Name: [pinterest.ad_groups]

JSON Element
Database Column

id

id

ad_account_id

ad_account_id

campaign_id

campaign_id

feed_profile_id

feed_profile_id

name

name

status

status

budget_in_micro_currency

bid_in_micro_currency

bid_in_micro_currency

bid_in_micro_currency

budget_type

budget_type

start_time

start_time

end_time

end_time

lifetime_frequency_cap

lifetime_frequency_cap

auto_targeting_enabled

auto_targeting_enabled

placement_group

placement_group

pacing_delivery_type

pacing_delivery_type

conversion_learning_mode_type

conversion_learning_mode_type

summary_status

summary_status

billable_event

billable_event

type

type

updated_time

updated_time

created_time

created_time

MD5(id + ad_account_id + campaign_id + feed_profile_id)

__sync_key

Ads

  • Update Method: UPSERT

  • Table Name: [pinterest.ads]

JSON Element
Database Column

id

id

ad_account_id

ad_account_id

campaign_id

campaign_id

pin_id

pin_id

ad_group_id

ad_group_id

android_deep_link

android_deep_link

click_tracking_url

click_tracking_url

creative_type

creative_type

destination_url

destination_url

ios_deep_link

ios_deep_link

is_pin_deleted

is_pin_deleted

is_removable

is_removable

name

name

status

status

view_tracking_url

view_tracking_url

collection_items_destination_url_template

collection_items_destination_url_template

created_time

created_time

review_status

review_status

type

type

updated_time

updated_time

summary_status

summary_status

MD5(id + ad_account_id + campaign_id + pin_id + ad_agroup_id)

__sync_key

Campaigns

  • Update Method: UPSERT

  • Table Name: [pinterest.campaigns]

JSON Element
Database Column

id

id

ad_account_id

ad_account_id

name

name

status

status

lifetime_spend_cap

lifetime_spend_cap

daily_spend_cap

daily_spend_cap

order_line_id

order_line_id

objective_type

objective_type

created_time

created_time

updated_time

updated_time

type

type

MD5(id + account_id + order_line_id)

__sync_key

illustrating the different tables and keys to join across tables.

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

🔌
Unified Marketing Schema (UMS)
(source)
Pinterest API documentation
Ad Accounts
Ad Analytics
Ad Groups
Ads
Campaigns
Click here to view the ERD for the Daasity Pinterest integration
Ad Accounts
Ad Analytics
Ad Groups
Ads
Campaigns
Ad Accounts
Ad Analytics
Ad Groups
Ads
Campaigns