Project Overview

Your task, should you choose to accept it, is to build a Customer Summary Report. It will need the following data (this should be columns that, when read across, form one row in this report):

  • Customer Name
  • A hyperlink to the Customer record in Books
  • The Customer’s first purchase
  • The Customer’s last purchase
  • Their invoice total (closed $$) from the last 12 months
  • Lifetime invoice total (closed $$)
  • Customer Status
  • Customer Owner (CRM Account Owner)

Much of this data you can find elsewhere throughout the Zoho Suite but it is very useful to have it all aggregated up in one place. On the Customer record in Books, it would be a little difficult to quickly see the First or Last purchase. There is a widget to be able to see purchases in the last 12 months, but not lifetime totals. (Add a user filter to this report to be able to quickly search by name for the right account.)

In addition, beyond the insights you can find for just one customer, there are some very cool reports you can build using this data:

  • You can create timelines of “First Customer Purchases” to see how old your customers are as a whole. Do you notice any patterns?
  • Add up 12 Month Invoices or Lifetime total by Account Owner to see who is producing the most revenue for your company.
  • Create reports to see which of your Customers haven’t bought in a while (using the Last Purchase column)
  • And of course, you can modify the SQL any way you want in order to create other reports.
Back to Lesson