Posts belonging to more than one category.

  • Anonymous AdWords placements

    Update 2 (august 2018): Should you still want to see specific placements that are sending you “anonymous” traffic you’ll need to leave the Google Analytics interface and use Google’s Analytics API. Three easy ways are Google’s Data Studio, Google Analytics’ Query Explorer and Google Sheets with a Google Analytics add-on.

    Update 1: as of June 2013, Google Analytics no longer “de-anonymizes ” URLs reported as anonymous by Google AdWords (see the comments below). It was fun while it lasted, though.

    Having a look at a placement performance report a few days ago I was both surprised and annoyed to see that I got the most clicks and incurred the biggest costs for some famous AdSense publishers, by the names of x65tw5263something.anonymous.google and such.

    Obviously, those placements only got me clicks and no conversions, otherwise I wouldn’t be writing this.

    AdWords anonymous URLs

     According to Google, “Some publishers choose to offer placements anonymously and not disclose their site names to advertisers.” (http://support.google.com/adwords/bin/answer.py?hl=en&answer=2471191). Which, to me, reads “you may find yourself spending money without knowing where your ads appear”.

    It’s like going out to dinner, asking for the bill and seeing, next to everything, from hors d’oeuvres to desserts, some items which requested to remain anonymous. In spite of representing a significant part of the bill. They just don’t like publicity, you know, so they chose to remain anonymous. In the background. Discrete. 🙂

    Luckily, every AdWords account I run is linked to a Google Analytics account, and AdWords related data is in there as well. And – lo and behold – Google Analytics knows no such thing as anonymous placement URLs. Every URL that got me at least a click is there, undisguised. In the foreground, for all to see. Transparent.

    Which means that I can see, per placement domain or URL:

    • bounce rate
    • pages / visit
    • visit duration
    • goal completion
    • revenue

    That’s enough for me to be able to judge whether a certain placement is worth my money or not. And although I won’t be able to say who is x65tw5263something.anonymous.google, specifically, I will be able to say that I no longer want my ads to show on a certain website or section of it.

    The image below represents filtered data; domains containing the string “anonymous”. As you can see, there are no such URLs in Google Analytics. All data is visible there.

    So, in the future, if you see a lot of x65tw5263something.anonymous.google in your placement reports, and do not know what to exclude, leave the AdWords interface and move to the Google Analytics one. Once there, see what placements are not performing according to your targets and expectations and exclude them.

    If you don’t have a linked Google Analytics account, get one and link it to your AdWords account. It’s free, and it’s the only way for you to access post-click data related to your AdWords visitors (data which is not in the AdWords interface).

    Unfortunately, you won’t be able to exclude placements with only impressions and no clicks, because those placements only appear in the AdWords interface, not in the Google Analytics one (obviously, as you need the visitor to reach your website in order for Google Analytics to be able to record anything). And those placements, if your ads keep showing without getting clicks, may drag your quality score on the display network down. But you can at least stop wasting money for placements that only get you clicks and no other benefits.

  • You’re running an E-commerce shop, or are in charge of advertising it, and you’re looking at a loooong list of products. You have cheaper products, and more expensive products. Popular products and less popular products. High-margin products and low-margin products. And there are a lot of them. Analysis paralysis is what comes to mind.

    “I have over 8000 products on stock”, that’s what I heard from a shop owner. “I’ve tried to advertise some of them, which I knew were popular, but it did not work. In the end my cost per conversion exceeded my profit.”

    Well, truth be told, you may not be able to advertise all of them without some serious automation in place. But what you can certainly do is to pick the lowest hanging fruits.

    What you need for this is, of course, Google Analytics, your product database, and a bit of math. Nothing fancy, nothing scary.

    And it all starts with profit. You want to spend less for advertising than you’re making by selling a certain product. You want a popular product, one that people search for, otherwise your ad will not show. And you want, of course, a high conversion rate.

    Assuming that you’ve been running your website for a while before making the decision to advertise your products, you can filter, in the Content – Pages section of Google Analytics, all your product pages. Usually categories have some URLs, static pages have other URLs, and product pages have easily-recognizable URLs.

    Let’s look at Interspire, a popular shopping cart software. A product URL is something like /products/some-words-here.html. Which means that if you filter for pages matching the ^/products/.+\.html regular expression, you’ll only have your product pages showing in your content report.

    Product page views

    Export that URLs list, and go into the admin area of your E-Commerce solution and match those URLs to the corresponding products (SKUs).

    You’ll end up with a list of products, and their respective pageviews, for a certain period of time.

    Get the sales for that products, in the same period of time. Then get your margin, per product, from wherever you have it.

    You should end up with a table showing you views, sales, margin and margin per view, for that list of products.

    Now, a product is:

    • popular, if it has many views
    • high-converting, if the sales/view ratio (Bryan Eisenberg calls its inverse the “look to book” ratio) is high
    • highly profitable, if the margin is high

    When choosing your lowest hanging fruits, you’re looking for popular products with a high historical margin per view ratio. That’s the metric which combines conversion rate (sales per view), and margin.

    And that’s it. Sort descending by margin per view and by views, and pick popular products with a high margin per view, and go advertise them.

    Don’t know what the maximum CPC should be? You do know. It’s margin per view, which you may want to adjust a little to cover for the costs for running the business. That’s because the margin, i.e. the difference between the purchase price and the sales price, is not sheer profit.

    So take your monthly costs for running the business, take your total margin and try to compute an adjustment factor for margin/view, then use it as your maximum CPC.

    And if, through advertising and bidding a certain percentage of your margin per view you manage to attain the same conversion rate as your historical conversion rate, then your cost per acquisition -or CPA – should not exceed your profit per sale.

    Once you’ve launched your campaign, all you need to watch for is the cost per conversion, which should stay under the profit per sale. The initial, target cost per conversion, is (max CPC) / (historical conversion rate). If you manage to get clicks for less, or if you manage to convert better, through more precise targeting, then your CPA will be lower than the expected one.

    That’s it. No more analysis paralysis. No more “I think these products are profitable”. Your data knows which are profitable and which show potential.

    Furthermore, if you analyze the performance of your products from this angle, you’ll quickly discover which products are totally uninteresting, so you can maybe decide to get rid of the stock at a lower price and replace them with something else.

    Bonus: Don’t know which keywords to use when advertising those products you’ve just picked?

    Oh, but you do.

    Filter your product landing pages by the same regular expression as above (depending on your shopping cart solution), and add “Keywords” as the secondary dimension. Export that list and see which keywords are related to those products (which keywords were used in search by people who landed on those pages). Maybe use the keyword list splitter to separate more general keywords from the more targeted ones. The nice part about this technique is that if you’ve shown up in organic searches for that keyword, and got clicks, those keywords are relevant for that page. So the chances of seeing the dreaded “Keyword relevance: poor” in your keywords diagnostics are very, very low.


  • What keywords got me those search terms?

    Or, in other words, how broad is broad match?

    Any serious AdWords manager is watching the search terms attracted by her keywords religiously.

    And any serious AdWords manager has already been frustrated by the fact that he cannot see, in one table, side by side, the search term, the match type of the keyword, and the keyword which was triggered by it.

    Ok, it’s a known fact that you can go to your keywords tab, and select one keyword, and click on “See search terms”, so you can see only the search terms attracted by that particular keyword.

    But would you do it a hundred times a day? Click, “See search terms”, click, “See search terms”, click, oh, no, I’ve already clicked that before, back to square one …

    Disclaimer: the solution I’m going to provide only works for search terms which attracted at least one click.