BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools

SAS BI Dashboard: Measuring the Conversion Rate with Google Analytics

Submitted by on 2012-02-08 – 9:14 AM

Once you start looking at your Google Analytics, it is thrilling to see that visitors are coming to your humble Web site and some even return. Your first inclination is to create fancy dashboards to show the traffic patterns, compare the patterns by day of week, segment into New and Returning visitors, soon your charts may even be trending on #StuffDataGeeksDo.  

In the past few weeks I have been leaning on you to adding more VA-Voom!!! (in the words of Dr. Suess) to your data using the SAS BI Dashboard. [More Google Analytics and SAS BI Dashboard articles]

Why Have a Website?

When I started this blog, the main purpose was to ensure SAS BI users were aware of my book, see my writing style, and determine if I knew enough to have written a reliable book. To this end, I had to measure was how many people followed the More Book Info link I had prepared. As a introverted data geek, this was a hard for me because I did not want to be the in-your-face, buy-this-now pushy sales lady! What I wanted was for SAS BI users to know that Angela and I had created an awesome resource that would really expand their skillset and answer the many questions we knew they were asking.

In the following figure [click on image to see a larger version], you can see the different methods I tried along with the success rate. Appears that Method 2 worked the best; however attracting more visitors to the site also had an impact. Some notes – when I started Method 2, I kept the sidebar ad. When I started Method 3, I stopped adding the Ask for the Sale line at the end of the posts but did not remove them from older posts, which still got many hits. My conclusion: a combination of all methods provided the best result.

Note: Week 45 Angela and I both attended meetings where we talked about the book – so some web traffic does come from real life. Who knew?

Measuring Conversion Rate with Web Report Studio

Measuring Conversion Rate

I like the method Avinash Kaushik proposed for conversion rate at his Occam’s Razor site. Here is the gist of it, of all the unique visitors to the site, how many clicked the link for more information. Some will argue to use pageviews – but I cannot tell a pageview about the book – only a person. You could probably argue the other side successfully.  So just be consistent with whatever method you use.

 

Conversion Rate Formula in SAS BI Dashboard

Using SAS BI Dashboard

When you add Google Analytics measurements to your SAS BI dashboard, you can select from a variety of indicators to display your data. It gets confusing very quickly and if you spend anytime reading about dashboard design, there are many opinions about what works and does not work. From my prespective, it all depends on your situation. What fails miserably on one dashboard, rocks another one. Today I wanted to show you some of the different indicators with the same basic information and let you decide what works.

Creating the Indicator Data

Using a SQL Query as the Indicator data, here’s how I created the data table. Visitor Type is a category and the other ones are measurements. For the dashboard, this data is extracted nightly so I used INTNX funciton in the WHERE statement to indicate I wanted the data from the day before.

Tip! Try your SQL query in SAS Enterprise Guide first. The SAS BI Dashboard does not show the log and may provide a cryptic message if you make a mistake.

SQL Query in SAS BI Dashboard

Adding a Range

The goal was anything above 5% was considered green and anything below was a massive failure (red). Here is how I setup the range.

Conversion Rate Range in SAS BI Dashboard

Comparing the Indicators

Conversion Rate Indicators in SAS BI Dashboard

First – this is not about a right or wrong way to present data; rather it is about effective and ineffective ways to present data. If your presentation is effective, the user quickly understands the message. In past posts I’ve preached about chart design so let’s just look at the examples.

  • KPI Gauges (1 & 2) – There’s little difference in the information presented in these gauges. This may just be a matter of preference. This method probably is more effective when there are limited gauges on the page. If every other image is a gauge, it’s probably confusing. I would want the gauge to be linked to another dashboard or Web Report Studio report with more trending information. 
     
  • My own experience is when I am looking at the information daily, then I know what the rates were in the past 7 days so trending isn’t a chief concern.
  • Bar Chart with Reference Lines (3) – When I look at this indicator, I instantly see the yellow bar was really way off target and the green bar really exceeded expectations.

    I don’t see the overall numbers – just the conversion counts. Is that important to the user?  Does it make it more or less effective?

  • Waterfall (4) – This chart contains the total count of visitors and then has them segmented by visitor type. It’s effective because you get an idea of overall visitors to the site, but frankly I have to stop and think about this indicator everytime I use it. I would not choose this indicator for this particular data.
I’d love to know which one you think is better or worse – leave me some comments.

 

Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.

Tags: , ,