By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    6 Min Read
    AI analytics
    AI-Based Analytics Are Changing the Future of Credit Cards
    6 Min Read
    data overload showing data analytics
    How Does Next-Gen SIEM Prevent Data Overload For Security Analysts?
    8 Min Read
    hire a marketing agency with a background in data analytics
    5 Reasons to Hire a Marketing Agency that Knows Data Analytics
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Measuring Conversion Rate: Are you making an Impact?
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Visualization > Measuring Conversion Rate: Are you making an Impact?
AnalyticsBusiness IntelligenceData VisualizationWeb Analytics

Measuring Conversion Rate: Are you making an Impact?

Tricia Aanderud
Last updated: 2012/02/09 at 1:57 PM
Tricia Aanderud
7 Min Read
SHARE

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 charts 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.  

Contents
Is Your Website Working for You?Measuring Conversion RateUsing SAS BI DashboardCreating the Indicator DataAdding a RangeComparing the Conversion Rate Indicators

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 charts 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. Seuss) to your data using the SAS BI Dashboard. [More Google Analytics and SAS BI Dashboard articles]

More Read

ai low code frameworks

AI Can Help Accelerate Development with Low-Code Frameworks

Data Analytics Helps Marketers Make the Most of Instagram Stories
What to Know Before Recruiting an Analyst to Handle Company Data
Tackling Bias in AI Translation: A Data Perspective
How AI is Boosting the Customer Support Game

Is Your Website Working for You?

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 links 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 for them.

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.

This helps you see how the different activities can have an impact on your conversion rate.

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 anything – 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.

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 Conversion Rate Indicators

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.

Conversion Rate Indicators in SAS BI Dashboard

  • 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.
Which one do you think is better or worse? Leave me a comment.

Building Business Intelligence with SAS was released last week, why don’t you check it out!  Yours truly, Pushy Sales Lady

 

    Tricia Aanderud February 9, 2012
    Share This Article
    Facebook Twitter Pinterest LinkedIn
    Share

    Follow us on Facebook

    Latest News

    ai low code frameworks
    AI Can Help Accelerate Development with Low-Code Frameworks
    Artificial Intelligence
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    Analytics
    data breaches
    How Hospital Security Breaches Devastate Local Communities
    Policy and Governance
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    Analytics

    Stay Connected

    1.2k Followers Like
    33.7k Followers Follow
    222 Followers Pin

    You Might also Like

    ai low code frameworks
    Artificial Intelligence

    AI Can Help Accelerate Development with Low-Code Frameworks

    12 Min Read
    data Analytics instagram stories
    Analytics

    Data Analytics Helps Marketers Make the Most of Instagram Stories

    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    Analytics

    What to Know Before Recruiting an Analyst to Handle Company Data

    6 Min Read
    data perspective
    Big Data

    Tackling Bias in AI Translation: A Data Perspective

    9 Min Read

    SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

    ai in ecommerce
    Artificial Intelligence for eCommerce: A Closer Look
    Artificial Intelligence
    data-driven web design
    5 Great Tips for Using Data Analytics for Website UX
    Big Data

    Quick Link

    • About
    • Contact
    • Privacy
    Follow US
    © 2008-23 SmartData Collective. All Rights Reserved.
    Go to mobile version
    Welcome Back!

    Sign in to your account

    Lost your password?