How To Set Up Your Infusionsoft Dashboard Reports

Leave a Comment / Infusionsoft / By

Most of what you do in marketing and in business doesn’t do you much good unless you can get reports on whether or not its working.

Infusionsoft is amazing because it stores all the data you need.  But it can be frustrating because the reporting capabilities are weak.

But one redeeming factor of Infusionsoft is the Dashboard.  When you know how to use the dashboard correctly, you can get a LOT of the data you need, right there on your dashboard.

Not only does the dashboard give you the data you need, but it can also be the place you go to keep track of tasks and actionable items.

First:

The first step is to determine what should be on your dashboard.  I recommend organizing your dashboard by function and then have the required data/action items in each function category.  Like this:

[vc_iconbox icon=”bullhorn” icon_style=”circle_solid” size=”small” title=”Marketing”]New Leads
Lead Source ROI
Lead Conversion
Campaign Performance
Email Stats
[/vc_iconbox]
[vc_iconbox icon=”usd” icon_style=”circle_solid” size=”small” title=”Sales & Financials”]Sales Pipeline
Sales Pipeline Forecast
Revenue Forecast
Failed Invoices
Accounts Receivable[/vc_iconbox]
[vc_iconbox icon=”thumb-tack” icon_style=”circle_solid” size=”small” title=”Operations”]Tasks
Staff Accountability
Client Monitoring
Broadcast Lists
[/vc_iconbox]

Second:

Once you’ve determined what you need on your dashboard, you need to set you your saved searches and report.

Searches can be done on records (Contact, Companies, Opportunities, Orders, Subscriptions, Referral Partners, and Visitors).

Reports can be run and saved on any of the standard reports under CRM -> Reports, Marketing -> Reports, E-Commerce ->Reports, or Admin -> Reports.

The process is the same for both.  It’s just important to know that there is a difference.

Here is the process:

  • Search based on the criteria you want to use to find a specific group of people.  You can use date ranges (usually under Misc Criteria), tags, product purchased, etc. in most searches and reports.

  • Determine the columns you want to bring into your search.  For example, if you plan on putting a stat on your dashboard like the “total amount collected” this month, you’ll need to make sure the “Pay Amt” column is in your “Payments Report” so you can sum up the totals.

  • Lastly, save the search by hitting the “Save” button after you’ve searched and found the records you’re looking for.  Give the search or report a name that will be easy to find.  Like tags, it’s important to use a simple naming convention to keep things organized.  I recommend starting the name with the category (Marketing, Sales, Operations, etc).

Third:

Once you have your saved searches and reports set up, you need to add them to your dashboard.

Some should be added directly to the dashboard as their own widget.  For example, I like to add the Monthly Payments report (sorted with the most recent month on top and showing about 6 months) to my dashboard like this:

report-monthly-payments

You can do this by adding the Saved Search or Saved Report widget to your dashboard, or just check the box when you’re saving the report:

report-saved-search-to-dashboard

But for many searches and reports, you’ll want to set up your own dashboard widgets with custom reports.   Here are the steps.

Click each point on the timeline to see the step details:

Step 1
Step 2
Step 3
Step 4
Step 5
Step 6
Step 7
Step 8
Step 9
Click the "Add Widget" button in the upper right hand corner of your dashboard: dashboard-custom-stats-1
Find "Custom Statistics" and then click "Add To Dashboard". dashboard-custom-stats-2
Select whether you are wanting a Saved Search or a Saved Report. dashboard-custom-stats-3
Select whether you want to show a count (number of records in the search), sum, average, maximum or minimum. When selecting a sum, average, maximum, or minimum, you'll be prompted to choose which column to use. dashboard-custom-stats-4
Select which type of record your saved search or saved report is in. dashboard-custom-stats-5
Select the actual Saved Search or Saved Report by the name you created. dashboard-custom-stats-6
The "Stat Title" will be filled in with the name of the Saved Search or Report. Edit if you'd like. dashboard-custom-stats-7
Either click "Save And Add" to add more stats or click "Save" to go back to the dashboard. dashboard-custom-stats-8
Click the "Rename" link to edit the name of this Custom Statistics box. You can add more boxes. So, create a box for each group of stats. dashboard-custom-stats-9
  •  Hint: Each Custom Statistics box can hold up to 10 stats.  BUT, if you click “Save And Add” on your 10th stat, there’s a glitch that’ll let you add an 11th stat.

So, that’s it.  It’s a few steps, but they’re not hard.  And, they’re totally worth the time investment.

P.S.  If you really want pretty graphical reports, we highly recommend checking out Graphly.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.