Edit ads in Ads Manager using Excel

30/11/2019

You can make changes to multiple campaigns, ad sets and ads with Excel by using Ads Manager's export and import features by uploading files or by copying and pasting info.

Upload Excel files

  1. Click Campaigns, Ad sets or Ads.
  2. If you want to edit a specific group of campaigns, ad sets or ads, tick the boxes next to each one. If you want to edit all of your campaigns, ad sets or ads, you won't need to tick any boxes.
  3. Click , then select either Export selected or Export all.
  4. Open the Excel spreadsheet that you exported from Ads Manager and make any changes necessary. Bear in mind that you can change any of the fields except for Ad ID, Campaign ID and Image hash.
  5. Save the changes in your Excel spreadsheet and then go back to Ads Manager.
  6. Click and then select Import ads in bulk.
  7. In the Bulk import window, click Choose file. Choose your saved Excel file from your computer and then click Import.

  8. When the file finishes uploading, click Close.
  9. Click Review Changes to publish your changes.
  10. Check the items that you want to publish and then click Continue.

Copy and paste

  1. Click Campaigns, Ad sets or Ads.
  2. If you want to edit a specific group of campaigns, ad sets or ads, tick the boxes next to each one. If you want to edit all of your campaigns, ad sets or ads, tick the box at the top of the column to auto-select all items.
  3. Press Ctrl + Shift + C on your keyboard.
  4. In the Export as text window, press Ctrl + C (on PC) or Cmd + C (on Mac) to copy the text, and then click Close.
  5. Click and then select Import ads in bulk.
  6. Under Bulk import, select Paste text from tab separated document.
  7. Press Ctrl + V (on PC) or Cmd + V (on Mac) to copy the text into the field and then click Import.

  8. When Ads Manager finishes uploading the text, click Close.
  9. Click Review Changes to publish your changes.
  10. Check the items that you want to publish and then click Continue.

Troubleshooting

Here are some tips to help you import changes in Ads Manager:

* Nguồn: Facebook