Reports let you download the data you need for back-office operations, quick analysis, and decision-making around marketing spend, product management, and subscription retention. You can use reports to pull data on subscribers, orders, payments, cancellations, inventory, and more, then apply filters to narrow down exactly what you need.
Types of reports in Loop
Loop provides a wide range of reports across different categories. Each report serves a specific purpose, from tracking subscriber activity to analyzing revenue and inventory. The table below lists all available reports and what each one covers.
Report | Description |
Subscribers | List of subscribers with details like subscription status, subscribed products, next order date, total spent etc. |
Subscriber summary | Track subscriber performance over time with daily, weekly and monthly aggregated view. |
Subscriptions | List of subscriptions with customer, shipping, payment, products, discounts and next order details |
Subscriptions summary | Track subscriptions performance over time. |
Subscription activity logs | List of events occured on subscriptions with timestamp, source and related data. |
Upcoming orders | List of upcoming subscription orders scheduled to be processed in the selected time period. |
Checkout orders | List of subscription orders directly placed via Shopify checkout. |
Processed orders | List of subscription orders processed with customer, shipping and payment related info. |
Skipped orders | List of subscription orders skipped with customer, product and payment related info. |
Checkout order line items | Track and analyze line items of checkout orders. |
Processed order line items | Track and analyze line items of successful processed orders. |
Subscription orders funnel | Track the complete order funnel to understand the revenue leakage due to actions like reschedule, skip, pause, cancel and payment failures. |
Subscribed products | List of subscriptions with detailed product info like price, quantity, discounts etc displayed row wise. |
Subscriber distribution by product | See active and cancelled subscribers by product. |
Bundle orders | List of all bundle orders with customer, products, pricing & discounting details. |
Bundle sales | Track bundle sales performance over time. Data is available from March 21, 2024 onwards. |
Transaction logs | List of transactions processed via Loop with subscription, customer, order and payment related info. |
Transaction summary | Track recurring order transactions performance over time with daily, weekly and monthly aggregated view. |
Product wise acquisition | Track subscription acquisition performance at product and variant level. |
Subscription sales | Track subscription sales performance over time. |
Product wise sales | Track subscription performance at product and variant level. |
Product wise upsells | Track product wise upsell performance across different channels and purchase options. |
Product wise upsell revenue | Track product wise upsell revenue across different channels and purchase options. |
Upsell profiles product wise performance | Track product wise upsell profile performance across different purchase options. |
Upsell profiles product wise revenue | Track product wise upsell profile revenue across different purchase options. |
Product variant wise cancellation | See product variant wise cancellation data. |
Cancellation logs | Track and analyze subscriber cancellation actions and data. |
Inventory forecast | View projected quantity of subscription products that will be sold in the selected time period. |
Product out-of-stock summary | Review subscription products which were out-of-stock. |
Inventory logs | List of all events due to low inventory (skipped, delayed, partially billed) along with order and product details. |
Prepaid credit transactions | List of all credit transactions for prepaid subscriptions with customer and order info. |
Upsell quick actions product wise performance | Quick action wise performance |
Upsell campaigns product wise performance | Campaign wise performance |
Subscriptions enrolled in Streak | Track subscriptions enrolled in a Streak program |
Streak cohort wise performance | Track streak program overall performance grouped by acquisition month. |
Streak order wise performance | Track streak performance at order level grouped by acquisition month. |
How to generate a report
Navigate to Loop admin > Analytics > Reports, then click on the report you want to view. For this example, we will use the Subscriptions report.
Click on the column filter you want to apply. For example, to see subscriptions that are active or paused, search for the "status" column, then select Active and Paused.
Click Apply Filters. The report updates to show only the filtered results, and you can export the data from here.
FAQs
How can I export product SKUs using reports?
How can I export product SKUs using reports?
You can view the upcoming product SKU report by navigating to Loop > Analytics > Reports, and then selecting Inventory Forecast.
This section will provide you with a detailed view of upcoming order products along with their associated SKUs, helping you get the insights you need.
Is there a way to export an email list of all subscribers to a specific product?
Is there a way to export an email list of all subscribers to a specific product?
In the Subscription Report, you can apply the Product filter. This will fetch all subscriptions that include that specific product. Once filtered, you can export the report for your records.
What report would be best for us to make to show us the success and churn rate of a few customers impacted by flows?
What report would be best for us to make to show us the success and churn rate of a few customers impacted by flows?
To see a report for customers churned based on flows:
Go to Analytics > Reports > Subscriptions.
Apply the filter for 'Subscribed product', 'status', and 'orders completed to date'.
Export and download this report.
Go back to the Reports section.
Select Subscription Activity Logs.
Apply the filter: Entity > Loop Flows.
Export and download this report.
In the data column, you will see the flow name. Filter this data according to the flow in the Excel sheet.
Use VLOOKUP to match the Subscription ID across both datasets
This will allow you to identify how many customers churned.
Why is there a discrepancy in the data of the product acquisition report and the subscriptions report?
Why is there a discrepancy in the data of the product acquisition report and the subscriptions report?
About a discrepancy in Product Acquisition Report and Subscriptions Report
In Analytics > Products we show the quantity of product present during acquisition of a subscription. In other words, what quantity of product was present in the checkout order that created the subscription.
The subscription report simply shows the current status of the subscriptions.
How can I export the email addresses of customers grouped by their subscription order count?
How can I export the email addresses of customers grouped by their subscription order count?
To export the email addresses of customers grouped by their subscription order count, you need to follow the steps below:
First, go to Loop Admin Page > Analytics > Report > Subscriptions > Filter by Report > Order completed to date > Export the subscription report.
From the Report > Segment mail > Once grouped, extract the email addresses for each group and use them for your segmentation.
Need help?
No worries - we're here for you!
If you have any questions or need assistance, feel free to email us at [email protected] or chat with us using the support beacon at the bottom right of your screen.
Regards,
Loop Subscriptions team 🙂