Roboteka
Roboteka · Fields · Customer LTV

Customer LTV

Customer LTV is a Bitrix24 (Alaio) custom field: it shows the total, count and average check of customer purchases in the contact or company record — from won deals or paid invoices — with the last purchase date and dormant customers highlighted. Periods, a pipeline filter and a rights mode are configurable; everything is computed server-side.

Total, count and average check of customer purchases right in the record — from won deals or paid invoices, with dormant customers highlighted by how long ago they last bought.

What gap it closes

A contact or company record in Bitrix24 (Alaio) lists the deals attached to that customer, and stops there: nothing adds the amounts up, and lost deals sit next to won ones. The lifetime total exists only in CRM reports, as a slice you have to leave the record to build. The Customer LTV field answers the question in place — total spend, number of purchases, average check and the date of the last one — and flags dormant customers.

How to set it up

  1. Attach the field to a contact, company, deal or lead record, then open gear-icon settings (admin-only).
  2. Data sourceWon deals by default, or Paid invoices.
  3. Whose LTV (on a deal/lead record) defaults to Automatic (contact, else company); pin By contact or By company instead.
  4. Period defaults to All time; also Current year, Previous year, Last N days (number in N days (for "Last N days")).
  5. Deal pipeline ID (empty = all) narrows the calculation to one pipeline.
  6. Dormancy threshold, days (0 = no coloring) is 180 by default.
  7. Calculate on behalf ofCurrent employee (their access rights apply) (default), or App installer (everyone sees the same numbers).

If the field stays empty

There is nobody to count: the deal or lead record has no contact and no company attached. Attach the customer first.

The purchases exist but the settings cut them off — a pipeline ID from another pipeline, or a period shorter than the age of the last deal.

The employee cannot see those deals. Under current-employee rights the field only sums what that person may open; switch to the installer mode.

Works together with

Field settings

Parameter Required?
Data source
Whose LTV (on a deal/lead record)
Period
N days (for "Last N days")
Deal pipeline ID (empty = all)
Dormancy threshold, days (0 = no coloring)
Calculate on behalf of

Related field types

Related articles