This is the fourth in the series of blog posts focusing on Microsoft Advertising Intelligence (formerly Microsoft adCenter Add-inBeta for Excel). As we have shown in past blogs, you can use Advertising Intelligence to create popular keyword lists, expand your negatives, create traffic proposals, research market trends and create bid proposals, all within Excel.

These features are great on their own, but combined they give you a complete campaign creation and optimisation package.

Imagine you are pitching for a new client, a flowers delivery company. You can use Advertising Intelligence from pitch to account creation as below:

Once you have won the pitch, you can then incorporate what you have done with the pitch and build upon it using the tool for a submission as below:

  • Run the core terms through the Keyword Generation tools to expand the keyword list
  • Use any irrelevant keywords produced to build out an extensive negative keyword list
  • Run the final list of keywords through the Monetisation tool to give the keywords bids for particular positions and use the click and CPC values to work out possible monthly budgets
  • Organise the keywords into an account structure and create ad copy and dynamic text insertion for the keywords
  • Upload the account through the adCenter Desktop Tool
  • Use the Age and Gender and Day of Week research in the pitch to add targeting to the campaigns

From pitch to upload in...10 steps. As easy as that!

Please note, all Microsoft adCenter Add-In Beta for Excel users: the Add-in is being replaced by Microsoft Advertising Intelligence. It is not compatible with Microsoft Excel 2003, so you must use it with Microsoft Excel 2007. Microsoft Add-In Beta for Excel will no longer be supported after Aug. 31, so you must uninstall it and install Advertising Intelligence. You can download the new tool from advertising.microsoft.com.  You can visit www.office.microsoft.com/excel to download a free 60-day trial version of Microsoft Excel as well as purchase the program.