Setting up a prize spreadsheet to track competition wins
It’s a new year and we’re all raring to get winning! Get ready to welcome all those shiny new prizes into your home by creating a spreadsheet to record all the details. Unlike a notebook, a spreadsheet enables you to tally up totals easily – you can also search it and create pie charts to see how well you do with different types of comps.
Here’s a screenshot of my 2021 prize spreadsheet to show how it works:
At the top you can see I have a green highlighted row – the ‘value’ in this row contains a formula and automatically updates with a running total when a new prize is added. If I’m not sure on a prize value I try to estimate it – if I’ve not had a prize delivered yet I’ll leave the value box blank until I know exactly what I receive.
It’s always exciting in December to look back over the year and see the total value of all your prizes – check out my 2021 comping year blog post for a complete breakdown of the statistics and graphs I have from my spreadsheet!
Over the years I’ve added new columns to my basic spreadsheet. I track whether I’ve responded to the winning notification, and also have a column to track if I’ve featured the prize in my monthly unboxing video on YouTube. Where possible I try to thank the promoter too, so I make a note of how I do it (usually a tweet or Instagram story).
I use Google Drive to create my spreadsheet – log in at http://drive.google.com using a Google or gmail account. The Drive app is also worth downloading to your mobile device. Using Google means you can access and add to your prize spreadsheet from your computer, phone or anywhere in the world.
Why keep a prize spreadsheet?
It’s useful to:
- calculate the value of the prizes you win over a certain period of time
- check on the prizes you’ve not yet received and the date you won them, so you can chase them up after 28 days
- give you a boost during a dry spell – you’ll be surprised how many small prizes you win, and making sure you list all those little wins will help you feel more positive and enthusiastic
- see which type of competitions you’re most successful with, and should be focusing on
- remind yourself to say THANKS to the promoter, which is really appreciated
- see how you’re doing if you set yourself regular comping goals – eg. to win a prize a week, or to win ten Instagram competitions in 2022!
Check out my Comping Year post to see how I use the information from my spreadsheet to do my annual comping success report.
How to set up your prize spreadsheet
- Click this link to Make a copy of my spreadsheet (if this doesn’t work, go to http://bit.ly/PrizeSpreadsheetTemplate then click FILE and MAKE A COPY)
- Tap in the title box to change the name of the document
- Type in the boxes to enter new content
It’s as simple as that! The box at the top will automatically update with your running total of prizes.
- Hover over the letters at the top of the columns and a small down arrow appears – tap this and you can Sort Sheet A>Z. Using this tool you can sort your prizes into value order, or type of competition – reset it by sorting the Date column.
- Delete or insert columns by clicking on the arrow at the top of a column
- If you tap Return in a cell, the cursor moves to the cell below – use Option-Return to start a new line in the same cell
- Change the width of columns by hovering between the letters until a blue bar appears, then drag the bar across
- Use different colours for text or background by highlighting a row, column or cell and clicking the A or the paint bucket in the top menu.
- Freeze rows at the top of a spreadsheet, so when you sort the content into alphabetical order those rows are ignored (on my template the top 2 rows are frozen)
- Create a pie chart or graph by clicking at the top of a column, then going to the … option at the end of the menu bar and tapping the bar chart icon.
- For advanced users, you can add filters to columns by selecting one or more columns, then tapping the funnel icon in the … menu. Tap the filter icon at the top of the columns and you can choose which values to display – for example, you can use a filter to only show you prizes you’ve won on Twitter.
- To search your spreadsheet, go to Edit > Find and replace and type your search term in – keep clicking Find to show all results
- Save your spreadsheet to your bookmarks bar for easy access!
Expanding your prize spreadsheet
For the last few years I’ve expanded my Prize Spreadsheet into a Comping Spreadsheet, by adding extra tabs (do this by tapping the plus sign at the bottom of the sheet), so I have:
- Prizes – prize spreadsheet
- Effort – list of creative/effort comps I want to enter
- Entered – effort, purchase or low entry comps I’ve entered
You could also add a Purchase comps tab, to keep track of your barcodes, batchcodes, and unique codes (I used to have a Purchase tab on my spreadsheet, but now use the compers shopping list and a daily task list in the Asana app to track my purchase entries instead!). Or add a tab to track your Text comp entries!
Compers always ask me if it’s worth keeping a spreadsheet of all the competitions they enter. I consider this to be a waste of time and means you’re focusing on the amount of comps you didn’t win, which can be rather deflating! Rather than recording everything, I just save details of the purchase, creative and low entry comps that I enter.
After entering purchase or creative comps I move these over to my Entered spreadsheet. On the Entered spreadsheet I also save links to any particular comps I’ve entered where I believe I have a good chance of winning – maybe a local comp or a comp with very few entrants. Then I can go back and check they announced a winner after the closing date. I highlight a row red if I didn’t win, and green if I did. White rows mean I’ve not heard of a winner, so when I have a spare moment I will contact the promoter to check a winner was chosen!
I hope you do decide to create a spreadsheet for 2022 – and let me know when you’ve added your first prize to it! Wishing you lots of luck for the year ahead.