Knowledge is the Foundation To Success  

I’ve blogged before about how Google AdWords can track revenue within the AdWords interface, without relying on Google Analytics. You can do the same for Yahoo Sponsored Search.

A note about why you might not want to only use Google Analytics to report revenue: Google Analytics attributes a conversion to “last touch” while Google AdWords and Yahoo Sponsored Search attribute it to “first touch.” What that means is if someone came to your website on a Monday through a paid ad, and didn’t buy anything, then returned a week later (either through a bookmark and manually typing in your URL) and bought something, Google Analytics would count that conversion as a Direct referral (the last way they came to your site), while AdWords and Sponsored Search would attribute it to PPC (the first way they came to your site).

It’s not a big deal when the vast majority of your visitors order on their first visit, but becomes a big deal when a large percentage of them don’t. I have several clients where over 50% of their visitors don’t buy on that first visit, which makes PPC look like it doesn’t perform that well. Once you factor in those “first touch” conversions, PPC certainly is a much more important piece of the marketing puzzle.

So back to how you track revenue in Yahoo Sponsored Search… I have to give Yahoo credit – they beat Google on this by including revenue right in the normal screens you use to manage your Yahoo Sponsored Search campaigns. Google only reports revenue on their actual reports, which makes it more of a pain to manage; Not impossible, just not as easy to analyze and then make quick changes.

To track Yahoo Sponsored Search revenue, you’ll just need to add one more tiny bit of code to your conversion tracking. Replace where I have ORDER.SUBTOTAL with your dynamically generated Order Subtotal field into this line of your Yahoo Sponsored Search Analytics code (You can also do Order Total, but I recommend doing the Subtotal which excludes tax and shipping, for a more accurate picture of your revenue.):

window.ysm_customData.conversion = “transId=,currency=,amount=ORDER.SUBTOTAL“;

That’s it. Pretty simple and pretty powerful. Now you can actually see what kind of revenue your Yahoo Sponsored Search campaigns are actually generating, and then make better informed decisions about where your PPC advertising dollars should be spent.

A note on this: I attempted to do it for a client that uses a Volusion cart and processes credit cards offline (meaning they don’t actually process the credit card at the time of order, but do it manually at a later time), but this won’t work for them. I’m guessing that this will hold true for any shopping cart; if you don’t process credit cards in real-time, it won’t work. In fact, for this client, it also prevented the number of conversions from tracking.

One last note: Unfortunately, MSN AdCenter does not have the same functionality. Here’s hoping they get that solved before they take over supplying Yahoo’s paid ads.

If you need help getting Yahoo Sponsored Search Revenue Tracking implemented and/or analyzed, contact a reputable PPC management company for assistance.

My last blog was about the different ways Google AdWords tracks pay-per-click (PPC) advertising conversions and Google Analytics tracks PPC transactions. If you have a large number of site visitors who don’t purchase on the first visit, but do on subsequent visits, Google Analytics doesn’t attribute the transaction to how they found you in the first place. A way to get around that is to track revenue in Google AdWords.

I’ll have to admit that this is something relatively new to me (and a thank you to Michael Whitaker at Monitus for telling me it was possible). A search through Google AdWords help files comes up with nothing, nor did my Google reps ever explain that it could be done – they always pointed to Analytics as the tool to track revenue. And the answer is really simple – when you add conversion tracking to your thank you page, you can alter the code slightly to capture the revenue generated by an order.

You’ll need to change the YOUR-ORDER$ to be the field name of your order subtotal which can differ by shopping cart.

One note on this: I attempted to do it for a client that uses a Volusion cart and processes credit cards offline (meaning they don’t actually process the credit card at the time of order, but do it manually at a later time), but this won’t work for them. I’m guessing that this will hold true for any shopping cart; if you don’t process credit cards in real-time, it won’t work. In fact, for my client above, it also prevented conversions from tracking.

One more thing to know about tracking Google AdWords revenue: you can’t see results within the Google AdWords interface, you have to run a report to actually get the data. You’ll need to select the field “Sales Conv. Value (many-per-click)” in order to add that data to a report, and then you’ll be able to see revenue by Account, Campaign, AdGroup and even keyword by keyword, and learn how profitable your PPC campaigns really are. If you need help getting Google AdWords Revenue Tracking implemented and/ or analyzed, contact a reputable PPC management company for assistance.

More about Nikki

Lately I’ve been getting asked by Google AdWords clients for help with Google Analytics and the need seems to be increasing rapidly. More and more of my ppc advertising clients are wanting information about their site, bounce rate, exit pages, revenue and more (Google Analytics is a free tracking program offered by Google). I’m not a Google Analytics expert by any means, but I do know the basics of how to create an account, how to implement the code, how to setup goals (which is critical for tracking conversions) and how to analyze results.

Google Analytics provides great information, but one issue that can arise is when Google Analytics transaction numbers and the Google AdWords conversion tracking numbers don’t jive. I know that different packages are not going to track exactly the same, but most of the time, they are close enough that it’s not a big deal. However, a big issue arises when you have an e-commerce site and a decent percentage of people don’t order on their first visit, but come back and order at a later date.

Here’s the problem: Google AdWords tracks “first touch” – if someone searches on a term, clicks on your ad and comes to your site, does not order at that moment, but comes back a week later, AdWords will log the conversion back that first date and attribute the sale to AdWords. Analytics on the other hand tracks “last touch.” In our same scenario, if someone were to search, click an ad, visit the site and leave, then come back a week later, Analytics would attribute that search to organic or other, unless they did a search and clicked on an ad again. Not a big deal if a majority of visitors order on the first visit, but if you have a large amount of people who order at a later date, this can be present a huge problem.

I have two clients who have this issue. For one of them, 40% of visitors don’t order on their first visit, and the other is 50%. And you guessed it, there’s a 40% and 50% difference in AdWords conversions and Analytics transactions. They can’t get a true picture of their PPC ROI with Google Analytics because they only see the revenue for anyone who ordered the first time they visited the site.

The big question is why is that? You would think that, both being Google products, they would track the same way, or at least have an option to track that way, but they don’t. Frustrating for both me and my clients!

But, I’ll explain how to get around this dilemma in my next Blog.

More about Nikki