WooCommerce Subscriptions is a WooCommerce extension that allows you to create subscription-based products with recurring payments. If you are using the WooCommerce Subscriptions extension, you might also need to search and analyze your users’ subscription data and their activity. The WooCommerce Subscriptions module of Users Insights extends the default user fields, by adding the WooCommerce Subscriptions data to the user table and filters. Some of the available fields are the number of subscriptions for each user and subscription status. This module also provides the tools to search and filter your user list by various criteria, such as the subscription product that your users are subscribed to or the lifetime value of the subscribers.
Number of Subscriptions of each user
The “Subscriptions” field shows the number of subscriptions that each user has. You can sort the user table by the number of subscriptions, so you can find who the most or least active subscribers in your shop are. This field is also available in the Users Insights smart filters, so you can filter the user list by the number of subscriptions that they have. For example, if you want to find the list of your subscriber users, you can just apply a filter “Subscriptions is bigger than 0”:
Listing the Users’ Subscriptions Statuses
Another field that the WooCommerce Subscriptions module of Users Insights provides is the subscriptions statuses field. This field lists the statuses of all the subscriptions that each user has in the table. With this field you can easily visualize the statuses of your users’ subscriptions.
This field is also available in the Users Insights filters, so you can easily filter the user list by their subscription status. Here is an example of listing all the users that have an Active subscription:
And another example of listing all the users, that don’t have an Expired or Cancelled subscription:
Searching users by their subscriptions
With Users Insights you can easily search your users by the product that they are subscribed to. This can be accomplished by using the “Is subscribed to [product]” filter. When you use this filter, only the users who have an active subscription for the selected product will be displayed.
Another way to filter your users by their subscription is by using the WooCommerce module “Ordered Products” filter. When a user subscribes to a subscription product, WooCommerce also creates an order for the subscription. This means that you can use the default fields and filters of the WooCommerce module to further analyze your WooCommerce Subscriptions user data.
The difference between the “Is subscribed to [product]” filter and the Ordered Products filter is that the latter includes subscriptions with any statuses. This means that even the users whose subscription is inactive will be also displayed.
In the following example we have filtered the user list to show the users who have ordered a CSS Online subscription. This shows both active and inactive subscribers:
As shown on the screenshot above, this filter provides a list with all the available products that you can choose from. The product options can be also searchable when the list is long.
In a similar way you can also list all the users who have never subscribed to a particular product, by applying an “Ordered Products exclude” filter.
Another field from the WooCommerce module that you can use along with the WooCommerce Subscriptions is the Lifetime Value field. The value of this field is managed and updated by WooCommerce and is now also available in the Users Insights user table and filters. This field shows the total amount that each user has spent in the WooCommerce store, including the payments for subscription renewals.
You can sort the user table by the lifetime value of the users, as well as filter the user list by their lifetime value. Here is an example where we have applied a filter to show the most valuable customers:
Next Payment Date
As its name implies, the Next Payment Date field indicates the date of the next scheduled payment for each user. With this field available in the user table and filters, you can now easily find the users whose subscription is due for renewal. When the user has more than one active subscription, this field will contain the date of the most upcoming subscription renewal. You can sort the user table by the Next Payment Date column or use this field in the filters to segment your user list. Here is an example where we have filtered the user list to show the users, whose next payment date is in the next month:
Number of renewals
If your WooCommerce shop consists of subscription based products only, you can use the default WooCommerce module “Orders” field to find the indicative number of renewals. The Orders field shows the number of orders that each user has made. Every time a user renews his subscription, a new WooCommerce order is placed, which means that the number of orders field can indicate how many renewals each user has had.
Another example of how this field can be useful, is finding how many renewals users have had before cancelling their subscription. This can be accomplished by applying a filter to list the users that have a cancelled subscription and making the Orders field visible on the table:
Listing the subscriptions details in the user profile section
The Users Insights user profile section also includes some details about the user’s subscriptions. It lists all the subscriptions of the user, including the start date of the subscription, the products that the subscription includes, as well as the status of the subscription.
Each subscription links to its corresponding edit page, where you can view and manage all the subscription details. This section also includes a “View all” link that links to the WooCommerce Subscriptions list, filtered to show the selected user’s subscriptions.
Exporting the WooCommerce Subscriptions user data
Your user and subscription data lives in your WordPress database. Users Insights collects and organizes this data in a way that it is easy for you to manage and make sense of it. However, there are many situations when you might want to use different tools and applications to work with your user data. This is when the custom export feature of Users Insights comes in handy.
The custom export feature of Users Insights gives you the tools to create your own custom user exports contain only the users and the fields that you need.
For example, the results of all of the above-mentioned fields and filters can be easily exported in a CSV format. Once you apply the filters that you like and make the fields that you need visible in the table, you can just click on the Export button to export the current selection.
For example, if we want to find all the users that don’t have an active subscription and apply the following filter:
we can then click on the Export button, that will export the results in the same format as displayed on the table:
You can then use the exported user list to send emails to those users, create reports or just to keep a record.
Combining the WooCommerce Subscriptions features with the rest of the Users Insights features
All of the WooCommerce Subscriptions features can be used in any combination with the rest of the Users Insights features. For example, you could use the Geolocation module to detect your users’ locations. Or you could use the Groups feature to apply custom groups to your users and later search the user list by those groups.
Here is an example, where we have filtered the WordPress user list to find the users that have a subscription, that are from the United States and have been online in the past 30 days:
As you can see with the help of the WooCommerce Subscriptions module of Users Insights you will be able to easily search, filter and analyze your customer data. Being able to analyze your user activity and subscriptions data can be beneficial to both your store and customers in many different ways. This can help you learn from your customer data, so you can better understand your customers and improve your products and offers.