Bold BI

Getting insights from key Infusionsoft metrics

Tracking Sales Metrics with Infusionsoft

Infusionsoft, by Keap, is a sales and marketing automation tool for small businesses. It offers an all-in-one CRM and advanced marketing automation platform that lets users manage their small service businesses by pulling data points together related to sales, marketing, leads, payments, customers, and more. Bold BI allows them to connect Infusionsoft data with a dashboard to track their periodical sales metrics and KPIs, such as contact details, orders, subscriptions, and revenue progress.

In this blog, let’s see how to track periodical information of sales-related metrics like contacts, orders, subscriptions, and revenue through KPIs and visualize them using a Bold BI dashboard.

Infusionsoft sales dashboard
Infusionsoft sales dashboard

Defining sales metrics

The following are some sales metrics from Infusionsoft data that sales leaders can track to improve and ensure their performance:

  • Total contacts of converted leads.
  • Subscription and revenue rate.
  • Orders and subscriptions over a time period.
  • Top revenue through orders by date.
  • Payment status over a time period.
  • Revenue vs. refunds over a time period.

Let’s see how each of these metrics can be visualized through KPIs in a Bold BI dashboard that sales managers and executives can then use to track and measure the sales team’s performance to improve the revenue of their business.

Total contacts with converted leads

By comparing the number of contacts with converted leads between the current and previous months, team managers can take necessary action to improve in next month. They can reduce duplicate emails sent and increase open-rate emails about their services and product, for example.

Total Contacts
Total Contacts

Subscriptions and revenue rate

The following KPI card visualizes the subscriptions and revenue comparatively between the current month and the previous month.

Knowing the subscription count, sales managers can easily see which subscription plan gets less attention and why. This lets them focus on improving the subscription plan for more revenue.

Total subscriptions
Total subscriptions
Subscription revenue
Subscription revenue

Orders and subscriptions over a time period

Sales teams need this KPI to calculate how much revenue has been generated through order subscriptions over a time period. The line chart is best to showcase the trends over a time period with a straight line connecting the data points.

The total count of orders over a time period is showcased in an area chart. This KPI will provide information about the number of orders received during a time period, which lets you determine whether you’ve met the target or not.

Knowing this info, sales leads and executives can decide where to increase promotional offers in order to increase orders from customers, leading to increases in subscription revenue.

Subscription revenue over a time period
Subscription revenue over a time period
Orders over a time period
Orders over a time period

Top revenue through orders by date

This KPI lets you identify when the revenue through orders is increasing or decreasing. A grid widget with a status bar column is good to showcase this metric.

Top 10 best revenue days
Top 10 best revenue days

Payment statuses over a time period

The following column chart shows payment statuses over a time period. With this, a sales team can easily compare the values with vertical bars. This metric helps them identify:

  • When the count of unpaid customers increases or decreases.
  • Where customers struggle to proceed further to pay.
  • Which subscription plan did not perform as well as others.

With these metrics, they can plan next to convert unpaid payments to paid ones and improve their services.

Payment status
Payment status

Revenue vs. refunds through orders by date

This KPI showcases the revenue generated and refunds required over a time period. A stacked area chart is best to compare revenue and refund measurements through filled curves stacked one atop another. This lets users identify when the refunds increase and determine which batch of products align with that date to see if quality was compromised. They can then take necessary action to improve customer satisfaction through good quality product delivery to avoid returns.

Order revenue and refunds
Order revenue and refunds

Fetch Infusionsoft data

Infusionsoft provides REST APIs to fetch data from a Infusionsoft account. Connect to Infusionsoft and create a data source with appropriate APIs like in the following table.

Subscriptionshttps://api.infusionsoft.com/crm/rest/v1/subscriptions
Transactionshttps://api.infusionsoft.com/crm/rest/v1/transactions
Contactshttps://api.infusionsoft.com/crm/rest/v1/contacts
Ordershttps://api.infusionsoft.com/crm/rest/v1/orders

 Let’s see how to create a dashboard to visualize the discussed KPIs using Bold BI.

Creating Infusionsoft dashboard using Bold BI

Let’s start creating a dashboard using the Bold BI On-Premise solution.

First of all, if you are new to Bold BI dashboards, register for a free trial on our website. At the end of the registration process, you will reach the following page.

Bold BI On-Premise download page
Bold BI On-Premise download page

You can download the latest version and launch it in your machine. If you are not familiar with deploying Bold BI On-Premise, refer to this documentation. Bold BI On-Premise’s server will launch, as shown in following image.

Bold BI On-Premise welcome page
Bold BI On-Premise welcome page

Follow the steps from here to startup the Bold BI On-Premise application. After, the homepage will open.

Homepage view in Bold BI On-Premise application
Homepage view in Bold BI On-Premise application

Check out our tutorial video to learn how to create a dashboard from scratch. To create the Infusionsoft data source from the dashboard designer, click the Data Sources button in the configuration panel and select the Infusionsoft connection in the connection panel.

Once you’ve selected the Infusionsoft connection, an alert window will open to set the intermediate database for data storage. Click the settings hyperlink on the window.

Window to set the intermediate database
Window to set the intermediate database

The data storage setting page will open, as shown in following image. Configure your SQL server details and save.

Data storage setting page
Data storage setting page

After that, choose the Infusionsoft connection again in the connection panel. An alert window will open for OAuth configuration. Subsequently, click settings on the window.

Alert window to configure OAuth
Alert window to configure OAuth

Now the data connector configuration page opens. Select the Infusionsoft connection and configure the client ID and secret of your Infusionsoft account.

Data connector configuration page
Data connector configuration page

Now, you can create your Infusionsoft data source. Follow the steps in this documentation to create the Infusionsoft data source, add required widgets to your dashboard, and connect data to them to visualize metrics.

You can also use built-in Infusionsoft dashboard templates and prepare a dashboard in about a minute using Bold BI. Let’s see how to prepare an Infusionsoft dashboard to track sales opportunities by using the Infusionsoft opportunities dashboard template in Bold BI Cloud.

Building dashboard using a built-in template in Bold BI Cloud

To use the Bold BI’s built-in Infusionsoft dashboard template, click the + icon in the navigation bar on left side of your dashboard site homepage.

Add button
Add button

Select the Start from Template option. Then, choose the Infusionsoft opportunities dashboard template from the list. The Infusionsoft template dashboard will load with sample data.

Infusionsoft opportunities dashboard
Infusionsoft opportunities dashboard

This Infusionsoft opportunities dashboard is used to analyze your opportunities progress information and conversion rate based on the current month’s data.

You can also connect your own Infusionsoft data to the template dashboard by using the Connect Your Data option at the top of the dashboard. Click it to open an authorization window. Provide the requested authentication details like account name and project name. They are needed to authorize a connection to your Infusionsoft account from your dashboard. Then, click Continue to prepare the dashboard. Once the preparation process is complete, the current page renders the Infusionsoft dashboard with your data.

Conclusion

We hope this article helps you understand how to monitor sales metrics and KPIs to motivate your sales team with Infusionsoft using Bold BI dashboards. If you have any questions, please post them in the comments section below. You can also contact us by submitting your questions through the Bold BI website or, if you already have an account, you can log in to submit your support question. Bold BI dashboards now come with a 15-day free trial with no credit card information required. We welcome you to start a free trial and experience Bold BI for yourself.

Start your free 15-day trial today

Leave a Reply