One of our team values at Tuff is to work smarter, not harder. For the work that we do, this often means creating clear and repeatable processes.
We also think dashboards are a little overrated.
Although they give you a snapshot of important metrics, and they look good, dashboards aren’t great at providing the details or context that effective data-driven decision making requires.
This is why spreadsheets have been such a staple for our team, helping us to collaborate more efficiently with our startup partners, track budgets and core metrics, see our growth more clearly, organize our experiments, and get more work done.
That being said, building the right spreadsheets that are actually helpful and relevant to your startup can be time-consuming. We’d love to help.
We’ve pulled together a list of the essential spreadsheets and templates we have used and improved to help prioritize experiments, run campaigns, and track growth for Tuff and our startup partners.
Let’s jump in…
For many of the growth marketing spreadsheets linked below, you can download as an .xls file to use and customize in Excel or Google Docs. Google Doc users can also go to “File > Make a Copy …” to add the spreadsheet to their account, then edit.
1. Growth Marketing Framework
Use for: Prioritizing and tracking your growth marketing experiments
We discovered this Growth Marketing Framework spreadsheet after attending Sid Bharath’s talk at the GrowthMentor summit last year. We tested it out on our own and it’s quickly become a go-to for our team when we need to prioritize campaigns, identify new experiments, and find big wins for our partners. We like it so much that we have one for Tuff that we look at weekly as a team.
In this spreadsheet, you have four core tabs:
- Customer Personas
- Customer Journey
- Tactics Backlog
Our favorite part about this spreadsheet is that your customer personas exist in the same spreadsheet as your ideas. In the past, we built out personas in a word doc or slides with visuals and descriptors, and sometimes we still do. But having your target audience in the same place you go to list ideas and pick experiments is extremely helpful when it comes to prioritization. Before we add any ideas to our backlog, we can revisit our personas, their journey, and then truly assess if they are the right fit for our audience. With this setup, your personas become a driving force for tactics instead of an afterthought. You end up with experiments that hit the mark more often because they’ve passed the persona check.
2. Channel Projections for Experiments
Use for: Forecasting budget based on historical data and determining projected performance
We get these two questions a lot: How much should I spend? And, what can I get in return?
In order to set monthly budgets and projections, we start with core KPIs. What are we trying to achieve? Do we want to book more demos, increase sales, drive more leads? Once we understand these goals, we can forecast budget based on historical data and determine projected performance using this spreadsheet. This isn’t an exact science but it helps us align as a team about what we’re trying to achieve based on specific targets. It also helps you know how much you need in the bank to test and learn.
For traffic and conversion rate data, we lean on tools like Google Analytics, Shopify, Metorik, Firebase, Salesforce, Facebook, and Google Ads. If you don’t have this data available because you haven’t experimented on these channels, you can still use this spreadsheet, you’ll just need to take bigger leaps with the numbers based on industry averages.
3. Growth Marketing Scorecard
Use for: Tracking results daily, weekly, and monthly in one shared spreadsheet
When you’re running experiments and testing new campaigns, we like to have a reporting template that gives us true insight into what’s working and what’s not. We use this spreadsheet to track daily, weekly, and monthly results for our campaigns.
One of the most important things about this scorecard is that it’s 100% manual. While there are a bunch of automated dashboards out there, after three years and 35 startups, we still think this is the best option for our team and partners in the early stages. It’s simple (no fluff) and sticks to the most important metrics. While pulling the data from various sources takes time (about 10 minutes each morning), it gives you an opportunity to really look at the data, dig into what it’s telling us, and then make smarter optimizations and budget allocations.
4. UTM Generator for Campaigns (Tracking)
Use for: Understanding which campaigns are driving meaningful results
UTM codes are snippets of text added to the end of a URL to help you track where website traffic comes from if users click a link to this URL. If you’re anything like the data-driven campaign managers on the Tuff team, you probably don’t run any campaigns without UTM parameters. By tagging your URLs with UTMs, you can get a good understanding of how your visitors interact with your website, allocate budget more efficiently, and cut out anything that isn’t working. For a full rundown on UTMs, we turn to Niel Patel’s ultimate UTM guide here.
So what’s with this spreadsheet? If you’re running multiple campaigns and experimenting quickly, it’s easy to lose track of your URLs. For example, we have a batch of Facebook campaigns active right now, with 23 different audiences, using 23 different URLS. These can add up! This spreadsheet keeps all active URLs organized so anyone on the team can check the URL, review performance in Google Analytics, and then help make smarter marketing decisions at the campaign level.
5. Blog Post Traffic Tracker from Buffer (Content)
Use for: Knowing which posts are gaining the most traffic
This is one of the best spreadsheets to understand how your content is stacking up. If you don’t have a blog yet, skip this spreadsheet.
The blog post traffic spreadsheet from Buffer enables you to keep an eye on which posts are hitting your traffic goals and it’s also really great to keep an eye on what topics are performing best, too. While this is easy to see in Google Analytics, pulling the data into a spreadsheet helps you benchmark performance more easily to identify content wins.
One of the more actionable ways we use this spreadsheet is to help us identify articles we want to update. To increase the effectiveness of your SEO efforts and boost your search engine traffic, you canupdate your old content and give yourself an improved freshness score.
Buffer has 10 other very helpful social media and content spreadsheets here, in case you want more.
6. Budget Tracker for PPC Campaigns (Paid)
Use for: Creating an automated monthly budget pacing dashboard for Google Ads
When you build this spreadsheet, you’ll get a quick glimpse at how your budget is pacing for the month on Google Ads. This can be helpful when you have specific monthly targets you want to hit.
With this spreadsheet you can see how far through the month you are, what percent of spend you’ve used, and how close you are tracking towards your goal. For example, you might be 61% of the way through your budget but only 53% of the way to your revenue goal.
This works best with larger budgets (below $1,000 per month is less effective) but as you ramp up, it can help you stay more efficient and effective with your spend.
7. Influencer Marketing Template (Influencer)
Use for: Managing and tracking your Instagram influencer marketing campaign
Performance-based influencer campaigns can drive revenue and user growth if you can tap into the right communities.
The way that this spreadsheet works is simple. Once you’ve defined your niche and set goals for your influencer program, you can start compiling your influencers in this spreadsheet. From here, you can start to calculate each influencer’s engagement rate. This will tell you who has an active audience.
There are a bunch of different ways to calculate engagement rates and this spreadsheet uses the below formula:
ER post = Total engagements on a post / Total followers *100.
A higher engagement rate typically spells out a wider reach and stronger influence.
Again, this is another manual process and it takes time. If you find early traction with your program in the first 90 days, we recommend transitioning to a tool to help manage as you scale.
8. Email User Onboarding Flow (Email)
Use for: Building and visualizing your welcome email flow
Installs, sign ups, and demos mean nothing if you can’t keep your users — which makes your onboarding email campaign incredibly important.
We use this template to outline our Email user flow from start to finish. For a successful strategy, it helps us:
- Set a goal for each email in the series
- Set timing for each email
- See the entire flow at once
From here, you can start thinking about copy, CTAs, and design for each email, benchmark performance, and start testing. This structure has helped us get higher retention rates and increase revenue.
Bonus Template: If you don’t have an onboarding flow for new customers or leads, this email marketing planning template from Hubspot is handy for planning marketing and transactional emails.
9. Google Ads Keyword Audit (Paid)
Use for: Efficiently auditing your PPC keywords & search queries to identify top performers based on ROAS.
When it comes to optimizing paid search campaigns, keyword optimizations can oftentimes be time-consuming, scattered, or – even worse – ineffective. A keyword with a high CTR and low CPC may be performing well at first glance, but these are surface-level metrics and they don’t necessarily correlate with the most important metrics.
Organizing your keywords and search queries into a format that helps you focus on what really matters the most – in this case, ROAS – will give you a clear picture of which keywords to invest more money into and which keywords to scrap from your campaign(s).
To use this spreadsheet, export your keyword report from Google Analytics for your chosen time period. Be sure to include the following attributes: Keyword, Campaign, Clicks, Cost, CPC, User, Sessions, Ecommerce Conversion Rate (or Goal Conversion Rate), Transactions (or Goals Completions), & Revenue.
The first row in this spreadsheet maps to these attributes. In Column K, you’ll find a ROAS calculation equipped with Conditional Formatting that will provide you with a quick visual representation of your Keyword success.
As a starting point, we’ve got Conditional Formatting set up to turn cells in Column K green when the ROAS is greater than or equal 250% and red when the ROAS is less than or equal to 150%.
With your exported data placed in this sheet, you’ll quickly see which of your keywords are driving the best ROAS.
To help sort, we have a filter placed in row 1 that provides you with endless filtering and sorting options. There’s also a nifty word count formula in Column L which will provide some insight into how your long tail and short tail keyword performance compare.
Run the same report at the Search Query level and compare it with your Keyword list. You may find some standout queries that can be added as Exact Match keywords to your campaigns.
Thanks for reading! I hope you picked up one or two new tips and tricks for your spreadsheets here.
I’d love to hear what growth marketing spreadsheets your team has been using? What has worked well for you?
Ellen is the founder at Tuff and one of the team’s core growth marketers. She is a versatile marketer with expertise in multiple channels – from ppc to seo to email to others – responsible for the experiments and testing. She is happiest when she’s on the ski hill or outside pointing her mountain bike downhill.