How to Build a KPI Dashboard With Whatagraph?
To build a good KPI dashboard, you will need to perform data visualizations providing context to the data from many sources. Luckily, for this, you will only need one system, and that is Whatagraph. Connect multiple sources to extract business data, build a dashboard using this guide and gain new insights into your agency's or your clients' performance.
Table of Contents
- What is a KPI dashboard?
- 5 Great Reasons Why You Need a KPI Dashboard
- How to Choose the Right KPIs?
- How To Build a KPI Dashboard With Whatagraph?
- Additional Advice
What is a KPI dashboard?
A KPI dashboard is a tool for a quick analysis of key performance indicators. Ideally, all these KPIs are displayed in a single dashboard, but such KPI dashboards can also be built for individual channels and campaigns.
KPI dashboards are used for on-the-spot analysis for situational awareness. They can indicate performance dips and peaks and point to actions that need to be taken. Marketing agencies use these KPI dashboards for everyday observation of their channel performance.
Example: Here, you can see a dashboard for Google Ads. The goals for the period are indicated on the left, while the primary KPIs - No. of conversions, CPC and CR - are at the top. It's also important to see trends over time, especially how CPC influences the number of conversions.
5 Great Reasons Why You Need a KPI Dashboard
- Data management. Building a KPI dashboard provides an opportunity to organize, filter out, visualize and analyze so much data. The best KPI dashboards builders bring all the data points together and give you the tools to translate all that chaotic data into an easy-to-understand format.
- Decision-making process. KPI dashboards are needed to make data-driven business decisions. Whether it's a decision on overall marketing strategy or everyday insights for channel performance - you need these dashboards to keep a close track of your business objectives.
- Teamwork. Each team and individual in an agency will have their own KPIs. All KPI owners should have direct access to the performance information, bringing all teams together towards the common goal.
- Real-time analysis. Tracking KPIs in real-time will help make informed decisions quickly. Such a method will also help improve performance and ROI on the spot if needed. All decisions are made faster with real-time data on well-built KPI dashboards.
- Trends and opportunities. With real-time data, improved performance and teamwork, a KPI dashboard can also show trends and opportunities that were not utilized. For example, there may be keywords you haven't ranked on yet or paid media opportunities you have missed.
How to Choose the Right KPIs?
Every key performance indicator must correlate with your objectives. Whether the revenue for an entire company, engagement for social media or number of leads - align your KPIs to your business needs.
The high-level KPIs for business goals are:
- Annual contract value (ACV) for B2B businesses;
- The transaction value of B2C;
- The customer churn rate for customer success teams;
- Return on investment (ROI).
These strategic KPIs will always be necessary for marketing, sales department, customer services and the executive team. But the strategy is achieved through operations, and here are some operational KPIs that each team and channel owner can use in their KPI dashboards:
- No. of leads;
- Cost per acquisition (CPA);
- Advertising spend;
- No. of transactions;
- Total and average revenue;
- No. of sessions on-site;
- No. of goal completions;
- Number of transactions;
- Average order value (AOV);
- and other important metrics.
You can find more great advice on KPI tracking in this blog article by Whatagraph.
How To Build a KPI Dashboard With Whatagraph?
To build a KPI dashboard with Whatagraph, you will need to follow a few simple steps.
Step 1: Create an Account
Head over to www.whatagraph.com and select Try it Free at the top right corner. You will get a short registration form, giving you access to a full seven days of free trial to build your first KPI dashboards. Expect a call from Whatagraph's Partnership Development Executives to provide you with more detailed instructions on using the platform.
Step 2: Connect Your Data Sources
To build a KPI dashboard for agencies, you will need the correct data from all your data sources. Software solutions like Whatagraph allow you to create an effective dashboard by connecting data sources directly into the platform. Select your desired channels from a list of 40+ options, connect to that channel's account while on Whatagraph, and you're all set.
Remember that you can also import data via Google Sheets or request custom integrations via Whatagraph's public API.
Step 3: Smart Builder for First-Time Users
KPI dashboard software can be notoriously tricky to implement and learn. That's why the Smart Builder by Whatagraph is an excellent place to start.
It's a 2-step process of selecting one or several data sources and the KPIs you want to measure. Then the platform generates a KPI dashboard within 1 minute.
While the choices of data sources are not as extensive as using a template (described below) or building a KPI dashboard from scratch, Smart Builder has the six most popular data channels and a good number of essential KPIs to start with.
Step 4: KPI Dashboard Templates
Another good way to build KPI dashboard is to use a template. Not only will this give a good stepping stone to start with, but it will also speed up building all KPI dashboards, now and in the future. With Whatagraph, several KPI dashboard examples are the most popular among users.
Here we have a consolidated PPC dashboard from three different paid media sources: Facebook Ads, LinkedIn Ads and Google Ads. You can track changes in conversions, customer acquisition cost, budget spend, total costs, and more on a single screen. Here you also can see how goal progression is going - all in the same KPI dashboard.
Performance of the organic marketing channels is also crucial in most marketing strategies. With a strategic dashboard like this, you can track data from Google Analytics, Google Search Console and Ahrefs (or Semrush). With this data, you can see the changes in organic traffic over time, identify opportunities and track how many goal completions your organic marketing efforts are bringing. As with the PPC dashboard, the SEO dashboard also provides goal tracking for a given period.
Social media dashboard
Social media is one of the most popular marketing channels. Tracking each channel is crucial, but it's just as important to follow all consolidated social media channels on a strategic level. In this example, you can see data from Facebook, Instagram, Twitter and LinkedIn accounts. This KPI dashboard focuses on goal completions and target audience information, providing detailed information on changes in these areas.
eCommerce is arguably the most complex dashboard to communicate performance. There are a lot of important KPIs to show the exact success or failure of eCommerce marketing. In this example, data is coming from Google Analytics and Shopify. With Whatagraph, it's also possible to plug in data directly from BigCommerce or WooCommerce. The dashboard shows goal completions, total revenue, revenue vs advertising costs, number of sessions, transactions and other business metrics.
When creating dashboards, make sure to keep in mind these best dashboard building practices:
- Keep it short and straightforward: show actual results and not vanity metrics;
- Choose the design and background colors that are easy on the eye. Read this dashboard design guide for more information;
- Accumulate as much historical data as possible to look for trends and opportunities;
- Use your dashboard regularly and keep improving it for better results.
Your key performance indicator dashboard is meant to help you monitor everyday performance. Make it your primary tool for success!