The Pinterest Conversions API Program for Offline Conversions
The Pinterest Conversions API Program for Offline Conversions enables advertisers to send offline conversion data to Pinterest. Once the advertiser requests an attribution report based on their desired settings, Pinterest performs attribution analysis on the impact of that advertiser’s Pinterest campaign on offline conversions and sends them an offline conversion report. This allows advertisers to understand how Pinterest campaigns drive offline conversions and to find additional data to better optimize ad spend or customer experience.
The Pinterest Conversions API Program for Offline Conversions is a Pinterest-paid program, so there is no cost for brands and advertisers.
Note
Pinterest must approve all program participants. Contact your LiveRamp or Pinterest rep to find out about getting approved for the Pinterest Conversions API Program for Offline Conversions.
The Pinterest Conversions API Program for Offline Conversions was formerly known as "the Pinterest Offline Conversion Reporting Attribution Program".
Overview of Steps Involved
The following steps need to be performed to enable the attribution analysis in Pinterest:
Before your campaign starts, you send LiveRamp a sample conversion data file so we can test the integration with Pinterest (if necessary).
You activate your campaign.
You send offline (in-store) conversion data from the last 30 days with PII to LiveRamp.
LiveRamp matches the PII to RampIDs and delivers matched data to Pinterest.
Pinterest matches RampIDs to Pinterest IDs.
You request an attribution report with your desired settings.
Pinterest generates an offline conversion report for the advertiser’s Pinterest campaigns.
See the appropriate sections below for more information on performing these steps.
Format the File
Tip
To download an Excel file template that contains all possible columns and formatting instructions, click here.
After transferring your data into the file template, be sure to delete the row with the formatting instructions and save the file in one of our allowed file types (.csv, .tsv, .psv, or .txt) before uploading.
Once the file has been formatted correctly, upload the file to LiveRamp. See the “Upload the File” section below for more information.
Note
Once you set up the file format for an existing attribution program feed, try to keep the file format (such as the column headers or the column order) the same for all subsequent files. If you change the file format for an existing feed, create a support case before uploading the new file to ensure your existing attribution feeds are not impacted. For more information, see "Changing the Format of an Existing File".
List of All File Columns
See the table below for a list of columns and formatting instructions:
Field Name | Column Required? | Values Required? | Notes |
---|---|---|---|
first_name | Yes | Yes (if name and postal address (NAP) is used as an identifier) | |
last_name | Yes | Yes (if NAP is used as an identifier) | |
address_1 | Yes | Yes (if NAP is used as an identifier) | |
address_2 | Yes | No |
|
city | Yes | Yes (if NAP is used as an identifier) | |
state | Yes | Yes (if NAP is used as an identifier) |
|
zip | Yes | Yes (if NAP is used as an identifier) |
|
email_1 | Yes | Yes (if email address is used as an identifier) |
|
email_2 | Yes | No |
|
email_3 | Yes | No |
|
email_4 | Yes | No |
|
transaction_category | Yes | Yes |
|
transaction_timestamp | Yes | Yes |
|
transaction_amount | Yes | Yes |
|
phone_1 | Yes | Yes (if phone number is used as an identifier) |
|
phone_2 | Yes | No |
|
order_id | Yes | Yes |
|
quantity | No | No |
|
product_id | No | No |
|
currency | No | No |
|
product_name | No | No |
|
promo_code | No | No |
|
product_category | No | No |
|
product_subcategory | No | No |
|
product_variant | No | No |
|
product_brand | No | No |
|
is_new_customer | No | No | Identifies whether the customer is a new or existing customer. Possible values:
|
Header Row Example
The headers shown below are all required.
first_name|last_name|address_1|address_2|city|state|zip|email_1|email_2|email_3|email_4|transaction_category|transaction_timestamp|transaction_amount|phone_1|phone_2|order_id
Conversion Data Examples
Alex|Chen|44 Main Street|#12|San Francisco|CA|94100|alex@gmail.com|ac@ymail.com|||In-store|2014-03-31|99.99|4157892314|4156438224|58239
Julian|Roodiger|55 Mission Street||San Francisco|CA|94500|julian@gmail.com||||Offline|2014-03-30|55.55|4159032427|4157823435|67324
Send Conversion Data to LiveRamp
If you’re not currently using another LiveRamp Conversions API program (such as Bing or Yelp), we might need you to send us sample conversion data to set up the integration.
Caution
Most platforms require that at least 1,000 unique transaction events be uploaded over a 28-day period.
Conversion Data Guidelines
Each conversion data record must include at least one PII identifier (name and postal address, email, or phone) and the required conversion data:
Transaction category
Transaction timestamp
Transaction amount
Order ID
Conversion data should be uploaded within 30 days of the conversion.
Upload the File
Upload conversion data files using LiveRamp’s SFTP server or your SFTP server.
You can also have us pull files from an AWS S3 bucket or GCS bucket. See “Getting Your Data Into LiveRamp” for more information.
Caution
Files for this conversions program cannot be uploaded via Connect.
To upload files using LiveRamp's SFTP: Use the credentials provided by your technical contact once the agreement has been signed and follow the instructions in “Upload a File via LiveRamp's SFTP”.
To upload files using your SFTP: Follow the instructions in “Upload a File via Your SFTP”.
After uploading, email LiveRamp support (pinterestmeasurement@liveramp.com) to confirm that you have uploaded conversion data.
Note
For future uploads, you do not have to email LiveRamp to confirm that you have uploaded data assuming headers have not changed or additional columns have not been added.
Once the file is uploaded, information on file processing status can be viewed in LiveRamp Connect.
Contact LiveRamp (pinterestmeasurement@liveramp.com) if you have any questions.
After Pinterest has ingested the conversion data, you can request an attribution report with your desired settings. Your Pinterest account team will then run the attribution report and send it back to you. The report will include aggregated offline conversion data for the requested date range.
FAQs
At what cadence should I send my conversion data files?
LiveRamp can receive conversion data files for this program on a daily, weekly, or monthly basis, but we highly suggest automated daily delivery as it gives LiveRamp the greatest ability to match. If you prefer not to send daily files, the next best option is weekly delivery as this enables data to be reported within the same month.
What conversion data should I include in my conversion data file?
Include all traceable offline transactions in your delivery. Do not include online transaction data.
Avoid sending duplicate transactions (transactions already sent to LiveRamp). If you send daily files, only include transactions that occurred on that day. If you send weekly or monthly files, only send transactions that occurred since the previous file was sent.
Do not include transactions with a transaction date in the future.
How long until will it take after I upload my data before I can request a report from Pinterest?
It usually takes 1-3 days to get the data to Pinterest and then about 2 days for Pinterest to ingest the data.