Edit Ads Using Bulk Import & Export
Last updated, July 2023

The Bulk Import & Export feature is a great way to quickly edit large numbers of ads at once. To do this, advertisers can export their ad settings in a spreadsheet and bulk edit their ads as they would on the platform.


The following editing scenarios are supported by the Bulk Import feature:

  • ​At the Campaign Level: Campaign Name, Campaign Budget

  • ​At the Ad Group Level: Ad group Name, Targeting (Audience, Gender, Age), Delivery Schedule, Bid, and Budget

  • ​At the Ad Level: Ad Name, Ad text, Profile image, and new Creative.


For a brief overview on how to edit ads in bulk, watch the video below.

For more information about what fields can be modified please see Index of Bulk Import & Export Template.


Edit Ads Using Bulk Import

Export your ads, edit your ad settings in a spreadsheet, and upload your file to TikTok Ads Manager.

Step 1. To edit your ads, you must first export your ads into a spreadsheet.


  1. ​Go to the Campaign tab.

  2. ​Select the Campaigns, Ad Groups, or Ads you want to edit.

  3. ​Click the Bulk create/Edit button.

  4. ​Click the Export Ads icon.

Edit Ads Using Bulk Import & Export-Export Ads-PNG

Step 2. Edit​ Settings

After you have exported your ads into a spreadsheet, you will then need to make the desired changes to the ad settings. When editing your ads do not edit your Campaign Id, Ad Group Id, or Ad Id fields. The system uses these IDs to identify your ads and it will be unable to edit your ads if these fields are changed. Additionally, when editing your ads, you need to make sure that you do not delete any required fields, as this will cause your file to fail to import successfully.


Note: Do not delete any columns or adjust the headers of your exported file as it will be unable to import properly.


Step 3. To import your spreadsheet to TikTok Ads Manager:


  1. ​Go to the Campaign tab.

  2. ​Click the Bulk Feature Icon next to the Create button.

  3. ​Click the Import Ads Icon.

  4. ​Upload CSV or Excel File.

Create Ads Using Bulk Import Feature-Import Spreadsheet-PNG1

Common Bulk Editing Scenarios

Now that we've covered the basic instructions for editing your ad settings using the Bulk Import feature, let's review some editing common scenarios.

Modify Ad Group Budget

  1. ​Find the Ad Group Budget Amount column and fill in the new budget.

  2. ​Leave all other fields unchanged.

Update Ad Group's Custom Audience

  1. ​Go to the Audience List sheet, find your desired custom audience, then copy its Audience ID.

  2. ​Find the Include audience ID or Exclude audience ID column in the file, and paste the relevant Audience ID into either column.

  3. ​Leave all other fields unchanged.

Change Creative for Non-Automated Creative Optimization (Non-ACO) Ad Groups

  1. ​In TikTok Ads Manager, go to the Assets tab and click Creatives.

  2. Upload your creative or select an existing asset and note the filename.

  3. ​Find the creatives you want to modify on your spreadsheet.

  4. ​Find the Video Name or Image Name column on your exported spreadsheet, and replace the current entry with your new creative filename.

  5. ​Leave all other fields unchanged.

Change Creative on ACO Ad Groups

  1. In TikTok Ads Manager, go to the Assets tab and click Creatives.

  2. ​Upload your creative or select an existing asset and note the filename.

  3. ​Check which ad groups you want to modify.

  4. ​Find the Auto Ad - Video Name or Auto Ad - Image Name column in the file, and only replace the filename of the creative you want to modify in this cell.

Add New Creative to (Non-ACO) Ad Groups

  1. ​In TikTok Ads Manager, go to the Assets tab and click Creatives.

  2. Upload your creative or select an existing asset and note the filename.

  3. ​Confirm which ad groups you want to add new creatives to.

  4. ​Copy the row of the target ad group you wish to add the new creative to. For example, if you want to add 5 pieces of creative to an ad group, copy that row 5 times.

  5. ​Delete the Ad Id for the newly copied rows. Do not delete this information in other rows.

  6. ​Find the Video Name or Image Name column in your exported spreadsheet, and enter the corresponding creative filename in the newly copied cell.


Note: You may want to adjust the Text and Call to Action columns to reflect your new creative, otherwise they will display whatever was copied from step 3.

Edit Ads Using Bulk Import & Export-Add New Creative(non ACO)-PNG

Add New Creative to ACO Ad Groups

  1. ​Upload your creative to your Creative - Assets on TikTok Ads Manager - or select an existing asset - note the filename.

  2. ​Confirm which ACO-enabled ad groups you want to add your new creatives.

  3. ​Find the Auto Ad - Video Name or Auto Ad - Image Name column in the file, and add the filename of the creative you wish to add to the ad group - separating each filename with a line break.

  4. ​Leave all other fields unchanged.

Edit Ads Using Bulk Import & Export-Add New Creative ACO-PNG

Content