In this article:

Finding eCommerce Metrics in Shopify: Conversion Funnel Metrics

One big strength of Shopify as a platform is its Analytics pages, where you can see how important marketing and eCommerce metrics change over time. Nowadays, awareness of these metrics is a huge advantage in bringing success to a business. This series, therefore, aims to show you how to access these metrics in Shopify.

For this tutorial, we will learn how to access the conversion funnel metrics, and use them to estimate the shopping cart abandonment rate metric. To refresh your knowledge, the Shopping Cart Abandonment Rate metric is the percentage of all online shopping carts abandoned before the purchase. If you need a full review, you can read our article about shopping cart abandonment rate here. 


How to access the conversion funnel metrics on Shopify

On the Overview dashboard of the Analytics panel, you will notice a box called Online store conversion rate. The online store conversion rate gives you the percentage of the customers who completed the purchase.

Online store conversion rate box in Overview dashboard on Shopify
We’re just starting. And all our orders are from point-of-sale actions.


The box lists the values through the conversion funnel: added to cart, reached checkout, and sessions converted.  The values decrease as you go down the conversion funnel, until you reach the Sessions converted. For most industries, the Online store conversion rate is very small. It is used in conjunction with other metrics to assess the performance of the products, the business, and the brand. 

The following information is listed, summarized over the specified period of time in the dashboard:

  1. Sessions: the number of times the online store was viewed
  2. Added to cart: the number of sessions where at least one item was added to the cart
  3. Reached checkout: the number of sessions where the items added to the cart was eventually checked out
  4. Sessions converted: the number of sessions where the customers actually bought the items (added to cart, checked out, paid online)

When you open the View report link on the upper-right corner of the box, the same information is given, but is both plotted as a bar graph and tabulated, each row set to a period of time specified on the upper-left portion of the page. 

Online store conversion over time graph on Shopify
The bar graph showing the trend in online store conversion. The time period covers one month. Again, all our sales are from POS. 


Online store conversion data broken down by Day on Shopify
The table showing the day-by-day summary of the given data... The time period covers one month. Again, all our sales are from POS. 

How to estimate the shopping cart abandonment rate metric

Another important metric is the shopping cart abandonment rate. Even if you open the View report link, the metric is not automatically calculated.  Fortunately, it is easy to estimate the value of the abandonment rate. To calculate the shopping cart abandonment rate metric, get the percentage of Sessions converted, then subtract it from the percentage of Added to cart, then divide the answer by the percentage of Added to cart


How to check the abandoned carts one-by-one

You can reduce the abandoned cart rate by following them up one-by-one. The list of abandoned carts can be accessed by clicking on the Orders option on the left panel, and then clicking on the Abandoned checkouts. It will list down the carts including the possible problems, such as payment issues. You can also send an email to remind the customer of their abandoned cart. You can learn more by reading this guide from Shopify: Recovering abandoned checkouts · Shopify Help Center

Making metric-hunting a bit easier...

While the metrics are accessible on Shopify, checking every day, week, or month for each of these can be a pain. For those who don't look forward to manually finding numbers over and over again, you can check out our Shopify integration that will pull your conversion funnel data alongside other Shopify and eCommerce platform data! Spend more time on data analysis and less time metric-hunting with Lido.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started