Green lamps and empty Excel files?

Posted by ShowMaster in FAQ & Help, Januar 5th, 2009

Hello everybody – and a happy new year! :-)   From time to time I’m going to post some user questions (and my answers) to help you avoiding some common  stumbling blocks…

Question: “Currently I cannot modify my keywords or ads with your Excel file, because the link generator Excel file that I download from my
control panel in the zanox site is EMPTY. This campaign has a green status on your zanox landpage site.
I am attaching a copy. This file used to be filled with all my campaign data a few days ago. Do you know how to solve this problem ?”

Answer: Everything is fine! Tool is set up correctly. If the campaign status is “green” (you see a green lamp), then there have to be no keywords or adtexts within your Excel file!

Why? Only keywords and texts with MISSING landingpage tracking links are shown in the Excel file.

Remember: LPO is NOT a campaign management tool! We only add tracking links to your campaigns. Do changes (new keywords or texts etc.) where you are used to do it: Using the AdWords Editor or the AdWords Interface directly. Once you have uploaded all changes, THEN use the “refresh campaign” button in the Look@Landingpages Interface and the Excel file will contain all changed elements with missing tracking links…

AddThis Social Bookmark Button
Read more! »

Tutorial: How to handle Search Trends?

Posted by ShowMaster in Optimization, Dezember 1st, 2008

How to react on search trends on holidays and other significant events? What are the right bidding strategies for Adwords?

(This tutorial was translated from the German version, here.)

Many occasions that are moving the „offline-world” have also direct impact on search engine marketing. On Christmas days people search for presents, on Mother’s day for flowers and on soccer championship for soccer shirts. At these times the search volume for certain keywords increases alike competition for them. Most events recur on a regular basis and thus becoming applicable for SEM planning. “Flower delivery on mother’s day” provides a good example for showing how to use Search Trends in a beneficial way.

Search Trends: Search volume fort the keyword “Blumenversand” (engl. flower delivery)

Source: Google Trends. Time period: 2004 – 2008.

This example depicts the average search volume for the keyword “Blumenversand” (engl. flower delivery) during the last years. How you can easily see two search trends are coming back every year. At the beginning of February and May due to two holidays the search volume tenfolds for a short period.

Search Trends: „Valentinstag“ (engl. Valentine’s day) and “Muttertag” (engl. mother’s day) 2007.

Source: Google Trends. Time period: 2007

Every year on Valentine’s and Mother’s Day the demand for flowers leaps upwards with a certainty as sure as death and taxes. Let´s have a closer look on how users search on Mother’s Day (11th of May).

Search Trend: „Muttertag“ (engl. Mother’s Day) in May 2008.

Source: Google Trends / Look@Landingpages. Time period: May 2008.

The green line depicts the daily search volume within Germany. The blue bar shows the AdWords spending while the grey one indicates the corresponding earnings; that is either orders, leads or transactions. Ok, let’s make clear what is it all about. In the following diagram I highlighted the days on witch I made either winnings (yellow) or losses (red).

Search Trend: „Muttertag“ in May 2008, winnings and losses.

Source: Google Trends / Look@Landingpages. Time period: May 2008.

We can make the following observations:

- The search volume starts growing approximately one week before the actual holiday takes place.

- The search volume doesn’t reach its peak on Mother’s Day itself, but four days in advance (in this case 7th of May)!

- On Mother’s Day the search volume is not significantly higher than on usual days in the year.

- Click through rate and conversion rate grow in conjunction with the search volume, but also collapse altogether (Peak also 7th of May).

Question: What is to be he right CPC bidding strategy on AdWords?

In my opinion we can derive from our previous observations four stages for which we can apply four distinctive bidding strategies. In doing so the most important thing is not skip one the phases and to manage your SEM campaign in an anticipating way. Furthermore you should keep track of you campaign on a daily basis. This is definitively the most certain way to make sure that you maximize your profits!

First thing to do: Identifying the four Search Trend stages.

Source: Google Trends / Look@Landingpages. Time period: Mai 2008.

1. Stage: search volume starts to grow slightly; raise CPC biddings reasonably!

The search volume is going to step up a few days in advance of the actual hype. In case of Mother’s day the first stage starts approximately two weeks before the holyday takes place. At the same time the competition is also going to raise its biddings. You can figure that from your declining average ad positions, without having reduced biddings yourself.

I recommend going along with the competition. But only that much you need to hold your previous position.

2. Stage: Search volume skyrockets; raise CPC biddings to the breaking point!

Now we have reached the most delicate stage. Here you should choose a step-by-step approach and raise your biddings in conjunction with the search volume. Now you should also consider bidding on keywords which usually won’t pay off. The sense in doing so is that since Mother’s Day (for instance) is such an important event (at least around here ;-) where nearly everybody buys flowers, CTR and CR will also perform much better than usually. In order to avoid losses you need to keep a daily check on your campaign keywords. In case certain keywords don’t perform, that is click costs are higher than estimated transaction provision: Do not hesitate a second to cut down your biddings!

Even more important is to determine the moment when the search volume will have passed its peak and the next stage begins! As rule of thumb we can keep mind that:

Rule: The very last day of stage 2, is the last day on which you can order the advertised products while still being delivered in the nick of time.

If we take our example we know that we have to order our flowers two days before Mother’s Day takes place if we want mommy to have them on time. This time period might vary among industries and products, but the point is that you make sure you will never going to miss it. Why? I’m going to tell you in stage 3.

By the way: The end of stage 3 is not necessarily the day with the highest search volume!

Keep an eye on your average ad position every day. For you will get a feeling for prices and competition. In order to stay at the top ranks I bid for instance up to 80ct for the keyword “Blumenversand” (engl. flower delivery), obviously the most important one if you are about to get a slice of the cake.

3. Stage: Search volume declines slowly; nevertheless cut all your biddings immediately!


Now it is all about paying the profit into the bank! The problem with stage 3 is that shortly before the event takes place most products can’t be delivered on time. That is why users search and click like mad, but don’t make orders anymore. As a result all of a sudden the conversion rate slumps down. The search volume is declining, remains on a high level though. So if you don’t pay proper attention there is good chance that you loose a lot of money.

In my example you can see, that I should have paid more attention. Even though I cut down my biddings on a large scale (just above usual level) it just wasn’t enough and in consequence I paid dearly.

My advice for stage 3: Do yourself a favour and reduce your biddings even lower than the regular level! For instance if you bid on usual days 20ct per click you should only go for 10 to 15ct in stage 3! Don’t be greedy and act decidedly in order not to gamble away your budget.

4. Stage: Normality comes back; set biddings on regular level.

Wait until the very end of the search trend. When the show is over, return your CPC biddings to the regular keyword level. Now your SEM campaign should return to balance again.

Handling other Search Trends and Seasons

Besides holydays like Valentine’s and Mother’s Day there are more interesting Search Trends. I’m trying to give you a brief list of the most important ones. Please add your ideas if you have something in mind I might have forgotten.

Holydays (short term trends): Valentine’s Day, Mother’s Day, Father’s Day, Christmas, New Years Eve.

Events (mid term trends): Most importantly sports events like football world cup or the Olympic Games. Also fashion trends or events alike occurring in the world may provide good opportunities for online marketing.

Seasons (long term trends): singles, vacations, garden time in spring, summer and beach fashion, barbecue and summer sports equipment, winter fashion and Christmas presents in winter.

Hot offers: New products, upcoming releases and trendy stuff should also be considered! For example, in Germany there’s a big campaign called “VolksDSL“, started by a hugh newspaper. Its a very good product, nice incentives for the customer especially before xmas. You should identify these trends early in order to participate. So have a look at newspapers and TV shows, too! Remember Starsearch, Popstars, Next Topmodel and so on? :-)

For any of these Search Trends our 4 stage scheme applies. For seasons the single stages take some more time, but for the bidding strategy the basic principle stays the same. Regardless whether running search engine marketing as an affiliate, agency, or in-house.

To find out more about hot trends or search trends in general, have a look at “Insights for Search“.

Have your say! What’s your opinion? Do you have other or even better approaches for bidding strategies?

AddThis Social Bookmark Button
Read more! »

New LPO release, out now!

Posted by ShowMaster in Release History, November 25th, 2008

Some of you will have noticed it: Last week we released a new version of Landing Page Optimisation (aka. Look@Landingpages). We fixed some minor bugs (layout issues and internationalisation stuff) and added a nice, little feature: The statistics are downloadable now:

Just configure a type of report, set filters as you like and “create” the statistics. Following the principle “what you see is what you get”, you may choose to display the selected report on screen or in a file. Its exactly the same data format.

This CSV download replaces the “raw data” download funcionality, witch is no longer available. Use it to store, document or share your performance values…

AddThis Social Bookmark Button
Read more! »

Search is back!

Posted by ShowMaster in News, November 24th, 2008

Hey guys. My last blog entry is quite some time ago. I had to work on another project parallel to our search tracking solution. So the blog faded out of my mind and was buried under a gigantic to-do pile…

But: Search is back in the house! :-)

I’m happy having time again to go on blogging about keyword tracking with AdWords and zanox. I hope to get all of you some inspiration about niches, clean and good working business models in the search area and of course news about our landingpage optimization tool, formerly known as Look@Landingpages.

Stay tuned!

AddThis Social Bookmark Button
Read more! »

ShowCase: Again higher SEM profits in June!

Posted by ShowMaster in ShowCase, Juli 7th, 2008

Another month passed by and our SEM showcase rocked again: We are still making some gooood money! :-) Have a look a last month’s performance:


Every month my little affiliate page makes more money and becomes more profitable. This is not a self runner! Its some work involved, not too much, but you have to spend some time on it. You have to check the performance and optimize bids constantly, at least once a week. I would do it every single day if more money was involved. But after some rounds of optimization the campaign is very stable now and I can let it run for a while without shivering or panic. :-)

Since I started posting about this showcase I experienced growing competition in this sector! I think we – let’s call it “inspired” – some affiliates to try a little flower page themselves in the hard online flower delivering industry, hehe.

Unfortunately most of these guys do NOT use any kind of keyword tracking. Why is that? Let me give you a hint: I think its almost impossible to do profitable SEM without keyword tracking, especially in areas with high competition like this. So people: Try your flower pages if you like, but please do yourself a favor and use keyword tracking! :-)

To be honest with you: I never expected to make good money with this showcase anyway, due to high competition from advertiser’s SEM agencies. But we are above 30% return on investment – constantly!

Now you give it a try: Build good landingpages and conquer your niches!

AddThis Social Bookmark Button
Read more! »

New Look@Landingpages Release out!

Posted by ShowMaster in Release History, Juli 6th, 2008

Last week we released a new version of Look@Landingpages. That means we are only some short steps away from the final release, our official version 1.0 of Look@Landingpages! But for today I’m gonna tell you about changes in the current release. We fixed some smaller bugs and implemented two new key features:

  • Support for international char-sets. The Excel LinkGenerator supports all char-sets now, so you can track international AdWords campaigns also in languages like Russian, Chinese, Polish, etc.

  • More color in online statistics. We colorized the columns showing profits in our browser statistics. If an item (i.e. a campaign, adgroup, keyword or day) is profitable we show it in green, if it looses money we mark it red. This improves the presentation of the selected data.

Enjoy using the new version and please give us feedback on how things are going!

AddThis Social Bookmark Button
Read more! »

Review: (S)EM Event in Munich.

Posted by ShowMaster in News, Juli 3rd, 2008

On June 18th, we invited a hand-selected number of well known German publishers in search engine advertising to our (S)EM Event to Munich`s Café Reitschule to discuss relevant topics about adwords and Co. and enjoy the European football Championship together.
As we always like to include a wide range of viewpoints we got external support from the usability specialist: Prof. Dr. Miriam Yom, eResult GmbH and the well known SEM Blogger: Lennart Paulsen.

Of course our Look@Landingpage tool was on the agenda as well. The open discussion gives us the opportunity to focus further developments for the tool. So please make notice of new, interesting features!

You find some nice pictures of our SEM event at Flickr!

Besides: There are still some (S)EM-Master shirts available! Go get them!

AddThis Social Bookmark Button
Read more! »

How to optimize AdWords campaigns with Look@Landingpages?

Posted by ShowMaster in Optimization, Juli 1st, 2008

Read this tutorial to see how easy it is to increase your AdWords profits step by step with Look@Landingpages!

1. Preparation

  • Keyword research, I do it mainly with Google’s Keyword-Tool.

  • Stay close to the topic of your advertisers products; don’t use keywords that are too generic.

  • Give your campaign a very fine structure. Take only a few keywords per adgroup.

  • Always book keywords in all three matching types!

  • At the beginning, set bids only on adgroups and never on single keywords!

  • Use seperate campaigns for Google search and for Google’s content network.

2. Collecting Data.

  • Set up landing page tracking correctly.:-)

  • Now run your Adwords campaigns for some days. Make shure you collect enough clicks and performance data before you start setting new bids for adgroups and keywords. You need a sufficient data base to start optimizing cpc bids.

3. Identify best and worst performing keywords!




  • Open up LPT online statistics and create a performance report per keyword.

  • Sort the keywords according to profit.

  • Open up AdWords-Interface to set new bids.

  • Bid-down all keywords, that…

    • have a lot of clicks but no transactions.

    • have a negative cost-value ratio, that is all keywords wich generate less transaction provision necessary to cover the bidding costs.





  • Raise bids for keywords that…

    • Have a lot of traffic, many transactions and a good cost recovery.

    • In doing so pay regard to the average position of the ad. If the ad is already at a top position (No. 1-2) further action won´t have much effect.





  • Advice: For mere content campaigns you don´t need to bid on keywords; point 3 does not apply.

4. Evaluate ad-groups separately!




  • Open online statistics and generate a report for ad groups.

  • Open adwords-interface and go to the ad group level.

  • Now sort both windows according to the same criterion ”ad group name”.

  • Make a separate bid for every ad group in the same way like for single keywords.

5. Optimize constantly!


  • Let the campaign work for a few days and gather performance data.

  • Use the data and repeat step 3 and 4 constantly until the campaign works profitable and all mavericks are under control.

6. Extend your campaigns!


  • Add new ad groups to your campaign

  • Take keywords into account which doesn´t seem applicable at first sight.

  • Try more generic keywords.

  • Constantly repeat steps 1 to 5!

AddThis Social Bookmark Button
Read more! »

(S)EM Masters – get your FREE soccer shirts!

Posted by ShowMaster in News, Juni 27th, 2008

You all will know it. Its not a surprise. Especially not for Germans, but:

GERMANY PLAYS IN VIENNA SOCCER FINALS! :-)

Last week we had a small SEM event with some of our publishers and got some nice, white soccer trikots printed. Slogan (German): “(S)EM Meister 2008”!

We have some nice shirts left and wanna give them to YOU! But nothing is completely for free, hehe, so we have a little CONTEST for everybody who wants to have a zanox soccer shirt. Here is what you have to do:

  • The topic is: zanox, EuroCup, afiliates and most important: SEM.

  • The task is to create a short, funny video or photo greeting, so be creative.

  • Load them up to Youtube or Flickr, tag them with the keywords given above and post the link in a comment to this page, so we can keep up with all participants. Don’t forget to add your name or account name.

  • The first ones and the best ones will win the shirts (one per person only)! But remember: Time is short, the finals are on Sunday. Last day of the contest is therefore Sunday the 29th of June.

Here you see our marketing fairy Alexandra wearing one of the shirts:


(she’s wearing a belt on top of the shirt, its not a waisted trikot, hehe)

So good luck and be fast! Greetz, Denis.

UPDATE: Since we played the worst match ever, I realy can’t see these shirts any more! So please: TAKE THEM AWAY! Just write a comment to let me know your email …

AddThis Social Bookmark Button
Read more! »

ShowCase: Performance May, a run for Mother’s Day!

Posted by ShowMaster in ShowCase, Juni 13th, 2008

May was definitely the best month for our showcase so far! This was no big surprise, since the week before Mother’s Day is the most important business time for flower deliverers. Lets have a look at the numbers first:


This month the overall search volume for keywords like “flowers, flower delivery, etc” was extraordinary high. Due to Mother’s Day we tripled the turnover of our little showcase and doubled the profit! I added another pic showing the run for Mother’s Day on a daily base:


Mother’s Day was on May, 11th this year. The whole week before was amazing. Ad impressions were almost 10 times higher than a week before and afterwards. Also the conversion rates were higher during this period: Everybody was mad about sending flowers around the globe! :-) But also the competition raise during this period. I had to go up to 80 Euro-Cents per click only to mantain the average position of my ads.

I made a little mistake at the end of the hype: The two days before Mother’s Day I lost some money, cause the search volume was still very high, but conversion rates were going down dramatically. Explanation: People want to get the flowers delivered just in time on Mother’s Day – but this is only possible if they order two days before! Otherwise the flowers come one or two days later. Nobody wants that. So  people go on looking out for flower shops that do deliver in time, they find any and go on searching. I knew about it, and reduced bids by 30 %. This was way too less! I should have reduced bids by 60 to 80 % for these two days in order to stay profitable…

Find out more about trends and bidding strategies in our next posts. Stay tuned! 

AddThis Social Bookmark Button
Read more! »