Any executive and business owner knows the importance of tracking performance via key performance indicators (KPIs). KPIs are used to report to investors and to guide the strategic direction of the group or firm. At Import Sheet we have a list of over 200 (and growing) KPIs that we track weekly and monthly. By regularly reviewing these KPIs we are able to make quick, fact based decisions for the company. We’re delivering this KPI Tracking Template so that our users have an easy, reliable, and centralized location to track their KPIs.
Overview of the template
This template includes 2 Google Sheets, one KPI Tracking Template which will centralize all your data and generate reports, and the second is a sample of a sales funnel. In order to use this template data must be first treated by the user to be output in a Pivot Table format with date’s on the vertical axis (column A) and categories on the horizontal axis (row 1) as we have done in the Example Sales Funnel. The template is configured for both monthly and weekly reporting.
Step 1) Install Import Sheet and Copy the Template
If you haven’t done so yet, install the Import Sheet add-on by clicking this link: Import Sheet Add-on for Google Sheets. Next click on the icon below to access the two sheets needed for this template, KPI Tracking Template, and Samples Sales Funnel. Open the sheets and make a copy of them by clicking ‘File > Make a copy…’
Install Import Sheet and Copy from the Template
Step 2) Configure your sales funnel
It’s likely that you have the data for your sales funnel already in a spreadsheet. We provide you with the Sample Sales Funnel sheet as an example of how the data should be organized to Import to the KPI Tracking Template. As a best practice we assign week and month IDs to dates in all of our sheets in order to track results versus specific week and month (e.g., it is much easier to relate data to a week in the past as ‘Week 11’ versus ‘February X-Y of this year’). In the Samples Sales Funnel spreadsheet you can see the tab results has the results of new sales leads organized by their stage in the funnel (Acquisition, Activation, Retention, Revenue, and Sales). We have this data daily and use columns B & C to assign week and month IDs. This info is then easily organized in the Weekly and Monthly Pivot Table tabs. It is likely that your data is in another format, in order to import it directly to the KPI Tracking Template you’ll need to get it to this format (hint: use the =TRANSPOSE() formula if your data is horizontal.
Step 3) Import your sales funnel to the KPI Tracking Template
Once you’ve configured your data open the KPI Tracking Template sheet and configure it to import from the Sales Funnel data.
- Click “Add-ons -> Import Sheet -> Start”, this will open side bar. Mouse over the green ‘+’ icon then click on the green down arrow to Import.
- In the second step click on the card Connect then search for your source spreadsheet. Once you’ve found it click on the source sheet within that spreadsheet (if you’re using the Sample Sales Funnel it will be Weekly Pivot Table).
- Next configure the automatic update intervals. If your sales data is updated daily select Daily then choose the hour you want to import data (likely sometime in the middle of the night)
- Last, name the connection. To overwrite the existing sales funnel from the Sample Sales Funnel, type ‘Funnel Weekly’. If you use another name it will create a new sheet with that name, just be mindful to delete the existing Funnel Weekly. Now click CONNECT to finish the connection process and bring in your source data.
Step 4) Configure the KPI Tracking Template
The KPI Tracking Template has two sheets for inputs.
- In the first tab Inputs type the name of the tabs you import to track (e.g., it is pre-filled with Funnel Weekly, if you have imported another sheet change the name to this sheet). Consider importing all of your results here to organize in one place all the data for the company. This could include financial results, Google Analyitics, or anything else that you regularly track. Lastly type in the Start date that you want to analyze from.
- In the Experiment List tab type the name of experiments as you execute them (e.g., ‘Changed on-boarding process’) and the KPIs which the results should be measured against. This auto generates the sheet Graphic to track results versus changes actions taken by the company.
Lastly on the sheets Monthly KPI Summary and Weekly KPI Summary type the names of the KPIs that you want to track in column A (they must match the name of the KPIs in your source sheet, see the pre-populated sales funnel for an example). This will auto populate the data in the weekly or monthly format depending on what you have imported.
You’ve now configured your own KPI summary. Make sure to expand and adapt this sheet by centralizing bringing in more data to this sheet as you collect it and centralize everything you have in one place.