Use the bulk editor

Bulk editor is a tool that helps to efficiently create and manage thousands of ad campaigns. Download a CSV file template, input the data for your campaigns and upload the spreadsheet to the bulk editor to make all of your changes in one go.

Note that the CSV file can only be downloaded in English, and the uploaded values must be in English as well; we cannot accept other languages at the current time.

Create ads with bulk editor

From the bulk editor page, you’ll be able to export empty templates for new campaign creation.

  1. Click Ads in the top left-hand corner of Pinterest and select ‘Bulk Editor’, or go to ads.pinterest.com/bulk_editor.

  2. Click Download sample sheet to download your template, which will serve as a model for how to set up your own sheet. You can now use customised templates such as unique campaign, ad group, Promoted Pin and keyword details to include fields that are necessary for the specific action you’re taking.

  3. To create a new entity (campaign, ad group or Promoted Pin), add a new row to the sheet and select 'Create' as the desired action in column A – you can leave the object IDs blank, as these haven't been created yet.

  4. Once complete, click Upload template to upload your bulk editor sheet.

  5. If you're creating Promoted Pins, use the 'Upload media' section to upload the images or video for your ad creative.

  6. Click Upload.

Edit existing ads with the bulk editor

To use templates with data from existing campaigns, please navigate to your campaign’s reporting page in Ads Manager and export as 'Bulk sheet for editing or duplicating'.

  1. From the reporting page of Ads Manager, please ensure you export as 'Bulk sheet for editing or duplicating'.

  2. When you're completing the sheet with changes to your existing entities, please include 'Edit' as the action in column A – we'll ignore any rows without an action in column A.

  3. To create a new entity (campaign, ad group or Promoted Pin), add a new row to the sheet and include 'Create' as the desired action in column A. Be sure to reference the parent ID in the bulk template you're editing and leave the other fields for that parent object blank.

  4. Once complete, click Ads in the top left-hand corner of Pinterest and select ‘Bulk Editor’ or go to ads.pinterest.com/bulk_editor.

  5. Click Upload template to upload your bulk editor sheet.

  6. If you're editing Promoted Pins, use the 'Upload media' section to add the images for your ad creative. Also, if you're using photo editing software (e.g. Adobe Photoshop) and you upload a file that contains document layers, please ensure that you export the image as a .jpg or .png before uploading it to our platform.

  7. Click Upload.

Once the file has been submitted for processing, press 'Continue' and you’ll be led to the change history table to see if your upload was successful. If the status of the upload switches to 'Succeeded', your sheet was processed without any errors. If the status shows 'Errors', download the results and view the 'Status' to see what changes need to be made. If the status shows 'Failed', click 'See details' to see what changes need to be made. Make your changes and re-upload – we’ll ignore any rows without an 'Action' designated (column A). Note that upload files are stored for 30 days and download files are stored for just 1 day.

Read our tips on using the bulk editor.

Still need help?
Contact us