Charlotte O'Hara
Cart 0
Charlotte O'Hara
Web Designer & Squarespace SEO Expert

Website Growth Tracker - 2024

Spreadsheet Templates



You know the saying "What gets measured gets managed?"

That has been the guiding mantra for my business and website goals since wayyyyy back in 2017 when I wanted to seriously up my game.

I had so many big plans and ideas for my business, and I knew that having a "bigger" website with a larger reach would help me achieve the kind of results I was looking for. I knew that if I wanted to grow my website and guarantee that all my plans actually happened, I would need to get serious and stay on top of my site's data & statistics.

When it comes to growing a website, there are SO many factors that come into play. Obviously you have to look at the raw numbers of how many visits and page views your site is getting, but what about social media, product/service revenue, affiliate programs, media mentions and email list? I couldn't forget about those too! In order to see the full picture, you have to look at data across all areas.

These factors are all major contributors to your website's growth so if you track them all in one place, you'll have a much better understanding of how your website is growing over time - and, most importantly, if you're on track to meet your goals.

Website Growth Tracker Mockup
website growth tracker mockup  | mobile
Website growth tracker | mockup

A few years back I created the first version of these spreadsheets for my own personal use and expanded them over time to meet my growing needs. By setting up these spreadsheets, I was able to take information from a bunch of different places and platforms and collect it all in one central home. This has streamlined my tracking process and has made the experience of tracking my website's growth way more visual and encouraging.

Since I shared these templates with my online business friends and clients, the response has been overwhelmingly positive. I figured if it was working well for us, you would find value in these website growth tracker spreadsheets too!

Reminder: All numbers and statistics are shown for demo purposes only. They do not reflect my website or business, or those of my clients!


READY TO TRACK YOUR WEBSITE'S GROWTH?

Download the updated 2024 Website Growth Tracker spreadsheets now!


Here's a quick rundown of what we cover in the video demo (at the top of this page):

1. Log your website traffic

The first page of the spreadsheet looks at website traffic on a weekly and monthly basis. You will pull those numbers from your analytics platform (here's how to do it with Squarespace) and put them into the weekly and monthly fields. The % change in page views from previous week/month will automatically fill up. 

The data will populate the timeline graphs on the right side of the page.

A look at the monthly website traffic overview section. There's also the option to track this information weekly.

2. Social media stats

Social media is a great way to drive traffic to your website which is why we track the number of followers on every platform regular intervals. There are fields for Instagram, TikTok, Youtube, Facebook and Pinterest but obviously you can add in others or rename the fields to suit your needs. If a particular platform doesn't apply to your website/business or you use a different platform, simply ignore it or rename it.

We track these stats monthly, as well as the 1st and 15th of every month in the appropriate fields.

A look at the Youtube field on the social media stats page - data table and timeline graph

There's another table that shows the breakdown of audience size on each social media platform, which is a great way to see how your audience size changes if you put more effort into one platform over another. This graph automatically populates based on the data in the tables and is colour coded accordingly.

3. Track email list subscribers

Next up we look at the growth of your email list. We track these numbers monthly, as well as the 1st and 15th of every month (set a calendar reminder to stay on top of this!) so that you can see your numbers growing at different time intervals. You will input the data and the timeline graph will automatically populate, as will the % change section

A look the monthly email list overview table & timeline graph. There's also a section to track this data on the 1st and 15th of the month.

A look the monthly email list overview table & timeline graph. There's also a section to track this data on the 1st and 15th of the month.

4. Predict revenue from products or services

If you monetize your website through products or services, this section is how you'll see where the money is coming from and when it's coming in.

You will name each product/service section, input the price as well as how many you plan to sell during each quarter for an initial overview. Next up, you'll break that down further into detailed looks at each quarter (Q1: January, February, March / Q2: April, May June / Q3: July, August, September / Q4: October, November, December). This allows you to predict any changes in revenue if you have a big promotion, launch, media coverage that results in sales, etc.

Product/service revenue overview. Each quarter also has it's own section that looks at each month individually.

Product/service revenue overview. Each quarter also has it's own section that looks at each month individually.

5. Keep track of media mentions

If your website or business gets any sort of media coverage, this is where you'll keep track of it. Whether it's a podcast interview, guest blog post, media feature, etc., you will log that as well as valuable information such as links and email list sign ups.

6. Log affiliate programs and predict payouts

If you use any sort of affiliate program, you can store all the program information here as well as predict how much you'll get paid out in every quarter. There's also a monthly breakdown for each program and a look at how much you'll make in commissions based on the number of sales you refer. Simply rename each affiliate program, adjust the price payout you'll receive and the number of commissions you plan to refer. The rest will autopopulate.

We also look at each quarter on a monthly basis for each affiliate program so that you can see how any big promotions affect your profits.

A look at the affiliate program predictions Q1 breakdown section

A look at the affiliate program predictions Q1 breakdown section


READY TO TRACK YOUR WEBSITE'S GROWTH?


File & Format

These spreadsheets are delivered in .XLSX format. They are compatible with Macs and PC and can be opened with Excel, Google Sheets, Apple Numbers, etc.


WHAT OTHERS ARE SAYING

Testimonials


Final Thoughts

Tracking my website's growth has been hands down one of the biggest game changers in my business. Once I started paying attention to the data and my stats, I was able to see see exactly where my efforts were paying off and what areas needed work. The numbers don't lie and once I stopped hiding from them, I felt empowered and motivated to keep growing my website and business.

These spreadsheets were something that I created for myself and then shared with my online business friends and clients when they started asking for them. I'm thrilled to be able to share them with you now!

Updated for 2024.

Happy tracking :)