{"id":3649,"date":"2016-04-29T13:38:00","date_gmt":"2016-04-29T05:38:00","guid":{"rendered":"http:\/\/www.waca.associates\/?p=3649"},"modified":"2018-03-13T11:34:50","modified_gmt":"2018-03-13T02:34:50","slug":"google-analytics-audience-analysis","status":"publish","type":"post","link":"https:\/\/www.waca.or.jp\/en\/web_analytics\/google-analytics-audience-analysis\/","title":{"rendered":"20 Minutes to Identify a $611 Customer"},"content":{"rendered":"<p><em>By David Chan &#8211; Web Analytics Master<\/em><\/p>\n<h3><strong>How I single out high value customers to increase profit.<\/strong><\/h3>\n<p><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/80_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3712\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/80_1.png\" alt=\"80_1\" width=\"555\" height=\"300\" \/><\/a><\/p>\n<p>Wouldn\u2019t it be nice if you could identify the profile of your high spending customers, <span style=\"text-decoration: underline;\"><strong>80%<\/strong> of your profit<\/span> from 20% of your customer &#8211;\u00a0The 80\/20 Rule. Technically known as Pareto\u2019s Law, or the Pareto Principle.<\/p>\n<p><strong>Why is it important for my business? <\/strong><\/p>\n<p>If you are able to identify them, know more about them then you can be more specific with your marketing. You can create touch points and content message to engage them, build trust and convert them. In my example I know male between age 45 &#8211; 54 has a great spending potential.<\/p>\n<p>With this in mind I can make good assumptions like:<br \/>\n1. high percentages of them likely to be married<br \/>\n2. income should be around than $7,000 &#8211; $12,000<br \/>\n3. strong\u00a0interest in ageing related content<\/p>\n<p>It need not cost you an arm or leg, I use simple free tools which most businesses already have to identify customer having $611 average spending.<\/p>\n<div id=\"attachment_3677\" style=\"width: 746px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/age_spend.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3677\" class=\"size-full wp-image-3677\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/age_spend.png\" alt=\"$611 average purchasse\" width=\"736\" height=\"495\" \/><\/a><p id=\"caption-attachment-3677\" class=\"wp-caption-text\">$611 average purchasse<\/p><\/div>\n<p>Let&#8217;s get started, tools I used:<\/p>\n<ul style=\"list-style-type: circle;\">\n<li>Microsoft Excel<\/li>\n<li>Google Analytics<\/li>\n<\/ul>\n<p><strong>Step 1<\/strong>: login to google analytics<\/p>\n<div id=\"attachment_3658\" style=\"width: 589px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-001.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3658\" class=\"wp-image-3658 size-full\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-001.png\" alt=\"log into GA\" width=\"579\" height=\"168\" \/><\/a><p id=\"caption-attachment-3658\" class=\"wp-caption-text\">Select the admin tab<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_3659\" style=\"width: 816px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-002.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3659\" class=\"wp-image-3659 size-full\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-002.png\" alt=\"asda\" width=\"806\" height=\"374\" \/><\/a><p id=\"caption-attachment-3659\" class=\"wp-caption-text\">Select the view you want to analyze<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 2<\/strong>: setup goals in google analytics, if you already have goals setup you can skip this step<\/p>\n<p>Depending on your goal objectives choose the right template, for the example we are using destination type<\/p>\n<div id=\"attachment_3660\" style=\"width: 519px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-003.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3660\" class=\"wp-image-3660 size-full\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-003.png\" alt=\"Add new goal\" width=\"509\" height=\"275\" \/><\/a><p id=\"caption-attachment-3660\" class=\"wp-caption-text\">Add a new goal<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_3661\" style=\"width: 611px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-004.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3661\" class=\"size-full wp-image-3661\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-004.png\" alt=\"sds\" width=\"601\" height=\"262\" \/><\/a><p id=\"caption-attachment-3661\" class=\"wp-caption-text\">Setting goal &#8211; step 1<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_3662\" style=\"width: 641px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-005.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3662\" class=\"size-full wp-image-3662\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-005.png\" alt=\"setting goals\" width=\"631\" height=\"483\" \/><\/a><p id=\"caption-attachment-3662\" class=\"wp-caption-text\">setting goals<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 3<\/strong>: Setup goal value, most users don&#8217;t step up value. One main reason is they are not able to determine actual value, for web analytics we don&#8217;t necessary need this value to be 100% accurate. An estimated value will be enough, as this will add another info into the data sources. For this example we put it as USD 50.<\/p>\n<p>However, if you have a eCommerce site you need not use this value since GA captures the transactional value.<\/p>\n<div id=\"attachment_3663\" style=\"width: 658px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-006.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3663\" class=\"size-full wp-image-3663\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/Image-006.png\" alt=\"setting goal value\" width=\"648\" height=\"468\" \/><\/a><p id=\"caption-attachment-3663\" class=\"wp-caption-text\">setting goal value<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 4:\u00a0<\/strong>navigate back to reporting and select audience<\/p>\n<div id=\"attachment_3679\" style=\"width: 536px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-001.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3679\" class=\"size-full wp-image-3679\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-001.png\" alt=\"Select reporting\" width=\"526\" height=\"98\" \/><\/a><p id=\"caption-attachment-3679\" class=\"wp-caption-text\">Select reporting<\/p><\/div>\n<div id=\"attachment_3680\" style=\"width: 341px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-002.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3680\" class=\"size-full wp-image-3680\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-002.png\" alt=\"Go to audience options\" width=\"331\" height=\"345\" \/><\/a><p id=\"caption-attachment-3680\" class=\"wp-caption-text\">Go to audience options<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 5<\/strong>: Segment with secondary dimension, segmentation allows you to gain more information about the subject you are analysing; in our case the gender<\/p>\n<div id=\"attachment_3681\" style=\"width: 707px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-003.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3681\" class=\"size-full wp-image-3681\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-003.png\" alt=\"Add secondary dimension\" width=\"697\" height=\"507\" \/><\/a><p id=\"caption-attachment-3681\" class=\"wp-caption-text\">Add secondary dimension<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 6:<\/strong> \u00a0configuring secondary dimension, if you are unsure of what secondary dimensions are\u00a0available, use short cut by typing into query bar and it will show you the drop menu<\/p>\n<div id=\"attachment_3682\" style=\"width: 497px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-004.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3682\" class=\"size-full wp-image-3682\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-004.png\" alt=\"configuring secondary dimension\" width=\"487\" height=\"244\" \/><\/a><p id=\"caption-attachment-3682\" class=\"wp-caption-text\">configuring secondary dimension<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 7 : <\/strong>secondary dimension added<\/p>\n<div id=\"attachment_3683\" style=\"width: 622px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-005.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3683\" class=\"size-full wp-image-3683\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-005.png\" alt=\"Secondary dimension added\" width=\"612\" height=\"536\" \/><\/a><p id=\"caption-attachment-3683\" class=\"wp-caption-text\">Secondary dimension added<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 8:<\/strong> if you have multiple goals be careful to select the appropriate goal for analysis.<\/p>\n<p>Also remember to expand the numbers of row to see all the details, recommend to select 50 rows as the default<\/p>\n<div id=\"attachment_3684\" style=\"width: 1075px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-006.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3684\" class=\"size-full wp-image-3684\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-006.png\" alt=\"goal selection\" width=\"1065\" height=\"487\" \/><\/a><p id=\"caption-attachment-3684\" class=\"wp-caption-text\">goal selection<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 9 :<\/strong> time to start making the graph<\/p>\n<div id=\"attachment_3685\" style=\"width: 339px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-007.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3685\" class=\"size-full wp-image-3685\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-007.png\" alt=\"download excel file\" width=\"329\" height=\"250\" \/><\/a><p id=\"caption-attachment-3685\" class=\"wp-caption-text\">download excel file<\/p><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Step 10:<\/strong> use excel to create graph, in our example we are using the gender and age as the x-axis.\u00a0You need to arrange the data is this way to plot\u00a0the graph<\/p>\n<div id=\"attachment_3686\" style=\"width: 229px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-008.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3686\" class=\"size-full wp-image-3686\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/waca_1-008.png\" alt=\"excel data\" width=\"219\" height=\"247\" \/><\/a><p id=\"caption-attachment-3686\" class=\"wp-caption-text\">excel data<\/p><\/div>\n<p>Final product<\/p>\n<div id=\"attachment_3677\" style=\"width: 746px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/age_spend.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3677\" class=\"size-full wp-image-3677\" src=\"https:\/\/www.waca.associates\/en\/wp-content\/uploads\/2016\/04\/age_spend.png\" alt=\"$611 average purchasse\" width=\"736\" height=\"495\" \/><\/a><p id=\"caption-attachment-3677\" class=\"wp-caption-text\">$611 average purchasse<\/p><\/div>\n<p>&nbsp;<\/p>\n<p>Here is an excellent video to help you with making graphs from excel<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/bKSTZgRKL9Q\" width=\"570\" height=\"465\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Now is your turn, if you run into any problem drop me note on the <a title=\"contact us\" href=\"https:\/\/www.waca.associates\/contact-form-general\/\" target=\"_blank\">contact form<\/a> &#8230;.. have fun<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"By David Chan &#8211; Web Analytics Master How I single out high value customers to increase profit. Wouldn\u2019t it be nice if you could identify the profile of your high spending customers, 80% of your profit from 20% of your customer &#8211;\u00a0The 80\/20 Rule. Technically known as Pareto\u2019s Law, or the Pareto Principle. Why is it important for my business? If you are able to identify them, know more about them then you can be more specific with your marketing. You can create touch points and content message to engage them, build trust and convert them. In my example I know male between age 45 &#8211; 54 has a great [&hellip;]","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101,52,19],"tags":[67],"class_list":["post-3649","post","type-post","status-publish","format-standard","hentry","category-articles","category-blog","category-web_analytics","tag-web-analytics"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/posts\/3649"}],"collection":[{"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/comments?post=3649"}],"version-history":[{"count":1,"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/posts\/3649\/revisions"}],"predecessor-version":[{"id":6237,"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/posts\/3649\/revisions\/6237"}],"wp:attachment":[{"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/media?parent=3649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/categories?post=3649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.waca.or.jp\/en\/wp-json\/wp\/v2\/tags?post=3649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}