Bulk editor

The bulk editor tool makes it easier to create and edit Promoted Pins if you want to promote and optimize many Pins at once. To use the bulk editor, hover over Ads in the navigation bar and select Bulk editor in the dropdown, or go directly to https://ads.pinterest.com/bulk_editor/.  

To opt in to the new version of the bulk editor, click on the “Try now” button in the upgrade banner you’ll see when you visit the bulk editor page. You’ll be able to switch back to the original version by clicking on the “Take me back” button at the top of the new bulk editor.

Click to see comparison of new and original versions of the bulk editor Comparison of the new and original versions of the bulk editor

 
Bulk editor - NEW
Bulk editor - original
Tips for using the bulk editor
Protected boards
Targeting codes

Using the new streamlined version of the bulk editor, you can take multiple actions on thousands of rows, using a single upload.
 
 
How to use the bulk editor (NEW version)
  1. Access the bulk editor by selecting “Bulk editor” in the Ads dropdown in the navigation bar, or go directly to https://ads.pinterest.com/bulk_editor/

  2. Download the template

    • Select “Download existing campaigns” for a sheet with your data.

    • Select “Download sample sheet” for a blank template with sample data. You can use this as a reference for how to format your own data.

  3. Fill out the necessary fields – use the descriptions in row 2 or the sample sheet as guidance, and refer to the tips in the sections below.

    • Creating new entities - to create new entities (campaigns, ad groups, Promoted Pins or keywords) add a new row and specify “Create” as the desired action in column A.

      • When creating objects, leave the object IDs blank, as these haven’t been created yet.

      • If you’re creating a new object within an existing campaign or ad group, make sure you specify the ID of the campaign or ad group you’re adding the object to. If you do not specify the parent ID, we will infer the parent via locality (i.e. looking at the sheet structure, we’ll infer the parent of the entity you’re adding is the one your new row is nested under)

    • Editing existing entities - in the data you’ve exported, designate the “Edit” action in column A for the rows you want to modify. You can use the bulk editor to make any changes you would do in the Ads Manager UI.

  4. Upload your bulk template and images (if you’re creating new Pins).

    • Preview your changes - Click on the “Preview” button and you’ll see a summary table of how many entities you’re creating and how many you’re editing. You can cancel or process your template.

    • Process your changes - Click on the “Process” button and your bulk sheet and any images you’re using will immediately be processed with no intermediary preview step.

  5. Confirm your template was successfully uploaded by viewing your change history. The “History of changes” table will keep uploads for 30 days and downloads for 1 day.

    • 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” (column AN) to see what changes need to be made. Simply make your changes and re-upload – we’ll ignore any rows without an “Action” designated (column A)

 

Get more details, diagrams, tips and tricks in the Bulk Editor guide.  


Using the original version of the bulk editor, you can create new or edit existing campaigns.

To CREATE new campaigns, ad groups, or Promoted Pins:

  1. Download the blank CSV template linked under Create

  2. Fill out the required columns (descriptions of each column in the second row of the CSV template). The descriptions in the CSV template start with a ‘#’ – your entries should not include the ‘#’

  3. Save the CSV file and upload it.

    • If you created your Pins in an Excel file, save the file with Unicode Text encoding. (The file extension might change from .csv to .txt but it won't be a problem)

    • You can have up to 2,000 active campaigns and up to 100 Pins per campaign

    • Note: if you max out on active campaigns, ad groups, and Pins per campaign, you may experience issues downloading a Bulk Edit template or reports for an extended period of time

To EDIT existing campaigns, ad groups, or Promoted Pins:  

  1. Download your existing Promoted Pins data under Edit

  2. Edit the fields you want to change.

    • If you’re making campaign-level edits, you only have to adjust one row and delete all other rows with the same campaign. Alternatively, you can apply the same changes to all lines with the same campaign

  3. Save the CSV file and upload it.

Campaign structure
  • Learn more about a campaign structure here and the attributes of campaigns here.

  • The fields in the bulk templates all have help text right under the column names to help guide you in filling out your sheets.

  • If you want to add a new ad group or Promoted Pin to an existing campaign, simply reference the parent ID in the bulk template you’re editing, and leave the other fields for that parent object blank. E.g. reference your campaign ID when adding an ad group; reference your ad group ID when adding a keyword or Promoted Pin.

  • Keep in mind that your budgets and bids will run in your account currency, e.g. if your business is in the US, you will run and be charged in USD.

 
Bulk sheet formatting
  • Do not change the contents of rows 1 and 2 (field name and help text) in the bulk template – the bulk sheet will not successfully upload if the field names have been modified or if row 2 is missing.  Do not delete or change the order of any columns.

  • If you already have existing Promoted Pins running, you can download all your data to take a look at how the spreadsheet is formatted.

  • Using the new version of the bulk editor, you can remove the values for spend caps and ad group end dates by replacing existing values with: CLEAR

 
Campaign setup
  • When creating new objects, set your Statuses to Active if you’re ready to go live, but remember, your Promoted Pins will still need to be reviewed

  • Enter campaign dates as [YYYY-MM-DD] – the brackets will prevent the date from getting reformatted

  • Promoted Pin creation:

    • To use a Pin that’s already saved on your profile: Copy and paste the organic Pin ID, prefaced with the letter ‘P’ (e.g. P580682945675999524), and leave the Pin description and organic Pin URL fields blank. You can find your organic Pin IDs in the URL of the Pin you want to use (e.g. https://www.pinterest.com/pin/580682945675999524/). Include a Promoted Pin URL if you want to track this Promoted Pin separately, or if this Promoted Pin has a different landing page. If you leave the Promoted Pin URL blank, we’ll default to the existing organic Pin URL.

    • To create brand new Pins to promote: In the bulk template, reference file names of the images you’ll upload (be sure to include the extension, e.g. test_image.png). Also fill out the template with a Pin description (required), organic Pin URL (the destination URL for the organic pin, required), Promoted Pin name (optional) and Promoted Pin URL (where the Promoted Pin will drive to, if you want to add specific tracking parameters; if you leave the Promoted Pin URL blank, we’ll default to the organic Pin URL)

  • To create multiple Pins in a campaign, just copy and paste the same campaign and ad group info for all Pins within that campaign

 
Targeting
  • Learn more about your different targeting options and the best practices for applying targeting here.

  • Keyword targeting (for the NEW version of the bulk editor only)

    • To add new keywords, you need to “create” new keywords. Each keyword should have its own row.

    • You can assign keyword-level bids – if this is left blank, we’ll use the bid set at the ad group level.

    • If keywords are being added to an existing ad group, be sure to specify the ad group ID

    • Other targeting details (e.g. interest, devices, gender, etc) are still defined at the ad group level.

  • Find the targeting codes you can use in your bulk sheet at the bottom of this article, here.

  • Keep in mind: for any comma separated lists (e.g. interests, keywords, locations), please make sure to enclose your lists with brackets. For example, interests: [exotic pets,insects,mammals,cute animals] or locations: [662,525,124522,826047]

 

Get more details, tips, and tricks in the Bulk Editor guide.  


Pins created using the bulk editor are automatically added to protected boards. A new protected board is created every time the bulk editor is used; you cannot bulk create Pins to existing boards.

Protected boards do not live publicly on your profile, so Pinners won’t be able to find the protected board unless they have the URL. Protected boards live in a specific section on your profile, which only you can see, and you can Pin to them as you would any other board.

Protected boards are named by default and will appear as: Created by Ads Bulk Editor date/time. You can rename the protected boards created, edit the board description and change the board category to reflect the content of the Pins on these boards.

Targeting codes
Interest codes Interest codes

View all interest codes

Note: Use Column C for original bulk editor codes and Column F for new bulk editor codes.

Location codes Location codes
Language codes Language codes
Device codes Device codes
Audience codes Audience codes

After you create audiences, you can find audience targeting codes in the Audience Manager. When adding audience IDs in the Bulk Create csv template, add an 'A' in front of the number.

ALL targeting codes ALL targeting codes