Try for freeTry free
Catalog
Tools

Sales Analytics

Manager earnings leaderboard for the month in US dollars, with filters by office, employee and sales line. Data is pulled from your payments spreadsheet.

Vector Inc.Sales analytics

A manager leaderboard by earnings in USD. Once an hour the app reads the “Managers list” sheet from your Google receipts spreadsheets and builds a ranking for a month, several months or a year, with filters by office, sales line and employee and summaries by office and sales line. The spreadsheets must follow the required format.

How it is today

Manager earnings are counted in a Google Sheet, and employees see it in pieces or not at all. Assembling a ranking for a month, several months or a year by offices and sales lines is manual work.

What changes

A manager earnings leaderboard — right in the CRM, from your own Google Sheet. Everyone sees their place, the boss sees the picture by offices and sales lines, without manual assembly.

What you get

  • A manager ranking by earnings (USD) for a month, several months or a year
  • Data from your Google Sheet (the “Managers list” sheet)
  • Filters by office, sales line and employees; the period is months or a year
  • Syncs once an hour; the administrator can refresh manually

How to connect

  1. 1Enable the appFree, in the Marketplace. Setup is in Settings → Sales Analytics.
  2. 2Key and navigatorPaste the Google service account JSON key (“Save key”), then the link to the navigator spreadsheet: click “Load sheets” and choose the year sheets. In the navigator each month links to a spreadsheet with the “Managers list” sheet.
  3. 3View the rankingThe “Analytics → Sales analytics” section (pin it to the menu with the star) shows the ranking for the chosen period. Fresh data is pulled once an hour; manually — with the “Refresh now” button in the settings.