The Chartio Blog

Expert advice on business intelligence to help drive data at your company.
Sign up to get the latest data tips delivered to your inbox.

How To Calculate Annual Recurring Revenue with Salesforce Data

Annual Recurring Revenue, or ARR, is an insightful metric for B2B SaaS businesses to track the total dollar amount that comes in every year for the duration of a customer’s annual contract. No matter the size of your company or industry, ARR is a universal metric that gives businesses the most insight about the success of their business.

Continue reading to learn how to use your Salesforce data in Chartio to calculate ARR in two simple steps.

Hi, I’m Your Data Evangelist

Hi, my name is Tim and I am your new Data Evangelist. For the past year and a half I’ve worked as a Customer Success Engineer. It is more than possible that I helped you through one of your tickets, helped you build a dashboard or trained you during one of our customer webinars or on-site visits. If none of that rings true, then you’ll simply know my henceforth as your Data Evangelist. 

How to Track First Touch Marketing Attribution with Hubspot Data

Marketing attribution continues to be a hot topic of conversation for marketing teams, no matter the industry or size of the organization. As marketers are beginning to leverage data and dive into the analytics of their marketing campaigns, it has become apparent that marketing attribution is still a hurdle for many of us.

In this blog post, we’ll walk you through how to track first touch marketing attribution with Hubspot data in Chartio. In implementing, a first touch attribution model, you’ll be able to iterate on campaigns, content and messaging faster and earlier on.

The Power and Cost of Hurricanes

According to, September 2017 was the most active month on record for Atlantic Hurricanes. These hurricanes were large, dangerous and deadly and ran through the United States and the Caribbean Islands, leaving vast destruction and death in their wakes. We've visualized the data to show just how magnitude and destruction of these hurricanes. 

The Importance of Practicing Good Data Hygiene with Your Visualization Tool

Practicing good data hygiene is crucial. Not only for data teams, but for every aspect of the business. Good data hygiene is like washing your hands. I’ll explain it all in this blog post and provide best practices on how to implement good data hygiene at your organization. 

Three Ways to Track Marketing Attribution in Google Analytics

Marketing attribution is challenging. However, you can use Google Analytics as a starting point to understanding and measure attribution. In this blog post, we’ll walk you through three ways to use Google Analytics to jumpstart your attribution strategy.

How to Create a Customer Success Dashboard

As customers are the livelihood of your business, having a bird’s-eye-view on the revenue activity generated from your customers is crucial for growth. A Customer Success dashboard monitors the health of this growth.

In this blog post, we’ll show you how to create a Customer Success dashboard that optimizes for growth.

How to Create a CEO Dashboard

A CEO dashboard visualizes your business data and tracks the health of your business by measuring revenue trends, growth and operational cash flow. In this blog post, get a breakdown on which metrics to track and how to create your own dashboard in Chartio.

Optimizing Your Content Using Google Analytics

With more and more content out there, companies are looking for ways to rise above the noise and optimize their content. In this blog post, we’ll uncover five ways to optimize your content while leveraging Google Analytics.

Off the Charts: An Interview with Lukas Biewald of CrowdFlower

In this edition of Off the Charts, an interview series where we chat with individuals doing industry-changing work in the data space, we spoke with Lukas Biewald of CrowdFlower. 

Read our interview with Lukas as we discuss the importance of training data and the evolution of Artificial Intelligence. 

The Guide to Building an End-to-End Data Stack

If you have yet invest in an end-to-end data stack, this white paper will be core to your evaluation process. For more insight, download our white paper The Guide to Building an End-to-End Data Stack.

Off the Charts: Jake Stein, Yaniv Leven and Dave Fowler

In this edition of Off the Charts, an interview series where we chat with individuals doing industry-changing work in the data space, we spoke with Jake Stein, Yaniv Leven and Dave Fowler about the current state and future of data technologies.

How to Optimize Amazon Redshift Performance

In running complex queries against large amounts of data within your Amazon Redshift data warehouse, it can be taxing on the overall system. It’s important to apply best practices and resolve optimization issues fast, because the longer you wait, the fewer real-time insights you’ll have access to and the more deep debugging awaits you in the future. This post will take you through the most common issues Amazon Redshift users come across, and will give you advice on how to address each of those issues.

How to Track Your Sales Opportunities in a Dashboard

A sales opportunities dashboard visualizes your CRM data with marketing data to track opportunities as they move through the sales pipeline. In this blog post, learn how to create a dashboard to track sales opportunities in Chartio.

How to Choose the Right ETL Tool for Your Business

For many companies, data comes from many places. Most companies utilize various cloud applications to run different parts of their business. With all this data, it brings about new challenges in gleaning insights from your data. But before you can sync your Salesforce data with a data warehouse, you need to realize one thing: you need an ETL tool. 

In this blog post, we'll break down everything you need to know about evaluating an ETL tool. 

How to Choose Metrics for Your Sales Dashboard

We’ve all heard the saying, "what gets measured gets done." As companies make hundreds of decisions a day, you simply cannot afford to make decisions solely on intuition alone. You need to measure everything. And dashboards are the way to measure performance insights, key results and growth indicators.

Before we all start creating dashboards, let's figure out which metrics to choose for our Sales dashboard.

There is A Lot of Data Out There, How Are You Governing It?

There is more information about you in a database than you can possibly fathom, or probably care to know. Current estimates for the amount of data created in the year 2020 is 1.7 megabytes per human being on Earth, per second.

If you were to convert that to mp3s you would have approximately 6.8 quadrillion hours of music. That is enough listening material to last each individual member of the human race 102 years of music. That's a lot of data

If the above statistic doesn't fuel your need to think about data governance, in this blog post, I'll dive into the importance of implementing a data governance strategy. 

Data Wars Episode I: The Democratization of Data

Centralized or Decentralized Analytics, which one is right for your organization? There's no right answer and that's leading to an internal data war. While there are defined pros and cons between the two analytics approaches, it's entirely up to you to implement the right one for your organization. 

In this blog post I'll provide examples and best practices on how either can work for your organization. 

The Mailchimp Email KPIs You Can Start Using Today

Undoubtedly, Mailchimp offers robust KPIs and analytics within their own platform and even compare your numbers to industry standards. This is a great starting point. But, it can be to your advantage to track those Mailchimp KPIs outside of the platform and alongside your other marketing KPIs (like numbers from your Google Analytics or Marketing Automation) to get the full picture.

In this guest blog post by Kostas Pardalis, co-Founder of Blendo, he'll cover the top KPIs for Mailchimp and provide a guide to implementing each one into your own dashboards.

The Age of Analytics: Data Governance

As more companies move through the four stages of data analytics and overcome the false fears of democratized data, this has reiterated the importance data governance and quality for organizations. With more people having access to data, creating data sources and analyzing data, it’s changed the way business departments manage their data.

In this blog post, learn how important data governance is to your growing organization and how to implement a strategy today.