Financial metrics is where the rubber hits the road. You can have nice website & do marketing campaigns. But financial metrics tell you the real story.
Site usage metrics tell you what works & what doesn’t on your site.Ecommerce businesses need to know how frequently & long your users use your site.
Here are are 5 key performance indicators to improve customer service.You can set goals to be achieved to improve customer service over time.
Here are 11 customer metrics that you can track for your Ecommerce business. To build a successful Ecommerce business it is important to understand customer behavior and preferences.
Every online business needs to increase conversion rate. Here are 9 Key performance indicators to boost conversion rate for your Ecommerce business.
MySQL Date format is a very handy function. It formats a date as specified in the argument. Here’s a cheat sheet for MySQL date format function.
MySQL date functions that help you directly get required part of date. Commonly used MySQL date functions. These MySQL date functions are easy to remember.
Calculate decile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders
You can calculate decile in MySQL to identify best customers. You can come up with more focused, relevant retention initiatives. Here’s a query to do it.
Calculate decile from frequency or counts in MySQL. E.g, to rank customers based on number of purchases or orders instead of total sales