Master Your Infusionsoft Data

I have a couple questions to ask you –

1-repeat-customer

What is the churn rate for your subscriptions?
How many of your customers come back for a second purchase?
What are your most effective marketing channels?
How much can you spend per lead and still make a profit?
How many of your subscriptions are NOT being paid every month?
What is your most popular product? What is your most profitable product?
If you are like most small to medium businesses then you have a pretty good idea of the answer to each of these questions, BUT you aren’t sure if you are right.  If you are like most Infusionsoft users, then you know that the answer lies within Infusionsoft somewhere, but you don’t know where.
Knowing the answers to these questions, and other questions like them, is critical to truly understanding your business, your customers, and your marketing.  Without specific data, then you are spending time and money on marketing efforts that may not even be turning a profit.

So – what can you do about it?

If you are a solo business owner, or work with only a small team, then Infusionsoft’s reporting does have a lot of tools that can help you. We’ve put a list together of the top 5 most useful Infusionsoft reports that you can check out here. This won’t give you the answer to all of your questions, but it does give you a push in the right direction.  To get the rest of your numbers you may still have to pull out a good ol’ Excel Spreadsheet and dump hours into trying to view your data and hope you get it right.  Alternatively, Novak Solutions can help you setup some more advanced reports specific to your needs, and you can avoid hours of Excel spreadsheet time.
2-reporting
If you work with a larger team and have access to a database engineer, then we have an awesome tool that you need to know about.  Novak Solutions DataWarehouse tool does all the heavy lifting for you – we’ve spent years putting together the most reliable and most complete tool for pulling data out of Infusionsoft. The end result – a MySQL database that has your Infusionsoft data, all ready to go
Your database engineer or reporting expert can connect the database directly to your reporting framework of choice or build custom reports into any in-house application.  You can get real data, live data and know exactly what’s going in your sales funnels.

Not sure if YOUR Infusionsoft database is large enough to warrant a backup solution?

Take our free assessment and find out for yourself!

Click Here to Get Started

One-Click Infusionsoft® Data Restore & Visualization with New Cloud Backup

What would you do if someone on your team accidentally assigned himself as the owner of every single one of your leads? Or if a botched import corrupted 500 of your hot leads? (These are all true customer stories, by the way)
Four years ago, back in 2013, Novak Solutions launched the original Cloud Backup Tool which offers backups of key Infusionsoft® data and making that data available to the customer on-demand. The tool has proven invaluable to many customers in those kinds of situations.
By having a backup to turn to, Novak Solutions was able to get these customers back on their feet in just a couple of hours.
But that wasn’t enough. We wanted to go a step further!
We wanted to be the ONLY place our customers need for their Infusionsoft® data problems AND make it easy for them to get those problems fixed when they occur.
Today is an exciting day because we’ve definitely taken it one step further with two new super powers in Cloud Backup…
First, we’ve totally redefined how you can look at your Infusionsoft® data.

Visualize Your Data

cloud-backup-visualization
Want to see all of the data changes made by a particular Infusionsoft® user? Done!
All of the changes done last Friday afternoon? Simple!
All of the deleted records from this morning when your sales pipeline imploded? There they are, I feel better already!
Super easy 🙂
Cloud Backup gives you powerful data visualization in two easy steps: pick a date range, then click on the data graphs to filter by User, time of day, or a specific field. Nothing else to it!
Easily isolate and view all of the data changes that you want to see.  And if that new super power doesn’t give you a big smile…

One-Click Infusionsoft® Data Restore

cloud-backup-restore
One-click restore!  Ok, technically its two clicks because you have to pick a bad change first and then click “Undo Selected Changes” but the point is Cloud Backup will fix it for you 🙂
Easy, easy, easy…
Infusionsoft® charges hundreds of dollars and takes several days to handle restoring data from their backups. Instead, when you sign up for Cloud Backup today, it takes literal seconds to fix your own data AND you’ll transform from regular Infusionsoft® User to Data Super Hero!

Sign Up Today!

Data corruption happens, its not a matter of if but WHEN.
Activate your Cloud Backup for Infusionsoft® today!

 

Top 5 Best Infusionsoft Custom Reports For Actual Meaningful Insight Into Your Business

Hey Novak Solutions readers!
I’m Paul Sokol and I’ve known these Novak guys for many years. Recently, Jordan has been writing a lot about data and wanted to do a post on the top 5 reports available inside Infusionsoft.
He reached out to me about it and well, here we are 🙂
The reason he asked me is because I’m pretty familiar with Infusionsoft and its native reporting functionality (been using the software since ’08). This was actually a really fun guest post because it forced me to take the entire lens of a small business and condense it to what I consider the most critical and insightful reports/data points.
Oh! One important thing to note: this intentionally doesn’t have ANY campaign reporting in it. That’s a topic for an entirely different guest post.
Alright enough flapping my digital gums, let’s get to these top five reports.

Best Infusionsoft Report #1 – eCommerce > Sales Totals (By Product)

This is one of the most important reports because it empowers a lot of crucial data points for the Product, Sales and Financial functions of your business.
From a Chief Product Officer standpoint, this report gives a high level breakdown of what specific Offers are actually selling which indicates the general health of their Product Line. If a business has 20 things to sell, but only 3 are being sold, that means something different than if 18 of 20 are being sold. Neither circumstance is bad (nor good) without additional context but this report empowers that kind of “troubleshooting” into your Product Line health.
From a Chief Sales Officer standpoint, this report shows how well you are doing you job, to be blunt about it. You can easily ascertain how many raw orders/sales came in and total volume sold per Offer. Again, great for “troubleshooting” the Sales process.
Lastly, from a Financial standpoint, this is a highly valuable report because it shows what Offers are driving the Revenue. You can also filter to see which Referral Partners are driving sales. Lastly, you are also able to filter the report by refunds and write-offs too which means you can see what Offers are experiencing those kinds of transactions. Knowing what is refunding/being written-off can also be an important data point for both the Chief Product and Sales Offers!
Please be aware this report doesn’t factor in any discounts so you cannot use it for your Accounting cycles. In other words, if you sold one thing for $97 but gave $20 off, this report will still show $97 as the amount sold.
Despite this gotcha there isn’t a better report, IMHO, that gives you a better pulse on the heartbeat of a business than this one.

How To Customize the “Sales Totals (By Product)” Infusionsoft Report

Since you can only pull this report by date range, I recommend setting it for the current full month so you can save it and then get month-to-date stats (MTD) on your dashboard using a Custom Statistics widget. Then, you build an Operational habit to manually update the date ranges and re-save the report at the beginning of each month to keep your dashboard up-to-date.
You can also setup a year-to-date version of this report as well if you want to keep track over the whole year.
Typically, I won’t filter by any referral partner or refund status (found under Misc Criteria) to keep it a general report. You can also do on-the-fly filtering to pull the data you need, when you need it, once the report has been saved.
As far as the data columns, you want to keep this simple and only need these three:
1-sales-totals-by-product-report-data-columns

Best Infusionsoft Report #2 – Marketing > Web Form Activity Summary Report

This is one of the best reports for the Marketing function of your business. If you use internal forms this will also give you insight into your Operations performance.
From a Marketing standpoint, you are able to easily see how many new contacts have been added to the system. This is how you can track the general database growth. You are also able to see how many unique submissions a form received and the repeat submissions. If you see a lot of unique submissions but few new contacts, that just means the existing database is heavily interacting. Depending on your goals, that may be a problem.
Repeat submissions are either a good thing or a bad thing depending on context. Marketing wise, it may mean that something is broken as there aren’t too many real-world cases where someone fills out the same form multiple times. Operations wise, that might actually be expected. You may have a single internal form for workflow that gets filled out multiple times.
Like the previous report, this gives you high level insight into the pulse of your Marketing and Operations. Its a great place to start troubleshooting if things seem to be off!

How To Customize the “Web Form Activity Summary Report” Infusionsoft Report

Similar to the above report, you’ll want to do a MTD saved report that gets updated every month. There is also no need to do any specific filter either. Just a date range search and go!
As far as the data columns, there is duplicated name column and you want to use the specific one shown here since that will help you determine which ones are an internal form:
2-web-form-activity-summary-data-columns

Best Infusionsoft Report #3 – eCommerce > Receivables

I’m always filled with apprehension when running this report for the first time with a new private client. Either they are on top of their books and don’t have a lot to collect OR they didn’t even know payments were failing and they are missing out on money they already earned.
In some cases, there are failed orders from years ago so that money isn’t coming. Ever.
Truly tragic.
That’s why the Receivables report is the next in line for this post. Basically, if someone owes you money they show up on this report and you know you have to do some legwork to recover the payment.
The beautiful thing about this report is that it also works with payment plans, so unless a payment is truly overdue, it won’t show up here.

How To Customize the “Receivables” Infusionsoft Report

Like the other two reports, you only need to filter by date range with no other criteria selected. The difference is you want to make the date range between far in the past (before you started recording Orders) and then through to 2099.
This way, you only need to setup one saved report ever since the date range covers “all of time” from Infusionsoft’s point of view.
The magic here is the data columns you want to use because you can easily overload the displayed information and make this report chaotic and useless.
Using the data columns shown below will create a clean, meaningful receivables report that is actionable:
3-receivables-data-columns

Best Infusionsoft Report #4 – Admin > Task Note Report

I’ll admit, I never saw the true power of this report until recently.
How many different things can create a task or a note? Heck, how many manual WAYS in the system can you create a task or a note? There are even more ways to have a task or note created automatically, including built-in system stuff.
Here’s what you need to understand: from a database standpoint, Infusionsoft has tasks and notes on (basically) the same database table. Its a leftover impact from their early architecture. Which is an advantage to us in this report.
Realize that, data-wise a note and task are interchangeable (a task-note) and this is how you can unlock the true power of Infusionsoft and this report.
A task-note has a Title which is searchable using this report. This means that you can report on nearly anything you want using intentionally structured task-note titles.
For example, let’s say you want to see how many people went to the unengaged marketable status in a certain time frame. Using the email status automation triggers, you can have the system automatically apply a note with the title “Email Status Change – Unengaged Marketable”.
Now, using this report, you can search for notes with that exact title. And since you can filter by date range, user and all sorts of other stuff, you can slice and dice that unengaged marketable data for the insight you need.
Its becoming my “Swiss Army Knife” for reporting when private clients need a certain stat, especially campaign stuff.
What about tasks? Its the same principle.
Let’s say you are automatically creating tasks to call people when their email hard bounces. Those task titles can have a specific name which you can then report on, something like “List Engagement – Hard Bounce Call”.
Remember to mindfully create your Note and Task titles inside your Campaigns, and you’ll get an extra layer of reporting out of it!
Here’s the other thing you probably are forgetting or didn’t even know about: custom Task fields. Similar to a Contact record you can add custom fields (up to 100) to the task-note database object. This is the report you would use to pull data on those fields 😉
How might you use this? For an Operational example, you could add a custom Decimal and Dropdown field for the class of work. Each time a task is completed, the User is trained to also update the hours logged and the kind of work they did (Marketing, Operations, People, etc.).
Now, you can pull reports of how many hours are logged for each User which is segmentable by class of work. This is actually how I personally pull the labor to track my Revenue per Logged-Hour business metric.
Oh yeah, I also forgot I guess you could also use this report to dig into the actual Tasks your Users are performing as well. What’s complete/incomplete, when was it done, whats overdue, etc. that kind of Operational management stuff.

How To Customize the “Task Note Report” Infusionsoft Report

I can’t tell you the answer because this report is SO ROBUST!
That’s like telling you how to fold a piece of paper. It all depends on what you are trying to do. Make sure you only show the relevant data fields to keep you focused on whatever you need the report for.

Best Infusionsoft Report #5 – Email Status Search

This little guy is your list hygiene power tool because you can search for people based on their email statuses.
Looking for all your hard bounces? This does it.
What about your confirmed folks? Yup!
You can also segment by pretty much everything available in a Contact search too. This means you can now look at email engagement within certain cohorts of your database. Curious to see how your customers for a specific product in a certain state are behaving? You can get super deep answers like that using this report.
You are also empowered to find people who are considered “cold” which means their email will be throttled the next time you attempt to send. This is really good information to have especially if you are doing any kind of a launch to your list. The last thing you want is to hit “Go” and emails slowly drip out because the list wasn’t warmed up. Using this report, you can be proactive and get ahead of throttling issues (or at least work to mitigate them).
Lastly, you can segment by the last engagement too. Engagement is any kind of email open, click or web form submission. There are lots of ways you can intelligently leverage this kind of data 🙂

How To Customize the “Email Status Search” Infusionsoft Report

While this report is super robust, I actually recommend using the following fields because they empower whomever to “work” the list in whatever way they need. Even if you aren’t doing outbound stuff, being able to see if phone numbers or addresses are present can guide your strategy.
5-email-status-search-data-columns
So there you have it folks, five native Infusionsoft reports that will give you real, meaningful and actionable insight into how your business is performing 🙂
Leave a comment and let me know what you thought!

Attention Infusionsoft Power Users!

Do you need advanced reporting beyond what Infusionsoft or a even 3rd party tool can provide? Learn more about our Data Warehouse which gives you mySQL access to Infusionsoft data via backup that is refreshed every 15 mins. Literally plug into any reporting platform you want to use, unrestricted!
Not sure if your Infusionsoft database is big enough to warrant a backup solution? Take our free risk assessment here>>

Website Backups – How To Do It Yourself

You never know when you’re going to have a website disaster.  At Novak Solutions, we’ve been called in to help with all kinds of website deaths.  We’ve seen websites taken down by viruses, websites taken over by viruses, websites lost due to unpaid hosting, websites lost due to an angry ex-employee or ex-contractor, and websites that just broke for no apparent reason.  Most small businesses in the Infusionsoft space have WordPress websites, which is awesome … until it isn’t.  WordPress is notorious for becoming bloated and buggy when a website is modified over and over and over again.  Our own WordPress website became so slow that we decided to completely rebuild it when did our last redesign instead of modifying what we already had.
The point is – your website is an incredibly valuable piece of your business, and you’ve probably invested thousands or tens of thousands of dollars in it. No matter where your website is hosted or who manages it for you, you need to keep a backup.  A website backup gives you two crucial abilities.

  1. If your website is corrupted or lost for any reason, you can get it back up with just a few button clicks (or paying a tech guy a couple hundred dollars to make the clicks for you)
  2. If you need to switch web hosts for any reason, you already have your website packaged up and ready. With a couple clicks (or just getting a tech guy) you have it back up and running exactly as it was before.

How do I backup my website?
6-data-backup
 
Most web hosts provide a backup service for you. You just need to turn it on (and for some web hosts, you have to pay extra for the service).
GoDaddy provides a “Backup” tool in the Files section of your hosting account.  You can create and download a backup from this page, but it tells you that automatic backups must be enabled by your “server administrator”.  A quick check into their help pages uncovers that you have to add “Site Backup” to your account, which starts at $1.99 per month (considering the importance of backups, that is pretty cheap).
Here’s the link for more info: https://www.godaddy.com/help/add-site-backup-to-your-account-18557
HostGator says that they take automatic weekly backups “on a random day”, but they only keep one backup and the next week overwrites the old backup.  Some issues go unnoticed for months at a time – you need more than just a single backup. Their “Professional” CodeGuard backup service costs $4.17 per month in order to provide sufficient backups for a business critical website.
We highly recommend contacting your website provider (whether you login to your account and do it yourself or contact them over the phone or via support chat) and ask them about your backup options.  Make sure that you have at least 1 month’s worth of backups, and download a full backup to your computer every month or two or any time you make a significant change.  The last thing you want to experience is being locked out of your web hosting account with no way to get your website back from them.

Not sure if your Infusionsoft database is large enough to warrant a backup solution?

Take our free assessment and find out for yourself!

Click Here to Get Started

Using Calendar Links in Appointment Reminders for Better Stick Rates

Problem: You send appointment reminders to your customers, but you still get dropped appointments and customers saying that they almost forgot about their appointment.
Solution: Put super-simple buttons in your emails for your customers to add the appointment directly onto their calendar of choice.
3-meeting
Think about the last time that you received an appointment reminder from someone else.  If you use technology anything like we do, then you either took the time to open your Google Calendar, Apple Calendar, or Outlook Calendar and add the appointment manually, or you instantly forgot about it and simply didn’t show up.  But – those awesome people who put buttons right into their emails so that you can simply click a button and the appointment is added right into your calendar – those people get your respect, because they make it easy.
4-appointment-calander
Novak Solutions makes it possible for you to be one of those awesome people with your Infusionsoft emails.  All you have to do is make sure the appointment times are being saved into a custom field and tell our Email Appointment Tool the details for the appointment.  Setup your Infusionsoft emails with your button of choice and use the URLs we provide in the Email Appointment tool.  When your customers get their appointment reminder, you’ll be giving them the best experience possible.

Don’t have a Novak Solutions account yet but want to try this appointment link tool out yourself?

Tap here and sign up today, its free for life!

Own Your Infusionsoft Data

Own Your Infusionsoft Data

What does it mean to own something?
I can say that I own my car or that I own my house. I have paid for them, and they are mine.
What about my business? I created my business through a lot of hard work and I’m proud to say that I’m a business owner. Each of these things I can lay claim to and I have them in my possession.
What about your business data? All of those contacts, opportunities, payment information, segmented lists, all of those things that are incredibly important to your business. These things belong to you, but you can’t lock these things away in your home or office, they live within Infusionsoft.
This is a good thing – with Infusionsoft you can do awesome things with all of this data. Your campaigns drive your business and your business thrives with Infusionsoft.

But you have to wonder...

But every business owner has to ask himself the question – if something happens to Infusionsoft, what impact would that have on my business?
If you don’t have a backup plan, then you could lose your customers. Don’t get me wrong – I have no doubts about the reliability of Infusionsoft to keep your data safe and secure, and they aren’t going anywhere. I’m just talking about being responsible for your data and having a backup plan.

Taking Ownership is Taking Responsibility

Remember that time that your computer randomly died and you could never get your family pictures back? We’ve all experienced something like this before, and it’s a terrible feeling.
Imagine losing all of your customer data – email addresses, purchase history, everything. Now, stop sweating and come back to today. You have your data inside Infusionsoft, how can you own your data and be ready for anything?
Easy answer – get a backup. A service such as NovakSolutions Cloud Backup will pull a copy of everything possible from your Infusionsoft application (Customer lists, emails, purchase history, active subscriptions, opportunities, etc) and make it available to you. Now, you can OWN your data. Download your data and keep a copy at the house, keep a copy in the office, put a thumb-drive in a picture frame and display it on your wall. Whatever you do with it, you have the power to keep your business running and you have claimed ownership of your data.

Not sure if your Infusionsoft database is large enough to warrant a backup solution?

Take our free assessment and find out for yourself!

Click Here to Get Started

Hard drive photo credit: Foter.com

3 Infusionsoft Data Corruption Events That Could Cripple Your Business

Your business depends on Infusionsoft – and that’s a good thing. Infusionsoft provides rock solid marketing automation and your business would barely be treading water without it.
But how safe is your Infusionsoft data?  I mean – what are the chances that your data might just disappear, or that half of your contacts inexplicably lose all of their tags?

The Good and The Bad…

First – let’s give you some peace of mind.  Infusionsoft uses strong industry practices to safeguard your data. They do run regular backups and data corruption is rare.
Now – the bad news. While rare, data corruption happens sometimes every once in a while. We’ve all been using computers since we were kids, right? We’ve all had a Word document decide to die on us and we lost our homework back in high school.  We’ve all hit the backspace key while filling out a survey online and our computer decided to go back a page and killed all that information we had already typed in (How many of you actually went back and filled it in right away as opposed to slapping the keyboard in frustration and going to eat an ice cream bar?)

3 Infusionsoft Data Loss Events We’ve Seen First-Hand

In the world of Infusionsoft, there are a number of things that can cause data loss, nearly all of it related to human error, but either way you’re left struggling to get your business running again after taking a couple of days to rip your hair out in frustration.  Here are 3 examples of data loss events that Novak Solutions has been witness to over the years.
1.Self-inflicted misery – Even the most awesomely apt tech guys, yeah – that’s us ;), can shoot themselves in the foot. One day we were taking a look at our Accounts Receivables in Infusionsoft, someone hit the wrong buttons and we told Infusionsoft to delete every contact that had an outstanding invoice to pay.
I still don’t know how we managed to do this. It wasn’t like we’re inexperienced using Infusionsoft, but we still hit the wrong buttons and effectively turned off our revenue stream in one click.  We were able to restore all of these most important of business records through some help from Infusionsoft support and a good bit of API work on our end to put our data back together.
2.Random data corruption – One of our awesome clients had a totally random data loss event. We have no explanation for it, but we did hear that it happened to a couple of other Infusionsoft accounts at the same time.  All of the data stored in the Company custom fields was erased. The regular Company fields were not affected, but every custom field on the Company records were blank when they got to work in the morning.  This was one of our top clients, and we have extensive data backups of their data, so we were able to get them back up in less than 20 minutes.
3.Total Chaos – This is another one of those “fat-finger” mistakes.  A staff member of a reputable company was doing a regular old Opportunity update. But – they did not notice that they had the wrong search results up, and they accidentally assigned every Opportunity record in their Infusionsoft application to themselves. So, like, total chaos, right?  Unless this staff member were Superman, he’s not going to be doing all of those follow-ups on his own – they needed the Owners put back, and they needed it fast.  Fortunately, this client was a subscriber to our CloudBackup solution, and it only took us about an hour to get all of the Opportunity records set back to the correct Owner.

Not IF, but WHEN…

Every company is going to experience a negative Infusionsoft data event. Most will be minor, maybe you can’t find a Contact because someone thought it was a duplicate and deleted it. Or you applied the wrong tag to a large group and now their custom fields have been inconveniently randomized.  It happens to everyone.  Some of you are going to experience absolute chaos, at least once, in the course of running a business.

What can you do about it?

Infusionsoft support can help you. They run two backups per week for every Infusionsoft application. So if you have a data corruption event happen on Thursday, and the last backup was taken on Monday, then they can restore the lost data to how it was back on Monday.  This is good, but you’re still going to have some significant risk of data loss.  Plus – they charge you for the data restoration, maybe only $200 or $300 for a simple restore, but significantly more if it is a large data loss event.
The other source of help is our Cloud Backup tool.  Unlike Infusionsoft, we don’t run backups twice a week, we run backups ALL THE TIME.  We keep a mirror of your Infusionsoft data on our own servers, and we keep things in-sync every 15 minutes.  If you messed something up on Thursday at 4pm, we can show you what the data was at 3:30pm.  There are some things we can’t restore – but 9 out of 10 data issues we can solve for you and with our tool you can even check your data yourself.

How Much Are YOU At Risk?

Our Cloud Backup tool is not for everyone. That’s why we created a free data risk assessment so you can see for yourself how much a data loss could impact your business.
Start Your Assessment Here
Click Here to Get Started