by Louise Harnby
(Editor’s Note: This is Louise’s last essay for AAE. Because of demands in her business, she has found it increasingly difficult to find the time needed to write the high-quality and informative essays she has been writing since she first began contributing to AAE in 2013. All of us at AAE wish her continued good fortune and hope that sometime in the future she will be able to resume writing for AAE.)
This isn’t an essay about what one should charge. What you should, want, or need to charge to make your editorial business sustainable may be different from what I should, want, or need to charge to make my proofreading business sustainable. Rather, I’m focusing on how even experienced editorial freelancers should regularly evaluate what they are charging and how they are determining the price for a job, and whether they should introduce new pricing models that could increase their income. We’re back in the world of testing.
Tracking the data
If you don’t know what you need to earn each fiscal year (required earnings) and you don’t know what you are earning each fiscal year and how many hours you are working to achieve this income (actual earnings), you can’t evaluate whether your business is profitable or unprofitable, nor whether it is in financial growth, stagnation, or decline. And if you can’t evaluate the health of your editorial business, you won’t be able to evaluate the impact of introducing new pricing models, new services, new working-week regimes…new anything, in fact!
Data tracking doesn’t have to be complicated. I use an Excel spreadsheet to track my work schedule and earnings (a very basic template, which you can adapt for your own purposes, is available on The Proofreader’s Parlour at “Editorial Annual Accounts Template (Excel)”). Each line in my annual spreadsheet tells me the name of the client, the client type, the title of the project, the word count, the price charged, the time taken to complete the job, the dates for arrival and completion, an invoice number, the number of words per proofread per hour, and £ per hour earned.
At the end of the year, I can see at a glance my total earnings, my average billable hourly rate, and my average billable rate per 1,000 words. I like to record previous years’ totals on my current spreadsheet so that I can make quick annual comparisons. In this way, I have a macro view of my business.
I can also look at micro issues including, but not limited to, whether particular types of work are proving more lucrative than others (e.g., students vs. indie authors vs. publishers). I can see what’s working well and what’s working less well. That tells me how I might want to focus future marketing activities in order to expand the amount of work I do in the most profitable sectors.
Importantly, I track all requests to quote, so I know how much work I turn down, refer, make an offer on, and whether those offers convert into bookings or are rejected by the client. I keep a spreadsheet on my mobile phone that logs all requests from new clients. This logs the type of client (e.g., student, agency, author, publisher), the date the request was received, the type of work (e.g., thesis, book, report), and my response (offer, referral, decline). If my offer converts into a booking or if the client declines my offer at a later date, I amend the spreadsheet. Requests to work for existing clients are logged in a separate file on my PC. All confirmed bookings are entered into my annual accounts spreadsheet.
The data that you need to collect and evaluate will not necessarily be the same as the data that I need to collect and evaluate. One thing’s for sure, though – the more data you collect, the more insightful your conclusions will be.
Testing different pricing models
Even experienced editorial freelancers can fall into the trap of not testing different ways of pricing. When I set up my proofreading business, most of my work was for publishers. In the main, the publisher offered an hourly rate and a budgeted number of hours in which they expected the work to be completed. I would accept, negotiate, or decline. I became used to thinking in terms of hourly rates and this model was the one I used to build a price when I was quoting for other client types, even when I was in control of setting a price. So when a student asked me to proofread a thesis, I’d estimate (based on a sample) how many hours the job would take, and then multiply the figure by my self-determined hourly rate.
There’s nothing wrong with this type of model. Many people prefer it and believe it to be the most profitable way of working. However, it is not the only option; and even if it is the most profitable way of working for person X, it may not be the most profitable way of working for you. Furthermore, different models may yield better returns depending on client type or editorial service.
What is certain is that unless you test different pricing models, and record the data acquired during your tests, you won’t know whether model A or model B is your best choice. Here’s a breakdown of how I went about testing an alternative pricing structure.
The pretest micro view
Note that my data tracking, reviewing, and testing decisions are particular to my business. I’m a proofreader who specializes in working on book-length projects for academics and independent authors. I sometimes work on postgraduate dissertations and theses, business reports, journal articles, and promotional material. In general, my proofreading service is fairly uniform in terms of what I’m required to do. Projects rarely overlap — it’s a case of project in, project out, move on.
After several insightful discussions with a trusted colleague/friend who used a different pricing model to my hourly rate one, I decided to take another look at my data. First, I looked at my macro-level totals. These told me that my business was growing year on year. That’s all well and good, but what about the micro data?
By looking at the micro data for each client, I was able to see which client types were giving me the best value for money for every hour I dedicated to working for them. Remember that at this point I was charging by the hour. My data told me, among other things, the following:
- When I was offered an hourly rate by publishers, I earned less per hour on average for this client type than when I charged independent authors, students, and businesses a fee based on price per hour.
- Three publishers were outliers and were competitive with my other client types.
- Many publishers were offering uncompetitive (for me) rates, though they were low-risk clients — long-term customers who paid on time, offered regular work, and were thoroughly enjoyable to work with.
- I was turning down a lot of work from indie authors and students because there was no room in my schedule. Some of those slots were being taken up by the less-competitive but long-term, low-risk, much-loved publishers!
The pricing-model test
I decided to take a leaf out of my colleague’s book and test the per 1,000 words pricing structure for indie authors, students, and businesses. I created a formula in an Excel spreadsheet that uses an array (see “Guidelines and examples of array formulas”). The array is useful because it takes a large number and break it into blocks of units. Those sections can be priced differently. So, for example, one could set up an array formula such that the following proofreading prices might be generated (these are fictitious examples for demonstration only):
- Initial 2,000 words: £18 per 1,000 words
- Next 3,000 words: £14 per 1,000 words
- Next 5,000 words; £10 per 1,000 words
- Next 20,000 words; £7.50 per 1,000 words
- Next 10,000 words; £7 per 1,000 words
- Next 10,000 words; £6 per 1,000 words
- Next 10,000 words; £5 per 1,000 words
- Next 20,000 words; £4 per 1,000 words
Thus:
- 100K-word novel = £658. Average rate per 1,000 words = £6.50
- 40K-word novella = £348. Average rate per 1,000 words = £8.70
- 10K-word business report = £128. Average rate per 1,000 words = £12.80
- 2K-word children’s book = £36. Average rate per 1,000 words = £18
You could build different arrays for different client types or different services. These would reflect the different demands of the work. Fundamentally, the array formula allows you to build economies of scale into a pricing structure.
The test results
I introduced the test pricing model in August 2015. One year later, my average earnings per hour are now 40% higher. That increase is a piece of macro information that’s pleasing to note, but the micro data are worth discussing, too. My posttest evaluation of the data told me the following:
- When I charged indie authors, students, and businesses on an hourly basis, I earned less on average than when I set the fee on a per 1,000 words basis.
- When I set my fees on a per 1,000 words basis, I earned more per hour from businesses than from students and indie authors.
- The business projects tended to be much shorter in length. Therefore, the total earnings per project were higher when I worked with indie authors and students.
- All of the businesses wanted a fast turnaround, which incurred a premium rate (hence the higher per-hour earnings mentioned above) because of the out-of-hours nature of the work.
The posttest evidence-based decisions
Evaluating the micro and macro data (and talking to a trusted colleague) helped me to work out where I might have been guilty of basing my pricing structure on untested assumptions, and where there could be room for improvement. Testing, and evaluating the results of that test, enabled me to make evidence-based decisions about client focus and marketing. Personally, I prefer to have fewer short turnaround projects on my books, and a greater number of longer, but profitable, projects. That means:
- I’ve whittled down my publishers to a those few whose rates are competitive with my other clients. That meant saying goodbye to some long-term clients whom I had very much enjoyed working with.
- I’ve increased my promotion focus on the student and independent-author markets.
- I now favor a price per 1,000 words model (there are exceptions) over a per-hour model.
- Fast-turnaround work for businesses on a per 1,000 words basis is very lucrative but rarely fits comfortably into my standard proofreading schedule because of the large amount of book projects I am commissioned to work on (especially fiction). I prefer not to work out of hours so I’ve increased my out-of-hours premium levies (from double to triple) to reflect this position.
If I’d not recorded and evaluated my data, I would not have been able to evaluate the then current state of my business and identify opportunities for potential growth.
Following on from that, I’d not have been able to take actions (e.g., the pricing-model test) that would affect the future state of my business.
In my case, it’s not just the change in pricing model that impacted on the increase in my average billable hourly rate; looking at the micro elements of my work schedule and accounting information helped me to fine-tune my existing client base (e.g., publishers aren’t out of the mix — I do still accept work from a small number of competitive presses, even though they set the fees and even though these fees are based on hourly budgets; and my out-of-hours premium rates have increased).
Using your business ownership to make
choices for growth
Owning an editorial business means you have choice — choice about what to charge and how to charge, and choice about what to accept, negotiate on, or decline. What works for your colleague may be less fruitful for you. Some pricing models may work better for particular client types. And different types of editorial service may favor different fee structures.
When it comes to pricing, what you know is as important as what you charge. If you are basing your fee structure on untested assumptions, you may not be getting the best out of your editorial business. I’d recommend that we all regularly look at our work schedules and accounts in detail, evaluating the data at micro and macro levels. We should ask ourselves whether there’s room for improvement and consider testing new models (pricing, of course, isn’t the only thing we can test). In this way, we can make evidence-based decisions about how to charge, where to target our marketing, and which clients to say goodbye to and which to retain.
Louise Harnby is a professional proofreader and the curator of The Proofreader’s Parlour. Visit her business website at Louise Harnby | Proofreader, follow her on Twitter at @LouiseHarnby, or find her on LinkedIn. She is the author of Business Planning for Editorial Freelancers and Marketing Your Editing & Proofreading Business.
The Business of Editing: Managing Comments with Comment Editor
Tags: Comment Editor, cost-efficient, EditTools, macros, profitability, timesaving
We all know that Microsoft Word wasn’t designed by editors for editors. As good a program as it is, it is a compromise. The result is that some “features” aren’t really features for editing; instead, they are time-consuming and thus cost efficient editors money.
This is certainly the case when it comes to managing comments and queries (hereafter “comments” means both) we have inserted in a manuscript, regardless of whether we inserted them using Word’s method or EditTools’ Insert Query macro. For example, to delete a comment, Word requires us to locate the comment in the text, select it, and delete it. Similarly, to modify the text of a comment, we need to locate the comment and open it. I have had instances where a comment I inserted on page 3 of a document needed to be changed because of information on page 19. To edit the page 3 comment, I had to leave page 19, not my preference when the only reason to do so is to be able to edit the comment. But that is the Microsoft way.
EditTools’ Comment Editor changes the way I deal with comments and has reduced the time I spend “managing” comments — which, in my editing world, means more profit for me.
Comment Editor is an easy-to-use method for reviewing and modifying comments created using either EditTools’ Insert Query macro (A) or Microsoft Word’s method. Comment Editor is accessed from the EditTools ribbon as shown here (B). Comment Editor can also be accessed by keyboard combination. To assign a hotkey combination, go to Hotkeys (C) and choose Set Up Hotkey for Macro and choose Comment Editor.
Comment Editor on the EditTools Riboon
When a comment is inserted, Word automatically numbers it as shown here (#1):
The Comment Editor dialog
The Comment Editor dialog is shown below. It is from this dialog from which anything that can be done to a comment is done. There is no need to locate the comment in the text or go to it; wherever you currently are in your document is where you will stay unless you choose otherwise.
Comment Editor dialog
When you open Comment Editor, the main text area (#2) is automatically populated with every comment present in your document. As you can see, in our example, the document already has six comments. Comment Editor gives you a few options. If you use Word’s method to edit a comment, you need to go to the comment — otherwise the comment is inaccessible. That means you need to leave your present location in the document. For example, if you are at the location where comment 5 is found and realize that because of the text at that location, you need to modify comment 2, with Word’s system, you need to go to comment 2. Word also doesn’t provide a way to automatically return to where you were in the document.
Comment Editor doesn’t work that way. Instead, Comment Editor offers you the option to go to the comment or not. If you want to go to the selected comment, you can click Go to Comment (#3) — the manual way of going to an individual comment — or if you prefer to always go to the comment, you can set your default to automatically go to a comment when it is selected (#4). When you are done, you can return to where you were in the document by clicking Return to Before (#3), the manual method, or make your default that you automatically return when Comment Editor is closed (#4).
Another difference from Word’s method is that to get to a specific comment in Word, you go to the Review ribbon and click Next or Previous. In contrast, with Comment Editor, you simply choose the comment you want to go to in the text field (#2).
When you select a comment in the text field (#2), you are given several bits of information: comment ID or number, a small amount of the comment’s text, and the text you attached it to (see, e.g., #1 above). More importantly, you are also shown the complete text of the comment in the Text field (#5). This Text field (#5) is where you edit the comment. If you make a change to the text, click Update (#6) to update the comment in Word. Want to delete the comment? Click the Delete button (#6) and the comment will be deleted from your document and the comments will be renumbered.
If you want to keep Comment Editor open until you manually close it, check the box at #7. Comment Editor also displays the total number of comments in the document (#8) should you not be able to see all of them in the main field.
Inserting a new comment
Note what is currently comment 6 in the list of comments shown at #2. In the image below, Insert Query has been used to insert a new comment (arrow), which is numbered 6 by Word.
Inserting a new comment
If we reopen Comment Editor, you can see that there are now seven comments listed and the comment we added above is shown as number 6 (violet highlight and arrow).
Reopening Comment Editor
If you were to use Word’s method, you would see the new comment at the bottom of the page, as shown here. (In this image the numbers 5 and 6 correspond to comments 5 and 6 in Word’s viewing pane.)
Word’s display
Modifying a comment in Comment Editor
Using Comment Editor, it is easy to modify a comment. As shown in the image below, we have selected comment 6 to modify (#9) by clicking on it to select it. Its text appears in the Text field at the bottom of the Editor (#10). The text we are adding to the comment is highlighted in yellow (for illustrative purposes; the highlighting is not part of Comment Editor) (#10). Clicking Update (#11) will add the text to the comment.
Modifying a comment in Comment Editor
Before modifying the text, you will be asked to confirm that you want to update the comment, and the comment to be updated will be identified by its ID (circled text below):
A comment’s identification
Clicking Yes results in the comment being updated as shown here:
Updated comment in Word’s view
which we can see in Comment Editor when we reopen it:
Updated comment in Comment Editor
The editing of the comment took place solely within the Comment Editor. Comment Editor lets us see the complete text of all comments in the document and lets us manage the comments as needed. Time is saved because we no longer have to travel around the document to find the correct comment to edit or to do the editing.
When there are a lot of comments
Dealing with comments in a long document that has many comments can be tricky. An example is shown in the image below, which shows the comments in the chapter I was editing when I was only two-thirds through the document. At this point in time, I already had 42 comments in the document (see #12). Because I could scroll through the comments in Comment Editor, I was able to locate the comment I needed to modify and change its text without moving from my present location in the document. A much easier and faster way to manage comments, especially when there are a lot of them.
Example of Comment Editor’s Ease of Use
In my experience, it is not unusual for one comment to be dependent on another comment, or even on several other comments. Before Comment Editor, I had occasions when I had to go to and check several comments, modifying some of them, deleting others, which took time, especially to locate the correct comments. Comment Editor has made that process quick and easy.
Comment Editor is a much easier, quicker, and more efficient way to deal with inserted comments in Word than the method offered by Word itself. Most importantly, because it is efficient and a timesaver, using Comment Editor means enhanced profitability.
Richard Adin, An American Editor
Related An American Editor essays are:
____________
Looking for a Deal?
You can buy EditTools in a package with PerfectIt and Editor’s Toolkit at a special savings of $78 off the price if bought individually. To purchase the package at the special deal price, click Editor’s Toolkit Ultimate.
Share this:
Like this: