With the export feature of Users Insights, you can create your own custom exports of your WordPress user data in a CSV format. You have the complete control over which users and fields to be included in your custom WordPress user export.
Exporting your WordPress users
The custom export feature of Users Insights works on the principle “What you see is what you get“, which means that your exported CSV file will look exactly like the current state of the Users Insights user table. All the advanced features and filters that Users Insights provides, such as selecting the visible columns in the user table, accessing the integrated plugins’ data, applying custom filters and selecting custom order are also available to be used when you create your custom user export.
Using the Users Insights custom export feature is very easy – it is available via the export button in the right options menu of Users Insights.
Clicking on the export button will open a dialog window asking you to confirm that you want to proceed with the export. If you confirm the export action, the export will start generating the file. Once ready, the CSV exported file will start downloading on your computer. If no filters are applied before doing the export, the exported file will include all of your WordPress users with the user data that you have currently displayed on your Users Insights table.
Here is a short video showing how the custom user export feature of Users Insights works:
Choosing which user data to be included in the CSV export
When using Users Insights, you can choose which fields and columns to be shown in the user table via the visible columns menu. This same feature can also be used to select which fields from the WordPress user data to be included in the export file. When you check/uncheck the different columns from the menu, those settings will be automatically saved for the export functionality as well. So, if you want a field to be included in the export file, you will have to make this field visible in your Users Insights user table before proceeding with the export. For example, if you have selected the following options in the Visible Columns section:
The exported file will look something like this:
Exporting custom user data from WordPress plugins
Since the Users Insights table doesn’t include only the default WordPress user data, but also custom user data from our 3rd party integrations (WooCommerce, Easy Digital Downloads, BuddyPress, Ultimate Member, bbPress, GravityForms), you also have the option to include custom user data from these plugins in your custom user export. If you use the WooCommerce plugin, you might want to export the WooCommerce related user data. For example, for each WordPress user you can choose to export the WooCommerce orders information, such as the number of orders and the date of the last order. If these fields are visible on the user table, your export file will then look like this:
Or if you use BuddyPress, you can export all of the BuddyPress activity information, such as groups info, friends, custom profile fields and activity updates for each WordPress user:
The username field is always added by default as an identificator for the user.
Exporting the Users Insights user data
The user table of Users Insights also includes all the fields and data that the plugin collects by itself, like user geolocation data, device detection data, and user activity data. This allows you to include this user data into your custom user export. Here is an example of export that contains the geolocation data of the WordPress users as well as the date of their last activity (Last Seen):
Exporting the WordPress custom user fields and custom user meta
The custom user fields feature of Users Insights allows you to extend the default WordPress user options and add your own custom user fields. Additionally, you can use the custom user fields to load already existing user meta data from your WordPress website. Since the custom user fields are automatically added to the user table, you can easily export the custom user fields and custom user meta of your WordPress users. Here is an example of an export of the custom user meta data (Secondary Email and Job Title) with the help of the Users Insights export feature:
Selecting the WordPress users to export
One of the key features of Users Insights is the ability to use the smart filters to create custom segments of your WordPress user list. Since the export feature of Users Insights integrates with the smart filters, you can use the filters to create your own custom exports that include only the users that you want.
The Users Insights filters allow you to apply custom filters to all of the available user data like:
- The default WordPress user data, such as username, name, email, date registered
- Additional data added by the Users Insights WordPress plugin, such as posts/comments created, last seen date and number of sessions.
- Fields added by the Users Insights integration modules including the Geolocation, Device Detection, WooCommerce, Ultimate Member, bbPress and BuddyPress modules data.
For more information on the available filters, please refer to the Available Fields and Filters page.
For example, if you have the following filter applied:
Only the WordPress users that have been recently active (in the last 30 days) will be exported:
Selecting the order in which the WordPress users will be exported
The sorting order applied to the Users Insights user list is automatically applied to the exported user file, so you can easily select the column to sort by and the type of the order (ascending/descending).
For example, if your Users Insights table is ordered by the number of comments created in descending order:
This will be the same order in which they will be exported:
There are many cases where you might need to export your WordPress user data. You might need to move your user data to a new website, or you might need to import your user data into a different system like a CRM, Analytics Tool or Email Marketing Software. Or you simply might need to create a report of your WordPress user activity. Whatever the use, having a tool that allows you to create your own custom user export that includes only the users and the user data that you need is a valuable thing to have.