Academy ↓
Hey there stranger!
Sign up to get access.
Tracker Tactics
About this Tutorial
Video Transcript
00:20 There may be some things that your audience or your buyers may want Either in making something very simple or creating sort of a more visual appeal Or making something more useful which I'll show you some scripts that might help you The first tracker is something I just created very recently actually
00:42 the most recent one. It's called big year It is a single tab that has the entire year in it instead of a calendar that has individual months this has every single month of 2024 I gave this away for free and then I asked people what else they wanted and one of them one of the buyers or not buyers umm
01:02 people who got this members of betterheats took uhh took a look and was like I need some checklists I need check boxes here and I thought this is pretty cool so I made a checkbox version of this and this is every single day of the entire year and a checkbox three checkboxes for every single day this
01:20 might be very good for tracking habits you may be able to track something daily it's very good for personal development life development mental improvement fitness those kinds of things anything in a personal life may be not as great for work because it is every single day but you could basically edit
01:43 this for a work day or work schedules I also have this tiny version which I don't think is a very good tracker but its great for printing and tracking umm one thing I did here is I had to make sure that there was space for writing stuff not for including stuff to be written in a spreadsheet so thats
02:06 one change I would do here if you were looking to use this as a sort of a rubric or a template for yourself to create something else and I wouldn't necessarily have three I would make it very specific to what you're doing especially like if you're creating some kind of social media posting checklist
02:23 I would have a check box designed for each social platform or if youre focused on like instagram I would only have one check box for maybe every day of the week that is a post and every day of the week that is real or or I would have different check boxes like a little checklist in each of the boxes
02:49 to say okay did we do we have everything ready do we have all the notes ready did things get approved here and I would make it more work flowy perhaps but this just gives you a good idea of fitting a lot of stuff into one tab might be doable especially if your if your audience is printing or downloading
03:08 and using a pdf version of this makes it really cool okay dark habit why I made this this is actually something I do sell and I have sold a couple I had a problem for a while where I was like I need to break bad habits by tracking them or tracking the not doing a bad habit I also wanted to try to create
03:34 a dark mode version of a spreadsheet and it thematically sort of went together of tracking hey these are streaks that I don't want to stop which is not drinking alcohol or not overeating or anything anything you want to track I wanted to make it modular so you could change what you were tracking instead
03:56 of just one bad habit and so yeah it all fit together sort of super well but here you can set goals it's modular you can choose any of these emojis you can even have a pretty blank one or if pizza if you want to not eat pizza if you want to not drink if you not want to smoke not gamble all that kind
04:17 of stuff I added a few there So if it, underneath the Emoji, you click the Check Box. And what this does is it has an on edit event that looks at this tab and says If it's edited.
04:46 Add it to your Data Tab. And so it keeps a log of . Every single time you check it And it even includes the same days but the Streak Tracker only tracks the number of days Ok so this will show up in the next tracker as well essentially some trackers are tracking every time you in every event and every
05:16 action you take but these this one and the next one track anything is a daily tracker you're only tracking if you're doing something within a 24 hour period and youre counting it as 0 to 1 and if you do more than once it doesnt necessarily show up and so this is great if youre doing some kind of simple
05:37 sort of on and off kind of tracking uhh if youre doing some personal tracking and youre like you know showing up every day is not umm great for personal development if you just want to show up and you just need to execute something each and every day let's go over to track anything and let's just see
05:59 it this way instead of tracking all different types of things and you have to click a specific box for each event this one it's only tracking one thing and you just click A1 when you click A1 over here its gonna show up on this calendar here that just showed you right there this Thursday and its gonna
06:22 show an emoji and so this is how do I explain this? This is showing you a full week vertically and then the number of weeks horizontally so instead of us seeing lets say for bad habits you know day of the week doesn't necessarily matter its like a person this however may be great to show you like oh
06:48 you need it be when are your energy levels high are you taking some action on these particular days and i have to say this is also very helpful to show full week from in in a different way than the streak is to show from an initial point of time over time how does your actions develop are you doing it
07:11 more over time this is very similar to github tracker it hub commits tracker if you're familiar with that if you're not familiar with that what they do differently than this does is that this only shows you if you've done that action once within 24 hours they have a little bit of a heat map version that
07:30 says okay how many times that darker it is the more times youve done that action on that day but what I like about this is like if Im tracking lets say if Im a solo partner and Im working 7 days a week or rather anytime I want and I want to just see like how do I actually work?
07:50 When do I actually show up? Am I showing up on Mondays or Sundays or Saturdays and how often and from a period of a moment in time till then this is not based on a calendar I mean it sorta is.
08:04 But it's 1 through 52 so I've augmented or changed this time year instead of okay I did this because when you start a project many times we follow into a trap where like yeah sure we can start a project on January 1st and see that calendar and calendars help us keep track of like this external year but
08:33 this you can set the day that you start and it shows you 52 weeks and so that is your year compartmentalized out of two like maybe two years so you can start a project anytime and do you show up every day do you show up five times a day three times a day are you doing something uhm this is also good
08:52 for fitness are you missing some weeks all right or once a week or five times a week are you balanced this might actually be very good for a tracking something where you want balance where you want to show up most days where you may not necessarily need a streak like bad habits you just want to cut cold
09:16 turkey you'd want to stop it and and every single day you're not breaking the chain this one however is not really good for breaking chains or seeing chains because it is vertical its a little wonky but its great for tracking and visualizing are you at least showing up when you expect to showing up and
09:37 checking off that box within a 24 hour period. Last one is project oriented so the first one was year oriented a single year umm dark habits was about streaks and tracking those streaks and never stopping track anything is any particular 52 week period you want and can be very modular for your needs
10:01 but this one is project oriented this is a tracker this is a just a course outline it's actually the course that i'm making right now and what i've done to set it up is add checklist and show my progress and as i check it off a few things happen one i show how many ive taped how many minutes ive executed
10:22 so im summing this all up and im checking off a visual boxes of these check boxes theyre changing from blank blink gray squares to checks so why i need all of this is because our brains at least my brain works in a number of different ways sometimes i see oh my god i have 53 things to do but i also see
10:48 the minutes so instead of thinking 53 random videos to make it's like no i have to spend 379 minutes that makes it easier for some reason to start just execute get some minutes in and if i execute some five or ten minutes that's two down and then i start getting a little bit of a on a roll i would say
11:15 as i progress through it i want to see maybe not the minutes i have are number literally a single number but i want to see the amassing of taped episodes right or lessons here i want to see those and that gives me sometimes oh i've done six that sometimes that gives me some motivation to keep going i've
11:40 done six let's do seven let's do eight but also i have to say my brain works in very different ways once i've gotten like halfway through i realize have i done the most important stuff cause how many minutes the minutes percentage may be different maybe ive backed umm put the longer videos in the back
12:00 or ive done the longer videos in the front so maybe im sixty percent of the way through with the lessons but im only forty percent of the way through with minutes depending on my mood im getting motivation from different aspects so i think this is really unique because it could give you motivation in
12:20 different ways and it could show you tracking umm not just a number but of minutes spent or minutes done umm i think it would be this has helped you and inspired you to start creating your spreadsheets soon in the next section we'll actually go and make some spreadsheets bye
Courses
Selling Spreadsheets Course Introduction
SECTION 1 - You Are The Sheet
Coupon Code Maker Updates February 2024 - New Dashboard
How to Make Good Looking Spreadsheets
Curate Google Sheets Easily - Automatic Bookmarklet Maker
Explore Your Spreadsheet Selling Options
What you know matters
Who you are matters
How you think matters
Why you think it matters, matters
Surprising Things about Selling Spreadsheets
SECTION 2 - Your Spreadsheet Blueprint
Easiest Sheet Ever to Sell
Problems Everywhere, and the Spreadsheets that Solve Them
The #1 Mistake Spreadsheet Sellers Make and how to Save People Time
Customer’s Context Is King
The Two T’s: Turn Templates into Tools
Create a Branded Lead Magnet from Qualitative Data
Tracker Tactics
SECTION 3 - How to Make a Spreadsheet
Ask Questions
Quality Curation
Fabulous Filters
Wield Wizardry
Automatic Calculations
Automate Emails
You Must Double Duplicate (If you're selling a sheet you use)
Different Kinds of Automation
How do I prevent people from sharing my spreadsheets by making a copy?
SECTION 4 - Spreadsheet Sales Mastery
Write The Sales Page
The Strangest Secret to Selling a Spreadsheet
The F Word
Reciprocity Rules
Pricing Strategies for Spreadsheets
Upselling and Cross-Selling Techniques
Avoid A Multi-Tier Approach
SECTION 5 - Marketing Mastery
Where to Sell Spreadsheets - Marketplace Marketing
Customer Service is Marketing
Six Figure Secrets
How to Sell Spreadsheets on AppSumo Marketplace
Protect Your Spreadsheet IP
Lock Your Sheets with OnlySheets
Weird Idea: Find a Great Sheet Domain Name
A Few New Spreadsheet Business Ideas
SECTION 6 - Spreadsheet Breakdowns
Maximize Spreadsheet Sales to Startups
A Spreadsheet CRM: Automation at work
How to Make Better Lead Magnets
How to Turn a Simple List into an Epic Lead Magnet
The Art of the Sell: Breaking down a Free Title Generator
How to Make an AI Integrated Freebie Spreadsheet