Bing Ads Editor exporting and importing
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:
- 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 dialog 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.
If you don’t plan on working with the Additional information to export, don’t export it as it will significantly increase the file size. If you want to work on your data immediately, choose 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.
Default import settings
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 Editor options button, and select Defaults. Under Campaigns, Ad groups and Keywords, select 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 modified Microsoft Office Excel spreadsheet. 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 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 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.
Bing Ads Editor Export and Import features help you manage your campaigns more efficiently.
- Set default values for campaigns, ad groups and keywords before importing.
- Use your Google credentials to quickly import those campaigns directly into Bing Ads.
- Bulk-edit exported campaigns in Excel, and then re-import the data to update or create new campaigns.
Please note all features in this training may not be available in your market.