Marketing Metrics Basics: Taking the Fear Out of Using Excel

man_at_outdoor_computer_desk

Excel Easily Becomes Your Bookkeeper and Your Business Manager

Recently during a mastermind conference call with my fellow copywriting colleagues, two of my fearless writers expressed their concerns and frustrations with communicating updates via an Excel file for a client project. My creative writer friends cringed at working in Excel, but had no choice in complying with the request if they wanted to keep working with the client.

Despite these frustrations, Excel can be useful in your copywriting business. Especially if you’re just starting out and need a bookkeeper — yet can’t afford one. Below I’ll show you some of the basics within Excel, along with some examples you can apply to your business today.

For instance, in a previous article, I suggested you start tracking four basic metrics for your copywriting business — Response Rate, Sales Conversion Rate, Revenue, and Return On Investment (ROI). I’ll show you how to set up an Excel spreadsheet to track these results so you can figure out your specific average results. You can then use these average results in your marketing and in your sales conversations to differentiate yourself from other copywriters.

The other example will show you how to set up a simple Excel file, with two separate tabs, to track your revenue and expenses for your copywriting business. In the beginning stages of a business, hiring a bookkeeper or purchasing a monthly subscription to an online accounting program just isn’t feasible. This spreadsheet will help you stay organized and ready for tax season.

This article is reserved content for Wealthy Web Writer platinum members. To continue reading this article please log in or become a member today.

Avatar

Jean Baliko

Leave a Comment

Scroll to Top