Dec 19

Urchin 6.5 was just released and we recommend you upgrade to take advantage of these new features:

  • The best new feature: a Pay-per-Click (PPC) data manager lets you create PPC sources that automatically import cost data from Google Adwords.
    • These PPC sources can then be applied to profiles as easily as you would apply log sources and filters!
    • Currently, this feature does not work with the autotagging feature of Google Adwords.
  • Urchin has been updated to show Chrome as a browser and Android as an operating system.
  • The installer has been improved to make for a more seamless installation or upgrade.
  • The Urchin configuration management utility has had its functionality extended.
  • The geo database has been updated to December 2008 data.
  • Some localization issues have been fixed.
  • Urchin help topics (both internal to the application and in the online Urchin Help Center) have been updated.

Feel free to contact us for all your Urchin consulting needs.

written by Rehan Asif \\ tags: , , , ,

Dec 12

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.

Alternatively, if you are using Google Analytics, under Traffic Sources/Campaigns you can use the inline filter with the “ysm_optimized” parameter and then schedule this report to be emailed to daily, weekly, or monthly. This way you capture any new campaigns as they pop up in your account.


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!

written by Feras Alhlou \\ tags: , , , ,

Nov 17
Back in November of 2006, our friends at GA Experts posted a method to get detailed PPC keyword data from Google Analytics. This method involved creating a seperate profile and using some intimidating but powerful filters. I really liked and referenced this method because it isolated the changes to a single profile and didn’t involve any updates to the GA tracking code. Obviously I would prefer if this feature came built-in to GA but at least now you could get to some very useful data with very little work. Lots of keywords!

As Google Analytics was updated over time, the way the filters were using Custom Field 1 was no longer possible and so the profile broke. The smart folks over at ROI Revolution came up with another way to get to the exact PPC keyword data using the User Defined field and adding 2 lines to the GA tracking code. This was a great solution and probably suitable for a lot of people. However, I preferred not having to update the tracking code (this can be very difficult on some client sites), saving the User Defined field for other uses, and also being able to isolate the keyword extraction and concatenation to one profile.

I still see some blogs referring to the original method that doesn’t work anymore so one day I tried playing with the original filters approach and after 2 months of observing the data, it appears to be working correctly. Please follow these screenshots & instructions to give it a try for yourself.

Filter 1 - look at only paid traffic data.

  1. From your account, click on Filter Manager.
  2. Click on Add Filter.
  3. Give it a name such as Data Filter - PPC.
  4. Filter type is custom filter.
  5. Select on the Include option.
  6. The filter field should be Campaign Medium.
  7. The filter pattern can be cpc|ppc
  8. Click on Save Changes.

PPC Keywords Filter 1

Filter 2 - extract the actual keyword that was typed and concatenate it to the paid keyword that was matched.

  1. Assuming you are still in the Filter Manager, click on Add Filter.
  2. Give it a name such as Data Filter - PPC Keywords.
  3. Filter type is custom filter.
  4. Select the Advanced option.
  5. Field A -> Extract A should be set to Referral and the value needs to be (\?|&)(q|p|query)=([^&]*)
  6. Field B -> Extract B should be set to Campaign Term and the value needs to be (.*)
  7. Output -> Constructor should be set to Campaign Term and the value needs to be $B1 - ($A3)
  8. Field A required, Field B required, and Override Output Field all need to be set to Yes.

Please click on the screenshot to view the full version.

PPC Keywords Filter 2

Finally create a new profile with a name such as PPC Keywords Data and all your usual settings (default page, search settings, goals, etc). Make sure you apply these two new filters to it.

This method seems to work for Google, Yahoo, and MSN paid traffic. Below is a screenshot with sample results. Let me know if it works for you!

Result of PPC Keywords filters

written by Rehan Asif \\ tags: , , , , , ,

Sep 23

At a recent speaking engagement on analytics, I was asked some questions on what appears to be discrepancies between search marketing platforms (such as Google AdWords and Yahoo! Search Marketing) and the data in the Google Analytics. I didn’t get a chance to answer these questions in details but here are some pointers on where to start your investigation!

In Adwords, ensure that your “auto-tagging” feature is enabled under account preferences.

Ensure proper URL tagging for all your PPC traffic. A useful tool to help you set up your URL tags is the Google URL builder. For tips on tagging Yahoo Search Marketing campaigns and MSN adCenter PPC campaign, check our earlier post.

Another area where problems may occur is URL redirects. Check our earlier post on this subject for more details.
So assuming you have turned on auto-tagging or your URLs are manually tagged, you will still see a discrepancy but don’t panic! Some Google Analytics help posts come to the rescue and explain why your “click” and “visit” numbers won’t match :(.
http://adwords.google.com/support/bin/answer.py?hl=en&answer=57164
http://adwords.google.com/support/bin/answer.py?answer=55610&ctx=sibling
http://adwords.google.com/support/bin/answer.py?answer=63917&ctx=sibling

Click on the the following thumbnail to view the full screenshot. It shows Adwords clicks and Google Analytics visits.
Adwords clicks vs GA visits

Now you have something to go back to your customer with (if you are a consultant) or to your boss (if you are an in-house analyst) and let them that the culprit wasn’t you. It isn’t Adwords, it isn’t Google Analytics, it is just how things are when looking at data from two different systems. Instead, we want to examine trends and not just absolute numbers (easier said than done :) ).

written by Feras Alhlou \\ tags: , , , , ,

Aug 22

Strategy, Techniques, and Track it all with Google Analytics

So you are the resident pay-per-click (PPC) guru, you have your campaigns running in Google Adwords, your metrics are looking good, your cost per acquisition is looking great, your post-click metrics in Google Analytics are just shining, and your return on your marketing spend is just outstanding. Your boss, or your client if you are an online marketing agency, says: “bring me more (and dangling the promotion/bonus carrot)!” And being the good sport you are, you say with confidence, “of course!”

You know Google is king when it comes to traffic volume, but you more or less exhausted your creative ideas to drive additional traffic through Adwords - what do you do? It is now time to explore other search engines, Yahoo! Search Marketing, MSN adCenter, and maybe some vertical or secondary search engines.

In this blog post, I’ll cover some PPC implementation techniques to optimize your paid search marketing across multiple search engines, especially Google Adwords and MSN adCenter, while ensuring your PPC post-click metrics are properly tracked in Google Analytics.

The process of transferring campaigns from one search engine to another can be very time consuming and tiring, especially when you have a big account with a large number of campaigns, ad groups, and keywords. A frequent problem popping up on the web these days is the ability to transferring campaigns from your Google Adwords account into your MSN adCenter account. In this post I hope to to answer this question and a little more.

  • We first advise that you optimize your campaigns in Google Adwords, allowing enough time for testing different ad variations, adding relevant and negative keywords, and applying other PPC optimization techniques. You can even go further and test few landing pages and pick the best performing ones. When you feel satisfied with the performance in Google Adwords, you can now start planning to migrate them into your MSN adCenter account.
  • You need to create and run an ad performance report in Adwords to get the needed information to transfer into your adCenter account. Our friends at Affiliate-Blog have came up with a clean and straightforward way to create this report and transfer it into your adCenter account.

Adding the campaigns in adCenter is one thing, but to be able to see campaign data and more in Google Analytics requires a little more work. It is time to tag those URLs! Here are few tips that will help you tag your URLs properly so that the data shows up in a clear and consistent manner. You can use the Google URL builder to create custom tags for your adCenter destination URLs.

Here is a list of the elements you needs to tag.

  1. Campaign Source: msn
  2. Campaign Medium: cpc
  3. Campaign Term: {QueryString}
    Adding this parameter will allow you to track all your keywords in Google Analytics without having to type each keyword manually.
  4. Campaign Content: (used to differentiate ads)
  5. Campaign Name: (whatever the campaign name is)

Example:

http://www.domain.com/?utm_source_=adcenter&utm_medium=cpc&utm_term=mykeyword&utm_content=variation1&utm_campaign=campaign1

For more details, check out this article written by our friends at PPC Hero

Few Suggestions:

  • I recommend you use a unique naming convention to make it easier for you to identify your adCenter campaigns in Google Analytics reports. For example, I want to set up a campaign to market E-nor’s Google Analytics services. In Google Adwords, the campaign name can be g_GAServices and for an adCenter campaign you can name it m_GAServices. Using this naming convention will make it very easy for you to visually identify which PPC system the campaign belongs to.
  • I would recommend you import one campaign to adCenter and allow enough time to test it. Check the results in GA to make sure your URL tagging was thorough. If everything goes smoothly, then start transferring the rest of the campaigns after following the same steps we mentioned earlier.

Have a great day transferring and tagging your campaigns! ;-)

written by PPC Team \\ tags: , , , , , ,

Aug 29

I just returned from my Internet marketing and web analytics training session in Melbourne, Australia. The training session went very well (my user engagement metric was calculated as the number of trainees awake after a heavy lunch divided by total number of trainees :) ).

Seriously though, in the Pay-Per-Click (PPC) optimization session, one of the consultants asked about Adwords account structure for clients that have campaigns targeting different geographies/countries. It is best practice to set up a unique/separate campaign for each geography, even if you are using the same list of keywords.

For example, if you have a client in the hospitality industry and they want to drive traffic from the UK, Australia and Japan, one campaign per country should be created. You’ll then have control, at the campaign level, for each of the following attributes:

  • daily click budget
  • language preference
  • ad serving and distribution options
  • start and end date

Following the same example above, if we see high traffic potential and good conversion from the UK campaign, we can increase the daily spend for that specific campaign with one click. And while the UK campaign is performing well, we can examine the other campaigns that might not be performing as well and make the necessary adjustment.

Another benefit of having different campaigns for different geographies is that it will make your analytics and ROI measurement much easier.

I also recommend you use a campaign naming convention that relates to the content of the campaign. For example, AirportTransportation_UK and AirportTransportation_Japan are much more meaningful than Campaign#1 and Campaign#2.

Will have a more detailed post on campaign naming conventions sometime in the future.

written by Feras Alhlou \\ tags: ,

Jul 15

If you are running PPC campaigns in Google Adwords and you are not taking advantage of the enhanced Adwords Editor, you are missing out big time! :-)

The Adwords Editor is a free desktop application that you can download, import your Adwords account into, work on them offline, and then upload to Adwords when you are ready to take the changes live. The application might take some getting used to (especially for making changes <–> approving changes <–> sharing files with changes) but once you get the hang of it, you’ll love it.

Check out these top ten features and put them to use right away. You’ll save yourself a whole lot of time and effort and end up spending more time on analysis and campaign performance improvements than edits and updates.

Thanks!

written by Feras Alhlou \\ tags: ,

Jul 02

Here is a cool tool to help advertisers see how their ads are shown on Google. Check it out at the following link; it is referred to by some as the “Ad Preview“.

I recommend you use this tool instead of you (or your colleague or clients) going on Google and searching for your ads. This way you don’t add unnecessary impressions to your keyword/ad performance.

Along the same lines, clients often ask why they can’t see their ads on Google. Here is a recent post on Google’s Inside Adwords blog that addresses this issue.

Hope you find this useful!

written by Feras Alhlou \\ tags: ,

Apr 06

Over the last few months it seems that a good percentage of the business we are getting is of the consulting or audit nature. Instead of clients asking us to implement PPC, they are actually complaining about PPC and how they are not realizing the anticipated ROI.

I once heard that “PPC is so easy to learn but it takes a lifetime to master”. That is so true! It only takes minutes to set up a campaign but few people invest the time to do the job right.

One of the most common mistakes we find when we audit an existing PPC account is the lack of meaningful account structure. The advertiser will create one campaign and then throw in all types of keywords in to one ad group. After turning the traffic on, they wonder why they are not seeing a good ROI!

It takes work and effort and creativity to implement a high performance PPC campaign. A recent post in the Inside Adwords blog addresses this issue of PPC Account Structure. Take look and re-examine how you set up your Adwords campaigns and see improvement & ease of management almost immediately.

We would love to hear your questions or comments!

written by Feras Alhlou \\ tags: , ,

Jan 08

NOTE: There is an updated version of this technique.

Do you ever wonder what searchers are exactly searching for and what actual keyword phrases are driving PPC traffic to your site? Using web analytics, you can examine your PPC traffic and configure the analytics program to provide you with “your PPC keywords vs. what searchers actually typed”. This data would help you refine your list of keywords by adding more targeted keywords or including unwanted keywords in your list of negative keywords.

For example, if you are marketing a limousine service for your client and you have “limousine service” as a keyword, the analytics PPC keyword filter might show you that people are typing “limo” or “limo service”. You can then add these two keywords and to your list of keywords. You also might find out that people are typing “cheap limo”, and let’s say your limousine service client doesn’t compete on price and doesn’t want to get traffic that is related to “cheap limo”, then you would add this “cheap limo” to your list of negative keywords.

Our friends at GA Experts came up with a way to get detailed PPC keyword data from Google Analytics. In case you need some extra help to configure this filter for www.domain.com, follow the instructions below.

  1. Go to the GA Account for domain.com.
  2. Click on Filter Manager.
  3. Click on Add Filter.
  4. For Filter Name, use something like Data Filter - PPC Keywords 1
  5. Filter Type is Customer filter.
  6. Choose Advanced.
  7. For Field A -> Extract A, choose Referral and enter in (\?|&)(q|p)=([^&]*)
  8. For Field B -> Extract B, choose Campaign Medium and enter in cpc|ppc
  9. For Output To -> Constructor, choose Custom Field 1 and enter in $A3
  10. The next 3 options should be yes followed by no for case sensitive.
  11. Hit Save Changes.
  12. Click on Add Filter.
  13. For Filter Name, use something like Data Filter - PPC Keywords 2
  14. Filter Type is Customer filter.
  15. Choose Advanced.
  16. For Field A -> Extract A, choose Custom Field 1 and enter in (.*)
  17. For Field B -> Extract B, choose Campaign Term and enter in (.*)
  18. For Output To -> Constructor, choose Campaign Term and enter in $B1, ($A1)
  19. The next 3 options should be yes followed by no for case sensitive.
  20. Hit Save Changes.
  21. Almost done! Click on the link that says Analytics Settings, then click on +Add Website Profile.
  22. Choose “Add a Profile for an existing domain”, make sure your domain is chosen, and enter in PPC Keywords for the Profile Name. Click on Finish.
  23. Click on Edit besides the PPC Keywords profile. Configure Main Website Profile Information, Conversion Goals and Funnel, and Users with Access to Profile just like it was configured for the other profile.
  24. Click on +Add Filter, choose “Apply existing Filter to Profile”, choose you’re other filters (if applicable) along with the two new filters you just created. Make sure Filter - PPC Keywords 1 comes in the list before Filter - PPC Keywords 2. In fact, these should probably be the top two filters. Hit Finish.
  25. Click on Analytics Settings. Your new profile will have data in it within hours or days depending on website traffic.

written by Rehan Asif \\ tags: , , , , ,