One the characteristics of internet marketing is that it is (or should be) DATA DRIVEN. That means you keep records, test, adjust and make your decisions based on the data you collect. This is all about testing, tracking and analyzing.
Although there are many tools that help you with this – ultimately, you are going to need to create and manage the data in a way that’s specific to your own business – and that means keeping your own records in spreadsheets.
I’m hoping that 90% or more of my readers are now nodding and saying “Yes – that’s obvious. What’s your point?”
But, sadly, I know from experience that rather more than 10% are saying something like “Oh, no! I’ve never used a spreadsheet before! Surely I can get round that somehow?”.
It was many years before I discovered how many of my subscribers struggled with spreadsheet. I wrongly assumed that anyone wanting to be an entrepreneur – and most especially an internet marketer – would obviously be familiar with spreadsheets.
Based on this assumption, I happily used spreadsheets as an integral part of various products and services that I provide. For example:
But I’m not about to change my approach to using spreadsheets in my products. Instead, I’m going to assert that, as an internet marketer you MUST become competent with spreadsheets. And after that long introduction – that’s what this article is about.
You don’t need to go to the extremes of using macros or Visual Basic, and you don’t need to get into the many complex and advanced functions and features, such as Pivot Tables.
There may be a few things I’ve missed out, but not much.
Your choice of technology to use comes down to three option:
Ignoring the fact that I just re-discovered my Microsoft account, and that admittedly, Excel is superior to Google Sheets (even the updated Google Sheets) – these days I use Google Sheets almost exclusively for my core spreadsheets. The only exceptions are my historical accounting records and a HUGE spreadsheets (800,000 lines!) where I was doing some analysis of the purchases of a major corporation. (I was certainly impressed that that Excel could handled that amount of data.)
Finally, here’s a good resource for learning Excel for free.