“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?

Take part in our public research question
See how your store compares against other 80:20 sentences
https://afreesellertool.com/tpt-seller-data/80-20-rule/Learn more

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)

0:00:00 Intro
0:01:00 Part 1. Just start

What Data Can Tell Us

0:06:01 Part 2. Follow the money
0:06:27 What data can tell us
0:07:00 Danger with data

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

Take Action and ASK TPT!

Email TPT Support asking them to do a TPT Seller Survey asking TPT Sellers what we’d like to see in an updated Seller Dashboard