# Pinterest

Pinterest is a visual discovery and bookmarking platform that allows users to save and share multimedia content. A Pinterest ad account allows businesses to create and manage advertising campaigns on the platform. Advertisers can set campaign objectives, define targeting parameters based on demographics, interests, and search terms, and track the performance of their ads through metrics such as impressions, clicks, conversions, and engagement.

#### This section includes:

* [Snapshot](#snapshot)
* [Tables/APIs Supported](#tables-apis-supported)
* [Setup Manual](#setup-manual)
* [Schema Information](#schema-information)

## Snapshot

| Features                        | Details                                      |
| ------------------------------- | -------------------------------------------- |
| Release Status                  | Released                                     |
| Table Selection                 | Yes                                          |
| Column Selection                | Yes                                          |
| Edit Integration                | Yes                                          |
| Replication Type Selection      | No                                           |
| Authentication Parameters       | <p>Pinterest Email<br>Pinterest Password</p> |
| Suggested Replication Frequency | 24 hrs                                       |

## Tables/APIs Supported

<table><thead><tr><th width="262">Table Name</th></tr></thead><tbody><tr><td><a href="#campaigns">campaigns</a></td></tr><tr><td><a href="#ad_groups">ad_groups</a></td></tr><tr><td><a href="#a-ds">ads</a></td></tr><tr><td><a href="#ad_accounts_analytics">ad_accounts_analytics</a></td></tr><tr><td><a href="#campaigns_analytics">campaigns_analytics</a></td></tr><tr><td><a href="#ad_groups_analytics">ad_groups_analytics</a></td></tr><tr><td><a href="#ad_analytics">ads_analytics</a></td></tr></tbody></table>

## Setup Manual

* [Prerequisites](#prerequisites)&#x20;
* [Integrate Your Pinterest account with Daton](#integrate-your-pinterest-account-with-daton)
* [Workflow](#workflow)

### Prerequisites <a href="#prerequisites" id="prerequisites"></a>

To integrate Pinterest into Daton, a user will require the following:

* A Pinterest Ads account with Admin access to the Pins and Boards of other linked accounts.
* An Advertiser under that account.

### Integrate Your Pinterest account with Daton

* [Sign in](https://daton.sarasanalytics.com/login) to your existing Daton account.&#x20;
* Search for Pinterest in the list of Connectors and click on the **'Configure'** button.<br>

  <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FmcM3ShPx4isrYH2jMRtJ%2FPinterest1.png?alt=media&#x26;token=d1302cdd-6757-4e6f-acc6-7f8476856625" alt=""><figcaption></figcaption></figure>
* Provide the necessary **Integration Name**, **Replication Frequency**, and **Replication Start Date** data and click on the **'Authenticate'** button.\
  \&#xNAN;*Please Note, the **Integration Name** would be used in creating tables for the integration and cannot be changed later.*&#x20;

  <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FZyboNWUhGsSIay9JKFcC%2FPinterest2.png?alt=media&#x26;token=5bf71ba5-4a28-455b-9750-b31151f8a3ff" alt=""><figcaption></figcaption></figure>
* You will now be redirected to **log in to your Pinterest ad account.**

  <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FQe7ThZgENCbRp8QvegR9%2FPinterest3.png?alt=media&#x26;token=fcbb7add-c8b9-4d54-8ab7-bcaba5ddbd76" alt=""><figcaption></figcaption></figure>
* Now **select** all or select specific accounts from all your existing Pinterest Ad accounts whose data you want to replicate. And click on the **'Next'** button.

  <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FHWbJzTg8tkqcIBVblgvg%2FPinterest4.png?alt=media&#x26;token=f1e5dbdd-62b0-4283-a187-c26958995f60" alt=""><figcaption></figcaption></figure>
* Post successful authentication, you will be prompted to choose from the list of available tables. **Add** the required Tables and click on **'Next.'**&#x20;

  <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FdRj927QHiI1cWKtIA75u%2FPinterest5.png?alt=media&#x26;token=934fd74c-c493-4056-a435-0e9f1ef8a3ea" alt=""><figcaption></figcaption></figure>
* **Select** all the **columns** or at least one column from each of the Selected tables and **Submit** the integration.&#x20;

  <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FQWfA0b568R3cOZocixPF%2FPinterest6.png?alt=media&#x26;token=42108823-351b-4520-9ba9-138b3855f6d6" alt=""><figcaption></figcaption></figure>
* Once submitted, you will be prompted to select the destination for your data to replicate. Select your favorite destination and click on **'Confirm.'**\
  You will now receive a popup saying **'Integration Successful.'**\
  \
  Congrats! Your Ad Account has been integrated with Daton.

### Workflow

1. Integrations would be in the **Pending state** *initially* and will be moved to the **Active state** *as soon as the first job loads* data successfully into the configured warehouse.
2. Users can **view** *job status and process logs* from the integration details page by clicking on the integration name from the active list.
3. Users can **Re-Authenticate, Edit, Clone, Pause** or **Delete** the integration at any given time by clicking on the settings\
   You can also edit the integration to **change frequency** and **history**.
4. Each table in your integration can be accessed by clicking on the integration on the 'Sources' page. Here you may find the **status of each table,** the **last replicated time,** and **Reload access buttons**.

## Schema Information

#### **campaigns**

Purpose: Get a specific campaign for a Pinterest ad account.

Source API Documentation: [Pinterest- Campaigns API](https://developers.pinterest.com/docs/api/v5/#tag/campaigns)

**FIELDS**

<table><thead><tr><th width="424.84444444444443">Field Name</th><th width="277">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>lifetime_spend_cap</td><td>INTEGER</td></tr><tr><td>daily_spend_cap</td><td>INTEGER</td></tr><tr><td>order_line_id</td><td>STRING</td></tr><tr><td>tracking_urls</td><td>RECORD</td></tr><tr><td>objective_type</td><td>STRING</td></tr><tr><td>created_time</td><td>INTEGER</td></tr><tr><td>updated_time</td><td>INTEGER</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>start_time</td><td>INTEGER</td></tr><tr><td>is_flexible_daily_budgets</td><td>BOOLEAN</td></tr><tr><td>is_campaign_budget_optimization</td><td>BOOLEAN</td></tr><tr><td>summary_status</td><td>STRING</td></tr><tr><td>CONVERSION_REPORT_TIME</td><td>STRING</td></tr><tr><td>daily_spend_cap_nu</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### **ad\_groups**&#x20;

Purpose: Get a specific ad group for a Pinterest ad account.

Source API Documentation: [Pinterest- Ad Groups API](https://developers.pinterest.com/docs/api/v5/#tag/ad_groups)

**FIELDS**

<table><thead><tr><th width="421.94301994301986">Field Name</th><th width="386">Data Type</th></tr></thead><tbody><tr><td>name</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>budget_in_micro_currency</td><td>INTEGER</td></tr><tr><td>bid_in_micro_currency</td><td>INTEGER</td></tr><tr><td>budget_type</td><td>STRING</td></tr><tr><td>start_time</td><td>NUMERIC</td></tr><tr><td>end_time</td><td>NUMERIC</td></tr><tr><td>targeting_spec</td><td>RECORD</td></tr><tr><td>lifetime_frequency_cap</td><td>INTEGER</td></tr><tr><td>tracking_urls</td><td>RECORD</td></tr><tr><td>auto_targeting_enabled</td><td>BOOLEAN</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>campaign_id</td><td>STRING</td></tr><tr><td>billable_event</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>ad_account_id</td><td>STRING</td></tr><tr><td>created_time</td><td>INTEGER</td></tr><tr><td>updated_time</td><td>INTEGER</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### **ads**&#x20;

Purpose: Get a specific ad for a Pinterest ad account.&#x20;

Source API Documentation: [Pinterest- ads API](https://developers.pinterest.com/docs/api/v5/#tag/ads)

**FIELDS**

<table><thead><tr><th width="425.4600938967136">Field Name</th><th width="326">Data Type</th></tr></thead><tbody><tr><td>ad_group_id</td><td>STRING</td></tr><tr><td>android_deep_link</td><td>STRING</td></tr><tr><td>carousel_android_deep_links</td><td>STRING</td></tr><tr><td>carousel_destination_urls</td><td>STRING</td></tr><tr><td>carousel_ios_deep_links</td><td>STRING</td></tr><tr><td>click_tracking_url</td><td>STRING</td></tr><tr><td>creative_type</td><td>STRING</td></tr><tr><td>destination_url</td><td>STRING</td></tr><tr><td>ios_deep_link</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>status</td><td>STRING</td></tr><tr><td>tracking_urls</td><td>RECORD</td></tr><tr><td>view_tracking_url</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>collection_items_destination_url_template</td><td>STRING</td></tr><tr><td>created_time</td><td>INTEGER</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>rejected_reasons</td><td>STRING</td></tr><tr><td>rejection_labels</td><td>STRING</td></tr><tr><td>review_status</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>updated_time</td><td>INTEGER</td></tr><tr><td>summary_status</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### **ad\_accounts\_analytics**&#x20;

Purpose: Get analytics for a Pinterest ad account.&#x20;

Source API Documentation: [Pinterest- Ad Accounts Analytics API](https://developers.pinterest.com/docs/api/v5/#operation/ad_account/analytics)

**FIELDS**

<table><thead><tr><th width="428.9686028257456">Field Name</th><th width="332">Data Type</th></tr></thead><tbody><tr><td>AD_ACCOUNT_ID</td><td>STRING</td></tr><tr><td>CHECKOUT_ROAS</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_1</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_1_GROSS</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_2</td><td>NUMERIC</td></tr><tr><td>CPC_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CPM_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CPM_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CTR</td><td>NUMERIC</td></tr><tr><td>CTR_2</td><td>NUMERIC</td></tr><tr><td>ECPCV_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPCV_P95_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPC_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPC_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPE_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPM_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPV_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECTR</td><td>NUMERIC</td></tr><tr><td>EENGAGEMENT_RATE</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_1</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_2</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_RATE</td><td>NUMERIC</td></tr><tr><td>IDEA_PIN_PRODUCT_TAG_VISIT_1</td><td>NUMERIC</td></tr><tr><td>IDEA_PIN_PRODUCT_TAG_VISIT_2</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_1</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_1_GROSS</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_2</td><td>NUMERIC</td></tr><tr><td>INAPP_CHECKOUT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>OUTBOUND_CLICK_1</td><td>NUMERIC</td></tr><tr><td>OUTBOUND_CLICK_2</td><td>NUMERIC</td></tr><tr><td>PAGE_VISIT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>PAGE_VISIT_ROAS</td><td>NUMERIC</td></tr><tr><td>PAID_IMPRESSION</td><td>NUMERIC</td></tr><tr><td>PIN_ID</td><td>NUMERIC</td></tr><tr><td>REPIN_1</td><td>NUMERIC</td></tr><tr><td>REPIN_2</td><td>NUMERIC</td></tr><tr><td>REPIN_RATE</td><td>NUMERIC</td></tr><tr><td>SPEND_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>SPEND_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICKTHROUGH</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CONVERSIONS</td><td>NUMERIC</td></tr><tr><td>TOTAL_CUSTOM</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_FREQUENCY</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_USER</td><td>NUMERIC</td></tr><tr><td>TOTAL_LEAD</td><td>NUMERIC</td></tr><tr><td>TOTAL_PAGE_VISIT</td><td>NUMERIC</td></tr><tr><td>TOTAL_REPIN_RATE</td><td>NUMERIC</td></tr><tr><td>TOTAL_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_3SEC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_MRC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P0_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P100_COMPLETE</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P25_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P50_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P75_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P95_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CLICK_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_ENGAGEMENT_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_VIEW_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>VIDEO_3SEC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_LENGTH</td><td>NUMERIC</td></tr><tr><td>VIDEO_MRC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P0_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P100_COMPLETE_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P25_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P50_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P75_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P95_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>WEB_CHECKOUT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>WEB_CHECKOUT_ROAS</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### **campaigns\_analytics**&#x20;

Purpose: Get analytics for the specified campaigns for a Pinterest ad account.&#x20;

Source API Documentation: [Pinterest- Campaigns Analytics API](https://developers.pinterest.com/docs/api/v5/#operation/campaigns/analytics)

**FIELDS**

<table><thead><tr><th width="422.9686028257456">Field Name</th><th width="375">Data Type</th></tr></thead><tbody><tr><td>AD_ACCOUNT_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_DAILY_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ID</td><td>STRING</td></tr><tr><td>CAMPAIGN_LIFETIME_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_NAME</td><td>STRING</td></tr><tr><td>CHECKOUT_ROAS</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_1</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_1_GROSS</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_2</td><td>NUMERIC</td></tr><tr><td>CPC_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CPM_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CPM_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CTR</td><td>NUMERIC</td></tr><tr><td>CTR_2</td><td>NUMERIC</td></tr><tr><td>ECPCV_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPCV_P95_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPC_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPC_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPE_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPM_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPV_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECTR</td><td>NUMERIC</td></tr><tr><td>EENGAGEMENT_RATE</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_1</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_2</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_RATE</td><td>NUMERIC</td></tr><tr><td>IDEA_PIN_PRODUCT_TAG_VISIT_1</td><td>NUMERIC</td></tr><tr><td>IDEA_PIN_PRODUCT_TAG_VISIT_2</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_1</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_1_GROSS</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_2</td><td>NUMERIC</td></tr><tr><td>INAPP_CHECKOUT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>OUTBOUND_CLICK_1</td><td>NUMERIC</td></tr><tr><td>OUTBOUND_CLICK_2</td><td>NUMERIC</td></tr><tr><td>PAGE_VISIT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>PAGE_VISIT_ROAS</td><td>NUMERIC</td></tr><tr><td>PAID_IMPRESSION</td><td>NUMERIC</td></tr><tr><td>PIN_ID</td><td>NUMERIC</td></tr><tr><td>REPIN_1</td><td>NUMERIC</td></tr><tr><td>REPIN_2</td><td>NUMERIC</td></tr><tr><td>REPIN_RATE</td><td>NUMERIC</td></tr><tr><td>SPEND_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>SPEND_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICKTHROUGH</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CONVERSIONS</td><td>NUMERIC</td></tr><tr><td>TOTAL_CUSTOM</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_FREQUENCY</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_USER</td><td>NUMERIC</td></tr><tr><td>TOTAL_LEAD</td><td>NUMERIC</td></tr><tr><td>TOTAL_PAGE_VISIT</td><td>NUMERIC</td></tr><tr><td>TOTAL_REPIN_RATE</td><td>NUMERIC</td></tr><tr><td>TOTAL_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_3SEC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_MRC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P0_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P100_COMPLETE</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P25_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P50_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P75_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P95_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CLICK_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_ENGAGEMENT_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_VIEW_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>VIDEO_3SEC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_LENGTH</td><td>NUMERIC</td></tr><tr><td>VIDEO_MRC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P0_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P100_COMPLETE_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P25_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P50_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P75_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P95_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>WEB_CHECKOUT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>WEB_CHECKOUT_ROAS</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### **ad\_groups\_analytics**&#x20;

Purpose: Get analytics for the specified ad groups for a Pinterest ad account.&#x20;

Source API Documentation: [Pinterest- Ad Groups Analytics API](https://developers.pinterest.com/docs/api/v5/#operation/ad_groups/analytics)

**FIELDS**

<table><thead><tr><th width="420.9686028257456">Field Name</th><th width="195">Data Type</th></tr></thead><tbody><tr><td>AD_ACCOUNT_ID</td><td>NUMERIC</td></tr><tr><td>AD_GROUP_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>AD_GROUP_ID</td><td>STRING</td></tr><tr><td>CAMPAIGN_DAILY_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_LIFETIME_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_NAME</td><td>STRING</td></tr><tr><td>CHECKOUT_ROAS</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_1</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_1_GROSS</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_2</td><td>NUMERIC</td></tr><tr><td>CPC_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CPM_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CPM_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CTR</td><td>NUMERIC</td></tr><tr><td>CTR_2</td><td>NUMERIC</td></tr><tr><td>ECPCV_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPCV_P95_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPC_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPC_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPE_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPM_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPV_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECTR</td><td>NUMERIC</td></tr><tr><td>EENGAGEMENT_RATE</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_1</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_2</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_RATE</td><td>NUMERIC</td></tr><tr><td>IDEA_PIN_PRODUCT_TAG_VISIT_1</td><td>NUMERIC</td></tr><tr><td>IDEA_PIN_PRODUCT_TAG_VISIT_2</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_1</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_1_GROSS</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_2</td><td>NUMERIC</td></tr><tr><td>INAPP_CHECKOUT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>OUTBOUND_CLICK_1</td><td>NUMERIC</td></tr><tr><td>OUTBOUND_CLICK_2</td><td>NUMERIC</td></tr><tr><td>PAGE_VISIT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>PAGE_VISIT_ROAS</td><td>NUMERIC</td></tr><tr><td>PAID_IMPRESSION</td><td>NUMERIC</td></tr><tr><td>PIN_ID</td><td>NUMERIC</td></tr><tr><td>REPIN_1</td><td>NUMERIC</td></tr><tr><td>REPIN_2</td><td>NUMERIC</td></tr><tr><td>REPIN_RATE</td><td>NUMERIC</td></tr><tr><td>SPEND_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>SPEND_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICKTHROUGH</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CONVERSIONS</td><td>NUMERIC</td></tr><tr><td>TOTAL_CUSTOM</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_FREQUENCY</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_USER</td><td>NUMERIC</td></tr><tr><td>TOTAL_LEAD</td><td>NUMERIC</td></tr><tr><td>TOTAL_PAGE_VISIT</td><td>NUMERIC</td></tr><tr><td>TOTAL_REPIN_RATE</td><td>NUMERIC</td></tr><tr><td>TOTAL_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_3SEC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_MRC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P0_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P100_COMPLETE</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P25_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P50_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P75_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P95_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CLICK_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_ENGAGEMENT_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_VIEW_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>VIDEO_3SEC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_LENGTH</td><td>NUMERIC</td></tr><tr><td>VIDEO_MRC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P0_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P100_COMPLETE_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P25_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P50_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P75_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P95_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>WEB_CHECKOUT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>WEB_CHECKOUT_ROAS</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### **ad\_analytics**

Purpose: Get analytics for the specified ads for a Pinterest ad account.&#x20;

Source API Documentation: [Pinterest- Ads Analytics API](https://developers.pinterest.com/docs/api/v5/#operation/ads/analytics)

**FIELDS**

<table><thead><tr><th width="447.9686028257456">Field Name</th><th width="386">Data Type</th></tr></thead><tbody><tr><td>AD_ACCOUNT_ID</td><td>NUMERIC</td></tr><tr><td>AD_GROUP_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>AD_GROUP_ID</td><td>NUMERIC</td></tr><tr><td>AD_ID</td><td>STRING</td></tr><tr><td>CAMPAIGN_DAILY_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ENTITY_STATUS</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_ID</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_LIFETIME_SPEND_CAP</td><td>NUMERIC</td></tr><tr><td>CAMPAIGN_NAME</td><td>STRING</td></tr><tr><td>CHECKOUT_ROAS</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_1</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_1_GROSS</td><td>NUMERIC</td></tr><tr><td>CLICKTHROUGH_2</td><td>NUMERIC</td></tr><tr><td>CPC_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CPM_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CPM_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>CTR</td><td>NUMERIC</td></tr><tr><td>CTR_2</td><td>NUMERIC</td></tr><tr><td>ECPCV_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPCV_P95_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPC_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPC_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPE_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPM_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECPV_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>ECTR</td><td>NUMERIC</td></tr><tr><td>EENGAGEMENT_RATE</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_1</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_2</td><td>NUMERIC</td></tr><tr><td>ENGAGEMENT_RATE</td><td>NUMERIC</td></tr><tr><td>IDEA_PIN_PRODUCT_TAG_VISIT_1</td><td>NUMERIC</td></tr><tr><td>IDEA_PIN_PRODUCT_TAG_VISIT_2</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_1</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_1_GROSS</td><td>NUMERIC</td></tr><tr><td>IMPRESSION_2</td><td>NUMERIC</td></tr><tr><td>INAPP_CHECKOUT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>OUTBOUND_CLICK_1</td><td>NUMERIC</td></tr><tr><td>OUTBOUND_CLICK_2</td><td>NUMERIC</td></tr><tr><td>PAGE_VISIT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>PAGE_VISIT_ROAS</td><td>NUMERIC</td></tr><tr><td>PAID_IMPRESSION</td><td>NUMERIC</td></tr><tr><td>PIN_ID</td><td>NUMERIC</td></tr><tr><td>REPIN_1</td><td>NUMERIC</td></tr><tr><td>REPIN_2</td><td>NUMERIC</td></tr><tr><td>REPIN_RATE</td><td>NUMERIC</td></tr><tr><td>SPEND_IN_DOLLAR</td><td>NUMERIC</td></tr><tr><td>SPEND_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICKTHROUGH</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_CONVERSIONS</td><td>NUMERIC</td></tr><tr><td>TOTAL_CUSTOM</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_ENGAGEMENT_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_IDEA_PIN_PRODUCT_TAG_VISIT</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_FREQUENCY</td><td>NUMERIC</td></tr><tr><td>TOTAL_IMPRESSION_USER</td><td>NUMERIC</td></tr><tr><td>TOTAL_LEAD</td><td>NUMERIC</td></tr><tr><td>TOTAL_PAGE_VISIT</td><td>NUMERIC</td></tr><tr><td>TOTAL_REPIN_RATE</td><td>NUMERIC</td></tr><tr><td>TOTAL_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_3SEC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_MRC_VIEWS</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P0_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P100_COMPLETE</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P25_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P50_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P75_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIDEO_P95_COMBINED</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_SIGNUP</td><td>NUMERIC</td></tr><tr><td>TOTAL_VIEW_SIGNUP_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CLICK_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_ENGAGEMENT_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_ENGAGEMENT_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_VIEW_CHECKOUT</td><td>NUMERIC</td></tr><tr><td>TOTAL_WEB_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR</td><td>NUMERIC</td></tr><tr><td>VIDEO_3SEC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_LENGTH</td><td>NUMERIC</td></tr><tr><td>VIDEO_MRC_VIEWS_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P0_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P100_COMPLETE_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P25_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P50_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P75_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>VIDEO_P95_COMBINED_2</td><td>NUMERIC</td></tr><tr><td>WEB_CHECKOUT_COST_PER_ACTION</td><td>NUMERIC</td></tr><tr><td>WEB_CHECKOUT_ROAS</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>