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 programs.
After reading this training, you will understand how to:
- Keep Bing Ads Editor data synchronized with your online data.
- Export and import campaigns and ad groups to and from Bing Ads Editor.
- Import Google campaigns using Google Adwords sign-in credentials.
Synchronizing offline and online Bing Ads data
When working in Bing Ads Editor, remember that you’re working offline. In order to affect your live campaigns, you must move your offline edits to your online account. To do this, simply click Post Changes. If you’ve only made a few edits, you can save upload time by clicking Post Changes, then Settings, and selecting the specific campaigns you’ve worked on.
Just as important as posting changes is getting changes. Before working in Bing Ads Editor, retrieve your current live campaign data by clicking Get Changes. By getting changes, your offline data will match your online data, ensuring you’ll be working on the most current campaign versions. The Get Changes drop-down menu gives you two choices. You can retrieve your entire account, or just your recent changes. Again, selecting and retrieving your recent changes saves time.
Exporting data from Bing Ads EditorWhen exporting data, the tool allows you to be selective. 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 Export 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 ad extensions.
- Choose to work on the data immediately.
If you don’t plan on working with the data immediately, don’t export it as it will significantly increase the file size. If you want to work on your data right away, choose the Open file after export option upon saving — the data automatically opens in an Excel workbook. Click Export, and in the Save as dialog box, 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 so, copy rows directly from the grid and paste them into your Excel workbook. While working in Excel, keep in mind the same advanced Excel functions, such as charting and pivot tables, are available.
Default import settingsBefore importing data, be sure 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 Tools, click Options, and select Defaults.
Importing campaignsTo import campaigns into Bing Ads Editor, click Import in the top ribbon. From the four choices, choose From a custom spreadsheet and follow the Dialogue Wizard prompts.
Importing Google campaignsIf you already have Google campaigns you’d like to run, you don’t need to recreate all your work. Using your Google AdWords credentials, it’s easy to import those campaigns directly into Bing Ads Editor.
As with importing a custom spreadsheet, click Import and choose From Google. In the dialog, enter your Google AdWords username and password. Google credentials are 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 Bing Ads 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.
Bing Ads Editor import function has been designed to quickly recognize the occasional new Google AdWords feature. Even though the import function updates to accommodate new Google features, you’ll still want to review your data after importing. Once you’ve reviewed and fixed any possible import errors, you can start working. When finished, be sure to post changes so the new or updated campaigns you’ve just worked on go live.
SummaryBing Ads Editor features help you manage your campaigns more efficiently. Remember these key tips and suggestions while working with the tool:
- 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.
|Top Tip: Easily send data to and from your Bing Ads online account and don’t disturb your online campaigns by using Post Changes, Get Changes, Import and Export.|
Please note all features in this training may not be available in your market.