Bing Ads Editor exporting and importing — training
The export and import features of Bing Ads Editor can help you save time performing common tasks. By exporting and importing, you can bulk-edit campaign data, quickly create new campaigns from existing campaigns and import campaigns from other online advertising tools.
After reading this training, you will know how to:
- export campaigns and ad groups from Bing Ads Editor
- import campaigns and ad groups to Bing Ads Editor from a file
- import Google campaigns using Google AdWords sign-in credentials
Exporting data from Bing Ads Editor
When exporting data, Bing Ads Editor allows you to be selective. You can export data from entire accounts, individual campaigns or specific ad groups. Let’s take a look at how to export and import data.
There are two ways to start an export. Either click the Export button in the top ribbon, or right-click the desired campaign or ad group, and select Export. This opens the Export dialogue where you select your export preferences:
- Export an entire account or only the selected campaign or ad group.
- Include or exclude additional data: targeting, negative keywords and sitelink extensions.
- Choose to work on the data immediately by selecting Open file after export
If you don’t plan on working with the information in the Also include… section, don’t export it as it will significantly increase the file size. If you want to work on your data immediately, select Open file after export. Upon saving, the data automatically opens in an Excel workbook. Click Export, and in the Save as dialogue, specify the folder, file name and file type.
There are times, however, when you’ll want to edit just a few items and not run a full export. To do this, copy rows directly from the Editor grid and paste them into your Excel workbook. To select multiple rows from the grid, hold the Control key while selecting rows. Press Control-C to copy, open your Excel workbook, choose the cell where you want to insert the rows, and press Control-V to paste them.
Your data and row headers will be inserted, and will be in the correct format for importing back into Bing Ads Editor. While working in Excel, keep in mind the same advanced Excel functions, such as charting and pivot tables, are available.
Default import settings
Before importing data, make sure that you’ve set default values, such as time zone, ad distribution and keyword match type. You can change your defaults at any time, but once saved, every import gets the same default settings until you change and save the settings again. To set defaults, click the Tools button in the main menu and select Options. From the options dialogue, select Defaults on the left-hand side and then edit values like Customer language, Location targeting and Ad distribution to your desired defaults.
To import campaigns into Bing Ads Editor, in the top ribbon, click the Import button. From the four choices, choose Import from a file. Select a file, and click Next to open the Import Wizard dialogue.
In the drop-down lists above the table, select the appropriate Bing Ads column header to apply to each column of your imported data. Click Import. When the import finishes, an import summary page opens. Campaign information may appear across several columns.
The New, Updated and Deleted columns, located in the View drop-down within Bing Ads Editor, display how the imported data has been changed. Skipped items will not be created or updated, as they duplicate existing values or contain invalid data.
When you export and import Bing Ads Editor data from a file, use comma-separated values whenever possible. However, the Bing Ads Editor also supports Excel workbook files and files with tab-separated values.
Importing Yahoo or Google campaigns
If you already have Yahoo or Google campaigns that you’d like to run on the Bing Ads network, you don’t need to recreate your work. Using your Yahoo or Google AdWords credentials, it’s easy to import those campaigns directly into Bing Ads Editor.
As with importing a custom spreadsheet, click the Import button and choose Import from Google. In the dialogue, enter your Google AdWords username and password. If you select Remember my credentials, your Google credentials will be saved onto your local computer only.
Click Next to see a list of your Google accounts. Select the desired account and click Next.
You can save time and space by importing only the campaigns that you plan to use. Select one or more campaigns, and click Add. Click Next to select import options. If you import updates to existing items, you can choose not to import specific settings. For example, if you’ve changed some keyword bids in the Editor and you don’t want to overwrite them, deselect the Apply changes to Ad group and keyword bids check box.
You can bulk-edit your keyword Destination URLs when you import them. For example, if your Destination URLs include Google as a source, you may want to change this text to Bing Ads. When you finish setting your import options, click Import.
The Import Completed dialogue informs you that your campaign data successfully imported. Just like importing from a file, the dialogue lists the type and number of new, updated, deleted and skipped entities.
Because there are some differences between the Google and Bing Ads platforms, you’ll want to review your data after you import it. Once you’ve reviewed and fixed any import errors, sync your Editor to Bing Ads to make the new campaigns active. Editorial checks are performed when you sync your campaigns with the Bing Ads platform. Read What gets imported from AdWords? for more information.
Bing Ads Editor Export and Import features help you manage your campaigns more efficiently.
Key take-away points:
- Set default values for campaigns, ad groups and keywords before importing.
- Use your Google credentials to import those campaigns directly into Bing Ads quickly.
- Bulk-edit exported campaigns in Excel, and then re-import the data to update or create new campaigns.
Please note that features mentioned in this training may not be available in your market.