412.343.3692
1.800.975.1844

Archive for the ‘WA Tools’ Category

Goal Copy Extension Update for FF3

Thursday, June 19th, 2008

Update to the Update:

Anders at IIH Copenhagen has modified the the Goal Copy extension to work with the alternate HTML that is being seen by some International Users (see comments).

You can get the alternate, international version from http://blog.iih.dk/goal-copy-extension-international/

Thanks Anders

——-

I have updated the Goal Copy extension for FF3 (I hope).

Let me know if there are any issues.

Update: Robbin pointed out the brief nature of this post and that many people would have no idea what I’m talking about. So for those who are going “what the heck is he talking about?”, the Goal Copy Firefox extension can be used to copy goals between profiles in Google Analytics. Take a look at my previous posts if you think this is something you might be interested in:

Goal Copy Extension Update

Copying Goals in Google Analytics (A Firefox Extension)

John

Know Your Tools

Wednesday, March 12th, 2008

When looking at your web analytics reports, it is important to know what you’re looking at. What may initially look like errors in the data, could just be the result of not understanding how the report or the individual metrics are defined. Consultants, who frequently work with multiple analytics packages, must be especially careful. Here’s a short example of what I mean:

A client came to me with 2 reports. One was the product SKU report for a particular SKU. The other report was that same report, but segmeted by source.

In the report that was segmented by source, all of the summary data was considerably higher than on the non-segmented report. The client didn’t know which one was correct — why was the data changing when he segmented the report? (And when you see two different sets of data you think should be the same, you wonder if either is correct.)Google Analytics Sidebar Navigation

 

 

 

Open up your own Google Analytics ecommerce report and follow along.

 

First go to the product SKU report by choosing Ecommerce -> Product Performance -> Product SKUs from the left sidebar menu in the reporting interface.

 

 

You’ll see a list of all SKUs that sold during your selected time period. Click on one to see a summary screen for just that SKU. It will look something like this:Product SKU Report - Single SKU

 

 

Now use the pulldown menu to segment by source. Most of you will see the summary numbers jump up, like my example here:

Single SKU - Segmented

 

In the example images, the Quantity went from 545 to 715, just from segmenting. And Product Revenue jumped from $14,385.33 to $19,585.61.

When Google Analytics displays the segmented report, it is pulling Quantity, Product Revenue, etc from the Transaction Level. That is, the Quantity is now the total number of items purchased in all transactions that included your selected SKU. Likewise Product Revenue is the total revenue for all transactions that included that SKU — not just the revenue generated by that product.

If you go straight to the segmented report, you might not even notice that the data is different, and you could be making decisions based on the wrong information.

It is not that the data presented is wrong, it’s not. But it may not be the data you are expecting, which can be just as bad.

Although my example is in Google Analytics, it’s important to consider regardless of your analytics package. Make sure you know how a report is defined and if you find something that doesn’t seem quite right, be careful of your assumptions and don’t always believe what the report tells you about itself.

 

-John

 

 

 

Copying Goals in Google Analytics (A Firefox Extension)

Monday, January 21st, 2008

Ever need 30 profiles, each with the same 4 goals? Me too. Unfortunately, Google Analytics doesn’t include an easy way to manage goals.

So, here’s the Firefox extension I created to speed up the process of copying goals. We’ll just call it “GoalCopy”.

What it doesGoal Form Fields

The Goal Copy extension records all of the values in a Google Analytics Goal Settings form. You can then navigate to another profile where you want to put that copied goal and paste all of those values into the new form. That way, you can get your goals from one profile to another without all the tedium.

When you install it, it will create a new toolbar with 4 sets of copy/paste buttons. Each set will copy and paste a different goal of your choice. The toolbar can be toggled on/off with View -> Toolbars -> GA GoalCopy

How to use it

1. After installation, navigate your Firefox browser to an existing Google Analytics Goal Settings form.

2. Click one of the four Copy Goal buttons on the Goal Copy toolbar.

GoalCopy Toolbar

3. The name of the Paste Goal button will change to show the name of the goal you copied. If the name of yourGoalCopy Paste Button goal was “Subscribe to Newsletter” then the Paste Goal button will display “Paste: Subscribe to Newsletter”

4. Go to another profile and navigate to a Goal Settings form page where you’d like to use your newly copied goal.

5. Click the Paste button to populate the new goal form with the values from copied goal.

6. Remember to scroll down and click “Save Changes” on the form.

That’s it. You now have your new profile ready to collect goal conversion data.

Notes

Buttons are grayed-out when not on a Goal Settings page.

There are 4 Slots to save goals in. Each set of Copy/Paste buttons uses its own slot.

Clicking Copy Goal again overwrites the previously saved goal for that slot.

Goals are saved persistently. Closing your browser does not erase your saved goals.

When clicking from a tab that is still Loading to a Goal Settings tab, the buttons will not re-enable properly from their grayed-out state – just click on a tab that is fully loaded (or blank) and then back to the Goal Settings tab to enable the buttons.

Requires Firefox 2.0.*

Thanks

Thanks to everyone who provided testing and feedback, including Jason Green here at LunaMetrics, Justin Cutroni at EpikOne, Shawn Purtell at ROI Revolution, and Mike Plummer at POP (sorry for not getting it out earlier that day, Mike).Install Dialog

Installation

Open this link in Firefox

Then click Install Now.

Depending on your setup, Firefox may want to download the file instead of installing it directly. Just select “Open With. . .” and choose Firefox from the list of applications.

Alternate Version

If you’re having problems with the toolbar being greyed-out on the ‘Edit Goals’ form page, try this version that never disables the toolbar buttons.

These changes have been incorporated into the latest version and are part of the goalcopy.xpi file.

-John Henson

How To Identify Query Parameters With Google Analytics

Thursday, December 13th, 2007

Tired of seeing “other” in your Top Content report? How about knowing how many times a page was viewed without having to wade through query parameters? If you’ve had enough of irrelevant query parameters making garbage of your Top Content report, read on!

When analyzing a website, it’s often helpful to view the core pages of the site
without being distracted by the query parameters. Identifying all of the parameters
also allows you to figure out which ones can be excluded. Thus reducing erroneous
pageviews.

Note: This post refers to Google Analytics, but the macro would work with any similarly-formatted
spreadsheet.

Why do I need a macro to identify the parameters? Why can’t I just use
a regular expression, \?, to find all pages in the Top Content report that contain
a question mark, and pull the parameters by hand?

If you have 10 or 20 pages with 4 or 5 parameters, this might be fine. However,
we’ve seen some sites with 80,000 unique pages that contain a question mark.
This would be a bit tedious to do by hand.

Step 1: Get the Macro

You can download the macro here as a .bas file. (findParameters.bas)

The macro has been tested in Office 2003 and 2007.

I would love to rewrite the details on how to install the macro, but Jeremy Aube
at ROI Revolution did such a great job, I’m compelled to point you there. (Instructions)

(Where he refers to Conversion.bas, replace that with
findParameters.bas)

This step is much more involved than I’m giving it credit for here. If you have trouble
installing the macro, leave me a comment and I’ll add more details to this post.

Step 2: Export your Data

2.1: Go to your Top Content report.

2.2: If you have this many, change the drop down box to show 500 rows.

(Yes. Unfortunately, GA only exports the data being viewed.)

2.3: Next, click Export, then CSV

2.4: Save the file, or Open it in Excel

Step 3: Prepare the Spreadsheet

- Basically, just get rid of everything but the URLs.

3.1: Delete all of the rows down to the headers above the list of URLs

- For a month of data, this should be around row 47.

- Select the rows above the headings, right-click, and select Delete.

3.2: Do the same for columns B through G (All columns after “A”)

When finished, your sheet should look something like this:

Step 4: Run the Macro

If you followed Jeremy’s instructions perfectly, you should have a button that you
can push to run the macro. Click that. *after reading the warnings below*

However, if you took a shortcut and just installed the macro, you’ll need to find
and run it manually:

- Press Alt+F8 to bring up your list of macros.

- Select “ExtractParameters”, and click “Run”

It will take about 1 minute to run.
When finished, you’ll have a new sheet named “Parameters” which will contain a list
of all unique parameters found.

Notes and Warnings:

  • The portion of the macro which eliminates duplicate parameters takes about 1
    minute to run. Your screen may flicker while this is happening. Don’t
    try to use Excel during this time, lest you wish to visit the task manager.
  • The macro will work with up to 500 urls (technically rows 1-505). If you have
    80,000, I recommend you create a new profile that excludes all the parameters identified
    here. Wait, and repeat after new data, and possibly more parameters, have
    been collected. It took me 3 rounds to get all parameters from this example.
  • There must only be 1 sheet in your workbook.

I look forward to everyones’ comments (and criticism). This is my first of
what I hope to be many more posts to the LunaMetrics blog.

- Jason Green

Designer KPIs

Sunday, April 29th, 2007

I’m hoping that a lot of readers will check out this post on the Benry blog — and comment on his blog. Benry (aka Scott) and I spent a while designing this KPI, in an effort to create a quick indicator of where to allocate scarce testing resources. We agreed that it wasn’t perfect, but that it was not bad at all. We’re both really looking forward to feedback from the WA community.

Bob Chatham answers my Visual Sciences post

Tuesday, January 16th, 2007


After the Emetrics Summit in October, I wrote this post about Visual Sciences. Soon afterwards, Bob Chatham (who was then the CMO of VS and is now SVP - Education for purchaser Web Side Story) wrote replies to all of my comments. And there they sat for almost three months, in my inbox. (I have no excuses other than work and family — but better late than never.) My comments from the original post are in italics and Bob’s should be indented:

Yesterday at the eMetrics Summit, I saw a one-hour demo of Visual Sciences. The “demo-er” was Bob Chatham, their CMO. It is incredibly awesome.

[BC] Thank you, I have to agree – it’s why I came to the company. It took me three or four demos just to believe that it’s real

.
I walked into the presentation knowing that the product is black and probably visual. I walked out trying to figure out why, beyond budget, companies would choose a different solution if they could choose Visual Sciences. (I did come up with some, see the bottom of this post.)

[BC] Don’t worry, there’s a white-background version for “executives.” We just picked black based on UI research that shows that it’w easier to stare at a black background for long periods.

Even budget shouldn’t be an issue with a properly-sized system considered over a 3-year period. The TCO [total cost of ownership] usually works in our favor given the capabilities and expansion headroom. But you have to be willing to look beyond the short-term 1-year CPM rates that most ASPs charge.

I won’t speak much to the implementation or technology. Among other reasons, you can’t easily put them in a box. They aren’t a client-side solution (you pretty much have to have software), but they sure aren’t an old-fashioned logfile solution either. Instead, I want to speak just to the features/benefits.

[BC] Actually, we *are* a client-side solution…and a server-side one…and a hybrid of both, if you want. I’m assuming that you’re talking about data collection methods here. We can use just JavaScript tags like any other ASP solution, or combine tags with logfiles or server-side collection based on Visual Sensor. If you’re speaking about deployment/ownership models, there’s a lot of latitude here as well. While the majority of our clients choose licensed software deployed behind their firewalls (about 2/3 of the customer base) the rest are either using our managed services (they own the software/hardware, we run/operate it on our premises or theirs), or an ASP-like setup where they effectively pay a CPM charge. There’s no political statement here about one being better than the other, just an ability to accommodate a client’s data collection and deployment requirements.


First, they have developed the capability (a “visual sensor”) to capture data from all sorts of sources, not just the web. RFID, bar codes, text files, call center logs all qualify. So it is no longer just a web analytic package, it becomes a total analytic solution. I don’t think they like the phrase 360 degree view, but if that isn’t a 360, what is?

[BC] It’s really a combination of Visual Sensor (for real-time event collection at the source, e.g., a web server) and Visual Load (for importing log files, campaign codes/costs, lookup tables, etc.) that builds the 360-degree view. The customer has to supply the common key across the sources so that we can join them (we don’t provide data scrubbing or matching services, but others, like Group One Software, Axciom, or Experian do).

They have a proprietary database — and maybe that term is already too “boxy” — maybe data storage or “place to keep their data” would be more accurate. This seems to be their primary secret sauce, and enables them to relate data in any way you want. (They call this n-dimensional.) They aren’t working with a traditional relational database, so the number of fields aren’t constrained and it is no longer incredibly expensive to have someone crawl into the database and expand the fields (in fact, there is no crawling in.) I kind of dismissed this as Bob spoke - it’s an expensive solution so even if you pay for an extra 10 eVars from Omniture, you probably pay less money - but then, you might need that info now, not when the LiveSupport people get to it. In some ways, it is easier to compare it to Google Analytics, where you get one custom variable and no more, but the customer sets are so different that that becomes a senseless comparison (albeit easy to understand.)

[BC] I’m not sure I understand the Google Analytics comparison. With VS, you can have as many “custom variables” as you want (since the schema is completely open and tailorable, they’re effectively all custom…). You get a standard “web analytics” schema for W3C logs out of the box for Visual Site. As for expensive…well, it’w probably more expensive not to be able to answer the questions that you need to answer…;-)

It is amazingly easy to create whatever report you want. We were five people watching them demo, and we couldn’t come up with a single request for a report that Bob Chatham couldn’t create from scratch within 5-10 seconds.

[BC] Hey…if you think 5-10 seconds is fast, you should see how fast web analytics guru Eric T. Peterson can do it. I’m just the marketing guy.

{note from Robbin - I deleted all the screen shot chatter that was in this spot because none of my screen shots were real jpegs and will be just awful in a post}

It’s real time. Almost all the other page tagging solutions are real time, but unlike VS don’t change while you watch unless you hit reload and wait 60 seconds.
So why doesn’t everybody buy it? First, it is really expensive.

[BC] Let me know if you want to review a TCO [total cost of ownership] model for the product. We’re working on better comparisons to conventional solutions.

I don’t know exactly how expensive but I have a pretty good idea. So it’s not a solution you buy lightly, and you sure don’t buy it without a full-time analyst or a team of analysts or you won’t learn much. Plus, if you don’t have time or resources to learn everything from your standard high-end solution (SC, HBX, WebTrends etc), then it’s really not worth spending the money. And let’s face it (this is my usual soapbox) - most people aren’t getting as much as they should out of their free Google Analytics. In fact, most sites either don’t have analytics, don’t know that they have analytics, or don’t care (but I digress…)

[BC] Agreed about the need for analysts with *any* high-end solution. As to why folks aren’t getting everything from their “standard” high-end solutions, maybe it’s because they’re…standard. And then they give up in frustration

.
Second, I think that the company would be smart to sell the product on its merits and not sell it against the competition so much. Maybe that’s just the IBMer in me (I was taught to NEVER mention the competition by name), but I think their product, in the right situation, solves so many problems that they don’s need to have a negative campaign.

[BC] Aw, I’m just overly sensitive. We spent four years in stealth mode building the product, ignoring what other people thought. If we mention other vendors, it’s really to facilitate comprehension based on what people are more familiar with. Any suggestions on how to make the product concepts more accessible/believable to reduce the time that it takes to get it?

Thanks Bob for all that wisdom. Apologies for waiting so long to post this (and if any little gibberish marks from the email crept in, double apologies!)

Robbin Steif
LunaMetrics

Absolutely blown away by Visual Sciences

Wednesday, October 18th, 2006

Yesterday at the eMetrics Summit, I saw a one-hour demo of Visual Sciences. The “demo-er” was Bob Chatham, their CMO. It is incredibly awesome.

I walked into the presentation knowing that the product is black and probably visual. I walked out trying to figure out why, beyond budget, companies would choose a different solution if they could choose Visual Sciences. (I did come up with some, see the bottom of this post.)

I won’t speak much to the implementation or technology. Among other reasons, you can’t easily put them in a box. They aren’t a client-side solution (you pretty much have to have software), but they sure aren’t an old-fashioned logfile solution either. Instead, I want to speak just to the features/benefits.

First, they have developed the capability (a “visual sensor”) to capture data from all sorts of sources, not just the web. RFID, bar codes, text files, call center logs all qualify. So it is no longer just a web analytic package, it becomes a total analytic solution. I don’t think they like the phrase 360 degree view, but if that isn’t a 360, what is?

They have a proprietary database — and maybe that term is already too “boxy” — maybe data storage or “place to keep their data” would be more accurate. This seems to be their primary secret sauce, and enables them to relate data in any way you want. (They call this n-dimensional.) They aren’t working with a traditional relational database, so the number of fields aren’t constrained and it is no longer incredibly expensive to have someone crawl into the database and expand the fields (in fact, there is no crawling in.) I kind of dismissed this as Bob spoke - it’s an expensive solution so even if you pay for an extra 10 eVars from Omniture, you probably pay less money - but then,you might need that info now, not when the LiveSupport people get to it. In some ways, it is easier to compare it to Google Analytics, where you get one custom variable and no more, but the customer sets are so different that that becomes a senseless comparison (albeit easy to understand.)

It is amazingly easy to create whatever report you want. We were five people watching them demo, and we couldn’t come up with a single request for a report that Bob Chatham couldn’t create from scratch within 5-10 seconds.

Did I remember to say that the visualizations are to die for? Here is one from their website:

This screen shot shows paths through the site. The height of a bar is traffic to a page and the thickness of a connection from one page to another shows how much traffic flows from page to page (I wonder how you tell what direction the traffic is flowing?) I know that this screen shot doesn’t do justice to the visualization but it was the best I could do - hope you can see the three-D connectors in “the air,” I can barely see them in my preview of this post.

It’s real time. Almost all the other page tagging solutions are real time, but unlike VS don’t change while you watch unless you hit reload and wait 60 seconds.

So why doesn’t everybody buy it? First, it is really expensive. I don’t know exactly how expensive but I have a pretty good idea. So it’s not a solution you buy lightly, and you sure don’t buy it without a full-time analyst or a team of analysts or you won’t learn much. Plus, if you don’t have time or resources to learn everything from your standard high-end solution (SC, HBX, WebTrends etc), then it’s really not worth spending the money. And let’s face it (this is my usual soapbox) - most people aren’t getting as much as they should out of their free Google Analtyics. In fact, most sites either don’t have analytics, don’t know that they have analytics, or don’t care (but I digress…)

Second, I think that the company would be smart to sell the product on its merits and not sell it against the competition so much. Maybe that’s just the IBMer in me (I was taught to NEVER mention the competition by name), but I think their product, in the right situation, solves so many problems that they don’t need to have a negative campaign.

Robbin Steif
LunaMetrics

The (Very) Unofficial Crazy Egg FAQs

Monday, October 9th, 2006

I got tired of waiting for Crazy Egg to have FAQs so I just wrote them myself. I put them together based on the many questions Hiten Shah from Crazy Egg has tirelessly answered for me, as well as my own perceptions. No one from Crazy Egg has seen this or blessed this, and any mistakes are mine (mine, mine, all mine.)

Q: How is Crazy Egg different from other overlays?
A: Other overlays show you where people click on links. Crazy Egg shows you where people click, even if they are clicking on a picture that doesn’t have a link associated with it. This is very helpful because it tells you where visitors expect to be able to click — where you should have links . Also, some overlays give the same amount of “credit” to two links on a page that go to the same place, and Crazy Egg only counts a click where it happened. Finally, Crazy Egg has not one but three different kinds of overlay reports.

Q: What are the differences between the three reports that Crazy Egg provides?
A: The Overlay (#1) displays your test page with buttons next to the places where people click. When the buttons are close to dark blue, you have few clicks, and when they are at the other end of the rainbow — the reddest — you are getting the most clicks. You can click on any Crazy Egg Overlay button to see how many actual clicks came to that spot. Alternatively, you can use the Flower Marker (the tab next to Overlay) to show you all the results associated with all the buttons. The List (#2) is just that — a list of the different kinds of clicks you get and how many of each there are. And the Heatmap (#3) shows you exactly where on a page people clicked (did they click in the middle of the picture? At the end of the link?) so you can see if links need to be longer or easier to reach.

Q: Can you describe the List better and explain what “Type” means?
A: Even though your most common type will probably be “A,” you won’t see B or C or D — when you see A on the list, it stands for an “a tag” like a href. (A link.) Drop down boxes usually have type Select. Free form large boxes usually have type Text Area, and free form one-line text areas have type Input. IMG is an image.

Q: Why does my dashboard say, 1324 views, 649 clicks, 589 shown? Why can’t Crazy Egg show all the clicks?
A: This means that there are clicks on the page that Crazy Egg is not identifying in the overlay. Many times it has to do with Flash elements, ads and even elements that are not on the page anymore. Javascript dropdown menus often have this problem.

Q: If someone clicks into a field and then enters a name with five characters and then hits the tab or enter button, how many clicks does Crazy Egg count — one, five, six or seven?
A: It is supposed to count that as only one click.

Q: What does it mean when Crazy Egg says that they can archive up to a certain number of snapshots?
A: The snapshots are pictures of a test when the test is finished, since Crazy Egg archives the way the test looked right when it ends.

Q: I thought that I knew how long I needed to run my test, but there weren’t enough visits so the data isn’t interesting enough yet. Can I extend the length of my test without starting a completely new test?
A: No, you can’t. Sorry. (Wouldn’t it be great if everyone’s FAQs were written this way, they actually answered a question like this without marketing doublespeak?)

Q: I can put the Crazy Egg code on four pages at no charge, right? And Crazy Egg will archive four tests at no charge, right? So does that mean that after I have ended one of my four free tests, I can start a fifth test, but I lose the archived snapshot of one of my first four tests? Or does that mean that my fifth test will not allow me to archive the final snapshot? Or does that mean that I am done with my free stuff and now I have to pay?
A: Wow, what a great question.

Q: I noticed that the code Crazy Egg gives me is always the same for my site, no matter which page it is on. Why can’t I add the code to an include file and let it run on every page? I would be happy to pay.
A: True, true. Read the editorial part of this post.

Robbin Steif
LunaMetrics

p.s. If you haven’t tried Crazy Egg, you are missing out on a great analytic tool.

CrazyEgg for web analytics: my 5 cents

Sunday, September 24th, 2006

I put CrazyEgg up on my site for a short period of time, mostly so that I could try it out before recommending it to a customer. And I loved it. First the explanation and then the editorial.

CrazyEgg is a website overlay on steroids, although they may be devastated to read that description (more below). Not only does it give you the standard overlay information that you can get from Clickmaps (or whatever overlay you have), but it also shows wherever people are clicking, even if that is not a link. For example, I saw this in my short test:


Notice how the words, “So now you have a website,” which are just a .gif, are more popular than the real links are.You can tell that at a glance because the overlay button is light blue, not dark blue — it is closer to red, and the redder the button, the more popular.

CrazyEgg makes this even more clear with the use of their heatmap. Notice how my “about us” link is my most popular one:


I always knew that About Us was my second most important page, but I never really “got it” quite as well as I did when I saw this heatmap. Pictures are worth thousands of words even for analysts, it appears.

Now that you see how cool it is, let me explain the issues.

The FAQs and other on-site Help on the CrazyEgg site don’t just suck - they are non-existent. Want to change the time period of your test? No idea how. Want to know what the classifications to all those clicks are? If you work with web stuff all the time, you’ll get it, otherwise you are lost. Want to know why they only show about 90% of the clicks that they report you have? No answers. Want to know what it means to archive four snapshots? Nope, no answers there either.

Furthermore, there is no way to add the code to an include so that you can just use it all the time, like you would an overlay. It would be the perfect solution for all those lost souls who are finally realizing that as great as GA is, the overlay is lousy, so they might as well pay $20/month for a great overlay.

I wrote CrazyEgg and asked why you have to tell them the name of every page you are adding your code to (and then still get the same code for each page). Hiten Shah (who was incredibly good about answering questions) wrote back very promptly three times and explained that they don’t want to be lumped in with all the WA and overlay providers. They are a testing solution, not a WA solution, he wrote. I think that’s just ridiculous (Sorry, Hiten). Scandanavian Airlines positions itself as a business airline, but they don’t make it hard for tourists to travel on them. CrazyEgg could easily position itself for testing and still allow people to use their services for day-in, day-out web analytic overlay work without compromising their marketing strategy.

Hiten tells me that he is a reader, so let’s see if he comments (and what he says.)

Robbin Steif
LunaMetrics

Auto-generate PowerPoint slides from Google Analytics

Sunday, June 18th, 2006

Post and software updated: November 24, 2006

Chris Harrington, who lives here in Pittsburgh, wrote a post on the Web Analytics Forum on Friday, directing everyone to his GA-to-PPT tool. He directed everyone to his site where all the details are, but if you just want to use the tool, here’s how you do it. (And, I know all the details because Chris user tested it with me on Friday afternoon.)

Before I start, understand what the tool does. It merely takes the information you already have in Google Analytics and formats it nicely into a PowerPoint slide. You could definitely do the same thing yourself with a cut and paste job, but if you are generating a lot of these, it’s pretty handy. Plus, it formats the information to fit on the slide perfectly.

The URL is http://www.activeinterface.com/pptatk/ga2ppt.hta . But before you click, you should know that it only works in IE. If your computer is set to a different browser default, you need to cut and paste the URL into IE. You always have to choose Run (not save) because your computer will want to open it in your non-IE browser. (Anyone is welcome to tell me what the workaround for this is, as long is it doesn’t involve changing browser preferences…) Also, you should know that it only works if you have MSXML 4.0 SP2 Parser and SDK.

Once you get past the IE and MSXML thing, you can Run the tool and you’ll get a window like this:

I’ve already filled in the first three fields but they’ll be blank, and you won’t yet have the report choices at the bottom of the screen. When I first looked at this, I didn’t really understand what he was looking for, but the date fields are just like the Google Analytics interface — you start by filling in the dates of the report you are interested in.

Next, you have to fill in the Site ID so that the tool knows which company you are tracking. Chris and I figured out that you don’t have to do any of that XML stuff to get the info — it merely wants the RID number that’s nestled inside each and every URL of your reports (and comes right after the question mark, like this: ?rid=123456&scid=something-else). Be sure to pick up just the six digit number and not the rid= or the scid information. Finally, choose a report area, marketing or content (Chris pointed out to me that he broke it down this way so that the user isn’t overwhelmed.) At that point, you’ll be able to select individual reports (which are identical to the ones you get in GA - remember, this is presentation, not analysis) and watch his magic.

Note: Chris and I worked together to update this software on November 24, 2006. As usual, Chris get the big applause and I was mostly nagging and testing. The updated version includes all the new reports that GA has rolled out in the past few months, like AdWords Analysis. In the newer version, the .ppt usually goes to your “My Documents” if you are a PC user (Mac users, please comment and tell us where it goes to.) The Excel version stays right on your desktop until you save it. Also, be patient when you see that black DOS screen come up — sometimes it takes as long as 60 seconds. If you’ve used this recently and not had success, be sure to clear your cache before trying again.

Every time I work with this, it is a great lesson not only in how to auto-generate GA slides but in the power of user testing.

Robbin Steif
LunaMetrics