Get Slack updates on Monthly Recurring Revenue changes.

Overview

This template provides live Slack updates about your customers’ MRR changes. By tracking this metric, you will be able to effectively assess the performance of your product.

Prerequisites

We have put together a list of prerequisites that are recommended for this workflow. This will be different depending on your usage, but you can use it for reference.

• A Sales processes list that includes:

  • MRR currency attribute to track your workspaces’ MRR

  • Subscription Status status attribute

  • Billed Seat Count number attribute

• Slack integration

How to use this template

Once opened, you will see a series of connecting blocks.

1. The Attribute Updated block will be activated every time you update the seat count attribute of the records in your Workspaces object. To make sure this is set up correctly, we will need to select the Workspaces object and the attribute used to track an account’s MRR contribution.

2. The Formula block detects the updated MRR attribute and calculates for a change. In this case, we are calculating for an increase, so an example series of input would be:

   Description: Calculate MRR increase {New Value} - {Previous Value}

3. The Filter block decides which workspace records get passed to the next block. This filter is set to detect for workspace records where their MRRs have changed. We have outlined a recommended filter below:

   {Result} [is not] 0

4. The If/Else block will branch your workflow into two options, based on whether your attribute fulfills the filters set in this block. The condition set in this block is to check whether an increase has occurred. The reason we are using an If/Else block is to offer a place for the alternative answers, where the MRR has either decreased or been cancelled.

4.1. If the filter was true

i.) The Post Message to Slack Channel block sends a message to your designated Slack channel about the MRR increase. You can input whatever message you’d like, but here is an example that works:

MRR Increased Workspace {Record > Name} 
Product <{Record > Billed Seat Count} x {Record > Product} MRR Contribution ~ {Previous Value}~→{New Value}

4.2. If the filter was false

i) This If/Else block gets activated if the record MRR has not increased. This indicates that the status of your customer is either “Active” or “Cancelled”. This is a filter that checks for the subscription status. Here is an example filter input:

{Record} > Subscription Status[is] “Active”

i.i.) If the filter was true, a Post Message to Slack Channel will be triggered, which sends a message to indicate the record’s MRR decrease. The example input is similar to that of the increase:

MRR Decreased
Workspace {Record > Name} Product <{Record > Billed Seat Count} x {Record > Product} MRR Contribution ~ {Previous Value}~→{New Value}

i.ii.) If the filter was false, a Post Message to Slack Channel will also be activated. This is for the accounts who have cancelled their subscription (thus changing their MRR contribution). The example input for this is similar to the previous one:

MRR Decreased
Workspace {Record > Name} Product Cancelled MRR Contribution ~ {Previous Value}~→{New Value}