Overview
The "Statistics" section of OneClickUpsell is designed to provide you with all of the information on the app's results. All of this data will help you in your funnel and offer optimization efforts!
You can view the following:
How much Extra Revenue has been made via Pre-purchase, In-checkout, one click Post-purchase upsells/downsells, and TY page offers.
How many Orders have been processed (that contain a pre, post, and/or ty page offer).
The Average Order Value (AOV) of orders with upsells (excludes In-checkout offers)
Your Top-performing Funnels and your Top-performing Offers.
📝The Total Value is shown for OCU Statistics (includes Shipping and/or Taxes). Stats for Post-purchase and TY Page offers will update only when the payment is captured.
To access the Statistics section, click on the "Statistics" button in the left-side navigation menu of the app:
You'll be taken to the Statistics Dashboard where it will show you the app's performance over the last 30 days by default.
📝Your Orders which contain a pre-purchase offer, post-purchase offer(s), and/or thank you page offers can easily be found in your Shopify admin Orders area by searching for the following tags there:
OCU Zipify Post-Purchase Upsell Bought
OCU Zipify Pre-Purchase Upsell Bought
OCU Zipify TY Upsell Bought
Choosing a Date Range
To change the date range for the Statistics from the default 30 days:
Click on the date selector button and choose from one of the pre-defined ranges (Today, Yesterday, Last 7 Days, Last 90 Days, etc.)
OR select a custom date range instead.
Then click the "Apply" button to update the Statistics Dashboard.
📝You can also manually type in a date into the Starting and Ending date fields if desired.
Working with the Bar/Line Charts and Pie Chart
Sales, Revenue, Orders, and Average Order Value with Upsells statistics will be displayed in bar/line charts and pie charts respectively.
For the Sales, Revenue, and AOV Charts, there are 2 views available, depending on how you want to display the data:
Bar Chart
Line Chart
You can toggle ON/OFF the following data points to filter the view:
Post-Purchase Upsells
Post-Purchase Downsells
Pre-Purchase Upsells
TY Page Offer
Hover your cursor over a data point for any of the Charts to see the statistics for a particular day:
📝A similar functionality works for the Revenue pie chart as well. Revenue pie chart shows the same data as Sales just in a different format:
Sales and Revenue Chart Details
Sales amount is a sum total of orders values.
Post-Purchase Upsells amount is a sum of upsell items prices.
Post-Purchase Downsells amount is a sum of downsell items prices.
Pre-Purchase Upsells amount is a sum of pre-checkout items prices.
Etc.
All values on the Sales chart include taxes and shipping.
Orders Chart Details
“Orders” is the sum of orders with bought post-purchase upsells, orders with bought pre-purchase upsells, orders with bought ty page offers and orders with combinations of bought offers.
“Orders with Post-Purchase Upsells” number is the total amount of orders only with post-purchase upsells and downsells bought.
“Orders with Pre-Purchase Upsells” number is the total amount of orders only with pre-purchase upsells bought.
“Orders with Pre and Post-Purchase Upsells” number is the total amount of orders with both pre and post-purchase upsells bought.
Etc.
Average Order Value with Upsells
Average Order Value with Upsells is the total revenue of orders with offers, divided by the total number of such orders.
The average value of category of orders with certain type(s) of offers is the total revenue of such orders, divided by the total number of such orders.
📝Average Order Value in your Shopify reports will differ from the one in OCU due to the update described below and in this Shopify article:
In Shopify reports, the definition of average order value has been updated as of December 23, 2022. Average order value is now equal to ((gross sales - discounts ) / orders), excluding post-order adjustments like edits or exchanges. The previous definition was ((gross sales - discounts + taxes + duties + shipping ) / orders), including post-order adjustments. The new definition is a more accurate reflection of an order’s value since it reflects only product revenue that was generated when the customer placed their order.
Working with the "Top Funnels" Table and Statistics
The "Top Funnels" table will show you your top-performing Funnels in terms of Revenue generated. You can switch between Post-Purchase / Pre-Purchase / TY Page Offer statistics for the Top Funnels table by making your selection below Stats Display:
To see even more detailed statistics about each offer in the funnel such as:
Number of Views
Conversion Rate
Revenue Generated
Average Funnel Value
...click on the "View details" button within the table.
Within the "Top Funnels" detailed statistics, you can set a Date Range for this data following the same steps described previously. Switch between Post-Purchase / Pre-Purchase / TY Page Offer views by making your selection.
📝 In the Post-Purchase view different offer types can be shown in the table by clicking the ⚙️ icon in the top-right corner.
📝 Pre-Purchase "Views" are calculated based on the Pre-Purchase offers that result in a successful checkout I.e. abandoned carts will not count towards Pre-Purchase views.
Top Funnels Details (Pre-Purchase)
Views amount is a number of times the funnel was triggered and the checkout was completed.
Conversion Rate is a ratio of the number of orders where pre-purchase was bought to the number of orders (not checkouts) where pre-purchase was shown.
Revenue is a sum of offer item prices without taxes and shipping.
Avg. Funnel Value is the total revenue of all offers in this funnel divided by the total amount of sold “add to cart” and “upgrade” offers.
Avg. Funnel Value = offers revenue sum / (number of add to order sold + number of upgrade sold)
Top Funnels Details (Post-Purchase)
Views amount is a number of times the funnel was triggered.
Offer Conversion Rate is the percentage of views that resulted in a purchase.
Revenue is a sum of offer item prices with taxes and shipping.
Avg. Funnel Value is the total revenue of all offers in this funnel divided by the total amount of sold “upsell1”, "upsell2" and “downsell” offers.
Avg. Funnel Value = offers revenue sum / (number of upsells sold + number of downsells sold)
Working with the "Top Upsell Products" Table and Statistics
The "Top Upsell Products" table will show you your top-performing offers in terms of revenue generated for each offer:
To see even more detailed statistics about your offers click on the "View Details" button within the table. There you can set a Date Range (1), choose a specific offer type's data to view (2) and see Per Product Conversion Rates (3) for each offer type and product:
The "Per Product Conversion Rates" statistics table has a lot of valuable information for you! It lists the conversion rates for all of your offer products and all the positions each product was shown in for all Funnels.
| Conversion Rate | Revenue |
Pre-purchase | Product conversion rate = (products sold / product views)*100 | Sum of offer item prices without taxes and shipping |
Post-purchase | Product conversion rate = (products sold / product views)*100 | Sum of offer item prices with taxes and shipping. |
By using the information in the tables, you can optimize all your upsell and downsell offer positions within Funnels to increase the conversion rates and generate as much revenue as possible.
Please reach out to us in chat if you have any questions at all!