Blogging can be overwhelming without direction. You need to consistently promote your blog. You need to have goals and know whether you are meeting them. Without a usable blog planner, you may find yourself blogging aimlessly and never getting anywhere.
Today I have rounded up some of my favorite blogging spreadsheets from around the web. Take a look and be sure to share your preferences in the comments.
Always at Your Fingertips
There are certain things that always come up in blogging for which you need quick reference. These reference worksheets may be best printed.
- HTML Cheat Sheet from Life Your Way
- Blog Notebook Printables by The SITS Girls
- Before & After Posting via By Regina
- Daily, Weekly & Monthly To Do Lists from By Regina
Tracking Affiliate Programs
Keeping track of your logins, passwords and affiliate dashboards can be a daunting task. Sugarrae has a spreadsheet that includes all of that and more allowing you to easily stay on top of your affiliate partners. Rae’s worksheet also includes columns for noting your commission percentage, affiliate link, cloaked link, affiliate manager and more. This can save so much time over logging into a network every time you need to grab a link or contact your affiliate manager.
I have long used this website earnings spreadsheet from Sugarrae. It’s a great way to track your blog’s monthly income and expenses. I don’t track clicks like Rae does, but that’s a possibility for those wanting an even deeper look into how their site is performing.
If you do a lot of sponsored posts or social media campaigns for brands, Simply Stacie has a great worksheet that tracking Accounts Receivable and blogging income.
The thing about tracking systems of any kind is finding one that works for you and that you actually use. Here are a few more to consider.
- Blog Success Worksheet from Retired by 40
- Blogging Income & Expenses by Blogging Mamas
- Printable Income Tracker by Kleinworth & Co
I use a spreadsheet very similar to the one below. It not only tracks your incoming traffic from popular social media platforms, subscriber counts, and monthly pageviews but also shows you the percentage change from month to month.
Take Action WAHM tells you how to set up a spreadsheet to track Pinterest Group Board promotion. I also have a very similar worksheet to this that I use for tracking what Facebook sharing groups I have put links up on.
Though we don’t like thinking about it, stuff happens. Everyone should have an ICE (In Case of Emergency) packet. This sheet includes the logins and passwords to your blog, hosting company, social networks, affiliate networks and instructions if needed, for handling each. Many bloggers have a close blogging friend designated to handle these things should something happen. If you will need to designate a friend or relative make sure your instructions provide clear instructions for what to do upon your demise.
Problogger doesn’t necessarily provide a spreadsheet, but he does tell you what yours should include. Get it here.
What are your favorite free blogger planners and spreadsheets?
Check out these popular posts from the Blogging for Profit category: