::::Paid Search Marketer::::

Paid Search Management Techniques | Excel

May 25, 2008 · 1 Comment

Commonly one may need to generate lists of keyword combinations which all share a similar root, possibly a location or service which may be modified by monetary terms, a service in the case of a location root or a regional service modified by budget, “ppc consultant new york” is essentially a “specialty + service + region” but “affordable paid search consultant nyc” would be a “budget + specialty + service + location” keyword.

In any event, in the interest of time I’ll cut to the chase and present the technique. Our objective is to:

a) easily generate keyword lists without using any formulas

b) generate the corresponding tracking URLs if necessary.

The tools required are Microsoft Excel and a free Add-In, ASAP Utilities (download page)

The method - let’s assume we’re beginning with a list of cities.

keyword list of cities in excel

Forgive the somewhat contrived nature of what follows but let’s pretend I’m advertising my PPC consulting activities in a popular paid search engine and I’m hoping that I can scrap up some interest through geo targeted (not campaign setting wise) keyword phrases.

{New York} + PPC Consultant

{New York} + Paid Search Company

{New York} + AdWords Management Firm

First review the location from which you’ll be accessing the ASAP Utilities tool for this exercise.

paid search consulting keyword list

Once I’ve chosen the selected option under, “Text” a dialog box prompts you to enter some data and I will in accordance with my paid search consulting keyword objectives. Please follow the arrows clockwise for a chain of causation if you’re not sure what’s going on.

paid search management keywords being created

And the final result in text.

New York paid search firm
Ne York City paid search firm
Manhattan paid search firm
Queens paid search firm
NYC paid search firm
Long Island paid search firm
Suffolk County paid search firm
Albany paid search firm
New Jersey paid search firm
NJ paid search firm
Connecticut paid search firm
CT paid search firm
NY paid search firm

This example is has been subject to extreme simplification so in case you’re not convinced of this tool’s usefulness I’ll take another screen shot with a more advanced application of the tool. Once you have your keywords you need to tag them presumably.

tagging ppc consulting keywords

The end result is:

last result of URL manipulation

So there’s the URL, you’re inserting tracking parameters after it and you’re ready to upload. Hopefully you’ve found this useful and are now a more efficient individual!

Jeff

jeffjames.vib@gmail.com | http://www.linkedin.com/in/jeffjames

→ 1 CommentCategories: Uncategorized
Tagged: , , ,

AdWords Conversion Optimizer - Early Results

May 6, 2008 · 3 Comments

Some experimentation with Google’s Conversion Optimizer has yielded positive results. 4 days into the experiment I’ve seen a significant increase in CTR and a 10-15% lower CPA. The conversion event is a lead and the conversion scenario across all campaign data is very much a homogeneous one. Many of the keywords are broad match geo targeted keywords (meaning keyword + location, the campaign is set to the entire United States) with essentially the same root and I’m using dynamic keyword insertion liberally in the title of the ads. Finally, the conversion event, if it happens will happen during the visitor session 9/10 times.

I had been using a tiered approach to CPA management with Omniture SearchCenter for the campaign. The rule formerly in use was roughly:

Assuming a CPA tolerance of $10 (for the sake of illustration)

  • If CPA = $10, do nothing.
  • If CPA {10 , 12} reduce max CPC by $.10
  • If CPA {12 , 14} reduce max CPC by $.25
  • If CPA {8, 10} increase max CPC by $.10
  • If CPA {6, 8} increase max CPC by $.25

So in general, given that this evaluation is done at the keyword level the CPA should trend to the middle value over time and hover around it. It is naive in some respects because it has no contemplative ability beyond analyzing a ratio of 2 data points over the course of N days. It may not be making statistically significant decisions and the long tail of keywords which may only accrue 1 to 2 clicks per interval may never see any meaningful adjustments.

The Google Conversion Optimizer requires your campaign to have over 200 conversions over the past 30 days which in some cases is beyond the reach of an advertiser. For any high volume lead gen program this should be a visible option in the AdWords interface by now. Obviously if you don’t have conversion tracking enabled this isn’t an option.

As far as bidding parameters are concerned - the advertiser can specify CPA at the adgroup level. When setting the CPA values initially it will give you its prediction (CPA) and if you bid below it you’ll be warned that traffic may decline. I bid about 25% lower than their recommendation and I’ve seen no decline in traffic thus far.

As far as what the fundamental difference between rules based bid management and the conversion optimizer might be - well, it could be quite large. Beyond simply computing basic conversion math I suppose that the following statement by Google expresses adequately (how) excess value may accrue to the adopting advertiser:

“It uses the optimal CPC bid for her ad in each auction, thereby working to keep her average cost per conversion below her CPA bid.

Using real-time performance data allows the Conversion Optimizer to adjust Kim’s bids for better performance than she’d get with manual bidding alone. Also, because the Conversion Optimizer chooses a new CPC bid for each auction, Kim only spends money on the sites and search queries where her ads are likely to get conversions.”

Hopefully I’ll have continued success with the campaign optimizer. I suspect that within 24 to 36 months , the same technology will be available at a much lower conversion volume entry point depending on how predictive and sophisticated Google’s algorithms become as they continue analyzing trials using the current minimum level of conversion data. This is also a very elementary strategic consideration as the more Google can help automate advertiser success, the more they will be able to reduce revenue volatility and advertiser turnover. I wonder if they’ll ever release a landing page generator for advertisers…

Jeff

supporting data and FAQs - here

→ 3 CommentsCategories: google conversion optimizer
Tagged: , ,

Rules Based Bid Management - AdWords Editor

April 9, 2008 · No Comments

For those of you managing PPC campaigns who may not have access to a rules based keyword bid management solution like SearchCenter, Index Tools or Keyword Max - or any other commercial application you can still be the beneficiary of a fairly robust rules based bidding solution.

In the following situations, AdWords editor will be a reasonably good alternative to the manual tracking and adjustment of keywords.

a) Your chief PPC success metric is either cost per sale, or cost per lead - or any other page view generating action. Google AdWords doesn’t process revenue, thus the only data in AdWords editor is “cost/conversion”.

b) You have AdWords editor - download here if you need it.

Our point of departure once the above conditions are satisfied will be something called a “custom view” which lets you do just what it says. Here’s a screen shot. It’s also called “advanced search”.

adwords editor image

After selecting the parameters for the keywords whose bids you wish to manage, you should select some performance criteria. If you want to filter so that all you have in your editing pane is keywords that have 20 clicks and no conversions, or > 20 clicks and 1 conversion, or impressions < 5 and average position less than 6, or clicks in the top 10% of all clicks and conversions DNE (do not exist). You get the idea. You can generate many layers of keyword classes with 2 performance selections. You can save up to 10 custom searches as well, which is useful.

Now - the next consideration is after you’ve defined your performance cohorts, how do you apply the bid changes. Let’s say you want to increase bids globally for all keywords that have had a cost/conversion above/below some absolute $ value over the past 7 days by 10%.

a) select the date range on top of adwords editor so that “last 7 days” are showing.

b) wait for the data to load (it can be a little sticky, make sure you’re freshly logged in).

c) set the custom view

d) once you’re confident the custom view is set and correct, go to the bottom of the editing pane and click on advanced bid changes:

advanced bid changes, adwords editor dialog box

Make the changes you’d like, while setting max CPC ceilings or min CPC floors to ensure that your global changes never push the keyword MAX CPC beyond a level you’re comfortable with.

That’s essentially all there is to it. Keep in mind if you have 10k + keywords you need to be patient with the custom view to set. Sometimes the date range won’t click so just log out, long back in and try again immediately. Another useful feature is sorting all of your keywords by minimum CPC and possibly deleting anything with a $.40 + minimum as it may have a negative impact of better quality keywords in the AdGroup.

Also - many advertisers use ROAS (return on ad spend) as their chief success metric). You can easily have a CPA 2x higher, and a ROAS 3x higher. SO…there isn’t a perfect correlation between cost per sale and return on adspend thus rendering this tactic somewhat ineffective. It’s still a great keyword editing tool and with a little ingenuity a combo of Google Analytics + AdWords Editor is a winning combo for most online merchants.

Jeff

→ No CommentsCategories: adwords editor · rules based bid management
Tagged: ,

Penguins at the New York Times Travel Show

March 2, 2008 · No Comments

new york times travel show - pengiuns

As seen on Saturday at the Jacob Javitz center in New York City.  2 Magellantic penguins, courtesy of Sea World. Given the weather that day they would’ve probably preferred to be outside the convention.

According to the exhibitors, they try to keep the penguins at 65 degrees or so. “Magellantic” is derived from Magellan + Atlantic in case you’re wondering.

Enjoy,

Jeff

→ No CommentsCategories: nyt travel show

Organic Search/PPC Mini site/Template

February 17, 2008 · 5 Comments

Many dynamic landing pages are structured to GET URL parameters based on the keyword specific destination URL. For example, if I’m driving traffic to a landing page to generate leads for some company I’m an affiliate for and my keywords have a {geography} and a {service} than my URL might look something like this:

www.ppc-management-firm.com/google.php?geo=NY&service=PPC 

The copy on the page might read something like:

Stop! You’ve just found the best way to research the right PPC management firm in NY for your company. In 3 simple steps we’ll help you find the right PPC management firm for you based on your online advertising budget and product or service type.

[the fields in bold would be grabbed from the URL] - In the source of the page, there would be a line of php that looks like this

“…..right <?php $_GET['kw'] ?>  management firm….”

But if nothing is set in the URL for kw, than your page won’t read properly and will have diminished value in the organic search game. You should at least let it get indexed regardless of whether or not it will ever rank. To do this and have a default value in the paramater’s place if it’s not set, the code would change slightly.

<?php

if (isset($_GET['kw'])){
//keyword DOES exist, show whatever.

} else { echo “PPC”;
//DOES NOT exist, show default

}

?>

In summary - why not make a mini site with a few different dynamic pages? Google should appreciate the relevant text on the page and it will still have something natural to chew on now, and down the line.

→ 5 CommentsCategories: landing pages · ppc tools · ppc tutorial · quality score optimization

Cool PPC Keyword Generator Excel Macro + Screencast

February 16, 2008 · 3 Comments

For any interested pay per click advertisers, ppc affiliates or mildly interested Internet marketing aficionados - here’s a neat little macro for excel which generates a list of keyword permutations based on 2 lists of data (columns A and B).

Check out the screencast I made to see how you might benefit from it and how to set it up.

Here is the code itself -

Sub MyConcatenate()
Dim rng As Range
Dim LastRow As Long
Dim I As Long

LastRow = Range(”A” & Rows.Count).End(xlUp).Row

Set rng = Range(”B1″)

While rng.Value “”

Range(”C1″).Offset(I).Resize(LastRow) = “=A1 & CHAR(32) &” & rng.Address

Set rng = rng.Offset(1)
I = I + LastRow

Wend

End Sub

There’s a wide variety of uses for this, especially when generating long geotargeted lists of keywords, or when you have a long list of “keyword + {attribute}.” They’ll be grouped somewhat logically the way the macro is written so you can simply just generate some dynamic URLs using the keywords immediately after generating them if you’re sending traffic to a dynamic template.

It doesn’t name the adgroups for you but if you’re brazen enough and the keywords are similar enough you have 2,000 keywords per adgroup and {KeyWord:Is Your Friend}.

Cheers!

Jeff

→ 3 CommentsCategories: keyword generator · ppc + excel · ppc bulk edit · ppc tutorial

Phrase Match Excel Formula + AdWords Editor for PPC

February 13, 2008 · No Comments

For a few days now I’ve seen hits for searches like this “phrase match excel.” I’m afraid that if you’re looking to for this you really need to get with the times.

1) Unless you’re editing through Google AdWords itself, there’s absolutely no need to use keywords actually wrapped in quotes - “paid search consultant” for example, if it was a phrase match keyword. AdWords editor made using the actual AdWords interface almost completely obsolete. The match type attribute can be selected through the keyword editing pane with keywords selected based on almost any attribute including:

  • adgroup name
  • campaign name
  • max CPC
  • min CPC
  • clicks/impressions/average position absolute and ranked
  • status

Go download AdWords editor here if you don’t have it yet. You can edit all of the keywords in your AdWords account at once if you were so inclined. Not that it would be very logical in most cases.

2) If you still want the formula here it is along with a few other useful excel maneuvers for the pay per click practitioner.

“    paid search consultant    “    =CONCATENATE(B5,C5,D5)

If the first quote is in B5, the keyword is in C5 and the end quote is in D5. There’s a suite of macros for excel called ASAP Utilities you should have as well. It’s great for sorting huge lists and cleaning up data very quickly.  Here are a few great features:

  • Delete all empty rows
  • Delete all duplicates (easy for Excel 2007 users however)
  • Variety of =Trim() functions to delete leading, trailing and excessive spaces, so duplicates are truly duplicates.
  • Delete every Nth row.
  • Many =upper(), =lower(), =proper() type functions dealing with capitalization.
  • Great conditional select and delete options.
  • Hundreds of other uses I’ve never used and probably never will.

I believe it’s still free and is a great add-in for Excel. In any event - if you’re still editing your AdWords account through the interface…well, you must be nuts! (in most cases…Placement targeted campaigns {researching sites}, longitude and latitude geotargeting, preferred CPC, conversion optimizer settings, day parting have to be done in your account).

With something called a “custom view” in AdWords editor you can actually implement basic rules based bid management since you can select keywords based on nearly any attribute along with 2 performance metrics (conversions, CPA, CPC, Impressions, position, others too I believe). Keep a notepad file of the changes you make and which groups of keywords if affected. Here’s an example -

Advanced search/custom view in AE (adwords editor)

- Select the 10 highest spending keywords in your account. Search, sort by CPA, use an advanced bid adjustment and increase or decrease by a % amount. You can implement ceilings and floors so if you’re doing this over hundreds of words you don’t end up with inactive keywords or really high bids.

- Try keywords that were in the top 50 of all your keywords for impressions and sort by CTR (click through rate). If they’re all broad match you might want to check that you’re CTR is good and your minimum bids are $.10 or below. Maybe you’re running heavy on impressions if your keywords are tangential to your core product/service.

- Find all keywords with over 1,000 impressions and have an average CPC of over $X.00.

- Find keywords whose average position is less than, less than or equal to, equal to, greater than, greater than or equal to some value. CPCs do go up - check out to see if you’re falling.

Another cool thing is that you can copy your custom view and paste it into excel. You don’t get the performance stats but at least you have your list and campaign data right there if you’d like to make any organizational changes to your PPC account.

Cheers!

Jeff

→ No CommentsCategories: PPC Essentials · ppc + excel · ppc bulk edit · ppc tutorial

Omniture eVars, custom events & s.props - SiteCatalyst Tutorial

January 27, 2008 · 3 Comments

I wanted to share an analogy with anyone who might be trying to more firmly grasp some of the elementary concepts of Omniture’s SiteCatalyst analytics software. I’ll outline the meaning and intended use of:

  • eVars - (s.eVarN) aka “custom commerce variables”
  • s.props - (s.propN) aka “custom insight variables”
  • custom events - (s.events) - “custom events”

Imagine there’s a bustling marketplace. You have many entrances, many shoppers, many browsers and in all likelihood a few shoplifters. If you were trying to better measure various metrics such as the ratio of those who enter the market to those who purchase, or even how many times people pass through a certain entrance you’d have quite a job to do. You’d have to be so many places at once with your eyes on more then you can possibly keep track of.

Cast a wide net and tag every entrance with java script tags! Custom insight variables or s.props will count whatever pass through them. Perhaps you’d like to find out the use frequency of the N entrances to the market. Let’s use

s.prop1=”entrance 1″ each time someone passes through entrance 1, and use s.prop1=”entrance 2″ each time someone goes into entrance 2. Keep in mind that although the values we’re passing through the custom insight variable vary, the actual tag (s.prop1) will stay the same for purposes of continuity. We can go into the SiteCatalyst admin and name s.prop1 “entrance frequency.”

So now you know where people are coming in…that’s nice. Say you want to know how many people go into store X in one month. Every time someone passes through the entrance point of store X you trigger a custom event, say s.events=”event1″ Now each time a shopper passes into the store the tally of event1 which will probably be set to “counter” if you’re not aggregating a monetary value the event count will increment upward by 1.

An astute reader will now say, “Jeff, what is this? You can just use a custom insight variable, why are you being all fancy using this custom event stuff eh??” Excellent point I’ll reply! I could use an s.prop and each time someone passes through the store entrance pass through the store name. So what’s the fundamental difference?

Well, when someone leaves the store it will also count them when you use a prop, whereas with the custom event you can serialize the event count so that you only increment the event once per “session” or visit. Is it better to know the number of times something passed through a gate or the # of unique people who went into the store that day? Both have a certain value (and that was a rhetorical question) but as we’ll see next, the custom event’s utility reaches further beyond that of the s.prop in the case of measuring commercial activities.

Okay, so we have the bustling marketplace, lots of people entering here and there, going into stores and we know from where they enter and which stores are most popular. The whole point of going there is to get them buying!!!! Spend your money with meeeeee says the marketplace’s collective wisdom.

Which entrance leads to the most revenue? Which store generates the most revenue? Let’s think about this…if we pass revenue into the s.prop, wait - you can’t do that it just counts the frequency of what gets placed into it, and how would you know what entrance they came into? If we set the custom event to “currency” (an advanced setting in the sitecatalyst administrative console) we can pass the revenue of each store into a custom event, but you’d have to use multiple custom events for each store. How can you get the data in 1 report.

Well first, to save face with any knowledgeable readers Omniture SiteCatalyst uses the s.products=”" tag to count revenue and product data so the custom event set to currency isn’t necessarily applicable here.

With that said, we can use the “custom commerce variable” aka the eVar (s.eVarN=”something”). A key feature of the eVar is it’s use of persistent cookies. Each eVar has its own unique attribution settings and you can control:

  • How long the persistent cookie will persist for.
  • Whether credit will be given to the first or last touched (first or last what, right? Whatever you put into the tag s.eVarN=”whatever is in here”).

I don’t think any cookie expiration length is typical, but attribution to the last item touched is. There is a great debate regarding the accuracy of this but in my view (without getting into great detail) I think it’s the best measurement.

So let’s set our eVar to persist for 1 day. When someone comes into the mall we have an entrance eVar, when someone enters a store we have a store eVar.

Someone comes into the mall -

s.eVar3=”west gate entrance”

Someone comes into Macy’s -

s.eVar4=”Macy’s”

At day’s end you can run an eVar report for each custom commerce variable against revenue and you’ll see which entrance generated the most revenue and which store generated the most revenue.

In all fairness in this strange example we could use the store name as the products variable in the s.products string and eliminate the need for the eVar4 report but that’s too tangential to this discussion.

Another cool thing about the custom insight variable is you can correlate them with other traffic variables. So if I wanted to know which articles were most popular in my international news section of my news content site, each time a page was viewed in that section, the article name would be passed through the prop. Check it out:

s.channel=”international news”

s.propN=”9 out of 10 politicians at home and abroad are corrupt: public easily forgets”

You could then correlate channel and prop and see how popular articles were within the section.

If you need consulting shoot me an email at JeffJames.vib@gmail.com or catch me on LinkedIn:
View Jeffrey James's profile on LinkedIn - Omniture Consultant, SiteCatalyst Implementation Consultant and Consulting

Jeff

→ 3 CommentsCategories: omniture · omniture tutorial · ppc tutorial

Google “Cars” and You’ll see the GOOG Caught off Guard!

January 13, 2008 · No Comments

http://www.google.com/search?q=cars

Ooohhps!!! :-()

google_spam_cars

→ No CommentsCategories: Uncategorized

Is Marketing Evolving towards or Away from Performance?

November 10, 2007 · 3 Comments

As we collect more data we can make more rational, performance based decisions. This we all agree upon. But how often do we change our ways once we have better data? Often times ingrained habits take precedence over actionable information solely due to the fact that it’s a habit. Further, if a large group of people who have the incentive to mirror each other’s actions are faced with the above dilemma - how long until they act?

First consider the power of habit. Some say if you do something for 21 days, it’s a habit. What if an industry has been doing something for 21+ years? Individual inertia is much easier to create or halt than industry inertia. A much larger machine, or network of machines cannot be replaced as quickly as a personal computer.

So, just how much money is wasted on advertising? How many times will people quantify “engagement,” and “interaction” in an attempt to justify purchasing media. Probably numerous times, no…many more times yet.

So is performance marketing the future? Is the Internet, (the best context we have for behavioral ad targeting and data collection) going to revolutionize the way companies spend advertising money? Yes. It’s the only way things can ultimately play out, with a few caveats.

The scaling of the above will be proportionate to our ability to segment, target, and re target groups of users. There needs to be many more definitions of “user” that exist already. Emo, or young adult, senior citizen, etc……this isn’t enough to let performance marketing overtake banners and the current waste we see now. One day, the musician from your Myspace page will follow you as you surf the net to be sure you’re aware of the new CD coming out on the 11th. Cookies will be placed on your PC once you log into your social network and they’ll get paid based on their ability to target effectively.

The keys to success are data and the ability to analyze and act upon it…most people won’t be able to and this will reduce efficiency & publisher profits will prevail for a while longer, but something will breakthrough, or the government will intervene (as if most often the case). As for now - I very much doubt your neighbors knows people have cookies on his browser waiting to meet Mr. Pixel over at Amazon.com! Long way to go folks.
watch out!
I bet he wants Chinese food! Based on some future metric that one day will be collected from his sniffing cellphone which regresses day/time with food consumed. Monday night at 7pm , really high R^2!

What’s your fortune?

Cheers!

Jeff

Blogged with Flock

Tags: , ,

→ 3 CommentsCategories: future of search marketing · performance marketing