I will do shopify sales analysis, customer segmentation and excel dashboards

Australia

I speak English

Excel and Google Sheets automation, Python and AI tools

I'm Ash, in Perth, Australia. I build small automation tools for online sellers and small businesses: Excel and Google Sheets reports that build themselves, website data collected into a sheet, PDF in...
About this Gig

Shopify sales analysis and customer segmentation, with Excel dashboards that show what to do next.


Treating every customer the same? I'll show you who your best customers are, who's slipping away, and what to do about each group, from your own order export (Shopify, WooCommerce, Amazon, eBay or a spreadsheet).


What you get: every customer scored on how recently and how often they order and what they spend after returns; segments such as Champions, Loyal, At risk and Lost, each with a suggested action; and monthly revenue, orders and new customers.


Proof: my demo on 541,909 real order lines from a public dataset (UCI Online Retail) found that 16% of customers brought 63% of revenue, and that 631 good customers were slipping away. I work by chat, with a written update at each step.

Technology:

Excel

•

Google Sheets

Analysis type:

Quantitative analysis

•

Descriptive analysis

Expertise:

Business Insights

•

Trends

•

Churn & retention

Programming language:

Python

•

SQL