Pinterest Ads

Conversion: Conversion is the process of a user interacting with your ad that subsequently leads to a action defined based on your ad goals. For example, signup, checkout, or an add to cart event.
Attribution: Attribution is the process of linking a current user action to a previous interaction with the ad. For example, a purchase made today may be attributable to an add-to-cart event a week ago, or a sign-up may be attributable to an earlier ad-click. The respective attribution window, then, defines the duration for which you want to capture the attributions. For example, you may generate a conversion report for checkouts attributable to ad-clicks in the past 20 days.
Ad-Action: Ad-action is the interaction or engagement of the user with the Pins such as clicks, reactions, or comments.

Prerequisites

An active Pinterest Business account from which the data is to be ingested.
A Pinterest user with Admin privileges, to access the data from the Pinterest Ads account.

Configuring Pinterest Ads as a Source

Perform the following steps to configure Pinterest Ads as the Source in your Pipeline:

Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select Pinterest Ads.
In the Configure your Pinterest Ads account page, click + ADD PINTEREST ADS ACCOUNT.
Sign in using your Pinterest Business account.
Click Continue to authorize Hevo to access your Pinterest Ads data.
In the Configure your Pinterest Ads Source page, specify the following:
- Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
- Select Accounts: The Pinterest Ads account(s) whose data you want to ingest. You can select multiple Ad accounts.
- Historical Sync Duration: The duration for which the historical data must be ingested. Default value: 6 Months.
- Breakdowns: The granularity of time that you want in your report data. For example, you can break down the number of clicks by Week or Month.
- Advanced Settings:
  - Attribution Windows: The number of days between a user’s responses on an ad. You can specify either one or both of the following:
    - Click Attribution Window: The number of days between a person clicking your ad and taking an action such as checking out an item.
    - Engagement Attribution Window: The number of days between a person engaging with your ad and taking an action such as adding the item to the cart.
    - View Attribution Window: The number of days between a person viewing your ad and taking an action such as visiting a page.
- Conversion Report Time: The factor based on which you want to generate a conversion report. Default value: Time of Ad Action. You can select either of the following:
  - Time of Ad Action: Displays the conversion report as per the time at which a user action such as engagement with Pins, clicks, reactions, or comments occurred.
  - Time of Conversion: Displays the conversion report as per the time at which a conversion event, such as sign-up or add to cart occurred.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

Default Pipeline Frequency	Minimum Pipeline Frequency	Maximum Pipeline Frequency	Custom Frequency Range (Hrs)
1 Hr	1 Hr	24 Hrs	1-48

Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.

Historical Data: In the first run of the Pipeline, Hevo fetches the data of all the objects and the reports available in your account until the current date and loads it to the Destination.
Incremental Data: Once the historical load is complete, all new and updated records are synchronized with your Destination daily. For objects, Hevo performs full load to capture any data changes. For reports, Hevo incrementally fetches data as per the Pipeline frequency.
Refresher Data: Hevo refreshes the report data once every 24 hours.

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination:

Data Model

Hevo fetches both objects and reports from your specified ads account. Reports provide metrics around your users, their interaction related details, and the performance of your Ads.

Objects

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object	Description
Ads	Contains the details of the ads per ad account.
Ad Accounts	Contains the details of the Pinterest Ads accounts.
Ad Groups	Contains the details of the ad groups per ad account.
Boards	Contains the details of the boards per ad account.
Campaign	Contains the details of the ad campaigns available in the specified ad account.
Pins	Contains the details of the pins per ad account.

Reports

The following reports are replicated as tables in the Destination when you run the Pipeline:

Ad Report
Ad Account Report
Ad Campaign Report
Ad Group Report

Revision History

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
May-10-2022	1.88	New document.

Last updated on 11 May 2022