Welcome to A FREE Seller Tool.com – Use data to improve your TPT Earnings!

Hey TPT Sellers!

Free Google Sheet analyzing TPT Seller Data - Product Stats CSV from TPT Dashboard. Colors indicate whether you should work on TPT Product Descriptions, Covers, or Keywords

FREE Google Sheet to help you analyze your TPT Seller Data

Do It Yourself TPT Data Analysis starts here!

NEW! Check out this Self Serve TPT Data Tool without Google Sheets!

Fix this in your TPT store to increase earnings.


Be part of a public movement

“Thanks for this great video and for the positive impact you’re having on our community!”
@teachietings
Dec 10, 2023
(read more)
“Yay! It worked. Thank you so much for getting back to me so quickly. And thank you so much for an amazing tool!”
@sheenalannin7829
Nov 15, 2023
(read more)
“Well done Enrica for standing up for Mike! You are a star burning bright and a role model for others”
@Eternal-Student
Nov 8, 2023
(read more)
“Just here to offer my support! I guess disrupters don’t like being disrupted, do they?… I do very well on TpT but am always keen to learn more. Until now, I’ve not found a place to communicate where I’m comfortable. I think I might have just found it.”
@Eternal-Student
Nov 6, 2023
(read more)
So sorry to hear about the black ball drama. TPT has too many [leaders] that take over too easily on what is right and wrong. I wish people would mind their own business. Best of luck to you!
TPT Seller
Sat, Nov 4, 2023
(read more)

Tutorial Videos

The FREE Do It Yourself Google Sheet is provided as-is without any guarantee of support or that it will work for you.

If you have any general questions (or would like to request a feature), please ask on one of the YouTube videos below!

This is a work in progress.

We are working on publishing more videos to help TPT sellers like you make data-based decisions… in case of just trusting your gut.

(Your gut might be right… but, let’s see if the data supports your theories!)

If you find this resource useful, please leave a comment on one of the YouTube videos.

No Time? Free 80/20 TPT Seller Data tool to focus on what works!

(What if you don’t need to update all of your products? What if you focused on the vital few? Could that help prevent TPT Seller Burnout?)

The Google Sheet seen in this video is Version 2023-12-02

How to do an 80/20 analysis of your TPT Store in less than 5 min

  • 0:00 Sneak Peek
  • 0:28 Introduction: TPT Seller Burn Out
  • 0:55 Is this video for you?
  • 1:37 Focus on the vital few (80/20 rule)
  • 3:54 How to do a FREE 80/20 analysis of your TPT store in under 5 minutes
  • 6:10 How to use the 80/20 TPT Seller data tool
80:20 Rule - TPT Seller Public Research Question 1

Is your store typical?

How to use your Teachers Pay Teachers (TPT) CSV Data to make business decisions

(Instead of just trusting your gut.)

The Google Sheet seen in this video is Version 2023-11-04a

A Deep Dive into TPT Seller Data (Master Class #6)

What Data Can Tell Us

Do you really need 300 page views before you can use your TPT data?

  • 0:07:50 How many TPT pageviews do you need?
  • 0:10:41 Do we need 300 pageviews? (cookie example)
  • 0:18:47 How many pageviews to be statistically accurate?
  • 0:22:33 Are TPT Seller “rules” oversimplifying how we make decisions

Be careful with TPT data.

It might not mean what you think it means!

  • 0:23:28 Does the TPT data tell us what we think it does (TPT ads)
  • 0:26:00 TPT SEO Snowball Strategy
  • 0:26:29 How do TPT Ads “work” (or how do we think they work)
  • 0:31:03 TPT Support
  • 0:35:58 How do we get TPT to innovate and embrace change?
  • 0:37:19 Data can be a distraction
  • 0:39:08 Test Assumptions
  • 0:40:19 What stage of the TPT journey should you use data?
  • 0:43:10 A Free Seller Tool.com
  • 0:43:15 Coffee break
  • 0:43:46 Free Google Sheet Tool walkthrough

How to IMPORT and use your “TPT Product Stats” CSV

  • 0:49:12 Part 3. TPT Product Stats CSV
  • 0:50:45 Getting your Product Stats CSV data into the free Google Sheet
  • 0:54:05 How to change the filter views (Product Stats CSV)
  • 0:55:18 PRO TIP – change the file name
  • 0:55:36 Key Performance Indictors: How are the colours set (Product Stats CSV)
  • 0:56:30 How do teacher buyers get to your TPT product page?
  • 0:57:50 Does the TPT data tell us what we think it does (TPT traffic dashboard)
  • 1:02:21 Traffic from “TPT” probably includes traffic from organic google search (Clickstream Data)
  • 1:05:05 Where do people go after leaving TPT?
  • 1:05:53 Active vs Passive Leads (Product Stats CSV)

The TPT Sales Funnel (What do the colors mean?)

  • 1:08:58 Sales Funnel / Sales Pipe from TPT Search (or Google Search)
  • 1:13:24 If your sold rate is low (red)
  • 1:15:01 If your preview rate is low (red)
  • 1:15:43 If your page views are low (red)

How to IMPORT and use your “TPT Sales Report” CSV

  • 1:20:11 Part 4. TPT Sales Report CSV
  • 1:21:30 Download your TPT Sales Report CSV data
  • 1:26:08 Upload your Sales Report CSV data into the free google sheet
  • 1:30:27 Troubleshooting when the CSV data upload doesn’t look right
  • 1:34:09 TPT Sales Report CSV data from 2017 and before might have a shipping price you need to delete
  • 1:35:52 Data clean up: remove duplicate sales entries
  • 1:37:20 How to upload new sales data into your Google Sheet
  • 1:40:10 How to check to make sure you’ve uploaded your TPT Sales Report CSV data correctly
  • 1:40:48 How to copy your CSV data to the newest version of the Google Sheet

How to use your TPT Sales Data CSV to increase earnings on TPT

  • 1:43:03 Analyzing your TPT Sales Data CSV
  • 1:44:30 Update the products that sold well last in this month (2. Advanced – By Product)
  • 1:46:15 Which TPT products sold well (in a specific state / province)
  • 1:47:45 Which TPT products sold well in a specific country?
  • 1:49:05 What percentage of sales come from a specific country, state, province? (3a Advanced – By Location / Earnings)
  • 1:52:12 Is my strategy of niching down to Ontario working (yet?)
  • 1:54:46 Are you selling more units in a specific country, state, province? (3b Advanced – By Location / Units Sold)
  • 1:57:42 Questions?

How to analyze your TPT Product Stats CSV for FREE

The Google Sheet seen in this video is Version 2023-10-21

Quick and Easy Way to know Which TPT Products To Focus On!

  • 0:20 Get the FREE Google Sheet
  • 1:22 If you don’t get the confirmation email…
  • 1:51 Copy the Google Sheet
  • 2:08 Import the TPT Product Stats CSV
  • 2:58 Done!
  • 3:14 How to Analyze Paid TPT Products
  • 7:36 How to Analyze Free TPT Products
  • 7:47 How to Reset the Google Sheet
  • 7:52 How to get the latest version

Question: Do People Who Buy $1 Deals Eventually Buy More?

The Google Sheet seen in this video is Version 2023-11-25.
(Older versions do not include the Magic Filter)

What’s a $1.00 Hashtag Sale?

  • 0:00 Introduction
  • 1:37 What’s a dollar hashtag sale?
  • 3:39 Hashtag sales can boost your TPT SEO search ranking

Exporting your data to the latest version of the Free Seller Tool

  • 7:40 How to get help using the Free Seller Tool
  • 9:10 Exporting your data from your old Free Seller Tool into the new Free Seller Tool

Using the Magic Filter to look for patterns in what people buy from your TPT Store

  • 11:33 Using the Magic Filter to find a specific group of teacher buyers (like teachers who buy hashtag products)
  • 15:33 How to figure out related products people buy (if they buy your magic filter product)
  • 18:07 How to see a timeline of purchases made by teacher buyers (who bought your magic filter product)
  • 25:29 PRO TIP: Double click your earnings in the pivot table to see the actual orders
  • 27:00 The magic filter lets you look for teacher buyer patterns
  • 27:34 Ways you could use the magic filter to look at your TPT Sales CSV data
  • 28:30 Should beginning TPT Sellers use the magic filter data tool?

How to use Data Locker v2.0 Orange

The Google Sheet seen in this video is Version 2024-02-05.
(Older versions do not include the Data Locker or Top 5 Update)

I need this data tool myself

  • 0:00 Introduction
  • 1:30 Simple Version of the TPT Data Tool
  • 2:37 10x Journey – Tue Feb 13, 2024
  • 4:01 TPT Business Key Performance Indicators

How to use the DATA LOCKER

  • 5:37 Data Locker (v2.0 Orange)
  • 7:47 Upload TPT Product Stats CSV to Data Locker
  • 12:44 Connect Data Tool to Data Locker
  • 14:34 Upload TPT Sales Data CSV to Data Locker

You can’t improve what you don’t measure

  • 4:01 TPT Business Key Performance Indicators
  • 17:36 Top 5 Analysis
  • 19:18 ABCD Analysis: Before & After Conversion Rates
  • 23:57 Using Wish List Rate To Determine Price Change
  • 27:28 Conclusion

Comparing TPT Product Stats before and after you make a change

The ABCD tool sneak peek is now available in the TPT Seller Ultimate Bundle (bonus file)

The ABCD tool will be available in the free version as soon as the YouTube channel hits 4,000 watch hours in the last 365 days.

The Google Sheet seen in this video is Version 2024-03-16 ABCD tool (Sneak Peek in the Ultimate Bundle)

Introduction

  • 0:00 Introduction
  • 1:04 Proof of Concept
  • 1:23 Get the Simple Version
  • 1:59 About the ABCD tool
  • 2:33 10x Journey TPT Seller Income Report

Getting ready to use the ABCD Tool

  • 3:30 Get a copy of the ABCD tool
  • 4:29 You need to use the Data Locker
  • 6:09 Use the Event Log Tool to keep track of your changes
  • 11:43 Using the ABCD Tool to do before / after comparisons

Examples of comparing before / after data using the ABCD tool

  • 12:04 Free / Paid Experiment Jan 22, 2024
  • 16:28 Price Drop Experiment Feb 13, 2024
  • 22:01 Adding another resource to the bundle Mar 4, 2024

Boost Your TPT Store With FREE TPT Business Data Analysis

Use the SEOT Dashboard to unlock new insights

The Google Sheet seen in this video is Version 2024-05-26 SEOT Dashboard (Formerly 10x Dashboard))

Introduction

  • 0:00 introduction
  • 2:45 TPT Product Creation Graph
  • 8:14 SEOT Dashboard, Inputs and Outputs

Looking at Lifetime Store Stats

  • 10:39 Lifetime Store Stats
  • 12:04 Your TPT Store Stats for the last 7 DAYS
  • 13:09 Your TPT Sales Funnel (Lifetime Store Stats)
  • 16:33 Top 10 Products and 80/20 reminder (Lifetime Store Stats)
  • 18:00 Number of Products, Page Views, Units Sold / Downloaded
  • 20:17 Store Conversion Rate

Making TPT business decisions based on recent store activity (not lifetime stats)

  • 21:13 Comparing Store Stats: Last 28 days vs Lifetime
  • 22:35: Update your top 10 recent sales: Fix the stuff in Red
  • 32:00 Store Review Rate (lifetime)

Unlocking Sales Data Secrets about your TPT buyers

  • 32:42 Sales Data CSV vs Product Stats CSV
  • 34:42 TPT Product Stats CSV Download Glitch 36:59 How many orders
  • 38:54 How many buyers come back and buy again?
  • 40:53 How much do teachers spend in your store? How much do teachers buy in one order?
  • 42:39 What’s the difference between this free tool and other TPT data tools?
  • 43:13 Learning Styles

Why do we need A FREE Seller Tool?

Watch this video

Are you able to be a “first follower”? Share this video with other TPT Sellers and ask who benefits.

Want to help out? There are two things you can do:

1:00:50 Part 4 – A call to action

  • 1:02:43 Action #1. Be a “First Follower” (if you can)
  • 1:10:01 Action #2. Ask TPT to do a Seller Survey