How to Convert Third Party Excel Files to Microsoft adCenter Excel Files

Microsoft adCenter is a pay-per-click service that allows you to advertise on the Bing search engine. AdCenter allows you to target specific keywords, so that whenever a person types in one of those keywords, your ad appears and it charges you a specific amount. If you are running multiple online campaigns, you may find it helpful to import your campaigns from other pay-per-click search engines, like Google Adwords or Yahoo Search Marketing, using a third-party Excel file in comma separate value (CSV) format.

Instructions

Exporting Your Campaigns

    1

    Export your campaign from Google Adwords by opening the Adwords editor and highlighting the campaign that you wish to convert to Microsoft adCenter. Click on "File" and scroll down to "Export Spreadsheet (CSV)." Click on "Export Current Campaign" and save the file to your desktop using a name that you can remember.

    2

    Export a campaign from Yahoo Search Marketing by opening your browser and logging into Yahoo Search Marketing. Scroll to the bottom of the screen and click on the campaign that you wish to export. Click on the "Download Campaign" button in the top, right corner of the screen.

    3

    Ensure that there is a bubble next to "As CSV" and that "Include Keywords," "Include Ads" and "Exclude Deleted Components" are all checked. Click "Continue" and save this file to your desktop, using a name that is easy to identify.

Importing Your Campaigns

    4

    Log into Microsoft adCenter using your user name and password. Click on "Create Campaign" on the left-hand side. Fill in your ad group settings, ad group targeting and ad group exclusions. Click on "Next."

    5

    Click on the "More" tab and select "Import Ads." Click on the blue text that says "CSV template" in the import ads box that appears. Save the file on your desktop using a name that is easily recognizable. Open the file.

    6

    Open up the exported campaign from either Adwords or Yahoo Search Marketing. Transfer the required information from these templates into the correct place on the adCenter template. Save the adCenter template as a new file by clicking "File" and "Save As," using a name that is easy to identify and ensuring that it saves as a CSV file.

    7

    Switch back to Microsoft adCenter in your browser and click on "Browse." Click the "Desktop" icon on the left side of the window and find the CSV file that you just saved. Highlight it and then click "Open."

Blog Archive