CSE Formulas are a lost science to the vast majority of Excel Users.  CSE stands for Control+Shift+Enter.  CSE formulas allow you to perform array calculations.  Let’s see how it works:

To calculate to total product sum of each row, you will need to write 4 short formulas (see image) or 1 long one = (A2*B2)+(A3*B3) )+(A4*B4) )+(A5*B5) )+(A6*B6)

To utilize the power of CSE formulas and simplify your calculations you would enter the following formula in Cell C4 and get the same result:  =sum(A2:B6*B2:B6).  Before you press enter, Remember, you must press (CSE) Control+Shit+Enter.  This is the only way to convert your formula to calculate Arrays.  You will notice that your formula converted from =sum(A2:A6*B2:B6) to ={sum(A2:A6*B2:B6)}. This may sound like its not worth the time, but consider more complex formulas over 1,000s of cells!

Now, like a child in school you are asking yourself: “How am I going to use this in the real (SEM) world?”  Lets take a look…

Say you have 2,300 new keywords in a massive list targeted to provide physical therapy to people with back issues, but it’s a dirty list and you want to exclude any keywords related to surgery.

• Column A should have your keywords
• Column B should have your negative keyword list
• Column D will be where your CSE formula goes

Use the following formula in Cell D2: =IF(SUM(NOT(ISERROR(FIND($B$2:$B$6,A2)))*1)>0,TRUE,FALSE) & CTRL+SHIFT+ENTER
The only variable you need to change in this formula is $B$6: The 6 represents the last row on which you negative keyword list ends.  In this example, it ends on Row 6.  If it ends on row 50, then the formula would change to $B$50 or ={IF(SUM(NOT(ISERROR(FIND($B$2:$B$50,A2)))*1)>0,TRUE,FALSE)}

.

.

Copy the formula down to the last row in Column A.  Turn on Filter and select True from Column D or sort by Column D.  You can now delete those rows which you do not want and continue with your clean keyword list.

You can also use this formula to build an account structure. Instead of using negative keywords, add a list of like minded words to help you group into campaigns and adgroups.

Excel, Keywords, negative keywords, SEM

Does it ever seem like the tricks to increasing conversions never work? Tune in this week to Best Search Strategies as we discuss the secrets to increase your conversion leads.

Join in to learn the EXACT formula for calculating how much data size you need to be confident with the correct landing page. Vertster CEO Scott Miller will be our guest host this week as he discusses:

• How to determine statistically significant data sample
• What to test?
• How long to run A/B tests?
• How to track Lead Generation with Phone Calls?
• The top 5 Mistakes and how to avoid them

Be sure to bring your calculator and tune into Webmaster Radio.com at 2:00PM (PST)

No tags

This week on Best Search Strategies, Clix Marketing CEO David Szetela joins in as a guest host to cover the current state of the search industry in respect to the Yahoo/Bing transition. The highly anticipated merger has left many search marketers wondering how this will affect everything in the future. So tune in this Wednesday at 2:00 PM (PST) to find out the details you should be aware of as the transition commences later this fall.

David Szetela’s topics will include:

• How to prepare for the transition of Bing / Yahoo?
• What is happening in the industry and how to stay ahead?
• What bid management software is best for agencies?

And as always the shows airs every Wednesday at 2:00PM on Webmaster Radio.com

No tags

This week’s Best Search Strategies show will air on Wednesday, July 28^th at 2:00pm Pacific Time.  We will be going over a 13-point checklist of the things you need to know to obtain PPC success.

When it comes to maximizing your PPC effectiveness, 13 is a lucky number. Listen in as you’ll learn the 13 must-know PPC management tactics you need to employ to setup and run a profitable campaign.

The 13 point checklist will include:

• The most common mistake made when changing bids
• Why your ads in the content network should never be the same as the search network
• The 3 most effective ways to increasing your quality score

So tune onto Webmaster Radio this Wednesday to join in on some helpful tips for your own PPC success.

No tags