Bitrix24: Calculating customer revenue on the fly

Calculating customer revenue in super-CRM Bitrix24 is not a big problem. You may find a lot of reports telling you that number. But! What if you want to use that amount as a trigger for business processes? What if you want to have it as a field of the table of customers?
In this video, I will explain to you very quickly how easy you may do such tiny customization.

Order Bitrix24 here, please:
Business process “If the customer has paid more than some certain amount, set the task to call him. If the cumulate payment is less, then send him an up-selling letter”: Download it here.
Webhook source code on GitHub.

The transcript of the video:

Bitrix24 has many reports, dashboards, and… some kind of analytics.
Look here…
And… Here… Isn’t it beautiful?
But… What if I want to see customer revenue?
First of all, it’s interesting.
Second, you may run business processes based on that knowledge.
Third, ABC analysis of customers or… Pareto analysis… What else?!!!!

Metrics you should be using to measure retention:
Customer Lifetime Value (CLV)
Customer Retention Rate
Repeat Purchase Rate
Redemption Rate

Measuring loyalty:
Repurchase Ratio
Upselling Ratio
Customer Loyalty Index (CLI)
Customer engagement numbers.

We can show you how to connect your Bitrix24 to Google Sheets or even to Data Studio but will do it in another video.
Now… Let’s ask ourselves: do we have customer revenue in Bitrix24? Maybe here [Company form]? No.
Or here? That is an ‘Invoice by company’ report. But this is a dynamic report. It shows you the number and doesn’t give you any freedom to use that number anywhere else! You literally can’t use it in any automation.
But! What if we do a custom field and… a tiny Webhook? Don’t be afraid! The devil is not as black as he is painted. Webhook is nothing to be scared of. I’ll definitely tell you about this powerful tool in a separate video!
Here it goes:

  1. Open Company form.
  2. Create a money field.
  3. Remember that number of your custom field.
  4. Create a webhook with the following algorithm:
  5. Has the invoice just been closed?
  6. Fetch invoices for that company for the current year.
  7. Updating company by the amount calculated.

That’s it!
Now you may use this field in many cases. For instance:
Look at this business process:

  1. If the revenue of a particular company greater than a certain amount,
  2. Set the task for your sales manager: call that customer after one week,
  3. If amount is less than minimum, send this customer some upselling letter!

As always, all scripts, reporting forms, and business processes you may find at the bottom of this video. Totally free!
If you want consulting or development regarding your Bitrix24, don’t hesitate to tell me about it.
If you want to raise your own skills, stay tuned to my channel and press Like. Right now I have a media plan for 20+ videos.
See you there!

Useful posts:

Customizing Bitrix24 by webhooks

Bitrix24 in Quora. Analysis

Originally published at




Entrepreneur. Investor. CRM consultant. No-code developer. UX/UI designer. Bitrix24, Salesforce, Webflow, Tilda Publishing, implementer.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Female Disruptors: Kathryn Mullen of GODDESS MAGAZINE TV On The Three Things You Need To Shake Up…

How to Use Facebook as a Digital Marketing Platform

Is Your Analytics Software Eating Up Your Productive Hours?

Why I sold my Clubhouse invite

Tracking Instagram mentions and its advantages

Write For ROI Overload

Approaching a Decade In Sales; and notes on calls, emails, social medial, snail mail, etc…

How to Improve Website Page Speed Test & Google Pagespeed Insights Tutorials

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Dmitriy Slinkov

Dmitriy Slinkov

Entrepreneur. Investor. CRM consultant. No-code developer. UX/UI designer. Bitrix24, Salesforce, Webflow, Tilda Publishing, implementer.

More from Medium

Lia Grimberg: Customer Loyalty and Insights

FMCG Micro-Influencer Marketing Tactics To Acquire And Retain Consumers

Portfolios: Showcasing the Best Assets

Ornate dinner room with white statues and artwork hung on the surrounding red-orange walls with a centered long table for seating 16+ people

Customer Loyalty in Automotive Industry