Website Growth Tracker - Spreadsheet Templates
You know the saying "What gets measured gets managed?"
That was the guiding mantra for my business and website goals in 2017 because I wanted to seriously up my game last year.
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.
A while 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!
WATCH MY VIDEO TO SEE HOW YOU CAN USE MY WEBSITE GROWTH TRACKER SPREADSHEETS TO TRACK YOUR OWN WEBSITE AND BUSINESS GROWTH FOR 2018!
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 2018 website growth tracker spreadsheets now!
Here's a quick rundown of what we cover in the video demo:
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.
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 Facebook, Twitter, Instagram, Youtube and Pinterest. 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.
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
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.
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.
READY TO TRACK YOUR WEBSITE'S GROWTH?
WHAT OTHERS ARE SAYING
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!
The 2017 version of these spreadsheets were hugely popular and thanks to popular demand, I've got the 2018 versions ready for you!
Happy tracking :)