The majority of us optimize marketing campaigns for e-commerce websites.
Therefore it is very important that whatever we do to optimize these campaigns must directly result in an increase in product sales.
Let’s say you have got 100,000 products to sell.
Now where should you start?
What should you change on the website?
Which key issues should you focus on that can quickly improve your website sales?
I have found the following six data drill-downs to be super useful in understanding and improving the performance of e-commerce products in terms of sales, quantity, average order value, and unique purchases:
Data Drill-Down #1: Find Your Top Selling Locations in Google Analytics
If you sell products worldwide then start your product analysis at the country level.
Find the top 10 countries in terms of sales in the last three months. Direct your marketing efforts and resources towards them.
Even if my target market is worldwide, I most likely won’t be running marketing campaigns in each and every country. I am most likely to focus on top 5-10 countries (top in terms of sales).
When you are advertising at an international level, cost per acquisition tends to be very high. So you need to make great efforts to keep costs under control.
No company has got an unlimited budget, no matter how big it is.
National Market
If you sell products only in one country but at the national level then start your product analysis at the state/region level.
Find the top 10 states/regions in terms of sales in the last three months. Direct your marketing efforts and resources towards them.
I target an entire state/region only when I cannot find clear top 10 winners.
Regional Market
If you sell products only in a particular state/region then start your product analysis at the city level.
Find the top 10 cities in terms of sales in the last three months. Direct your marketing efforts and resources towards them.
Local Market
If you sell products in a particular town/city then you start your product analysis at the town/city level.
However, these rules are not set in stone.
I sometimes achieve great success by targeting at the city level even when my target market is international. It all depends upon your industry, business model, and target audience.
The point to remember here is, find those geo locations which are generating maximum sales for your company and direct your marketing efforts and resources towards them.
You cannot sell your products at each and every location in your target market.
So do not spread your marketing efforts and resources too thin by trying to be visible everywhere, for everything you sell.
For example, I have noticed many marketers advertise all over the US just because they think that their target market is national. But if they dive deep into their analytics reports they would most likely find that they are not getting sales from each and every location in the US.
They are most likely getting the majority of sales from 10-20 locations. These locations could be cities or states.
Remember the Pareto principle, 80% of sales come from 20% of the locations.
The other 20% of sales come from 80% of the locations.
Often businesses spend 80% of their marketing budget to get that 20% of sales from the remaining 80% locations which lead to a high cost per acquisition.
Don’t make this mistake. Yes, you are getting that 20% sales but at what cost. If you are spending $100 to sell a $50 product then is it worth it? No.
Even public traded companies, advertising at national level should not afford to ignore top selling locations.
If your target market is as big as US, China, or India, where the cost per acquisition tends to be very high because of the ginormous population and cut-throat advertising competition, you should definitely not ignore your top selling locations.
For small businesses, finding top selling locations is critical because they have got a very limited budget. So you need to find your top selling locations before you move further with your product analysis.
Let us click on the US map to determine top selling locations at the national level in the last 3 months:
From the report above we can conclude that California and Florida are top selling locations at the national level. But I want to drill down further.
Let us click on the ‘California’ map to determine top selling locations there:
From the report above we can conclude that the city of Los Angeles is the top-selling location in the California region in the last 3 months.
We also now know that it is not profitable to target/advertise all over California let alone throughout the US.
You won’t get such type of insight without segmenting top selling locations.
Get my best selling books on Attribution Modelling
Learn to implement attribution modelling in your organisation
Understand the customer purchase journey across devices
Determine the most effective marketing channels for investment
Click book covers to find out more
Data Drill-Down #2: Find Top Selling Product Categories
Once you know your top selling locations, you need to determine your top selling product categories.
Now let us find top selling product categories in the city of Los Angeles:
You may have got dozens or even hundreds of product categories on your website. But you won’t generate an equal volume of sales from each and every product category. There will always be some product categories that almost always outperform others.
Remember the 80/20 rule, 80% of your sales come from 20% of your product categories.
So you need to find your top product categories (in terms of sales) and work relentlessly on them to increase their sales further.
The rule of thumb is to sell what is selling and sell even more.
There is no point working tirelessly on promoting a product category which generates little to no sales.
I am most likely to focus on the top 5-10 product categories (top in terms of sales).
However, I focus on top product categories only when I cannot find clear top 10 products.
These are the products that generated 80% of the website’s total sales in the last 3 months.
Data Drill-Down #3: Find Top Selling Products
Once you know your top selling product category, you need to find top selling products in that category.
Now let us find top selling products in the top selling product category in the city of Los Angeles:
You may have got dozens or even hundreds of products in your top product category. But you won’t generate an equal volume of sales from each and every product. There will always be some products which almost always sell the most.
Here the 80/20 rule comes into play according to which, 80% of your sales come from 20% of your products.
So you need to find your top products (in terms of sales) and work relentlessly on them to increase their sales further.
The rule of thumb is to sell what is selling and sell even more.
There is no point working tirelessly on promoting a product that nobody has ever bought especially when you as a marketer have no control over product price, product quality, features, design, and packaging.
Data Drill-Down #4: Find Top Performing Traffic Sources
Once you know your top selling product, you need to find the traffic source which is responsible for its sales.
Without knowledge of the traffic source, you cannot do much in terms of improving product sales.
Let us determine the top traffic sources in terms of sales for my best selling product in the city of Los Angeles:
From the report above we can conclude that the top traffic source is Google and the top traffic medium is organic search.
So if I could improve the performance of organic search i.e. SEO, I could improve the sales of my best selling product further.
At this point, I can also choose not to promote this product via PPC, Facebook, or Twitter ads any more, if the sales and ROI have not been good in the last 3 months from these traffic sources.
The point to remember here is, to invest more in the marketing channel which has proved to work and de-invest in the marketing channels which are not working.
Data Drill-Down #5: Find Top Landing Pages for Conversion Funnel Analysis
Once you know your top traffic source in terms of sales for your best-selling product(s), you need to determine the top landing pages, so that you can optimize them further to improve sales.
There could be one or more top landing pages for your best selling product:
Once you know your top landing page(s) for your best-selling product, determine how your customers move through the conversion funnel once they land on your top landing page.
Getting traffic to your website is one thing but getting it to convert is a totally different ball game.
You may be getting millions of visitors to your website each month but if they are adding little to no value to the business bottomline then your cost per acquisition will remain high and your gross profit would remain low.
In order to make your business a success, you need to focus on increasing revenue and decreasing cost per acquisition/conversion.
The home page is the top landing page for many websites.
So if the home page is your top landing page then you would like to know how people go through the conversion funnel once they land on this page.
The traditional way of doing this is by analysing the funnel visualization report in Google Analytics and then identifying and removing the bottlenecks in your conversion funnels:
Marketers look for drop-offs in conversion funnel from one step to the next; determine the reason for the drop off and what could be done about it.
If you are optimizing your shopping cart experience then funnel visualization reports are of great help. As you can see from the report above, every person who proceeded to the shopping cart page, checked out.
Make sure once a person adds an item to the shopping cart, he/she complete the checkout on your website. You can do this by identifying and removing the bottlenecks in your checkout funnel and through remarketing.
In the funnel above, we have achieved the checkout nirvana. You no longer need to worry about your checkout process here.
But what you need to worry about here, is the huge drop in traffic from the home page to the shopping cart page. Just 0.47% of 8266 visitors proceeded to the shopping cart page. If you could make more visitors reach the shopping cart page, you could generate more sales.
Now the problem is, you don’t know which visitors proceeded to the shopping cart page from the home page and which didn’t.
You have got a lot of questions:
Were they the visitors from organic search?
Were they the visitors from paid search?
Were they the visitors from social media?
How many visitors viewed a particular product category page before they added items to the shopping cart?
How many visitors viewed a particular product detail page before they added items to the shopping cart?
Without segmenting the conversion funnel there is nothing much you can do about the drop off from one step to the next in a conversion funnel.
Unfortunately, Google Analytics does not allow applying advanced segments to Funnel Visualization reports.
You can overcome the limitation of segmenting conversion funnels in Google Analytics to an extent by creating a filtered view for each major traffic source/medium for your website:
Through this report, you can determine how your customers move through the conversion funnel once they land on your top landing page.
Through this report, you can (sort of) create conversion funnels on the fly for historical data and apply custom/advanced segments to them:
You can see from the goal flow report that visitors are dropping off at each step of the funnel.
In order to understand the reason for this drop-off, you need to segment this funnel by applying any/all of the 14 custom segments:
Once you know the reason for the drop-off from one step to the next and which funnel page(s) need to be optimised, only then you start your testing (A/B testing, usability testing, etc) and/or optimization of marketing campaigns.
The home page is the top landing page for many websites.
So if the home page is your top landing page then you would like to know how people go through the conversion funnel once they land on this page.
Follow the steps below to create a conversion funnel for the home page in Google Analytics:
Step-1: Login to your GA account and then navigate to the main reporting view.
Note: Select the reporting view which includes traffic only from the location where your target market lives. So if your target market is only the US then your view should include only the US traffic and not the traffic from all over the world.
Step-2: Navigate to the Goal flow report (under ‘Conversions’ > ‘Goal’).
Step-3: Select the goal which tracks purchase in your reporting view from the ‘Goal’ drop-down menu (located at the top of the ‘Goal Flow’ report:
Step-4: Select the ‘Landing Page’ dimension from the dimensions drop-down menu:
Step-5: Click on the wheel button next to the dimensions drop-down menu:
Step-6: Click on the link ‘Add an item’:
Step-7: Select ‘/’ from the drop-down menu (under ‘Expressions’), enter the text ‘Home Page’ in the second text box, and then click on the ‘Apply’ button:
You should now see the conversion funnel in which the users started their purchase journey from the home page:
You can see from the goal flow report for the home page that the visitors are dropping off at each step of the funnel.
In order to understand the reason for this drop-off, you need to segment this funnel by using any/all of the 14 advanced segments I mentioned earlier.
Let us apply an organic search advanced segment to this funnel visualization report and at the same time remove the ‘All Users’ segment:
You are now looking at the goal flow report in which people first landed on the home page via organic search.
Similarly, you can apply paid search traffic, social media traffic, mobile traffic, and several other custom segments to your goal flow report.
The entire process for creating conversion funnel for a product category page or Product detail page is similar to creating conversion funnel for the home page.
"How to use Digital Analytics to generate floods of new Sales and Customers without spending years figuring everything out on your own."
Here’s what we’re going to cover in this training…
#1 Why digital analytics is the key to online business success.
#2 The number 1 reason why most marketers are not able to scale their advertising and maximize sales.
#3 Why Google and Facebook ads don’t work for most businesses & how to make them work.
#4 Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.
#5 The number 1 reason why conversion optimization is not working for your business.
#6 How to advertise on any marketing platform for FREE with an unlimited budget.
#7 How to learn and master digital analytics and conversion optimization in record time.
My best selling books on Digital Analytics and Conversion Optimization
Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.
Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.
Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.
Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.
About the Author
Himanshu Sharma
Founder, OptimizeSmart.com
Over 15 years of experience in digital analytics and marketing
Author of four best-selling books on digital analytics and conversion optimization
Nominated for Digital Analytics Association Awards for Excellence
Runs one of the most popular blogs in the world on digital analytics
Consultant to countless small and big businesses over the decade
Get My Step-By-Step Blueprint For Finding The Best KPIs (32 pages ebook)
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
Cookie
Duration
Description
cookielawinfo-checkbox-analytics
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional
11 months
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy
11 months
The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.