Analytics
What is Cancellation log report?
What is Cancellation log report?
This report gives a complete picture into how a subscription got cancelled:
Full cancellation flow journey for each subscription cancelled by the customer (benefit page viewed, reason chosen, treatment opted, offer viewed).
For subscriptions churning due to payment issues you can view details like Payment in recovery status, Last payment attempted date, Payment failure reason, Previous failed orders count.
We also show details on 0-day cancellation, Upcoming order cancellation, Cancellation source.
Is Paused subscription counted in Active Subscription in retention cohort on Analytics section?
Is Paused subscription counted in Active Subscription in retention cohort on Analytics section?
Yes, paused subscriber is an active subscriber so paused subscription is counted in Analytics section > Cohorts.
What's the difference between values "-" and "success" on Analytics?
What's the difference between values "-" and "success" on Analytics?
In Analytics, When the value of Last payment status is -, it means that there has been no payment attempted by Loop yet on this subscription. This generally means that the second order has not yet been placed on the subscription.
And "success" means that the last payment attempt was a success.
What is LTV in Analytics > Cohorts?
What is LTV in Analytics > Cohorts?
In Analytics, LTV for all cohorts is basically the total order value of all subscription orders.
How to read the graphs in Analytics > Payment Failures section?
How to read the graphs in Analytics > Payment Failures section?
In Analytics > Payment failure section, both graph means:
Pie chart:
It shows failure wise distribution of only those orders whose last attempt in the given duration is failure.
Bar graph:
It shows all failures in the given duration.
How can I export the subscriber data? I am willing to move to another subscription app.
How can I export the subscriber data? I am willing to move to another subscription app.
You can export your data by going to: Loop > Analytics > Reports > Subscription, however, we suggest that you let us know what went wrong. We at Loop take feedback very seriously and try to work on all requested customizations possible.
Where can I view monthly subscription revenue?
Where can I view monthly subscription revenue?
To visit your subscription revenue details, go to Loop Admin > Analytics > Subscriptions, and there you'll find the option to view subscription revenue. You can apply the date filter according to your requirement.
How does loop define/calculate (subscription cancellation rate) churn rate?
How does loop define/calculate (subscription cancellation rate) churn rate?
The subscriber churn rate is defined by percentage of subscribers that cancelled their subscription over a period of time. You can find it in Loop > Analytics > Cancellation.
For the calculation of the Churn Rate for your store, you can use this formula:
Churn Rate = cancellation in the specific month / (Total active before start of month + created in the month) * 100
Is there a way to exclude the cancelled subscriptions from the analytics view? Its impacting the analytics reporting that we wish to see.
Is there a way to exclude the cancelled subscriptions from the analytics view? Its impacting the analytics reporting that we wish to see.
To exclude the cancelled subscriptions from Loop > Analytics > Subscriptions, you can click the 'Churned' button on the legend of the chart. That way, your remaining charts shall zoom out for a better visibility.
How can we get a forecast of the next month's orders by product? (similar to the subscriber by product but for next month). We just had a bunch of orders come through from subscribers.
How can we get a forecast of the next month's orders by product? (similar to the subscriber by product but for next month). We just had a bunch of orders come through from subscribers.
To know the next month inventory forecast of orders by the products, please navigate to Analytics > Products > Inventory Forecast, and you can apply the date filter as needed.
What are the common retention strategies any merchant can follow?
What are the common retention strategies any merchant can follow?
Common retention strategies are mentioned below:
Payments:
Set up payment retries
Set up backup payments
Use quick actions in payment failure emails
Churn:
Set up the benefits page
Set up reasons and treatments
Create a cancellation offer
Create a subscription journey
Where can I find the monthly sku velocity for Loop subscription orders?
Where can I find the monthly sku velocity for Loop subscription orders?
To find the monthly sku velocity for Loop subscription orders.
Go to analytics->Products->Scroll down-select Acquisition date- Scroll down to Product-wise Acquisition. It will give you product product-wise snapshot of the selected period's activity.
Is there a way to check how many subscribers are visiting the customer portal?
Is there a way to check how many subscribers are visiting the customer portal?
Currently, checking how many subscribers are visiting the customer portal is not something we can show natively on the Loop app page. In case if you require this information explicitly, we are happy to look into it. Kindly drop us an email with your requirement (subscription number if any, and we'll look into it).
How to check scheduled vs actual attempted orders?
How to check scheduled vs actual attempted orders?
The scheduled vs actual attempted orders mean 'realised orders', which is shown in the revenue realised under Loop > Analytics.
How are acquired subscribers and acquired MRR calculated on the analytics dashboard?
How are acquired subscribers and acquired MRR calculated on the analytics dashboard?
The calculation logic behind acquired subscribers and acquired MRR is as follows:
Acquired subscribers: This is the count of customers who
became subscribers in that time period. (Buying their first
subscription on the store - no previous subscription orders on
Loop)Acquired MRR: This is the MRR based on the subscription they
were acquired on. One-time products from these orders are not
included while calculating this.
Is there any way to view a breakdown for acquired MRR based on (e.g. daily level, user-level, or subscription plan-level)?
Is there any way to view a breakdown for acquired MRR based on (e.g. daily level, user-level, or subscription plan-level)?
As of now 'a breakdown for acquired MRR based on (e.g., daily, user-level, or
subscription plan-level)' is not available in our dashboards.
Are there any filters, transformations, or exclusions applied in the
dashboard that could affect the MRR or subscriber count?
Are there any filters, transformations, or exclusions applied in the
dashboard that could affect the MRR or subscriber count?
There are no exclusions applied in the dashboard that could affect the MRR or subscriber count.
How is the monthly revenue derived for subscriptions with different billing intervals (e.g., 3 months, 1 month)?
How is the monthly revenue derived for subscriptions with different billing intervals (e.g., 3 months, 1 month)?
The possible cases driving the monthly revenue for subscriptions based on interval types are:
Year based: Subscription price x (1/(12' Interval count))
Month based: Subscription price x (1/ Interval count)
Week based: Subscription price x ((30/7) / Interval count)
Day wise: Subscription price x (30/ Interval count)
Why don’t my latest subscriptions show up in Analytics immediately?
Why don’t my latest subscriptions show up in Analytics immediately?
Analytics data in Loop may take up to 24 hours to fully sync and display in the dashboard. This delay happens because subscription and order data need to be processed and updated across all reports for accuracy.
If you don’t see your recent subscriptions after 24 hours, please reach out to the Loop Support Team for assistance.
What number and percentage % of new subscriptions each day are coming from Existing customers and New customers?
What number and percentage % of new subscriptions each day are coming from Existing customers and New customers?
To know the number and percentage % of new subscriptions each day that are coming from:
For existing subscribers, you can check the acquisition tab in the subscriber analytics section
New subscriptions can be seen on the home dashboard as well as in subscription analytics.
The only caveat is that certain new subscribers might create more than one subscription with a single checkout order (on different frequencies, etc)
How is AOV calculated in Loop, and how is it different from Shopify?
How is AOV calculated in Loop, and how is it different from Shopify?
The difference is due to the way we calculate vs Shopify calculate AOV.
For any time period
Loop AOV: Sum of Order Total / Orders
Shopify AOV: (gross sales - discounts) / orders
Shopify does not include Shipping and Taxes in AOV calculation
How can I see churn for a specific product during a date range?
How can I see churn for a specific product during a date range?
To see churn for a product during retention, please see the below:
Product variant-wise cancellation data under Analytics > Products > Churn and retention.
If you want to export a report, you can download the same by following these steps: Analytics > Report > Product variant-wise cancellation
Could you please let me know what the subscription spent and remaining orders mean?
Could you please let me know what the subscription spent and remaining orders mean?
The 'subscription spent field' is the total amount spent on a specific subscription till date.
The 'remaining orders' shows the total number of orders a customer can have in that subscription
At what interval/duration or time all Analytics data syncs?
At what interval/duration or time all Analytics data syncs?
Regarding the syncronisation period on Analytics dashboard, there are multiple metrics available inside Analytics and some of them are 'near real-time' and some are periodic (daily basis).
If you open any metric and go to: Date Range and open the dropdown, you'll notice 2 things.
Few lists will have 'today' in the drop down list.
If, 'today' is appearing in the date range, its 'near real time', if today is not appearing in the list, its periodic - 1 day basis.
Near real time means sometimes there can be a delay of minutes - it being a data sync.
The data refresh rate is primarily dependent on the Cache logic. So lets say if you are looking at the 'real time Analytics' for the first time, it'll be most accurate, but if you want to see the data again - the recommendation is to wait for 30-60 minutes.
Usually, merchants look at the save rate this frequently - so this logic saves us making the processes frequent and thus avoids the load on databases.
What is the definition of the following terms in analytics: [Active subscribers, New subscribers, Activated subscribers, Deactivated subscribers]?
What is the definition of the following terms in analytics: [Active subscribers, New subscribers, Activated subscribers, Deactivated subscribers]?
Active subscribers - The # of subscribers with an ACTIVE subscription.
New subscribers - People who create a new subscription
Activated subscribers - Activated subscribers refer to customers who have an active subscription status.
Deactivated subscribers - Churned + subscribers who pause or cancel their subscription.
Does the subscription churn metric include cancellations?
Does the subscription churn metric include cancellations?
Subscription churn metric in analytics takes checkout orders in consideration.
How can i check my upcoming subscription revenue?
How can i check my upcoming subscription revenue?
The upcoming subscription revenue is shown on the home page under the upcoming sales and it accomodates the 30 days by default.
How to find out the data of subscription cancellations that were initiated from the portal specifically?
How to find out the data of subscription cancellations that were initiated from the portal specifically?
Currently, cancellation logs do not include cancellations made through the Admin portal. Merchants have to run two separate reports to get the complete data on cancellations. Therefore, it may not be possible to directly track the number of subscription cancellations specifically from the portal without additional reporting capabilities being implemented
I would like to find out how many discounts codes starting with "CC-" were added in a specific time frame and what the discount value of these codes in total is?
I would like to find out how many discounts codes starting with "CC-" were added in a specific time frame and what the discount value of these codes in total is?
To find out the total discounted amount based on the discount codes applied, you need to navigate to Loop > Analytics > Reports > 'Subscription Orders Processed' > Add Filter > Discounts Added > filter with Prefix = cc
How do I find customers who have active subscriptions in Loop?
How do I find customers who have active subscriptions in Loop?
To find customers/subscribers with active subscriptions, please head over to Loop > Analytics > Reports > Subscribers, and apply Active Subscriptions filter accordingly.
Why isn’t Google Shopping showing subscription pricing and how do we fix it?
Why isn’t Google Shopping showing subscription pricing and how do we fix it?
Google Shopping only pulls one-time product prices from Shopify, not subscription prices. To display subscription pricing, you'll need a feed app like Simprosys or DataFeedWatch.
Reports
Does Loop offer analytics-only mode that works on top of Shopify's native subscriptions?
Does Loop offer analytics-only mode that works on top of Shopify's native subscriptions?
At the moment, Loop does not support an analytics-only mode that works on top of Shopify’s native subscriptions. To access Loop’s analytics and reporting features, the subscriptions need to be managed through Loop using our selling plans and flows.
How is the 'Attempted rate' calculated in the analytics dashboard?
How is the 'Attempted rate' calculated in the analytics dashboard?
The 'Attempted Rate' is calculated in the Analytics dashboard by (No of attempted orders / Total scheduled orders) * 100
Attempted orders can be found by Scheduled Orders - all cancelled - paused, skipped, delayed etc.
In the "Subscribed products" report, I currently only see the subscriptions and the date for the immediate next order. I'm looking for a way to also view all upcoming order dates for these subscriptions, along with the quantities scheduled for each of those future orders. How to include the number of products reserved for subscriptions?
In the "Subscribed products" report, I currently only see the subscriptions and the date for the immediate next order. I'm looking for a way to also view all upcoming order dates for these subscriptions, along with the quantities scheduled for each of those future orders. How to include the number of products reserved for subscriptions?
To find the number of products reserved for subscriptions, please follow the steps below:
Go to Loop > Analytics > Reports
Open the Upcoming Orders report
Set a custom date range based on your preference
Ensure that "Products" is selected in the columns
Export the report as an Excel file
Once exported, you’ll be able to view and analyse the number of products reserved for upcoming subscription orders
We are using customer tags within the flows. Can you tell me which reports I can access and filter by tags?
We are using customer tags within the flows. Can you tell me which reports I can access and filter by tags?
To access tags based subscription reports and filter Subscriptions with tags, please go to Analytics > reports > subscribers > now you can add columns of "customer tags" in this report.
Is there a way to see that, when and how much credit merchants added from their end to which customer accounts?
Is there a way to see that, when and how much credit merchants added from their end to which customer accounts?
To check, when and how much credit merchant added from their end to customer accounts please go to:-
Loop > Analytics > Reports > Select Prepaid Credit Transactions > filter by Event Type = Manual adjustment
and then go to Subscription Activity report and filter by Type = prepaidCreditsAdjusted
How can I pull all active subscription customers into one email list to email them all the same email/notification?
How can I pull all active subscription customers into one email list to email them all the same email/notification?
You can follow these steps to view the active subscriptions:
Navigate to Loop > Analytics > Reports.
Click on the Subscriptions tab.
Apply the Active filter to view only the active subscriptions.
Once filtered, you can refer to the Email ID column for the subscriber details.
How can we filter active subscriptions that are based on the old default variant ID: 41946595393601 (which no longer exists)?
How can we filter active subscriptions that are based on the old default variant ID: 41946595393601 (which no longer exists)?
To filter your subscription data for the old variant ID, please follow these steps:
Export your subscription data:
Go to Loop App → Analytics → Reports → Subscriptions.
Filter by ‘Subscribed products’ = [Old Product Name] and export the list.
How can I check inactive products and get a report directly from Loop?
How can I check inactive products and get a report directly from Loop?
You can easily extract the list of inactive products from the Loop App using the steps below:
Go to Alert Center → View Details → Inactive Products — here you’ll see a full list of all inactive products.
To get a detailed report for these products, go to Loop App → Analytics → Reports → Subscriptions.
Use the ‘Subscribed Products’ filter to select each inactive product and export the data as needed.
Is there a way for us to be able to determine how many active subscribers are subscribed to a particular bundle?
Is there a way for us to be able to determine how many active subscribers are subscribed to a particular bundle?
To view Products assigned to a bundle, you need to go to Loop> Analytics> Reports> Subscribed Products> Apply filter of Plan Name> Select the bundle name and click filter.
How to check the payment processor for a particular subscription?
How to check the payment processor for a particular subscription?
To check the payment processor for a particular subscription, please go to loop admin portal > analytics > reports > transaction summary
How to run a report to filter our subscribers by location country USA?
How to run a report to filter our subscribers by location country USA?
To find a subscription by location, please go to Loop > Analytics > Reports > Subscriptions > Columns > Delivery country
How can I find all subscriptions that had a failed order do to the following error: inventory_allocations_not_found?
How can I find all subscriptions that had a failed order do to the following error: inventory_allocations_not_found?
To find subscriptions that have a failed order with a specific error, please go to Analytics > Reports > Subscriptions > and apply filter: Payment Failure reason
How to create a report that includes the orders created via API?
How to create a report that includes the orders created via API?
To create a report where the API was involved in creating orders, here’s what you can do:
Go to the Loop Admin Portal
Navigate to Analytics > Reports
Open Subscription Activity Logs
Apply a filter for Source and select API
Apply another filter for Type and select Order Created
How do I find out customer IDs who took an action between a time period, for example, the people who delayed the orders between a time period?
How do I find out customer IDs who took an action between a time period, for example, the people who delayed the orders between a time period?
To find customers with their customer IDs that took an action like 'Delay an order' between a time period, you can go to 'Subscription Activity Logs' under Analytics > Reports and then apply the filter called 'Type' for the action type. Once you have the filter done, please export this report and then compare it using the vlookup formula in Excel with a Subscription report.
It shall give you the desired data.
How do I see the customers who accepted the offer on a campaign?
How do I see the customers who accepted the offer on a campaign?
You can find customers who accepted the offer in campaign, by going to Loop > Analytics > Reports > Subscription Activity Logs. Please apply the relevant filters and review the attributes in the Data column. Also, make sure to adjust the Created At date to show results from a specific date onwards.
How to export a report of cancelled and paused subscriptions?
How to export a report of cancelled and paused subscriptions?
To export all the customers that have cancelled/paused their subscription, please do the following:
Loop Admin > Analytics >Reports > Subscription. (Add filter Status = Pause and Cancelled). Then export the report.
What is the easy way to calculate the actual retention, because some people had to drop off because of the payment processing or the delay in their order?
What is the easy way to calculate the actual retention, because some people had to drop off because of the payment processing or the delay in their order?
The easy way to calculate the actual retention is:
Go to Loop Analytics > Reports > Subscribed Products > Filter by the specific selling plan
Export the report (This will give you a list of all subscriptions under that plan, including statuses.)
Export the subscription list (if you need payment details or other info). This gives additional fields like payment status, etc.
Combine the reports
Use VLOOKUP (or XLOOKUP) in Excel/Sheets to match subscriptions with their payment/status details.
Is there any way to get the information on how many subscriptions were added/sold via the different sources (Upsell Profile, Quick Actions)?
Is there any way to get the information on how many subscriptions were added/sold via the different sources (Upsell Profile, Quick Actions)?
We at Loop have started upselling performance data from March 10, 2025, so the reports won’t include anything before that date.
However, there’s a workaround for Upsell > Added. Here’s how you can view it:
Go to Analytics > Reports > Subscription Activity Logs
Apply a Date filter
Apply a Type filter and select Product Added
Apply a Source filter and select Customer Portal
This will give you the view you’re looking for
How to extract data of each product that was sold along with the quantity?
(we are trying to understand how much of each product we need to prepare with out manually looking at all orders in Shopify)
How to extract data of each product that was sold along with the quantity?
(we are trying to understand how much of each product we need to prepare with out manually looking at all orders in Shopify)
To access the report, which shows you the products that were sold in the subscription, please go to Analytics > Reports > "Subscriber Distribution by Product". There, you will be able to see how many subscribers have subscribed to each specific product and the quantity subscribed for each.
How to find the report for the total payment attempted and payment realized?
How to find the report for the total payment attempted and payment realized?
To fetch the report for the total payment attempted in the last x days, head to the Analytics > Reports > Transactions logs > apply filter as "status" - Success + failed
Similarly, to check how much payment was realized out of the total payment attempts, just remove the filter "status" = failed and select "success" only, and it will show all the transactions that were successfully realized for the subscriptions.
How can we see the subscriptions that were auto-resumed on a particular day from the report?
How can we see the subscriptions that were auto-resumed on a particular day from the report?
To see the subscriptions that were auto-resumed on a particular day, you can utilize the "Subscription activity logs" report. This report will allow you to track the reactivated subscriptions within the specified date period you are interested in. You may need to filter the logs to identify the specific date you are looking for
How do I understand the forecast- revenue report?
How do I understand the forecast- revenue report?
The forcast revenue report located at Analytics > Orders is simply a calculation of queued up charges and is only built on the basis of the upcoming order that are to be processed in the time frame. This doesn't account the cancellation rates, but only dunning vs non-dunning.
How to fetch a report where I can see the % of churn for the subscribers, per month, on a time period of 12 months?
How to fetch a report where I can see the % of churn for the subscribers, per month, on a time period of 12 months?
To create a report showing the percentage of churn for subscribers per month over 12 months, you can use the Cohort analytics feature.
Here’s how you can do it:
Access Cohort Analytics: Navigate to the Cohort Analytics dashboard in your analytics section.
Set Time Range: Use the time range filter to set the period to the last 12 months.
Select Metrics: Look for metrics related to churn and retention. You can track cohort retention and churn across the specified time frame.
Analyse Data: You can analyze customer behavior at both monthly and order-level precision, which will help you understand how subscribers behave over time and identify churn patterns.
This will allow you to see the percentage of subscribers who remain active each month and help you evaluate churn trends effectively
How can we find the subscriptions that were auto-resumed on a particular day from the Subscription Activity Log?
How can we find the subscriptions that were auto-resumed on a particular day from the Subscription Activity Log?
We can find the subscriptions that were auto-resumed on a particular day from the Subscription Activity Log:
Steps: Loop Admin > Reports > Subscription Activity log > Filter through date and add filter (Type = Subscription Resumed)