Question
How can I create custom HubSpot dashboard reports that include text messaging information?
Answer
Using HubSpot custom dashboard reports, you can analyze records and activities in your HubSpot account across almost any dimension. Using the HubSpot text messaging integration from Sakari you can create custom reports that include text messaging.
The Sakari HubSpot text messaging integration pushes all sent and received text messages back to custom HubSpot contact properties. These properties can be used to create custom dashboard reports in HubSpot based on your text messaging activity.
In addition to the the Sakari-populated properties we recommend setting up two HubSpot workflows to populate the total send and received SMS quantity properties. This article covers how to create these two workflows: Total Sent and Received SMS Quantities
This article will cover how to create some of the most common text messaging reports in HubSpot.
Total SMS Sent by Contact Owner Donut Chart
The sum of text messages sent by Contact Owner.
Configuration
1. In HubSpot, in the top navigation menu go to Reports > Dashboards.
2. Click the Create Custom Report button in the top right.
3. Select a Single Object report type using Contacts.
4. On the Data tab, add the SMS Sent Quantity contact property.
5. Click the Visualization tab, select the Donut chart type.
6. In the Displaying section add the Contact Owner property.
7. In the Measured by section, add the SMS Sent Quantity property.
Total SMS Received by Contact Owner Donut Chart
The sum of text messages received by Contact Owner.
Configuration
1. In HubSpot, in the top navigation menu go to Reports > Dashboards.
2. Click the Create Custom Report button in the top right.
3. Select a Single Object report type using Contacts.
4. On the Data tab, add the SMS Received Quantity contact property.
5. Click the Visualization tab, select the Donut chart type.
6. In the Displaying section add the Contact Owner property.
7. In the Measured by section, add the SMS Received Quantity property.
Count of Contacts by Last SMS Sent Date
The count of contacts based on the last text message sent date.
Configuration
1. In HubSpot, in the top navigation menu go to Reports > Dashboards.
2. Click the Create Custom Report button in the top right.
3. Select a Single Object report type using Contacts.
4. On the Data tab, add the Message Sent At contact property.
5. Click the Visualization tab, select the Line chart type.
6. In the Display section add the Message Sent At property.
7. In the Measured by section add the Count of Contacts.
Total SMS Sent/Received by Contact Owner
The sum of total text messages sent and received by Contact Owner.
Configuration
1. In HubSpot, in the top navigation menu go to Reports > Dashboards.
2. Click the Create Custom Report button in the top right.
3. Select a Single Object report type using Contacts.
4. On the Data tab, add the SMS Received Quantity and SMS Sent Quantity contact properties.
5. Click the Visualization tab, select the Table chart type.
6. In the Displaying section add the Contact Owner property.
7. In the Measured by section add the SMS Received Quantity and SMS Sent Quantity properties.
Contacts Opted-Out By Date
The count of contacts that have opted-out of text messaging by date.
Configuration
1. In HubSpot, in the top navigation menu go to Reports > Dashboards.
2. Click the Create Custom Report button in the top right.
3. Select a Single Object report type using Contacts.
4. On the Data tab, add the Opted Out contact property.
5. Click the Visualization tab, select the Line chart type.
6. In the Displaying section add the Opted Out property.
7. In the Measured by section add the Count of Contacts property.