Monthly Recurring Revenue

Filed under following categories:

Summary financial metrics

Most commonly used with the following data sources:

Pipedrive
Monthly recurring revenue or MRR measures the predictable income of a company for each month. MRR is usually used with subscription-based sales model.

Sample MRR algorithm for Gtmhub and Pipedrive CRM


# Get the reference to pipedrive deals entity
deals <- entity("pipedrive_deals")
# Take only deals that have been won
wonDeals <- filter(deals, lower(status) == "won")
# Calculate the amount of won deals
summary <- summarise(wonDeals,
    count = n(),
    total_value = sum(value)
)
# Retrieve findings from DB
summary <- collect(summary)
# Output findings
bookings <- summary$total_value / 12 # This assumes contracts are for 12 months
out(bookings = bookings)