Set up, create and edit ads with Bulk Editor

It looks as though you're viewing this from a region where Ads aren't available yet. See where Ads are available to Pinterest Business accounts.

Learn more

Bulk Editor is a tool that helps you create and manage thousands of Pinterest ad campaigns in one go. To get started, download a CSV file template, enter the data for your campaigns and upload the spreadsheet to Bulk Editor to make all of your changes at the same time.

Format your bulk editor sheet

It’s important that you set up your bulk editor spreadsheet correctly otherwise your upload may fail. As you work, make sure your bulk editor spreadsheet follows the following parameters.

Note: The CSV file can only be downloaded in English, and the uploaded values must also be in English. We can’t accept other languages at the current time.

  • Don’t edit rows 1 and 2. Rows 1 and 2 in every bulk sheet are reference rows that include a description of the columns, eligible parameters and special formatting required for each entry.
  • Save your CSV file as a CSV UTF-8 file to ensure that all values in the template are properly formatted.
  • Enter an action in column A for every row. If there’s no action specified, the row will be ignored when the bulk editor sheet is uploaded.
  • Enter campaign dates with brackets as [YY-MM-DD] to prevent the date from reformatting.
  • To remove the values for spend caps and ad group end dates, replace the existing values with CLEAR.

Create ads with the bulk editor

Once you've formatted your template, you can create ads and campaigns with it.

  1. Log in to your Pinterest business account.
  2. From the top of the screen, click Ads, then click Bulk Editor.
  3. Click Download sample sheet to download your template onto your desktop. You can use customised templates to include fields that are necessary for the specific action you’re taking.
  4. To create a new entity (campaign, ad group or ad) in your spreadsheet, add a new row in the sheet and enter 'CREATE' as the desired action in column A. Leave the object IDs blank as these will be auto-generated when you run your campaign.
  5. Once you’ve filled in your spreadsheet, click Upload template from the left-hand side navigation to upload your bulk editor sheet.
  6. If you're creating ads, upload the images or video for your ad creative in the Upload media section.
  7. Click Upload in the bottom right-hand corner of your screen.

Edit existing ads with the bulk editor

  1. Log in to your Pinterest business account.
  2. From the top of the screen, click Ads, then click Reporting.
  3. At the top of the Campaigns reporting table, click Export, then click Bulk sheet for editing or duplicating to download the file to your desktop.
  4. Edit your spreadsheet.
    • To make changes to your existing entities, include Edit as the action in column A. We'll ignore any rows without an action in column A.
    • To create a new entity (campaign, ad group, or ad), add a new row in 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.
  5. Once you’ve filled in your spreadsheet, go to your Pinterest Business account
  6. From the top of the screen, click Ads, then click Bulk Editor.
  7. Click Upload template from the left-hand side navigation.
    • If you're editing ads, upload images or video for your ad creative in the Upload media section
  8. Click Upload in the bottom right-hand corner of your screen.

Bulk sheet review process

Once you’ve submitted your bulk editor spreadsheet, you can monitor its status to see if it was uploaded successfully.

  1. Log in to your Pinterest business account
  2. From the top of the screen, click Ads, then click Bulk Editor
  3. Click History of changes from the left-hand side navigation

If the status of the upload changes to Succeeded, your sheet was processed without any errors. 

If the upload status changes to ERRORS or FAILED, click See details to see what changes need to be made, then click Download results to make the changes. Make your changes and upload your sheet again. We’ll ignore any rows without an action in column A.

Find out more about Bulk Editor error messages.

Note: Upload files are stored for 30 days and download files are stored for 1 day.

Still need help?
Contact us