Customize & Automate
Each store has different products and customers, and therefore different criteria regarding customer equity. To get better results, you need to take into account your own priorities.
That’s why Green Flying Panda allows you to define formulas using whichever variables suit your needs best.
Remember – your store is unique, so don’t depend on standard settings!
Customer Loyalty
Determine what makes a customer loyal to your store based on their activity! Here are some examples of customer loyalty formulas.
{number_completed_orders}>5
This means that customers who have completed more than five orders will be considered loyal to your store!
{order_average_days}<30
Customers will be considered loyal if the average interval between their orders is less than 30 days.
And many more!
Keep scrolling to see the full lists of variables you can use to define formulas!
Customer Variables
The tags below refer to each individual customer – they are replaced with real values when building the formulas.
| Variable | Value |
|---|---|
| {last_order} | Days Since Last Completed Order |
| {first_order} | Days Since First Completed Order |
| {account} | Days Since Registration |
| {number_reviews} | Number of Reviews |
| {number_orders} | Number of Orders |
| {number_completed_orders} | Number of Completed Orders |
| {percentage_complete_orders} | Percentage of Completed Orders |
| {order_amount} | Total Order Amount |
| {order_average} | Order Average |
| {percentage_order_amount} | Percentage Order Amount Compared with Global Average |
| {order_average_1year} | Order Average in the Past 1 year |
| {order_amount_1year} | Orders Total in the Past 1 year |
| {order_average_older} | Order Average before the Past 1 year |
| {order_amount_older} | Orders Total before the Past 1 year |
| {order_average_days} | Average of Days Between Orders |
| {shipping} | Total Shipping Amount |
| {taxes} | Total Taxes Amount |
| {subtotal} | Total Subtotal Amount |
| {discount} | Total Discount Amount |
| {profit} | Total Profit Amount |
| {refunded} | Total Refunded Amount |
| {cost} | Total Cost Amount |
Global Variables
These tags don’t refer to individual customers, but to global values or periods – they are also replaced with real values when building formulas.
| Variable | Value |
|---|---|
| {retention_rate} | Customer Retention Rate |
| {rate_of_discount} | Rate of Discount (Check the Extension Configuration) |
| {customer_lifespan} | Customer Lifespan (Check the Extension Configuration) |
| {global_orders_number} | Global Number of Orders |
| {global_orders_average} | Global Orders Average |
| {global_orders_number_average} | Average Global Number of Orders |
| {global_orders_completed} | Global Number of Completed Orders |
| {global_orders_amount} | Global Orders Amount |
| {global_cost_amount} | Global Costs Amount |
| {global_refunded_amount} | Global Refunded Amount |
| {global_shipping_amount} | Global Shipping Amount |
| {global_taxes_amount} | Global Taxes Amount |
| {global_profit_amount} | Global Profit Amount |
Periods Variables
Get current period, previous periods and date ranges from formulas!
| Formula | Returns |
|---|---|
| {global_orders_amount} | Combined Orders Amount from All Orders |
| {global_orders_amount[n]} | Combined Orders Amount from current period (year or month) |
| {global_orders_amount[n-1]} | Combined Orders Amount from previous period (year or month) |
| {global_orders_amount[n<1]} | Combined Orders Amount from previous periods before current minus 1 (year or month) |
| {global_orders_amount[n>1]} | Combined Orders Amount from previous after the specified (year or month) |
| {global_orders_amount[2017]} | Combined Orders Amount from the specified year (2017) |
| {global_orders_amount[>2017]} | Combined Orders Amount from years greater than the specified year (2017) |
| {global_orders_amount[<2017]} | Combined Orders Amount from years less than the specified year (2017) |
| {global_orders_amount[-90]} | Combined Orders Amount from the last 90 days |