Importing and exporting with Bing Ads Editor

Importing and exporting with Bing Ads Editor

Use Bing Ads Editor to quickly:

  • Import data from other online advertising programs. Get Bing Ads campaigns up and running quickly by exporting accounts, campaigns, and ads from Google, Yahoo, or other programs, and then importing them into Bing Ads Editor.
  • Bulk-edit Bing Ads data in a spreadsheet. If you prefer to edit data in a Microsoft Excel spreadsheet, export it as a comma-separated values (.csv) file, edit it in Excel, and then import the data into Bing Ads Editor.
  • Base a new campaign on an existing one. To create a new campaign from an existing campaign, export the campaign, change the campaign name and edit the data, and then import the new campaign into Bing Ads Editor. You can also do this with ad groups but be sure to change the ad group name.
Notes
  • The file must be an Excel or .csv (comma-separated values) file and must be closed before you try to import it.
  • If you are importing location targets see this article for information on how to find location IDs.
How do I import campaigns from Google Ads?expando image
Important

Not everyone has these updated Google Ads import features yet. If you don't, don't worry - it's coming soon!

Using your Google Ads account credentials and the Google API, Bing Ads Editor can retrieve all of your Google Ads campaign data, letting you skip the spreadsheets.

Import Google Ads campaign data with your Google credentials

  1. In the ribbon, click Import, then select Import from Google Ads.
  2. If not already selected, click Import Google Ads campaign data directly from your Google account and click Sign in to Google.
  3. Sign in to your Google account and allow Bing Ads to access your Google Ads account.
  4. Copy the provided code and paste it into Bing Ads Editor.
  5. You can import all campaigns within an account, or, if your account is very large, only selected campaigns. Click Next.
  6. Review the steps to import from Google Ads and post directly to the server, then click Next.
  7. Set your import options. Note: What you import here will get posted directly to the server, so be sure to check the import options you want.
  8. Click Next.
  9. Schedule your import to run now, once at a later date and time, or on a recurring basis.
  10. Click Import and post to server.
  11. Once the inport is complete, you can view any import errors on a spreadsheet.
  • Unmatched columns will not be imported.
  • You can optionally edit destination URLs and choose to share identical sets of ad extensions between campaigns.
How do I import campaigns from a file?expando image

There are three ways to import campaign data with a file:

  • Create a new file using a Bing Ads template.
  • Export data from Bing Ads Editor, make changes, and import the file back in to Bing Ads Editor.
  • Export data from Google Ads, make changes, and import file back in to Bing Ads Editor.

Campaign data can be imported in .csv, .txt, .tsv, .xls, or .xlsx files.

Create a new file using a Bing Ads template and import the file back

  1. Download the template from Bing Ads. The template contains examples for your reference. Replace the data in the template with your campaign data.
  2. Select File and thenSave as.
  3. Type a name for the import template. Use quotation marks around the name and include .csv at the end. For example, "YourFileName.csv". The quotation marks will not appear in your final file name but are used to prevent Excel from adding ".txt".
  4. Select Unicode Text, and then click Save.
  5. Click Import from the ribbon and select Import from a file.
  6. Select the previously saved file and click OK.
  7. Use the drop-down lists to adjust any Bing Ads column headings to match those in your import file, then click Next.
  8. Review the default settings and click Next.
  9. Review the Import summary to see what entities were newly added, updated or couldn't be imported (skipped).
  10. If you want to review the details of the campaigns and make changes, click the link next to Download the details.
Things to note:
  • Unmatched columns will not be imported.
  • You can optionally edit destination URLs and choose to share identical sets of ad extensions between campaigns.
  • For details on how to add location targets, see How do I add a location target?
Important

Dynamic search ads are currently available only in France, Germany, the United States, and the United Kingdom. Bing Shopping Campaigns and product ads are available only in the United States, Canada, United Kingdom, Australia, France, Germany, and India.

Export data from Bing Ads Editor and import the file backexpando image
  1. Select the campaigns or ad groups from the tree view in the left panel that you want to edit and import back.
  2. Click Export from the ribbon and select Export selected campaigns and ad grous.
  3. After making necessary changes to the exported file, save the file.
  4. Click Import from the ribbon and select Import from a file.
  5. Select the previously saved file and click OK.
  6. Use the drop-down lists to adjust any Bing Ads column headings to match those in your import file, then click Next.
  7. Review the Import summary to see what entities were newly added, updated or couldn't be imported (skipped).
  8. If you want to review the details of the campaigns and make changes, click the link next to Download the details.
Things to note:
  • Unmatched columns will not be imported.
  • You can optionally edit destination URLs and choose to share identical sets of ad extensions between campaigns.
Export data from Google Ads Editor and import the file backexpando image
  1. Sign in to your Google Ads Editor account.
  2. Select the campaign or ad group you want to export.
  3. Under the Account menu, click Export and select Export the selected campaigns and ad groups.
  4. Save the .csv file.
  5. Make any necessary changes and save the file.
  6. In Bing Ads Editor, click Import from the ribbon and select Import from Google.
  7. Select the previously saved file and click OK.
  8. Use the drop-down lists to adjust any Bing Ads column headings to match those in your import file, then click Next.
  9. Review the Import summary to see what entities were newly added, updated or couldn't be imported (skipped).
  10. If you want to review the details of the campaigns and make changes, click the link next to Download the details.
Things to note:
  • Unmatched columns will not be imported.
  • You can optionally edit destination URLs and choose to share identical sets of ad extensions between campaigns.

See more videos...