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.
    • Set the status on new objects to 'ACTIVE' if you’re ready for them to go live. Your ads will still have to go through ad review.
    • To create multiple Pins in a campaign, copy and paste the same campaign and ad group info for all Pins within that campaign.

    Note: Budgets and bids will run in your account currency. For example, if your business is in the US, you’ll be charged in USD.

    To add new keywords, add a row for each keyword and add “Create” as the action in column A.

    You can assign keyword-level bids. If this is left blank, we’ll use the bid set at the ad group level. Other targeting details, such as interests, devices and genders, are still defined at the ad group level.

    If you’re adding keywords to an existing ad group, make sure that you specify the ad group ID.

    For any comma-separated lists (e.g. interests, keywords, locations), please enclose your lists with square brackets. For example, interests: [exotic pets,insects,mammals,cute animals] or locations: [662,525,124522,826047]

    For a complete list of targeting codes, download each of the respective sheets:

    Please refer to our targeting guidelines to ensure that your ad campaign doesn’t violate our targeting policies. 

    Create ads with the bulk editor

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

  • Log in to your Pinterest business account.
  • From the top of the screen, click Ads, then click Bulk Editor.
  • 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.
  • 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.
  • Once you’ve filled in your spreadsheet, click Upload template from the left-hand side navigation to upload your bulk editor sheet.
  • If you're creating ads, upload the images or video for your ad creative in the Upload media section.
  • Click Upload in the bottom right-hand corner of your screen.
  • Edit existing ads with the bulk editor
  • Log in to your Pinterest business account.
  • From the top of the screen, click Ads, then click Reporting.
  • 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.
  • 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.
  • Once you’ve filled in your spreadsheet, go to your Pinterest Business account
  • From the top of the screen, click Ads, then click Bulk Editor.
  • 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
  • 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.

  • Log in to your Pinterest business account
  • From the top of the screen, click Ads, then click Bulk Editor
  • 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.

    End of Other articles Links
    Still need help? Contact us
    User feedback
    Was this article helpful?

    collection_fields

    How can we make this article better?