👉 Start Your 14-Day Trial 👈

The purpose of this article is to describe how one could create a custom report on a HubSpot dashboard to visualize the number of SMS messages sent & received by the HubSpot contact owner.

Let's be real, who doesn't want pretty graphs to visualize actionable data.

Here's an example of the reports you can run once you set this up...


Step 1: Create Your HubSpot Custom Properties

First, you will need to create a few HubSpot Custom Properties in order to start to track and calculate your SMS messages that occur on Salesmsg.

Property Name

Field Type

Salesmsg: Last SMS Received Date

Date picker

Salesmsg: Last SMS Sent Date

Date picker

Salesmsg: Total SMS Received Count

Number (unformatted)

Salesmsg: Total SMS Sent Count

Number (unformatted)

Step 2: Create Your Workflows

To set this up to track your sent and received texts, we'll need to create two Workflows.

Workflow #1: Track SENT Text Messages

Trigger

By creating this Trigger, any sent SMS on Salesmsg will enroll the contact in this Workflow.

Next, be sure to set the Re-Enrollment to run anytime the criteria is met.

Action 1: Set the Last SMS Sent Date Property

  1. Select Set property value

  2. Select Salesmsg: Last SMS Sent Date property

  3. Select Date of step.

Action 2: Set the Last SMS Sent Date Property

  1. Select Increase or decrease property value

  2. Select Salesmsg: Last SMS Sent Date property

  3. Select Date of step.


Workflow #2: Track RECEIVED Text Messages

Next, be sure to set the Re-Enrollment to run anytime the criteria are met.

Trigger

By creating this Trigger, any Recieved SMS on Salesmsg will enroll the contact in this Workflow.

Action 1: Set the Last SMS Received Date Property

  1. Select Set property value

  2. Select Salesmsg: Last SMS Sent Date property

  3. Select Date of step.

Action 2: Set the Last SMS Sent Date Property

  1. Select Increase or decrease property value

  2. Select Salesmsg: Last SMS Sent Date property

  3. Select Date of step.

That's it! Now turn ON your Workflow and it'll work automatically from here on out.

Salesmsg will populate your new HubSpot properties with data like this...


Frequently Asked Questions

What is the difference between this and Salesmsg Analytics

This report shows you messages sent or received by the total amount of a single message regardless of the size or type of message.

Does this track the total amount of messages that are sent from workflows as well as one-off messages my team executes?

This tracks any and all messages sent or received as long as the contact who is involved in the correspondence has a valid Salesmsg x HubSpot user as their contact owner.


Related Articles


Need Help? ✋🏻

Contact us on live chat or send an email to us at [email protected].

Did this answer your question?