Upload a CSV file with web, in-app and/or offline conversions into Ads Manager. We'll then match relevant campaigns to these conversions so that you can then review total campaign conversions in Ads Manager.

Note: Make sure you have an active campaign.

Prepare your CSV file
  • Frequency: Upload your file at least once a month and send conversion data within 30 days of each conversion occurrence to Pinterest.
  • File size: Your file must be under 5 GB in size and contain fewer than 10 million rows.
    •  Upload conversions to Ads Manager
  • Log in to your Pinterest business account
  • Click on in the top left-hand corner of the page
  • Under Business, click Conversions
  • Click Upload file from the left-side navigation
  • Click  to select the file you want to upload, or drag and drop the file to upload it
    •

    Once we’ve received your conversion file and completed the match process, we'll 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
  • Log in to your Pinterest business account
  • Click on in the top left-hand corner of the page
  • Under Business, click Conversions
  • Click Upload history from the left-side navigation
    •

    If the upload was successful, your data will become available in the reporting dashboard in Ads Manager in 48 hours. If the upload was not successful, move on to Troubleshoot your upload.

    Troubleshoot your upload

    If your upload fails, find and review the upload errors and make updates before you resubmit the CSV.

  • Log in to your Pinterest business account
  • Click on in the top left-hand corner of the page
  • Under Business, click Conversions
  • Click Upload history from the left-side navigation.
  • Click the row of the failed upload to see a drop-down displaying information about reasons for failure.
  • Click into View Data Errors to see the invalid data values in the CSV. Review the Customer data fields and Event data fields for expected schema and examples of expected values.
    •

    Pinterest does not store original CSV files from advertisers after the match process has been completed. To troubleshoot, you should refer to the invalid data values on your original uploaded file. 
    CSV file specifications
    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 using SHA256, SHA1 or MD5 hashing, use lowercase characters and remove extra spaces before, after or between the email address.

    		 example@email.com Either email or madid fields are required
    madid
    Mobile ad IDs; we accept Android ad IDs    		 AECE52E7-03EE-455A-B3C4-E57283966239 Either email or madid fields are required
    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 accept these formats:
    • dd/MM/yyyy hh:mm:ss aa
    • dd/MM/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
    • dd/MM/yyyy
    Unix timestamp
    Transaction data should be uploaded within 30 days of the conversion.
     

    14/08/2012

    or

    14/08/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 it's not included, we'll default to Checkout.

    		 Checkout Yes
    source_type Add the event source type: 
    • offline
    • app_android
    • app_ios
    • web
    If it's not included, we'll 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 but preferred for Checkout events
    quantity Number of items purchased. 15

    No
    product_id The item number field can 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, e.g. SKUs or UPCs, for each item that's 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 Subcategory of the 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 next?

    Once you have your offline conversions data connected to Pinterest, find out more about Offline conversion events reporting.
    Still need help? Contact us
    Was this article helpful?

    How can we make this article better?