Posts Tagged ‘search engine marketing’

Mar 01
2010

It’s March 1st already, my goodness, I am already so behind on things I want to do in the first quarter! And this week it’s going to be busier since I’ll be attending & presenting at SMX West. But it’s worth every bit of it. The folks at SMX have assembled a great line up of speakers on all-things search (and yes, some analytics too).

For those of you attending SMX West, I’d love to meet and catch up. In addition to attending and taking notes at the various sessions, here is where I’ll definitely be networking or speaking: :)

  • Monday 3/1, 6pm-7:30pm: Meet & Greet reception
  • Tuesday 3/2, 5:45pm-7:00pm: Expo Hall Reception
  • Thursday 3/4, 11:30am-12:30pm: Measuring How Search Ads Drive Offline Conversions – Q&A Moderator
  • Thursday 3/4, 12:30pm-1:30pm: Birds-of-a-Feather Analytics Table (lunch)
  • Thursday 3/4, 1:30pm-2:30pm: Analytics Action Plans For PPC & SEO – Q&A Moderator
  • Thursday 3/4, 2:45pm-3:45pm: Conversion Ninja Toolbox – A Review of Tools & Technologies – Speaker
  • Friday 3/5, 9am-5pm: Google Analytics Workshop – Presenter

To our clients: many of us at E-Nor will also participate in parts of the conference and we plan to absorb as much as we can, pick some golden nuggets here and there and take it all back and continue to enhance our processes and add more value for our clients.

Thanks,
Feras

Technorati Tags: , , , , ,

Feb 25
2009

Integrating lead information from one system such as Google Adwords into a CRM like Salesforce is definitely not a new topic, especially since the Salesforce-Google Adwords integration has been announced for a while now.

I want to highlight the steps required for a seamless integration, as well as a few additional pro-active steps you want to take to keep your Google Analytics data clean. The same concept would apply to other analytics tools you might be running. As Avinash always reminds us, data accuracy is always one of the biggest challenges in web analytics.

Here are my steps:

  1. Create Adwords and Salesforce accounts.
  2. Link Google AdWords with Salesforce.
  3. Exclude SalesForce parameters from Google Analytics.
  4. Set up AdWords lead tracking.
  5. View report.

1) Create Adwords and Salesforce accounts

You need to have a Google AdWords account and a Salesforce account before you can integrate them.

2) Link Google AdWords with Salesforce

  • In Salesforce, click the Google AdWords Setup tab.

  • Enter your AdWords customer ID and login e-mail.

3) Exclude SalesForce Parameters from Google Analytics

When Salesforce performs its integration with AdWords, it appends parameters (_kk and _kt) to all destination URLs in your AdWords account. We suggest that you strip these query parameters out of URL to insure no duplicate entries in your Top Content report.

To strip the query parameters, please follow these steps:

*A note for AdWords managers. Keep in mind that when Salesforce appends the destination URLs with its _kk parameters, this is actually “editing” your AdWords ads and the stats associated with these ads will now reset, according to how Google AdWords works.

4) Set up AdWords Lead Tracking

  1. Back in SalesForce, click on the Google AdWords Setup tab.
  2. Click on the “Set up Lead Tracking” button.

i – Create a Web-to-Lead Form

  • Click on the “Create Web-to-Lead Form” button

  • Add the form to your page
<META HTTP-EQUIV="Content-type" CONTENT="text/html;
charset=UTF-8">
.
.
.
<form action="https://www.salesforce.com/servlet/servlet.WebToLead?
encoding=UTF-8" method="POST">

<input type=hidden name="oid" value="xxxxxxxxxxxxxxx">

<input type=hidden name="retURL"
value="http://www.mysite.com/thankyou.html">

<label for="first_name">First Name</label><input id="first_name"
maxlength="40" name="first_name" size="20" type="text" /><br>

<label for="last_name">Last Name</label><input id="last_name"
maxlength="80" name="last_name" size="20" type="text" /><br>

<label for="email">Email</label><input id="email" maxlength="80"
name="email" size="20" type="text" /><br>

<input type="submit" name="submit">
</form>

ii – Add the Salesforce Tracking Code to the Website

Typescript,Computer Graphic,Text,Single Word,Article,Newspaper Headline,Information Medium,Newspaper,Printed Media,Print Media,The Media,Folded,Report,Business,Finance,Banking,Document,Paper,Printing Out,Printout,Print

Add the following tracking code to every page of your site right before the </BODY> tag

<!-- Begin Salesforce Tracking Code -->
<SCRIPT type="text/javascript" src="https://lct.salesforce.com/sfga.js">
</SCRIPT>
<SCRIPT type="text/javascript">__sfga();</SCRIPT>
<!-- End Salesforce Tracking Code -->

iii – Test Your SalesForce installation

By clicking the “Test your Setup” you will be able to test the installation of the codes in step i and ii

5) View report

This report gives an overview of the leads submitted to SalesForce from your website

For more detailed information, click on each lead and learn more about the lead source

Technorati Tags: , , , , , ,

Jan 13
2009

You are working on your site’s SEO by publishing press releases and you wish to track traffic to your site from those press releases.  You are not adding source campaign parameters (and therefore no campaign parameters at all) to your links because you are not sure which sites will pick up your press release.

Sounds familiar, doesn’t it?

In Google Analytics, you noticed that links from press releases are tracked as:

  • Source = cnn.com, bbc.co.uk, or domain.com
  • Medium = referral
  • Campaign = (not set)

I am sure you are not satisfied with this basic level of tracking because it does not tell you much, especially if you wish to track across different campaigns and mediums.

The following example makes more sense and will help you evaluate and analyze your campaigns.

  • Source = cnn.com
  • Medium = press_release
  • Campaign = hurricane_katrina

To overcome this challenge of tagging links from unknown sources, I came up with the following trick.

Algorithm:

  • Add a parameter on all links to your site that are in the press release. (example: http://www.mysite.com/myfile.html#id=1)
  • On the target page (http://www.mysite.com/myfile.html), check the value of the “id” parameter.
  • If the “id” parameter equals “1″, replace the parameter in the URL with the following utm parameters (utm_source, utm_medium and utm_campaign) before the call to pageTracker.
  • If the “id” parameter does not equal 1, call the pageTracker function normally.

View the entire code segment.

Let us explore the code, section by section:

var parameter = get_parameter('id');

function get_parameter(name)
{
name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regexS = "[\\?&#]"+name+"=([^&#]*)";
var regex = new RegExp(regexS);
var results = regex.exec(window.location.href);

if( results == null )
  return "";
else
  return results[1];
}

This portion of the code will return the value of the “id” parameter from the URL and assign it to the “parameter” variable.

if (parameter == '1')
{
window.location.hash = "utm_source="+srcPage+"
&utm_medium=press_release&utm_campaign=hurricane_katrina";
}

If the page url contains the “id” parameter and its value is 1, then the url will be updated with the utm parameters.

Link URL
http://www.mysite.com/myfile.html#id=1

New URL
http://www.mysite.com/myfile.html#utm_source=www.cnn.com&utm_medium=press_release&utm_campaign=hurricane_katrina

* Notice that we did not use window.location.href function because this function will re load the page with the new URL, which is not what we want to happen. We just want to update the URL, without affecting the visitor experience, in order for the Google Analytics tracking code to attribute the visit in a certain way.

How to get the value of the utm_source (referral site)?

var srcPage = getDomain (document.referrer);

function getDomain (thestring)
{
var urlpattern = new RegExp("(http|ftp|https)://(.*?)/.*$");
var parsedurl = thestring.match(urlpattern);
return parsedurl[2];
}

This portion of the code is responsible of assigning the URL of the referral site to the variable scrPage. The “getDomain” function parses only the domain name (www.domain.com) out of the long url string (http://www.doman.com/file.html?parameter=abc)

The last piece of code that needs to be added is the setAllowAnchor command, which allows the # sign to be used as a query string delimiter instead of the question mark (?).

We used # in the press release link instead of ? for SEO reasons, but you could use ? in the original link and still use the above method.

pageTracker._setAllowAnchor(true);

Alright, now it is time to use our friend Advanced Segments to track our press release visitors, measure their engagement, and analyze their behavior.

Now we can really analyze! :)

Technorati Tags: , , ,

Jan 02
2009

Questions I always hear with regards to SEO and marketing optimization:

  • How does Google Analytics improve my search engine optimization (SEO)?
  • How can I get more out of my SEO?
  • What is the real effect of ranking on search engines for my business?

I am hoping the case study below will shed some light on these questions. If you apply a similar analysis you can help your customer, manager, or whoever is delaying your SEO effort. But instead of answering “the importance of ranking” question, maybe something more quantifiable and measurable might get your decision makers’ attention! How about “how does ranking on a specific keyword, or lack thereof, impact the bottom line?” Answering such questions will help us make the most of our marketing spend during these tough economic times and help us do a more effective job in marketing and campaign optimization.

I’ll use real time data and analysis but won’t mention the name of the website for privacy reasons. Here are the details:

  • Website type: eCommerce
  • The website used to rank near the top of Google on two competitive keywords until August 2008.
  • Historically, these two keywords have driven traffic to the site. For a specific time period, these two keywords drove 5,684 visits and led to 46 conversions for a 0.81% conversion rate.

If you have your Google Analytics eCommerce features properly configured and working, the above data is easily accessible under the Traffic Sources -> Search Engines -> Non-paid report. The inline filter was used to get data for just these two keywords.

  • We then start examining the time period when the ranking for these two keywords took a big hit.
  • Next, using the date comparison function in Google Analytics, we compared the traffic generated by these two keywords for this year with poor ranking versus last year with better ranking. Here is the result:

The table on the left is for one of their keywords and the table on the right is for the other. As you can see, a significant drop in visits in 2008, 4471 to be exact. So the negative impact of the drop in SEO ranking was less opportunities to make sales on their primary keywords!

  • The 4471 visits might be a small percentage of the overall website traffic but when you put a dollar sign next to it, we typically react to it more quickly. Take the 4471 visits and multiply it by your average conversion rate for these keywords, which is 0.81%, and then multiply by the average order value, which is $846.
  • 4471 x 0.0081 = 36 lost sales
  • 36 x $846 = $30,456 of lost revenue!

Now one can argue that this number is not accurate because of many factors BUT the findings are very actionable! If I were to present this analysis to my boss or client, I would add 2-3 other scenarios:

  • Scenario 1, with a higher conversion rate of 1.62% after improving the design and usability of the site, the lost revenue would be $60,852. (ouch!)
  • Scenario 2, with a lower average order value and the existing conversion rate of 0.81%, our lost revenue would have been $15,228.
  • You could create a table to show the range. The main point is that there was between $15K and $60K of lost revenue. In tough economic times, wouldn’t you rather have that revenue?

Depending on your company size, marketing budget, and other factors, the $30K might be a significant number or it might be a rounding error. But at the end of the day, $30K of lost revenue is $30K of lost revenue, especially in times like these where cutting cost and marketing optimization is more important than ever. By doing similar analysis, you can find other lost sales opportunities, monetize them, and get some corrective actions underway.

I think you can take this analysis to a business owner or marketing manager, and I am pretty sure they would get the SEO effort prioritized.

Technorati Tags: , , ,

Dec 12
2008

In September of this year, Yahoo! announced the formation of a Digital Advisory Council to drive discussions with advertisers. Our agency was invited and we welcomed the invitation to listen to what Yahoo had to say and provide some feedback. Our office being literally less than ten minutes away made the decision a little bit easier!

During the meeting we were told that we are under an NDA so I won’t go into the specifics.  But here are some comments and thoughts:

  • We applaud Yahoo’s efforts to be open, reach out to their clients (advertisers and agencies), and solicit their input. That spirit was felt throughout the council meeting, from the Senior VP that hosted the event to managers and other Yahoo staff.  They really wanted to be transparent and sought input from us.  Good job, Yahoo!
  • Despite the poor picture that might have been portrayed in the news about Yahoo and search, we were reminded that Yahoo! is still a profitable company and has some very high traffic sites, including Yahoo! Sports (we were told it has more traffic than ESPN) and Yahoo! News (gets more traffic than CNN).  I didn’t know that and I would say it is pretty impressive!
  • Various folks from Yahoo! presented about new features and innovations (sorry, can’t blog about it yet :( ) but expect to hear from Yahoo! on areas they are strong in, including Display (banner) Advertisement.
  • There was a talk about Traffic Quality and the favorite discussion topic of click fraud.  Without spilling their beans, we got a better picture of how Yahoo! handles click fraud and also learned that you can get reports from within your Yahoo! Search marketing account about credits your accounts is getting for false clicks.
  • Lunch was really good too, including the Israeli Couscous which was very tasty!  To be fair, I have to say that the food in Mountain View during the GAAC Summit was really good too.

So in summary, I am really glad to see Yahoo! opening up and creating additional forums to communicate with advertisers and agencies.

While we are on the subject of Yahoo! Search Marketing, there is another topic that we have been wanting to blog about but didn’t get to until now.  Yahoo! has a mechanism of optimizing your accounts and campaigns on their own! Yes, that means without your
knowledge.  Maybe this is not so recent but many clients I speak with are still not aware of this mechanism, so it is important that we share it. The following was drafted by a couple of folks in the office:


We hope you are aware of Yahoo’s decision to optimize PPC accounts by creating optimized campaigns on their own and running them without checking with the client. As strange as this may sound, it is very true! For a regular advertiser who doesn’t tag his campaigns and review them in any analytics tool, this may not be that bad. For those who do tag their campaigns and review all of their traffic sources and conversions via an analytics tool, this could be trouble.

Yahoo does the whole nine yards when it comes to campaign creation (naming convention, ad group, keywords, ad copy) but they miss a very crucial step. They don’t tag the campaign at all with tracking parameters so a web analytics tool can recognize it as PPC traffic. This means traffic from this new campaign will be recorded as organic traffic and will dilute the quality of your data. The number of visits attributed to Yahoo cpc and Yahoo organic will be wrong, and conversion rates for these two sources will be subject to speculation.

There are two ways that you can deal with this issue:

  1. If you would like to try these optimized campaigns and see how they will perform while capturing the data properly in your analytics account, you need to go to your Ads under the AdGroup they created and make sure that you tag the destination URLs properly. If you are using Google Analytics, here is a good post from our friends at PPC Hero that will help you.
  2. Otherwise, once you see a new optimized campaign in your account, pause or delete it and make sure that you opt-out from this service. You can opt-out by submitting a request to Yahoo customer support.

If you have too many campaigns in your own or your client’s accounts, the easiest way to spot the Yahoo optimized campaigns is by their naming convention. See the below snapshot for an example.


My request to Yahoo! is that they back out of this practice and allow user more control before they turn campaigns on and spend someone else’s money!

Technorati Tags: , , , ,