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 programs.
After reading this training, you will understand how to:
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 dialog where you select your export preferences:
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 dialog, specify the folder, filename 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.
Before importing data, be sure you’ve set default values, like 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 dialog, 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 dialog.
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.
If you already have Yahoo or Google campaigns 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 dialog, 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 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, uncheck 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 dialog informs you that your campaign data successfully imported. Just like importing from a file, the dialog 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.
Thanks for reading this training on Bing Ads Editor exporting and importing. Continue your training or take the Bing Ads Accredited Professional exam to become accredited.
Please note all features in this training may not be available in your market.