Upload conversions with Ads Manager

Upload a CSV file with web, in-app, offline conversions or any combination thereof into Ads Manager. Pinterest matches relevant campaigns to these conversions, and you can then pull relevant reporting for these uploaded conversions in Ads Manager.

Before you get started

  • Make sure you have an active campaign

Prepare CSV file

  • Frequency: Upload at a regular interval, at least once a month or more frequently. Send conversion data within 30 days of each conversion occurrence to Pinterest on a monthly or more frequent cadence.
  • File size: Files must be under 5GB in size and contain less than 10M rows.

Upload conversions to ads manager

  1. Open Pinterest with your business account and click Ads.
  2. Click Conversions
  3. Click Upload Conversions
  4. Upload your .csv

Matching events

Once we’ve received your conversion file and completed the match process, we delete your original file along with any user identifiers you gave us, as covered in our Ad Data Terms.

Check the status of your csv upload

  1. Open Pinterest with your business account and click Ads.
  2. Click Conversions
  3. Click Conversion upload history
  4. Was the upload a success?

Troubleshooting

If an upload fails, review the upload and errors before you resubmit the CSV.

  1. Open Pinterest with your business account and click Ads.
  2. Click Conversions
  3. Click Conversion upload history
  4. Click on the row of the failed upload to see a dropdown displaying information on reasons for failure
  5. Click into View Data Errors to see the invalid data values in the CSV

Pinterest does not store original csv files from advertisersafter the match process is completed. To troubleshoot, you should refer to the invalid data values on your original uploaded file. 

CSV File Specifications

Customer data fields
Column name Description Example Required?
email

Up to 4 email addresses (can have up to 4 columns with the header name email or email_1, email_2, email_3, email_4)

We support both hashed (SHA256, SHA1, MD5) and cleartext customer data fields.

If SHA256, SHA1, MD5 hashing, use lowercase characters and remove extra spaces before, after or in between the email address.

example [at] email.com Either email or madid fields are required
madid Mobile Ad IDs; we accept Android Ad ID and Apple IDFA AECE52E7-03EE-455A-B3C4-E57283966239 Either email or madid fields are required
Event data fields
Column name Description Example Required?
event_time
(Please do not compile data using Excel so as to avoid auto-correct)
Unix timestamps are recommended. We will accept these formats:
  • MM/dd/yyyy hh:mm:ss aa
  • MM/dd/yyyy HH:mm:ss
  • yyyy-MM-dd HH:mm:ss
  • yyyy-MM-ddTHH:mm:ss
  • yyyy-MM-dd HH:mm:ss+zzzz
  • yyyy-MM-ddTHH:mm:ss+zzzz
  • yyyy-MM-dd
  • MM/dd/yyyy

Unix timestamp
Transaction data should be uploaded within 30 days of the conversion
 

08/14/2012

or

08/14/2012 5:01:54 PM

or

2019-08-14T12:32:42+0700

Yes
event_type

Standard conversion event types:

  • Signup
  • Checkout
  • Custom
  • ViewCategory
  • Search
  • AddToCart
  • WatchVideo
  • Lead

If not included will default to Checkout

Checkout Yes
source_type Add the event source type: 
  • offline
  • app_android
  • app_ios
  • web

If not included we default to offline.
 

offline Yes
value Cost of product on the row 500.00 Yes for checkout
order_id A contiguous identifier for the offline transaction, 64 character limit X-151481 Optional - preferred for checkout events
quantity Number items of purchased 15

No

product_id The item number field may contain an alphanumeric value with no special characters, currency symbols or commas; this field allows you to split a transaction into multiple events by using unique product ids, i.e. SKUs, UPCs etc., for each item that is associated with the same transaction-id

108

or

F28

No
currency Currency paid

USD

CAD

No
property Website property that the item is purchased from brandsite.com No
product_name Short name of the product Gabrielle chair No
promo_code Promotion that was used for the purchase Winter 10 No
product_category Top level category of product furniture No
product_sub_category Sub-category of product chair No
product_variant Any product variation identifiers of the product

red

or

leather

No
product_brand Brand name of the product Gabrielle No
is_new_customer

New customer (Y)

Existing customer (N)

Y No

What's the next step?

Learn about offline conversion events reporting

Still need help?
Contact us