Bing Ads Editor exporting and importing With Bing Ads Editor, you can edit campaigns offline and then publish changes at your convenience when you are back online. You can manage your accounts in bulk, from the campaign level down to the individual ad level. Another key feature is the ability to import Google AdWords directly into Bing Ads. 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 AdWords into Bing Ads. Exporting Data When exporting data, Bing Ads Editor allows you to be selective. You can export data from entire accounts, individual campaigns or specific ad groups. You can export the campaign or ad group you have selected using the Export current campaign/ad group option under the File menu in the top ribbon. Export all the rows in the Manager pane using the Export current view option. Here you can choose do the following: 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 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. Importing campaigns 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. You can also create a Microsoft Excel or CSV (comma-separated values) import file. (Download the import file template here.) Click Import Campaigns, and then click Import from file. If you have imported from a file in the past 90 days, you will see a table that tells you the Data/Time and Uploaded file. Default import settings The default mode of Bing Ads Editor is that all active campaigns are imported, with options to import paused campaigns and to search for specific campaigns. You can select an option to adjust your bids and budgets to meet Bing Ads Editor's minimum requirements, and if you are importing a file from Google AdWords, you will now have all of the same import options available with other types of import. 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. Google AdWords If you're already using Google AdWords, you can save a lot of time by importing your AdWords campaigns directly into Bing Ads. Simply import your Google Campaigns using your Google AdWords sign-in credentials. Bing Ads allows customers to use the Google Import tool to schedule and sync imports from Google AdWords campaigns automatically. The Google Import tool allows advertisers to copy a combination of 1.5 million keywords and ads from Google AdWords over to Bing Ads, as well as up to 200,000 negative keywords, campaigns, ad groups and extensions. Customers can do this with just three easy clicks: 1. Sign in to Bing Ads. 2. Click Import from Google AdWords. 3. Follow the steps to import your campaigns. Another option is to import Google AdWords using Bing Ads Editor. Simply Click Import from Google, and finish by following the steps to import your campaigns. 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. Note: Before you begin importing campaigns from Google AdWords to Bing Ads, be sure to review Importing your campaigns: Requirements. When you're finished importing, you can view your data and have the opportunity to fix any issues. Summary Bing Ads Editor Export and Import features help you manage your campaigns more efficiently. Key takeaways: 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. 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.