When NetGalley added feedback to approval ratios to profiles, there were a lot of questions, and in my case at least, there was a moment of sheer terror. Like a lot of bloggers, I went absolutely crazy with requests when I first signed up, and I also didn’t really pay attention to archive dates, so an awful amount of books I got approved for got archived before I got to downloading them.

My NetGalley ratio is **nowhere near** the recommended 80%, and I’m determined to increase it drastically this year. I know I’m not the only one whose approval ratio is lower than they’d like (though mine is pretty horrifically bad), so I thought I might as well do a post on HOW I’m planning to increase it in case it helps anyone else who wants to work on their ratio.

*I’ll be using screen shots from NetGalley with made up numbers just for the sake of easy maths and explanations.*

## Step 1 – How bad is it, really?

There can’t be a plan for improvement until you know just how far you’ve got to go, so the first thing I did was take a deep breath and check my exact approval ratio. For those of you who aren’t sure how to do this, log in to NetGalley, go to your dashboard and click the little arrow next to your picture. Scroll down until you see this:

There’s three important bits here.

- The most obvious is where it says ‘Yours is 25%’. On your profile, it’ll obviously have a different number, and this is your
**feedback to approval ratio right now**. - The number of approvals (in the example screenshot it’s 200)
- The number of pieces of feedback you’ve submitted (In the example it’s 50).

Okay, so now you know your current feedback to approval ratio, what’s next? (Hint, the answer is NOT get depressed about the fact you’ll never catch up and go on a requesting spree).

## Step 2 – How far have you got to go?

Remember how I said the number of approvals and the amount of feedback you’ve submitted were important? Here’s why:

**You need to know how many reviews you have to submit to hit 80%!**

Sure you could just keep reviewing until you get to 80%, but that’s not much of a plan!

This is where my favourite tool comes in: Excel! (you could of course use Google Docs or something similar, but I’m confident with Excel’s formula)

We’re going to use the first sheet of the workbook to:

- Find out how many books you need to review to get to 80% (and smaller milestones)
- Find out what each review is worth as a percentage

Here’s what my sheet looks like to do that:

You can see I’ve called **Column A feedback**, and underneath that I’ve put: the current number of approvals, 1, and 2.

I’ve called **Column B approvals,** and all three rows contain the number of books approved (200).

**Column C is called %** and I’ve put in a formula to tell us (exactly as it says) what each row is worth as a %. The formula for row 2 is: =SUM((A2/B2%)) [just drag it down to lower rows].

This first section tells us that 50 books is 25% (as NetGalley currently says), but also what 1 book is worth as a percentage (a lowly half a percent) and that two books are worth 1%.

Next we want to work out how many books we need to review to get to 80%. To do that, I’ve filled column E with various percentage targets (make sure to include the % symbol for the formula to work), and to work out how many books I need to review to hit that milestone I’ve put a formula into F2. The formula is =SUM(E2*200) [again just drag down as far as you need to].

So now we can see that a total of 160 books would need to be reviewed in order to get to a feedback to approval ratio of 80%. Now how are we going to get there?!

## Step 3 – What are those 200 approvals?

This is where it gets a bit tricky. Who can remember what those 200 books are and which of those you’ve already read? I haven’t figured out an easy way to figure that out yet I’m afraid! Here’s how I’ve been doing it:

- Go to NetGalley, click the arrow next to your picture and select Activity
- Copy and paste the list of books under approved into a separate Excel sheet
- Click the drop down menu on the right hand side and go to archived
- Copy and paste the list of books that appear now into the same Excel sheet you just added the approved books to.

Now as far as I can tell, that should give you a complete list of all the books you’ve been approved for (it does for my account). Here comes the time consuming bit: you need to figure out which of those you’ve read. I literally just added a column next to the list, and put each book in one of the following categories

- Read & reviewed
- Read & Need to review
- Unread, downloaded
- Unread, archived but available at the library (Yes I literally went through and searched my library catalogue for these)
- Unread, archived, no access

## Step 4 – Is 80% the best goal?

If in the example above, the blogger had 100 books unread and archived, the most she could achieve would be 50%, so there’s not much point aiming desperately for a ratio of 80%!

To figure out your maximum possible ratio, add up all the books you have no access to, then go back and stick that number into A4 (where it used to say 2). Then C4 will tell you what percentage those books are worth. Take that away from 100 and you’ve got your maximum possible percentage. If it’s below 80%, aim for whatever your maximum is. If it’s above 80%, it’s up to you whether you want to go for your maximum or go for the recommended 80%.

## Step 5 – How long will it take?

So now our example blogger knows she needs to write 160 reviews in order to hit 80%. She’s already submitted 50, so that leaves her needing to write 110 more reviews to hit her goal. But how long will that take?

This bit is of course completely up to you, your blogging schedule, and how often you want to write reviews! To work out how long it’d take, divide the number of reviews you need by how many reviews you want to write a week. Our example blogger could:

- Write 1 review a week, which would take 110 weeks (~ 2 years)
- Write 2 reviews a week, which would take 55 weeks (~ 1 year)
- Write 3 reviews a week, which would take 37 weeks (~ 9 months)
- Write 4 reviews a week, which would take 28 weeks (~ 7 months)
- Write 5 reviews a week, which would take 22 weeks (~ 6 months)

Admittedly, she’s got a long way to go no matter how many reviews she manages a week, but there’s a huge difference between writing 1 review a week and 5 reviews a week. Before you decide to go for loads of reviews a week though, you need to consider:

- Whether you really want to write that many reviews a week. If you currently write one a fortnight, the step up to several a week may rapidly lead to blogger burn out!
- Will writing more reviews a week mean you have less time for things you currently love posting?
- How many of your requests have you actually read? Go back to the list you made in Step 3 and see how many you’ve read but not reviewed. If there’s only 5 on the list, you won’t be able to keep up a pace of five reviews a week for very long before you need to start reading again!

## Step 6 – Get going!

I’m afraid there aren’t really any tips for this bit, it’s pretty much just sit down and write reviews! It may be worth considering though whether you want to reduce your NetGalley usage, so your percentage isn’t going down further while you try and catch up.

For advice on writing reviews, being organised and scheduling your reviews, try a few of these great links:

- NetGalley has 8 tips for writing a good book review
- A comprehensive guide from Kimbacaffeinate on writing reviews, with what to include (and what not to!).
- You can’t always love a book, so for tips and tricks on writing a negative but fair review, try this post, also from kimbacaffeinate
- Celine’s post on creating a blogging calendar and her post on 5 tips to help schedule posts
- Amanda’s post on creating a blog schedule, being organised and scheduling

Increasing your NetGalley Feeback to Approval ratio probably will be hard, I admit, but that doesn’t mean it’s not worth trying. If your ratio is currently at 15%, think how great it’d feel to get to 50% or even 25%! (And if it means you’re more likely to get approved for that book you want, that’s a definite bonus!)

It may be slow, but watching that percentage go up, even a little is really satisfying! Last year, my NetGalley ratio terrified me, so I pretty much avoided looking at it. By forcing myself to face up to it, I’ve managed to get motivated, and increase my ratio by 8% since the start of 2014.

## bookgeeking

/ January 18, 2014Approving my rating is definitely a goal of mine this year, read 4 already this year, so doing okay. I download them the moment I get approved, most go to kindle, none have expired yet (as far as I am aware) apart from the two that I got approved for after they archived them. I am trying to mix between ones that are being published at a certain date, the oldest ones and the newest ones. I thankfully only have 50 unread but my rating is still not great. I am hoping to improve my ratio by at least 10% each month. :) Good luck to you :)

## studentspyglass

/ January 18, 2014Thanks :) I’m aiming for 5% a month at the minute, (although I’m ahead of that for January obviously). 50 unread isn’t too bad, and it’s great that you don’t have any that have expired!

Good luck to you too :)

## Rachael @ Rachael Turns Pages

/ January 19, 2014Great advice. I don’t use netgally because I have a lot of other books to read, but I do wish you luck in this goal.

## Celine

/ January 19, 2014Great post Faith! Once I bring my physical TBR down I’m going to tackle the Netgalley one (my approval rate is like 40% – which isn’t all that bad considering). Good luck on the path to that coveted 80% ratio, and thanks a lot for linking up my posts (:

## Livvvy75

/ January 25, 2014Haha all this maths makes that glowing 80% approval to feedback look achievable. I totally have to figure mine out. Thanks so much for this post, had not thought of it like that! I know what you mean about crazy requesting in the beginning!

## studentspyglass

/ January 31, 2014No problem, hopefully it can help us get back on top of things!

I went through all these steps to try and get organised so I thought I’d share in the hope it can help someone else :)

## Livvvy75

/ January 31, 2014Thank you – it certainly has! It’s motivating me and actually making it look reachable.

## Rinn @ Rinn Reads

/ January 28, 2014I NEED THIS, FAITH!!

But you already knew that… =P I’m not going to add the formula right now but I will be adding it to my spreadsheet soon – that’s a really handy thing to have!

I found that Netgalley has a really weird system, sometimes if a book is archived you really have to go digging for it. To add the feedback to all the archived ones, I had to find them first (via Activity then Archived I think), then add them to my shelf manually, then go back to my shelf and add the feedback one by one. Then I removed them from the shelf as the feedback (or rather message saying I was unable to review =( ) was sent and there was nothing further for me to add.

Thanks for this post, there’s some really helpful hints! =D We can support each other through this tricky time, haha!

## studentspyglass

/ January 28, 2014Haha no problem, glad to be of help! I figured I couldn’t be the only one who needed to get organised, and I figured going through my process step by step maybe it’d be of help to someone else too.

Yeah the NetGalley system is really strange. For ages I couldn’t get the number on my dashboard to equal the books on my shelves. I assumed that if I went to my Shelf and selected All, that would be all of my books and it wasn’t. I think I had to go to Activity – Archived and add those to Activity – Approved to get a complete list.

Stormy’s tip about the notes to publishers was so helpful. It’s depressing how many I didn’t download and therefore couldn’t review, but at least my ratio went up as a result of owning up to it!

Supporting each other definitely sounds good! Did you sign up for Vicky and Celine’s Review Copy Clean up in February? I’m hoping it’ll get me motivated to get through a few of my unread NetGalley titles.

## Rinn @ Rinn Reads

/ January 28, 2014Celine mentioned it to me yesterday – I will definitely sign up tomorrow when I sort more site stuff out! Sounds perfect, I could dedicate (almost) all of February to ARCs and see how I go…

Also, I just submitted another review and my ratio is now 30.5%! Aaaaahhhh! =o

## studentspyglass

/ January 28, 2014I know, I just went through and did a whole bunch of “Thank you for the chance to review this book, however unfortunately I was unable to download this title before it was archived” and my ratio went up by 15% !

I’m aiming for at least 2/3rds of my February reads to be review titles. That still gives me a little bit of freedom at least!

## Ashley

/ February 2, 2014Great post! I think one thing that helps is remembering to leave books you DNF. I had a few books that I only read like 10 pages of before quitting, so I didn’t submit feedback for them at the time. But then, I eventually went back and submitted feedback, even if it was just a few sentences saying:

So even if you can’t actually finish the book, you can still submit feedback and tell the publisher why you decided to DNF! That helps a lot if you have a bunch of books that you tried to read but couldn’t get through.

## studentspyglass

/ February 2, 2014Yes, this is such a good point! It hadn’t even occurred to me that you could do that (or that it would count towards your ratio if you do) until after I posted this. It’s such a helpful tip though because it means you can draw a line under those books you couldn’t get on with/the ones eaten by a kindle/those you didn’t download before they were archived.

## Lauren @ Lose Time Reading

/ February 2, 2014Improving my Netgalley status is definitely a goal of mine. This post is incredibly helpful to me, it made me realize that my future on Netgalley is not as daunting as I thought :P Thanks so much for this!!

## studentspyglass

/ February 2, 2014No problem! My NetGalley ratio had been depressing me pretty much since it was implemented so I finally took the plunge and decided to do something about it. It’s slow going, but knowing now that I can do it (and exactly how far away from a milestone I am at any point) helps a lot in terms of keeping motivated. I’m just setting myself mini goals of 5% increases for now and so far it’s working!