Black Thursday Iteration 5 - Customer Analytics

Back to Black Thursday Home

Our marketing team is asking for better data about of our customer base to launch a new project and have the following requirements:

Assuming we have a SalesEngine instance called sales_engine, let’s initialize a SalesAnalyst like this:

sales_analyst = sales_engine.analyst

1. Find the x customers that spent the most $:

sales_analyst.top_buyers(x) #=> [customer, customer, customer, customer, customer]

If no number is given for top_buyers, it takes the top 20 customers by default

sales_analyst.top_buyers #=> [customer * 20]

2. Be able to find which merchant the customers bought the most items from:

sales_analyst.top_merchant_for_customer(customer_id) #=> merchant

3. Find which customers only have only one invoice:

sales_analyst.one_time_buyers #=> [customer, customer, customer]

4. Find which item most one_time_buyers bought:

sales_analyst.one_time_buyers_item #=> [item]

5. Find which items a given customer bought in given year (by the created_at on the related invoice):

sales_analyst.items_bought_in_year(customer_id, year) #=> [item]

6. Return item(s) that customer bought in largest cumulative quantity.

If there are several items with the same highest quantity, return all items:

sales_analyst.highest_volume_items(customer_id) #=> [item] or [item, item, item]

7. Find customers with unpaid invoices:

sales_analyst.customers_with_unpaid_invoices #=> [customer, customer, customer]

Note: invoices are unpaid if one or more of the invoices are not paid in full (see method invoice#is_paid_in_full?).

8. Find the best invoice, the invoice with the highest dollar amount:

sales_analyst.best_invoice_by_revenue #=> invoice

sales_analyst.best_invoice_by_quantity #=> invoice