TES Author Sales Tracker and Analysis Tool

A ready-to-use tool to track and analyse your author sales on TES. This tool is simple (no need for Excel skills) but also powerful. The analysis that I was able to undertake using this tool allowed me to rapidly increase my TES sales from bronze to gold level. Watch the preview video to see how you can use it to grow your TES author business.

• Simply copy and paste the sales data from TES - the magic of Excel does the rest.
• Full instructions provided

Summary Sheet:

• See the value of your sales, and the amount of your author royalty.
• See your average sales per day, and the date you can expect to get to the next tier.

Analysis Sheets:

• See how often each resource has sold, the average price it sold for, and how much you have made from each resource.
• Spot what makes your best sellers more successful, which resources sell the most and which are most profitable (not always the same thing!).
• Spot which resources have stopped selling using the Title Sales by Week sheet.
• See the number of sales and the amount of royalty you made week by week - this is always nice when your business is growing!
• Work out the best times to promote and upload your sales with the sheets that analyse sales by day of the week, hour of the day and even by country.

As this is just a normal spreadsheet there is no software to download and the spreadsheet should work fine on work issued laptops.

Instructions are provided so that you can easily change the chart type (e.g. from a pie chart to a bar graph) on most sheets. There are filters on most sheets so that you can select a specific date range e.g. to ask “what are my biggest sellers this week?” For those more proficient in Excel the spreadsheet is not locked so you can easily build upon what is already provided.