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)