# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Pinterest v2 connector:

* [AdAccountAnalytics](#adaccountanalytics) 
* [AdgroupAnalytics](#adgroupanalytics) 
* [Adgroup](#adgroup) 
* [Ads](#a-ds) 
* [AdAnalytics](#adanalytics) 
* [Campaigns](#campaigns) 
* [CampaignAnalytics](#campaignanalytics)

### AdAccountAnalytics 

Provides access to analytics and insights for a Pinterest ad account, allowing businesses to track and measure the performance of their advertising campaigns. For more information, see [AdAccountAnalytics](https://developers.pinterest.com/docs/api/v5/#operation/ad_account/analytics).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>TOTAL_VIDEO_P25_COMBINED</td><td>NUMERIC</td></tr><tr><td>VIDEO_MRC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P0_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_3SEC_VIEWS</td><td>NUMERIC</td></tr><tr><td>VIDEO_P0_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_3SEC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_MRC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_FREQUENCY</td><td>BIGNUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_USER</td><td>NUMERIC</td></tr><tr><td>VIDEO_P25_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND</td><td>NUMERIC</td></tr><tr><td>ADVERTISER_ID</td><td>NUMERIC</td></tr><tr><td>DATE</td><td>DATE</td></tr><tr><td>IMPRESSION_2</td><td>NUMERIC</td></tr><tr><td>AD_ACCOUNT_ID</td><td>STRING</td></tr></tbody></table>

### AdgroupAnalytics&#x20;

Businesses can retrieve analytics and performance data specific to ad groups within their Pinterest ad account, enabling in-depth analysis of individual campaign components. For more information, see [AdgroupAnalytics](https://developers.pinterest.com/docs/api/v5/#operation/ad_groups/analytics).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>AD_GROUP_ID</td><td>STRING</td></tr><tr><td>CAMPAIGN_OBJECTIVE_TYPE</td><td>NUMERIC</td></tr><tr><td>AD_GROUP_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>VIDEO_MRC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P0_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION</td><td>NUMERIC</td></tr><tr><td>VIDEO_P0_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_MRC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_FREQUENCY</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_LIFETIME_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_USER</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_DAILY_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>ADVERTISER_ID</td><td>NUMERIC</td></tr><tr><td>DATE</td><td>DATE</td></tr><tr><td>IMPRESSION_2</td><td>NUMERIC</td></tr><tr><td>AD_ACCOUNT_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_NAME</td><td>STRING</td></tr></tbody></table>

### Adgroup&#x20;

Allows for the management and configuration of ad groups within a Pinterest ad account, facilitating the creation and optimization of targeted advertising campaigns. For more information, see [Adgroup](https://developers.pinterest.com/docs/api/v5/#tag/ad_groups).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>created_time</td><td>NUMERIC</td></tr><tr><td>updated_time</td><td>NUMERIC</td></tr><tr><td>campaign_id</td><td>STRING</td></tr><tr><td>ad_account_id</td><td>STRING</td></tr><tr><td>auto_targeting_enabled</td><td>BOOLEAN</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>budget_type</td><td>STRING</td></tr><tr><td>billable_event</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>lifetime_frequency_cap</td><td>NUMERIC</td></tr><tr><td>targeting_spec</td><td>RECORD</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>placement_group</td><td>STRING</td></tr><tr><td>pacing_delivery_type</td><td>STRING</td></tr><tr><td>conversion_learning_mode_type</td><td>STRING</td></tr><tr><td>summary_status</td><td>STRING</td></tr><tr><td>feed_profile_id</td><td>STRING</td></tr><tr><td>optimization_goal_metadata</td><td>RECORD</td></tr><tr><td>bid_strategy_type</td><td>STRING</td></tr></tbody></table>

### Ads&#x20;

Enables businesses to create, manage, and monitor individual ads within their Pinterest ad account, ensuring effective ad campaign management and optimization. For more information, see [Ads](https://developers.pinterest.com/docs/api/v5/#tag/ads).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>ad_group_id</td><td>STRING</td></tr><tr><td>ad_account_id</td><td>STRING</td></tr><tr><td>campaign_id</td><td>STRING</td></tr><tr><td>created_time</td><td>NUMERIC</td></tr><tr><td>creative_type</td><td>STRING</td></tr><tr><td>destination_url</td><td>STRING</td></tr><tr><td>is_pin_deleted</td><td>BOOLEAN</td></tr><tr><td>is_removable</td><td>BOOLEAN</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>pin_id</td><td>STRING</td></tr><tr><td>review_status</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>summary_status</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>updated_time</td><td>NUMERIC</td></tr></tbody></table>

### AdAnalytics&#x20;

Businesses can access detailed analytics and performance data for individual ads, helping them assess ad effectiveness and make data-driven decisions. For more information, see [AdAnalytics](https://developers.pinterest.com/docs/api/v5/#operation/ads/analytics).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>PIN_ID</td><td>NUMERIC</td></tr><tr><td>AD_GROUP_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_OBJECTIVE_TYPE</td><td>NUMERIC</td></tr><tr><td>AD_GROUP_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_FREQUENCY</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_LIFETIME_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_USER</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_DAILY_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>AD_ID</td><td>STRING</td></tr><tr><td>ADVERTISER_ID</td><td>NUMERIC</td></tr><tr><td>PIN_PROMOTION_ID</td><td>NUMERIC</td></tr><tr><td>DATE</td><td>DATE</td></tr><tr><td>IMPRESSION_2</td><td>NUMERIC</td></tr><tr><td>AD_ACCOUNT_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_NAME</td><td>STRING</td></tr></tbody></table>

### Campaigns&#x20;

Provides tools for managing and organizing advertising campaigns within a Pinterest ad account, simplifying the process of creating and tracking multiple campaigns. For more information, see [Campaigns](https://developers.pinterest.com/docs/api/v5/#tag/campaigns).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>ad_account_id</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>objective_type</td><td>STRING</td></tr><tr><td>lifetime_spend_cap</td><td>NUMERIC</td></tr><tr><td>daily_spend_cap</td><td>NUMERIC</td></tr><tr><td>created_time</td><td>NUMERIC</td></tr><tr><td>updated_time</td><td>NUMERIC</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>is_flexible_daily_budgets</td><td>BOOLEAN</td></tr><tr><td>summary_status</td><td>STRING</td></tr><tr><td>is_campaign_budget_optimization</td><td>BOOLEAN</td></tr><tr><td>start_time</td><td>NUMERIC</td></tr></tbody></table>

### CampaignAnalytics

Businesses can retrieve comprehensive analytics and performance data specific to their advertising campaigns, aiding in campaign optimization and decision-making. For more information, see [CampaignAnalytics](https://developers.pinterest.com/docs/api/v5/#operation/campaigns/analytics).

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>TOTAL_IMPRESSION_FREQUENCY</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_LIFETIME_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_USER</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_DAILY_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>ADVERTISER_ID</td><td>NUMERIC</td></tr><tr><td>DATE</td><td>DATE</td></tr><tr><td>IMPRESSION_2</td><td>NUMERIC</td></tr><tr><td>AD_ACCOUNT_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ID</td><td>STRING</td></tr><tr><td>CAMPAIGN_NAME</td><td>STRING</td></tr></tbody></table>