Pages

Friday, July 25, 2014

Assessment Answers – Ecommerce Analytics: From Data to Decisions

The Ecommerce Analytics: From Data to Decisions Google Analytics course is open now. You can register for the same on Google Analytics Academy website. The course contains everything you need to understand and make better use of Google Analytics for any Ecommerce business. Go ahead and register for this course.
This course is as very much informative and well-thought out. The course is divided into 3 units, after completing every unit there is an assessment to test your knowledge and completing all assessments will earn you an online certificate.
I have posted answers to all assessments below but refer to them only when you are really stuck on a particular question. The assessment can be attempted many times and there is no time restriction as well. You should pursue the course for learning not just for a certificate.
Correct answers are marked bold.
Unit 1 Assessment answers
1.     You should always use the same dashboard to monitor your site’s performance, regardless of your business objectives and job role.
§  True
§  False
2.     Google Analytics allows you to copy and customize built-in segments or create your own customized segments for analysis.
§  True
§  False
3.     Sequence segments allow you to:
§  analyze a subset of sessions with a specific sequence of pageviews
§  analyze a subset of sessions with a specific sequence of pageviews and event interactions
§  analyze a subset of users with a specific sequence of pageviews and event interactions
§  analyze a subset of users with a specific sequence of traffic sources that bring them to your site across multiple sessions
4.     Given the data in the following report, which audience segment appears to be the most engaged based on bounce rate, time on site and pages per session?
§  the Referral Traffic segment
§  the Search Traffic segment
§  the Direct Traffic segment
§  All of the above segments appear to be equally engaged
5.     The Great Outdoors’ Marketing Director would like to create a segment that includes all users who have seen the summer promotion landing page during any session. Which of the following settings in the segment set-up would he have to change to create the correct segment?
§  change the filter setting from “Sessions” to “Users”
§  change the filter setting from “Include” to “Exclude”
§  change the dimension setting from “Landing Page” to “Page Title”
§  change the rule from “exactly matches” to “does not match”
Unit 2 Assessment answers
1.     Which of the following actions would you consider if you discovered one of your site’s paid traffic sources had a low ecommerce conversion rate?
§  Stop investing in the source immediately.
§  Start investing more in the source immediately.
§  Investigate whether the traffic source contributes towards other site goals besides ecommerce conversions.
§  Investigate whether the source has value in assisting conversions by using the Multi-Channel Funnels reports.
2.     Given the data in the following report, which two channels would benefit the most from coordinated marketing messaging because of their audience overlap?
§  Paid Search & Social Network
§  Paid Search & Display
§  Email & Display
§  Display & Social Network
3.     Given the data in the following report, which channel is the best at assisting ecommerce conversions relative to the number of last or direct click conversions it drove?
§  Direct
§  Referral
§  Organic Search
§  Email
§  Social Network
4.     Given the data in the following report, which channel seems to be missing out on the most conversion credit when using the Last Click Interaction model versus the First Interaction or Linear conversion models?
§  Direct
§  Email
§  Referral
§  Organic Search
§  Social Network
5.     Given the data in the following report, how would you adjust your advertising targeting to try reaching users who are more likely to convert?
§  Use demographic targeting to reach female users
§  Adjust demographic targeting bids higher for the 25-34 age range
§  Use remarketing to customize ad messaging for new users versus returning users
Unit 3 Assessment answers
1.     In order to use the Enhanced Ecommerce reports, like the Product List Performance report and the Shopping Behavior Analysis report, you need to:
§  open a new Google Analytics account
§  have your developer implement Universal Analytics (analytics.js) on your site
§  have your developer use the ec.js plugin to tag your site
§  turn on Enhanced Ecommerce for your report views
2.     The Product List Performance report provides a list of products that you should stop selling on your site.
§  True
§  False
3.     Given the data in the following Product List Performance report, which product list and list position is the most efficient at driving product views for The Great Outdoors?
§  Position 1 on the Homepage Promo list
§  Position 1 on the Similar Products list
§  Position 3 on the Homepage Promo list
§  Position 3 on the Similar Products list
4.     Given the data in the following Product Performance report which product would you check first for issues with the product details page?
§  22 oz. Mini Mountain Bottle
§  Travel Journal
§  Organic Basic T-Shirt
§  Men’s Heather T-Shirt
5.     Given the data in the following Checkout Behavior Analysis report, which step in the checkout process would be the best candidate for optimization based on it’s drop-off rate?
§  Billing
§  Shipping
§  Payment
§  Review


Thank you for your time to read this post and please go ahead and complete this fantastic course.

Thursday, July 3, 2014

How to Get Free Google Voice Account for India and Any country in the world

Google voice is one free service from Google which will let you make free voice call in U.S.A. This service is currently available only in U.S.A. In this tutorial I will be sharing how you can get Google Voice account and number if you are in any other country including India.
To get started with first you need a U.S.A based incoming number to verify your Google voice account. To get a Free U.S.A based Incoming number, read my previous tutorial on How to get Free U.S.A. based incoming phone number.
Getting started with Google Voice Account:
If you will try to open Google Voice website from any other country apart from U.S.A you will  be prompted with message that Google Voice is not available in your country. To get rid of this issue, you need to use a U.S based proxy. You can either take help of any of  these free VPN service ( Do check which VPN service offer U.S based IP) or you can use proxy software like HotSopt hotshield and Ultrasurf.
In this tutorial I used combo of HotSpot hotshield and Ultrasurf. <Download Hotshied> <Download Ultra surf>
Install Ultrasurf and Hotshield. Start Hotshield and after that Ultrasurf.
Google Voice Account:
Now you are on a U.S based proxy site and you can access Google Voice website. <Link>. Now use your Gmail account to login to your Google voice account and follow the  steps mentioned to get a Google Voice account for yourself.
Select Google Voice Number:
First step is to select a Google voice number for yourself, which you can do by adding a word or your desired number. Follow screenshots:
google-voice-numberharsh
Set Pin number for Google Voice account:
Next step is to set a PIN for your voice account so that you can use voicemail feature of Google Voice account.
google-voice-pin-number
Add a forwarding phone:
In this step you need to add your incoming U.S mobile number which we already got using my previous tutorial. That number will also be used to verify your Google voice account, so make sure you enter the number which you have and keep your softphone open, as you will be receiving a call on your phone to verify.
us-phone-number
Verify your Phone:
Now on the next screen you will see a code and link to call on your phone. Click on the link and you will be receiving a phone on your softphone. You need to type that code after accepting the code and instantly your Google voice account will be activated.
10-4-2010 8-54-35 PMincomin-call
verified

hat’s it and now you can make free phone call to U.S.A and receive call from U.S.A for free using your Google voice account.
If you have any questions, feel free to ask in comment form and if you like this tutorial, don’t forget to stumble and share it on Facebook with your friends.

How to Get Permanent U.S. Based Incoming Number for Free

Google voice is not available in every part of the world and I have been trying to get Google voice account for me in my country (India) and one thing which I need the first is a U.S based number. One way which can help me is I can ask any of my friend in U.S. to use his number to register a Google Voice account for me else second way is take help of online tool to get a U.S. based phone number for free.
In this tutorial I will be sharing how you can use online websites to get a free U.S phone number for yourself.
1) Sign up for Tpad:
After signing up for Tpad, you will be getting a SIP number which is require to login to Tpad. FYI, signing up for Tpad is free
tpad
2) Login to Tpad:
Now login to your Tpad user account by using Tpad number you received in Email and password you specified while signing up.
Tpad-login
3) Download softPhone and configure it.
Now download software from this link and install and configure it. To configure Softphone, you can use this tutorial.
softphone
Sign up for IPkall
ipkall
Next step is to sign up for IPkall. While signing up for IPkall, you need your SIP phone no, which will be your Tpad username and SIP proxy would be sipx.tpad.com.
Once you sign up is done, within couple of minutes you will receive an Email with your U.S based no.
US-Phone-No


Wednesday, July 2, 2014

Calling a Web Service from a SQL Integration Services package

Introduction

The SSIS framework provides a Web Service task which executes a Web Service method. You can use the Web Service task for the following purposes:
  • Writing to a variable the values that a Web Service method returns.
  • Writing to a file the values that a Web Service method returns.
Image1.jpg
This article defines a step by step approach to using a Web Service call in SQL Integration Services.
First, create a web service project.
image2.jpg
Figure 2 - Create a Web Service
Now, expose a method call in the Web Service:
public class SSISService : System.Web.Services.WebService
{
    [WebMethod]
    public string HelloMoon()
    {
        return "Hello Moon";
    }
    [WebMethod]
    public int Multiply(int nParam1, int nParam2)
    {
        return nParam1 * nParam2;
    }
}
Create an SSIS package:
image3.jpg
Figure 3 - Create an SSIS Package
Add a web service task:
image4.jpg
Figure 4 - SSIS Toolbox
image5.jpg
Figure 5 - Web Service Task
Next, modify the Web Service task:
image6.jpg
Figure 6 - Edit Web Service Task
image7.jpg
Figure 7 - Web Service Task Editor
Now, define the HTTP connection:
image8.jpg
Figure 8 - HTTP Connection Manager Editor
The next step is to define the WSDL file:
image9.jpg
Figure 9 - Web Service Task Edit (Definition of the WSDL file)
Define the Web Service Task inputs:
image10.jpg
Figure 10 - Web Service Task Editor (Definition of web service input properties)
Now, define the Web Service output. The output of the Web Service can be written to variables or to an output file. This sample outputs the results from the Web Service to a file system file that is defined using the File Connection Manager Editor (Figure 11).
image11.jpg
Figure 11 - Web Service Task Editor (Definition of Web Service output properties)
image12.jpg
Figure 12 - File Connection Manger

Results

The following is the encoded output from the Web Service, stored in a test.txt file:
<?xml version="1.0" encoding="utf-16"?>
<int>200</int>