Skip to main content
Solved

How to do RFM analysis in Amplitude?

  • July 4, 2023
  • 1 reply
  • 529 views

can anyone tell me how to do RFM analysis in Amplitude?

 

related links

https://amplitude.com/blog/customer-lifecycle

https://www.investopedia.com/terms/r/rfm-recency-frequency-monetary-value.asp#:~:text=The%20recency%2C%20frequency%2C%20monetary%20value%20(RFM)%20model%20is,%2C%20the%20better%20the%20result).

Best answer by Saish Redkar

Hey @akravchenko 

I haven’t personally done RFM analysis in Amplitude, but looking at that it seems like it’s ideally done on a event which captures purchase / key value proposition events from your end customer.

Here’s how I would go about breaking down each phase roughly -

  • Recency
    • This can be done by tracking the last purchase either via a custom property or via Computations
  • Frequency
  • Monetary value
    • This becomes an easy metric to calculate if you are triggering revenue events with the revenue captured as the relevant property

All these can be summarized using Data Tables to get the desired results in a tabular format.

By no means this is the best approach, since there could be several different ways to tackle this in Amplitude.


Hope this helps.

View original
Did this topic help you find an answer to your question?

Saish Redkar
Expert
Forum|alt.badge.img+10

Hey @akravchenko 

I haven’t personally done RFM analysis in Amplitude, but looking at that it seems like it’s ideally done on a event which captures purchase / key value proposition events from your end customer.

Here’s how I would go about breaking down each phase roughly -

  • Recency
    • This can be done by tracking the last purchase either via a custom property or via Computations
  • Frequency
  • Monetary value
    • This becomes an easy metric to calculate if you are triggering revenue events with the revenue captured as the relevant property

All these can be summarized using Data Tables to get the desired results in a tabular format.

By no means this is the best approach, since there could be several different ways to tackle this in Amplitude.


Hope this helps.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings