Understand your WOOCOMMERCE data through subdivision art

The longer the business store, the more data you generate, but when you are the first When you open the store and find your own foothold, you have almost no data: there are no orders, no customers -only infinite potential. As your business grows and orders start, the amount of data you processed daily is exponentially growing.

The first five, ten, or even a hundred orders are easy to handle -you may remember every customer and place an order in your mind! But analyzing the data of the store from memory cannot really expand.

I have a sentence not only applicable to the e -commerce world, but also any problems you encountered when operating business:

The first thing to make anything better is the first The step is to understand it .

I want to talk about your Woocommerce data through segmentation art. Once you master the data segmentation, you will start looking at your stores and customers with a completely different perspective. These revelations can be used to take action on your data, whether it is determined which products need to be replenished, or actively find orders you need to pay attention.

We will start with the basic knowledge and importance of subdivided segment Whether Metorik may be a good supplement to your store.

Understanding the importance of data segmentation

What is segmentation, why is it important to understand and segmented data?

Segmentation refers to the subset of you obtaining data and using a filter to obtain the data. For example, if we want to figure out which orders are more than $ 100, we will do this by filtering them by total. This will provide us with a

subset

or order Section . Why is the subdivision so valuable and important?

It allows you to quickly

    Answer the complex questions about your business

  • . For example: \”How many orders do I have?\” Or \”How many customers do I have in a country or state?\” It can help you make
  • Marketing

  • . For example, find VIP customers who have not been ordered for a while to contact them. It can be used for
  • to detect and observe the trend

  • . One example of this may be that the customer is using a certain payment method or the transporterIt often costs more money when the formula. It enables you to position some orders or customers when you need
  • . So hypothetical, if a specific product has a packaging error within a month, you can target all these orders to let customers know that they should return.

  • It makes customer support
  • easily. Segmentation allows you to filter customers according to detailed information such as street addresses and phone numbers.

  • The box is used immediately, and the segments are not easy.

Impossible. It involves thousands of accurate details in a few seconds, usually millions of data points. WooCommerce, SHOPIFY and all other e -commerce systems only provide basic subdivisions in their instrument panels because it is difficult to do well.

Why is this? Technically, this is a challenging thing. One of my favorite Woocommerce functions is that you can have and host all data. But a problem is that most servers used by stores cannot handle complex data query. Even if you can subdivide in the dashboard, you are facing real risks that affect the performance of the store and close the store. I have seen and experienced this situation many times. This is not just about division. After mastering the data, you need to be able to quickly export segment data, create preserved segments for future use, share segments with your team, and view segmented counting and key performance indicators (KPI). This is a measurement for evaluation The success of an enterprise. Segmentation is not the core function of any platform, because it needs to focus and focus.

How to start the data of the store

Segmentation is a technology you can use now, maybe you have done it unknowingly for a while. There are many different methods that can be segmented in built -in Woocommerce and through extended data.

First, when the order is involved, you can use the built -in filter of Woocommerce [ 123] Customers who are based on the order status, the month of the order, and the order in the order segmented the order.

When more controlling the date is needed, there are some free expansion

may be helpful, such as the woo order of the WOOOSS.ORG on WordPress.org Range filter plug -in.It allows you to choose a specific date range to filter orders, or some common date range, such as \”past 14 days\”.

WooCommerce 内置过滤器的屏幕截图

If you have technical capabilities, a choice is Run the original SQL query on the store’s database

. By connecting the Order table to the POST Yuan table, you can run the query so that you can view all orders from a certain city or more than a certain number of orders. But this may be a time -consuming manual process. If you don’t know what you are doing, you may mess up your data. This is a great blog post, which can be used as your starting point, including a SQL query example. The query returns to a certain product

During Woo Orders 日期范围过滤器插件屏幕的视图 all the dates

The order has been completed.

The most common method is to export the data to CSV, then

Use Excel or Google table filter electronic table data . Using functions and custom formulas, you can use CSV files to do a lot of things. All these are good entry methods, but you may encounter some restrictions: may not have enough fields to be filtered (it is difficult to export customers to buy customers in CSV format to buy The category or order \”Recommended site\”.

If you segmented the outdated CSV, it may not allow you to use real -time data. You cannot save the subdivision or filter to so as to use it to use it to use it to use it to use it to use it to use it to use it to use the filter to use it to use it to use it to use it to use the filter to use it to use it to use the filter to use it to use it to use it to use the filter to use it to use it to use it to use the filter to use it to use it to use it to use the filter to use it to use it to use the filter to use it to use it to use the filter to use it to use it to use it to use the filter to use it to use it to use the filter to use it to use it to so as to use it to use the filter to use it to use it to use the filter to use it to use it to use it to use the filter to use it to use it to use it to use the filter. It is convenient for reuse.

You need to run each segment one by one.

  • In order to solve these restrictions and raise the Woocommerce data segment to a new level, I decided to build it A solution. It is called Metorik, which makes WOOCOMMERCE subdivided into any store or skill level.

Metorik: Promoting the wooocommerce data to the new level

The core of Metorik is to try to be your WooCommerce co -pilot. It through comprehensive reports, useful integration, and the most important thing is its powerful strong. The subdivision system to do this. The core concept behind the metorik division system is its unlimited custom filter construct . You firstSelect the field to be filtered.

1. Select the field you want to filter

You can use the field according to your subdivided content. For orders, you can subdivide according to attributes, such as the number of products in the order, the products, transportation methods included, and even the custom of the element key.

You can use the fields of customers to segmented the client, including the value of the customer’s life cycle, the time they ordered the last time, and the category they purchased.

动画显示如何选择要过滤的字段

Please keep in mind that in Metorik, you can divide almost all Wooocommerce data, including:

动画显示您可以分段的各个字段

[

123]

第二个动画显示您可以过滤的内容

Command

Customer Product Changes

[ 123] Category

  • Coupon
  • Refund
  • 2. Select the role and value After the field, Metorik allows you to choose the role and value. The character varies depending on the field type, but the character will be shown below for digital fields like customer total expenditure:
  • After selecting Essence
  • But you usually want to segmented the data through multiple filters and combine multiple filters when constructing segments. Metorik allows you to stack multiple filters together by clicking + icon.

Although the creation segment is a relatively fast and simple process, it is annoying to do this every time you want to subdivide. Therefore, this is one of the most important features: preserving custom segmentation for future use .

3. Save and reuse custom segment

When saving custom segmentation, you can choose whether to want it to want it Only available for you or your entire team. If your entire team can access it, they will be able to choose it from the preserved subdivision list. To better, you can share the URL of your page, and this paragraph will automatically apply to anyone who visits the link.

动画显示如何点击加号图标

Therefore, you are creating segments to save them for reuse, and may even share them with your team. But when it comes to reusing them, there are unlimited use of details.

保存和重复使用自定义细分 Customers, orders, subscriptions, etc. all have their own details. If we want to visit customers, it looks a bit like this:

The top part- Family friends -The self -created self -created self -created self -created Define part. But other: VIP, returning guests, etc. are the suggestions that Metorik will generate for you, and different from the past performance of your store. Let’s take a look at Backer subdivision:

保存自定义细分时,您可以选择是否只对您或您的整个团队可用

This will show us all customers who have passed more than one order from the store.

For each subdivision on the subdivision page, you will find the number of resources currently belonging to the subdivision (in this example) and some of its statistical information. These statistical information will be Divided different. For the subscription details, you can see some valuable KPIs that are particularly subscribed to, such as each subdivided monthly recurring income (MRR).

显示客户、订单、订阅等各有自己的细分页面的图形

Please remember that the segment is only part of the process of this process —— Once you have segmented data, it is also important to operate it.

There are several ways to allow you to do this in Metorik, but I see that many people do are 放大查看回头客细分 Export segmentation data

, and then send them to customers by email.

4. Export the data segment for further use

When guided in metorik, you have two options: Immediate export of export Regularly export regularly in the future

显示订阅段的表格,包括 MRR 和 ARR The option you choose vary from you. After exporting, I usually recommend using batch email services you choose, such as Mailchimp or Campaign Monitor. Once the segment list of emails is there, you can send emails to everyone immediately.

But this may be a bit troublesome, especially if you want to automatically contact customers in the market segment regularly.

In order to solve this problem, I have been developing a new feature called English for Metorik. The idea behind this can be described in a few steps:

  1. Create a subdivision.

  2. Emails that will be sent to customers matching the market segment.

Whenever a customer, order or subscription matching and subdivision, automatically send the email in the second step to them.

I have been trying at some stores that use Metorik, and I am very excited about the results. In some cases, I saw that a single automation/email had sent about 2,000 times and produced a sales of more than $ 100,000.

If you are interested in trying to use English, please contact me through Metorik’s real -time chat after the test, and I will enable you to use the test version!

When you communicate with customers who are interested in your store through the order, make them the next order is much easier to get a brand new customer. However, only when you have the ability to subdivide customers can you realize this interaction. ———————

  1. Starting from the first day More income
  2. Segmentation is an indispensable technology for each shop owner, but you don’t have to panic from the first day of this day. Remember it, and take priority as your growth. The more data you have, the easier it is to subdivide and get income from the existing customer base.

Author:

Leave a Reply

Your email address will not be published. Required fields are marked *