Mike's Diagnostic Tool for TPT Seller

SEOTpreneur.com/guide

2025-10-18

Mike’s Diagnostic Tool for TPT Sellers

START

Which tool do I need?

Click Me!

NEED HELP?

Mike@SEOTmindset.com

Please view this on a desktop or laptop. It will crash on a mobile device.

I want to getmore sales

Mike's Diagnostic Tool

for TPT Sellers

Click Me!

How does TPT SEO work?

Play the Game!

What is the TPT Sales Funnel?

More page views

...

Better Conversion Rate

Did my change make a difference?

What's a good conversion rate?

Play the Game!

My sales are down!

SELF SERVE dATA TOOL Tutorial

WANT AN UNFAIR ADVANTAGE for free?

Questions? Ask Mike!

I want to get on page 1

Home

Self Serve Data Tool Tutorial

I want to get more sales

What do the buckets mean?

1. Fix my COVER

2. Fix my TITLE

3. Fix my SNIPPET

Bucket 1

Click Me!

4. Fix my THUMBNAILS

5. Fix my DESCRIPTION

Bucket 2

6. Fix my PREVIEW

Bucket 3

Home

Self Serve Data Tool Tutorial

I want more page views

What do the buckets mean?

1. Fix my COVER

2. Fix my TITLE

3. Fix my SNIPPET

Bucket 1

Click Me!

(if you show up in TPT search but people don't click your search result)

If you don't show up on page one of TPT search...

I want to get on page 1

Home

Self Serve Data Tool Tutorial

What do the buckets mean?

I want a better conversion rate

People visit my product page but don't buy...

4. Fix my THUMBNAILS

5. Fix my DESCRIPTION

Bucket 2

Click Me!

6. Fix my PREVIEW

Bucket 3

I want to get more sales

Home

TPT Sales Funnel Bucket Metaphor

Picture teachers as drops of water you carry to a money garden (the checkout, ka-ching!). Bucket 1 moves them from search results to your product page, Bucket 2 from the page to the preview, and Bucket 3 from the preview to the cart. Find the leakiest bucket and patch it first, so more water—more shoppers—reaches the money garden.

Click Me!

Bucket 1

Bucket 2

Bucket 3

Home

I want to get more sales

Bucket 1

Update your cover

I want to fix my COVER

If you are just starting, here are some Canva templates for covers and thumbnails.

What to write

Use the custom trained ChatGPT tool to come up with short phrases based on features, benefits, and pain points.

Click Me!

Research: What’s an attractive cover?

Did your change make a difference?

TPT uses dynamic re-ranking and moves products that get more clicks closer to the top. Search your keyword and study page 1. What makes those covers pop? Consider words, fonts, font size, colours, product photography, etc.

Home

I want to get more sales

Bucket 1

I want to fix my TITLE

Write for humans

The goal of the title is to get clicked. No PREP or FUN are not keywords that people search for. But if they get your product clicked, you’ll go up in search. (Dynamic reranking)

Click Me!

Update your titles

Use this tool to quickly see which of your products have space for more keywords

Strategy: Sales Psychology vs 80 Characters

The goal of the title is to get clicked. How can you speak directly to your ideal customer avatar so it’s clear that your product is right for them.

Did your change make a difference?

Research: Keyword Strategy

Find higher volume, lower competition keywords (keyword niche unicorns) that you can rank on page 1.

Home

I want to get more sales

Bucket 1

Update your snippet / description

I want to fix my SNIPPET

Only the first 1,000 words of the description are looked at by the algorithm. (The Algolia search database sets this limit)

What to write

Use the custom trained ChatGPT tool to come up with a snippet based on features, benefits, and pain points. Customize it for your specific product.

Click Me!

Research: What’s an attractive snippet?

Did your change make a difference?

TPT uses dynamic re-ranking and moves products that get more clicks closer to the top. Search your keyword and study page 1. What makes people want to click those snippets? Consider keywords, benefits, features, pain points and calling out to your ideal customer avatar.

Home

I want to get more sales

Bucket 2

Update your thumbnails

I want to fix my THUMBNAILS

If you are just starting, here are some Canva templates for covers and thumbnails.

What to write

Use the custom trained ChatGPT tool to come up with short phrases based on features, benefits, and pain points

What’s an attractive thumbnail on your store?

Click Me!

Did your change make a difference?

A thumbnail should 1) Make the product look valuable and 2) Push shoppers to click the preview. Which product on your store has thumbnails that get lots of preview clicks (i.e. high preview rate). What do they all share?

Home

I want to get more sales

Bucket 2

Update your description

I want to fix my DESCRIPTION

Only the first 1,000 words of the description are looked at by the algorithm. (The Algolia search database sets this limit)

What to write

Use the custom trained ChatGPT tool to come up with a snippet based on features, benefits, and pain points. Customize it for your specific product.

Research What’s an attractive description?

Click Me!

A description should 1) Make the product look valuable and 2) Push shoppers to click the preview. Find the descriptions that get lots of preview clicks (i.e. high preview rate). What do they all share? The goal of the description is to get you to purchase that product. Do you have any distractions (i.e. links to socials)

Did your change make a difference?

Home

I want to get more sales

Bucket 3

Update your preview

I want to fix my PREVIEW

The preview is not “read” by the TPT Search Algorithm so keywords do not matter from an SEO perspective.

What to write

Use the custom trained ChatGPT tool to come up with short phrases to use in your preview based on features, benefits, and pain points. Customize it for your specific product.

Research: What’s an attractive preview?

Click Me!

A preview should 1) Make the product look valuable and 2) Push shoppers to buy the product. Find the preview with the best preview effectiveness. What do these previews all share? The goal of the preview is to get your ideal customer avatar to purchase that product. Do you have any distractions that you need to remove? (i.e. links to socials)

Did your change make a difference?

Home

I want to get more sales

Did your change make a difference?

Click Me!

1. What did you change?

2. Did your product stats improve?

Make a note about what you changed and when you made the change. Save your Product Stats CSV the day you make a change.

Compare your preview rate, preview effectiveness, conversion rate, pageviews, and sales data before vs after you updated your product. You need multiple product stats CSV files.

3. Did you do better or worse (compared with last year)

4. Follow the money

Teaching is cyclical. After your tweak, were sales up or down? Compare with the same time last year. This uses sales data CSV which you can download for any time period.

Do more of what’s working. Stop doing things that aren’t working.

Hey Mike, I have a question… Can you help?

Home

Let’s cut to the chase. I love talking about TPT SEO, FB Ads, WordPress, Data and anything TPT related. I want to help as many TPT sellers as I can for free. But, I also need to pay business expenses, earn a living, and feed my family. Unlimited free is not a sustainable business model. So, I have to practice what I preach, be assertive, and set boundaries.

Click Me!

be assertive

I have some money and some time

I have NO money but I have time

I have money but NO time

I purchased one of your tools

Click Me!

Home

1. Choose a product to research

Best seller? A product you know has potential?

I want to get on page 1

2. Brainstorm keywords and search volume

Look up the popularity of different keywords on TPT

3. How tough is the competition?

How to do keyword research

A keyword with high traffic isn’t always a good choice. It might have too much competition or not fit your product. Check how many resources already show up for that keyword on TPT.

4. AI research tool

Sometimes it’s hard to guess what teachers are searching for. This AI tool can help by suggesting keywords that match your product.

6. Look at your short list

Look for keywords with low competition first. Then pick the one with the highest popularity among those low-competition options. (If you can't find any good options, you may need to go back to step 2

...

5. Narrow down your choices

Rercord your findings as you look for a keyword that has higher search volume with lower competition

7. Where do you currently rank?

Before changing your title, check if you already rank for your new keyword ideas. You don’t want to lose spots you already earned.

Home

Learn how TPT search works!

TPT uses a search tool called Algolia to decide what shows up when a teacher types in a search. We don’t know exactly how TPT search works, but the Algolia manual gives us some default settings. It sorts products into “buckets” based on how well they match 7 search rules. When you end up in the final bucket, TPT then sorts the results based on things like how many times a product has sold. Note: This game is to help us learn how the "tie-breaking" bucket system works. TPT might apply the 7 rules in a different order or change them to give better search results.

PLAY

Home

RANK: 768

A teacher is searching for a "two word" phrase. Pretend there are 768 results.

NEXT

Home

RANK: 768

Click Me!

Do you have the search phrase in your product title or description?

NO

YES

NO

Home

RANK: no

Your product will not show up for this search term.

The search algorithm doesn't see your product as a match for the search term because you don't have the search phrase in your product. Put the search phrase in your title and your description and try again!

play again

Home

RANK: 768

Click Me!

Do you have any typos in the search phrase?

Is your spelling of the search phrase the same as how the teacher typed it in the TPT search box or do you have typos?

2+ typos

1 typo

no typos

Home

RANK: 384

How close are you to the buyer

Where is your store located? Where is the buyer located?

within 500km

same city

500+ km

same city

Home

RANK: 384

How many words from the search phrase are actually in your product title or description?

one word

same city

two words

Home

RANK: 192

Do you match the search filters used by the teacher?

NO

YES

NO

Home

RANK: 768

How close are you to the buyer

Where is your store located? Where is the buyer located?

within 500km

same city

500+ km

same city

Home

RANK: 768

How many words from the search phrase are actually in your product title or description?

one word

same city

two words

Home

RANK: no

Your product will not show up for this search term.

Your product is not relevant because you have two or more typos. The TPT search algorithm no longer sees your product as a match for the search term. Spell the search phrase the way teachers type it in the TPT search bar, then try again!

play again

Home

RANK: 384

Do you match the search filters used by the teacher?

NO

YES

NO

Home

RANK: 576

Do you match the search filters used by the teacher?

NO

YES

NO

Home

RANK: 768

Do you match the search filters used by the teacher?

NO

YES

NO

Home

RANK: no

Your product will not show up for this search term.

Your product is not relevant because you do not have the correct categories and tags selected (i.e. grade, subject, etc) Spell the categories and tags that the teacher searched for and try again!

play again

Home

RANK: 192

Are the words side-by-side and in the correct order?

NO

YES

NO

Home

RANK: 384

Are the words side-by-side and in the correct order?

NO

YES

NO

Home

RANK: 576

Are the words side-by-side and in the correct order?

NO

YES

NO

Home

RANK: 768

Are the words side-by-side and in the correct order?

NO

YES

NO

Home

RANK: 96

Do you have the keyword phrase in the title?

Until now, the keyword phrase could have been in the description or the title.

NO

YES

NO

Home

RANK: 192

Do you have the keyword phrase in the title?

Until now, the keyword phrase could have been in the description or the title.

NO

YES

NO

Home

RANK: 288

Do you have the keyword phrase in the title?

Until now, the keyword phrase could have been in the description or the title.

NO

YES

NO

Home

RANK: 384

Do you have the keyword phrase in the title?

Until now, the keyword phrase could have been in the description or the title.

NO

YES

NO

Home

RANK: 480

Do you have the keyword phrase in the title?

Until now, the keyword phrase could have been in the description or the title.

NO

YES

NO

Home

RANK: 576

Do you have the keyword phrase in the title?

Until now, the keyword phrase could have been in the description or the title.

NO

YES

NO

Home

RANK: 672

Do you have the keyword phrase in the title?

Until now, the keyword phrase could have been in the description or the title.

NO

YES

NO

Home

RANK: 768

Do you have the keyword phrase in the title?

Until now, the keyword phrase could have been in the description or the title.

NO

YES

NO

Home

RANK: 48

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 96

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 144

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 192

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 240

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 288

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 336

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 384

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 432

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 480

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 528

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 576

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 624

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 672

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 720

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 768

Do you have the exact keywords in your title or description?

NO

YES

NO

Home

RANK: 24

Bucket #1 (1-24)

Your product is EXTREMELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 48

Bucket #2 (25-48)

Your product is VERY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 72

Bucket #3 (49-72)

Your product is VERY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 96

Bucket #4 (73-96)

Your product is VERY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 120

Bucket #5 (97-120)

Your product is VERY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 144

Bucket #6 (121-144)

Your product is VERY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 168

Bucket #7 (145-168)

Your product is VERY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 192

Bucket #8 (169-192)

Your product is VERY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 216

Bucket #9 (193-216)

Your product is RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 240

Bucket #10 (217-240)

Your product is RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 264

Bucket #11 (241-264)

Your product is RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 288

Bucket #12 (265-288)

Your product is RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 312

Bucket #13 (289-312)

Your product is RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 336

Bucket #14 (313-336)

Your product is RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 360

Bucket #15 (337-360)

Your product is RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 384

Bucket #16 (361-384)

Your product is RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 408

Bucket #17 (385-408)

Your product is SOMEWHAT RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 432

Bucket #18 (409-432)

Your product is SOMEWHAT RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 456

Bucket #19 (433-456)

Your product is SOMEWHAT RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 480

Bucket #20 (457-480)

Your product is SOMEWHAT RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 504

Bucket #21 (481-504)

Your product is SOMEWHAT RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 528

Bucket #22 (505-528)

Your product is SOMEWHAT RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 552

Bucket #23 (529-552)

Your product is SOMEWHAT RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 576

Bucket #24 (553-576)

Your product is SOMEWHAT RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 600

Bucket #25 (577-600)

Your product is BARELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 624

Bucket #26 (601-624)

Your product is BARELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 648

Bucket #27 (625-648)

Your product is BARELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 672

Bucket #28 (649-672)

Your product is BARELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 696

Bucket #29 (673-696)

Your product is BARELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 720

Bucket #30 (697-720)

Your product is BARELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 744

Bucket #31 (721-744)

Your product is BARELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

RANK: 768

Bucket #32 (745-768)

Your product is BARELY RELEVANT to this search phrase.

You're in a tie with other products that are just as relevant. Your spot in the list now depends on your secret TPT SEO score based on things like units sold and recent sales.

Learn More

Home

You now have your starting rank for that keyword search

1. Textual Ranking Criteria 2. Business Relevance 3. Personalization 4. Category Rules 5. Dynamic Re-ranking 6. Product Rules

We just finished steps 1 and 2 to find your starting rank. A few more things—like dynamic re-ranking and product rules—can still change your spot. TPT SEO keeps changing as TPT updates the system (through A/B testing). I'm still learning too, so let me know if you spot anything different in TPT land!

Click Me!

play again

provide feedback

Self Serve Data Tool Tutorial

Home

Welcome to the Self Serve Data Tool. This resource comes with VIP support. If you get stuck, just email

mike@SEOTmindset.com

Click Me!

Step 2Visualize Your data

Step 1Upload Your data

Step 3 Interactive Data Table(Fix This)

Welcome! Navigating The Site

Home

Self Serve Data Tool Tutorial

How to delete data

Step 1. Upload your data

View Lifetime Stats or Recent Stats

Upload your data

Click Me!

Get Your Product Stats data from TPT

START HERE

How to troubleshoot

Home

Self Serve Data Tool Tutorial

If the numbers look wrong (or don't match what you see in the TPT dashboard)

Step 2. Visualize your data

View stats between two specific dates

(if you have uploaded multiple Product Stats CSV files)

View recent stats

(if you have uploaded multiple Product Stats CSV files)

Click Me!

View your lifetime stats

(if you have uploaded ONEProduct Stats CSV file)

START HERE

What to do if Google Looker Studio doesn't load

How to troubleshoot

Home

Self Serve Data Tool Tutorial

If the numbers look wrong (or don't match what you see in the TPT dashboard)

Step 3. Interactive Table (Fix This)

Have things gotten better?

View your recent stats(if you have uploaded multiple Product Stats CSV files)

Click Me!

What do you need to fix?

View your lifetime stats(if you have uploaded ONEProduct Stats CSV file)

START HERE

What to do if Google Looker Studio doesn't load

Home

What is a "good" conversion rate?

There’s no one “good” conversion rate that works for every product. It depends on many things like number of page views, your niche, the price, and the time of year.

Choose a product from your store. Use the Self Serve Data Tool to get your product stats.

Self Serve Data Tool - Advanced (Fix This)

Self Serve Data Tool - Google Sheet (FREE)

Look up the number of page views, earnings, preview rate, preview effectiveness, and the conversion rate (sold rate) Then see how your product did compared to others!

Click Me!

DATA SOURCE: from the Self Serve Data Tool website. Data analyzed on July 11, 2025

Anonymous, aggregated product stats

NEXT

Home

Start Over

Describe your product

Click Me!

under $100

over $1,000

$100 to $1,000

earnings

How much has your product made so far? (lifetime)

50,357

30.2%

33.2%

9.9%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Home

Start Over

Describe your product

under $100

earnings

How much has your product made so far? (lifetime)

Click Me!

page views

over 1,000 views

100 to 1,000 views

under 100 views

How many times have teachers looked at your product page? (lifetime)

34,538

34.2%

28.7%

10.0%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Home

Start Over

Describe your product

under $100

earnings

How much has your product made so far? (lifetime)

page views

under 100 views

How many times have teachers looked at your product page? (lifetime)

21,326

41.5%

25.3%

11.8%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

Start Over

Describe your product

under $100

earnings

How much has your product made so far? (lifetime)

page views

100 to 1,000 views

How many times have teachers looked at your product page? (lifetime)

12,108

24.4%

34.3%

7.8%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

Start Over

Describe your product

under $100

earnings

How much has your product made so far? (lifetime)

page views

over 1,000 views

How many times have teachers looked at your product page? (lifetime)

1,104

4.6%

35.6%

2.0%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

Start Over

Describe your product

$100 to $1,000

earnings

How much has your product made so far? (lifetime)

Click Me!

page views

over 1,000 views

100 to 1,000 views

under 100 views

How many times have teachers looked at your product page? (lifetime)

11,308

22.6%

42.4%

10.0%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Home

Start Over

Describe your product

$100 to $1,000

earnings

How much has your product made so far? (lifetime)

page views

under 100 views

How many times have teachers looked at your product page? (lifetime)

85

25.8%

47.0%

16.8%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

Start Over

Describe your product

$100 to $1,000

earnings

How much has your product made so far? (lifetime)

page views

100 to 1,000 views

How many times have teachers looked at your product page? (lifetime)

5,474

29.3%

44.7%

13.4%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

Start Over

Describe your product

$100 to $1,000

earnings

How much has your product made so far? (lifetime)

page views

over 1,000 views

How many times have teachers looked at your product page? (lifetime)

5,749

16.2%

39.9%

6.8%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

Start Over

Describe your product

over $1,000

earnings

How much has your product made so far? (lifetime)

Click Me!

page views

over 1,000 views

100 to 1,000 views

under 100 views

How many times have teachers looked at your product page? (lifetime)

4,515

20.1%

43.4%

9.0%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Home

Start Over

Describe your product

over $1,000

earnings

How much has your product made so far? (lifetime)

page views

under 100 views

How many times have teachers looked at your product page? (lifetime)

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

Start Over

Describe your product

over $1,000

earnings

How much has your product made so far? (lifetime)

page views

100 to 1,000 views

How many times have teachers looked at your product page? (lifetime)

115

24.2%

40.4%

9.6%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

Start Over

Describe your product

over $1,000

earnings

How much has your product made so far? (lifetime)

page views

over 1,000 views

How many times have teachers looked at your product page? (lifetime)

4,400

20.0%

43.4%

8.9%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Click Me!

How do I fix my product?

Start Over

Home

My sales are down!

There are two reasons for why your sales are going down. Either one, you have a page view problem. People aren’t looking at your product page any more. Or two, you have a conversion rate problem. People are looking at your product page but they don’t buy.

And the solutions to these problems are different. So if you are doing the wrong things, you might not be addressing the root problem.

I have a pageview problem

I have a conversion problem

I don't know if I have a pageview or conversion problem

Home

What is a "good" conversion rate?

Click Me!

under $100

over $1,000

earnings

$100 to $1,000

How much has your product made so far?

page views

under 100

100 to 1,000

over 1,000

How many times have teachers looked at your product page?

50,357

30.2%

33.2%

9.9%

Average Preview Effectiveness

Average Preview Rate

AverageConversion Rate (sold rate)

Number of Products Analyzed

Home

Learn how TPT search works!

TPT uses a search tool called Algolia to decide what shows up when a teacher types in a search. We don’t know exactly how TPT search works, but the Algolia manual gives us some default settings. It sorts products into “buckets” based on how well they match 7 search rules. When you end up in the final bucket, TPT then sorts the results based on things like how many times a product has sold. Note: This game is to help us learn how the "tie-breaking" bucket system works. TPT might apply the 7 rules in a different order or change them to give better search results.

UNDER CONSTRUCTION I have finished up to rule #8

PLAY

2025-07-02 11 AM (ET)

Home

RANK: 768

A teacher is searching for a "two word" phrase. Pretend there are 740 results.

Do you have the search phrase in your title or description?

NO

YES

NO

Home

I want to get more sales

Mike, can you help me?

Click Me!

1. What did you change?

2. Did your product stats improve?

Make a note about what you changed and when you made the change. Save your Product Stats CSV the day you make a change.

Compare your preview rate, preview effectiveness, conversion rate, pageviews, and sales data before vs after you updated your product. You need multiple product stats CSV files.

3. Did you do better or worse (compared with last year)

4. Follow the money

Teaching is cyclical. After your tweak, were sales up or down? Compare with the same time last year. This uses sales data CSV which you can download for any time period.

Do more of what’s working. Stop doing things that aren’t working.

Home

I want to do TPT SEO

3. Monitor

What is TPT SEO?

1. Research

2. Optimize

Click Me!

Home

I want to do TPT SEO

3. Monitor

What is TPT SEO?

1. Research

2. Optimize

Click Me!

Page links

To get a Genially page address or embed code, copy and paste one of the two boxes below onto the page. In PREVIEW mode, copy the address it gives you. Then you can delete the box again and use the link you have copied somewhere else. It is possible to embed one Genially presentation into another.

slide url

slide embed code

When a teacher clicks on the top menu, TPT automatically turns on the category filter. Does your product match the search filter used by the teacher?

Step 2. Record your findings

Step 1. Research Keywords

As you research keywords, write down the popularity and number of competitors. You can use pen and paper or copy the results into the “My Research” tab to keep track.

PRO Keyword Tool

Google Sheet report

Google Form

Each time I edit a TPT product, I fill out a quick Google Form. The answers land in a Google Sheet, showing every change. For coaching clients, I link this sheet to their sales data. Then we can see if each update makes sales rise, fall, or stay the same.

Download TPT Seller Tip 005

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Here's how to find higher search traffic, lower competition keyword niche unicorns. Note: They're called unicorns because they're hard to find. The video goes over a free method as well as showcased the PRO keyword tool.

TPT doesn’t use geolocation right now. Geolocation is like when an app shows you coffee shops near you based on your location.

Use the Keyword Rank Position Tool to check where your products rank for the keywords you’re thinking about. The PRO version shows search volume (popularity). Don’t remove keywords you’re already ranking well for.

Download PRO version

Get TPT Seller Tip 010

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Use the Keyword Rank Position Tool to see where your products rank for any keyword on TPT. What makes the products ahead of you more attractive?(PRO version shown above)

Download PRO version

Get TPT Seller Tip 010

TPT doesn’t use geolocation right now. Geolocation is like when an app shows you coffee shops near you based on your location.

The Advanced "Fix This" table allows you to compare the stats that matter. Find your top selling resources that have an above-average preview rate. Study those product pages (i.e. thumbnails / descriptions) —what do they share that influence teachers to look at the preview?

Self Serve Data Tool - Advanced Fix This

The title is the most important attribute to put the keyword phrase in, followed by the snippet / description.

Check out these 56 Canva templates to get a head start on your own TPT product covers and thumbnails.

Get TPT Seller Tip 012

When you upload a CSV file, it replaces the data for that date. To delete data for a specific date, upload a blank file for that same date. It will clear out the old data without adding anything new. (If you want to delete all data, email Mike.)

Download a blank Product Stats CSV file

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

If you have time, but no money, watch my YouTube videos and ask your questions in the YouTube comments! FREE Public Support (ONE-TO-MANY) What I can do

• Reply to general TPT questions in YouTube comments or Facebook.
• Make YouTube videos that answer your questions.

What I can’t do

• Provide feedback on your specific store or blog.
• Open links
• Look at images (unless shared in the Facebook group).
• Answer questions by email

Ask a question on YouTube

Ask a question on Facebook

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Bucket 3 goes from the preview PDF to the checkout (ka-ching!) If the preview does a good job and the perceived value of the resource is higher than the perceived cost of the resource, the teacher will buy. In this case, I had 15,438 people who looked at the preview PDF. But only 1,396 people bought the resource. This means I lost 91% of my water.

Self Serve Data Tool - View Data

Welcome to the Self Serve Data Tool website! If you're new, here are a few places to explore to help you get started.

Self Serve Data Tool

If you have money and time, use my Do-It-Yourself tools, do the Boot Camp, and join the PRO community so you can ask me questions directly in our forum. Earn Mike Minutes in the PRO forum which you can use for one-on-one consults. PAID Semi-Private Support (ONE-TO-SOME) What I can do

• I can answer specific questions about your TPT store, data, or blog in the PRO community. (I’m in the PRO forum several times per day.)
• Post your question in the PRO forum.
• Ask your question during a Zoom Saturday Staffroom chat

What I can’t do

• I’m not able to answer questions privately about your TPT business via email (i.e. you don’t want to post what you’re doing in the PRO network.)

Get the TPT Seller Ultimate Bundle

Ask a question in the PRO community

If the numbers look wrong, it might be because 1. You only uploaded one file, so it's showing lifetime stats, 2) the product is new and wasn't in the first file, so the system can't compare, or 3) you deleted a product from your store, which changed the row numbers—so the system is comparing two different products by mistake.

Self Serve Data Tool - View Data

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

We use Google Looker Studio, so you must use a Gmail or Google Workspace account to visualize your data or use the Advanced (Fix This) table.

If Google Looker Studio says you don’t have access or the report doesn’t exist, you’re probably signed into the wrong Google account. Watch this video to learn how to make a separate Google Chrome profile.

If this is your first time using Google Looker Studio on the Self Serve Data Tool website, there are a few things you might need to do to get started. Watch this video from 4:50.

Step 2. Record your findings

Step 1. Research Keywords

Everyone wants high-popularity keywords with no competition—but those are rare, like unicorns. Based on your research so far, what’s your best real option? (You may need to go back to step 2 if you haven't found anything good, yet.)

PRO Keyword Tool

Bucket 1 carries shoppers from the search listing to your product page. Unfortunately, TPT doesn't give us data on how many search impressions we get (i.e. how many times we show up on a TPT search result page.) If they did tell us search impressions, we could calculate the click through rate. (The percentage of people who see our search result and actually click on our listing to go to the product page.) So right now, the only metric we have is to look at pageviews. If we have low pageviews, it could be because of one of two problems. Problem #1: We show up in search, but our search listing is not attractive and it doesn't get clicked on. This is a bucket #1 problem Problem #2: We don't show up in search. This is a keyword research / TPT SEO problem.

The title is the most important attribute to put the keyword phrase in, followed by the snippet / description.

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

The title is the most important attribute to put the keyword phrase in, followed by the snippet / description.

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Brainstorm potential keywords for your product. You might have the best lesson in the world. If you don't use the search terms teachers are using, you won't be seen in TPT search. What would you search for if you were looking for this product? Then check the search traffic for that keyword.

PRO Keyword Tool

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Ideally, you want to use all of the words in the keyword phrase in your product title and description. The number of words matters!

Dynamic Reranking means TPT shuffles the top 20–100 (maybe up to 240) products based on how teachers interact with them after a search. If lots of teachers click a product for a specific keyword, it gets a boost for that keyword. If some of those clicks turn into purchases or adds to cart, the product gets an even bigger boost.

Google Sheet report

Google Form

Each time I edit a TPT product, I fill out a quick Google Form. The answers land in a Google Sheet, showing every change. For coaching clients, I link this sheet to their sales data. Then we can see if each update makes sales rise, fall, or stay the same.

Get TPT Seller Tip 005

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

This video shows how to calculate your proximity score if you have multiple words in the keyword phrase. A lower proximity score is better.

Check out these 56 Canva templates to get a head start on your own TPT product covers and thumbnails.

Get TPT Seller Tip 012

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

This video shows how to calculate your proximity score if you have multiple words in the keyword phrase. A lower proximity score is better.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

When a teacher clicks on the top menu, TPT automatically turns on the category filter. Does your product match the search filter used by the teacher?

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

The title is the most important attribute to put the keyword phrase in, followed by the snippet / description.

This tool shows which titles still have room. You don’t have to fill every gap—short, clear titles can speak right to your ideal buyer and often win more clicks. But adding keywords can help you appear in more long-tail searches.

Get TPT Seller Tip 021

Use the Keyword Rank Position Tool to see where your products rank for any keyword on TPT. What makes the products ahead of you more attractive? (PRO version shown above)

Download PRO version

Get TPT Seller Tip 010

The title is the most important attribute to put the keyword phrase in, followed by the snippet / description.

The problem with lifetime stats is you can’t see if your changes helped. But if you upload your product stats the day you make a change, and again a few weeks later, you can compare and see if things got better or worse.

Self Serve Data Tool - Advanced (Fix This)

How do I fix...

Check out these 56 Canva templates to get a head start on your own TPT product covers and thumbnails.

Get TPT Seller Tip 012

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Bucket 2 goes from the product page to the preview. If the thumbnails and product description do a good job, they will get the buyer interested enough to check out the preview (PDF). In this case, I had 63,006 chances to sell my resource. But only 15,438 people went on to look at the preview PDF. This means I lost 75.5% of my water.

Self Serve Data Tool - View Data

The Before (AB) and After (BC) tabs let you pick specific dates. I use this to check if a change worked. If you know when you made a change (Date B), and you have one Product Stats CSV from two weeks before (Date A) and one from two weeks after (Date C), you can use this tool to compare and see what changed.

Self Serve Data Tool - View Data

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Upload your sales data and this Google Sheet tool will tell you if the changes you made on a certain date made things better or worse (relative to how things were last year.)

Download TPT Seller Tip 022

You know you need to use data and TPT SEO but you dont have time to figure this out on your own. Purchase Mike Minutes and I can do it for you (or show you how to do it). I work with newer sellers as well as sellers who have earned millions. PAID Private Support (ONE-TO-ONE) What I can do

• Answer specific questions via email or Zoom meetings.
• Do computer stuff for you (i.e. Optimize Facebook Ads, do website / domain stuff, create custom data dashboards.)

What I can’t do

• Log into your store to download your data. You will still need to email me your product stats CSV and sales data CSV files.

Learn More about Private Consulting

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

If the numbers look wrong, it might be because 1. You only uploaded one file, so it's showing lifetime stats, 2) the product is new and wasn't in the first file, so the system can't compare, or 3) you deleted a product from your store, which changed the row numbers—so the system is comparing two different products by mistake.

Self Serve Data Tool - View Data

Use the custom trained GPT to create an intro snippet about your product, focusing on benefits, features and pain points. Make sure to include keywords in your snippet (so teacher buyers will see the words highlighted!

Get TPT Seller Tip 017

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Upload your data to the cloud. Make sure you choose the correct date the Product Stats CSV was downloaded from TPT—if the date is wrong, the system won’t be able to calculate your recent stats.

Self Serve Data Tool - Upload Data

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Use the custom trained GPT to create four phrases about your product, focusing on benefits, features and pain points. The best phrases call out to your ideal customer avatar (i.e. this is exactly what I need!)

Get TPT Seller Tip 017

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

The title is the most important attribute to put the keyword phrase in, followed by the snippet / description.

We use Google Looker Studio, so you must use a Gmail or Google Workspace account to visualize your data or use the Advanced (Fix This) table.

If Google Looker Studio says you don’t have access or the report doesn’t exist, you’re probably signed into the wrong Google account. Watch this video to learn how to make a separate Google Chrome profile.

If this is your first time using Google Looker Studio on the Self Serve Data Tool website, there are a few things you might need to do to get started. Watch this video from 4:50.

If you purchased a resource from my TPT Seller Store, the Ultimate Bundle (or the Self Serve Data Tool + PRO Tool plan), I can provide VIP support for the tool. What I can do

• I can make a video screen recording showing you exactly what to do.
• I can answer questions about how to use the tools.
• I can troubleshoot any problems you have using the tools.
• Please include a screenshot of the problem if possible!

Ask a question using the TPT Q&A form

Email Mike@afreesellertool.com

Email Mike@SEOTmindset.com

All other tools:

The title is the most important attribute to put the keyword phrase in, followed by the snippet / description.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Upload your sales data and this Google Sheet tool will tell you if the changes you made on a certain date made things better or worse (relative to how things were last year.)

Get TPT Seller Tip 022

Go to the "View Data" page and pick a product in the red box. The next pages won’t show any data until you choose a product.

Self Serve Data Tool - View Data

The title is the most important attribute to put the keyword phrase in, followed by the snippet / description.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Before (AB)

After (BC)

If you have a product stats file from when you updated the product (date B),plus one from a few weeks before (date A) and a few weeks after (date C), you can compare the stats before the change (AB) and after the change (AC). In this example, the preview was updated on June 2, 2025. The preview effectiveness went from 11% to 21%. The data is too small to be conclusive, but it looks like things are going in the right direction.

Self Serve Data Tool - Advanced View

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

This is an interactive table that helps you compare products quickly. The top boxes are clickable filters which control the list of products in the bottom table.

Self Serve Data Tool - Advanced (Fix This)

When a teacher clicks on the top menu, TPT automatically turns on the category filter. Does your product match the search filter used by the teacher?

Before (AB)

After (BC)

If you have a product stats file from when you updated the product (date B),plus one from a few weeks before (date A) and a few weeks after (date C), you can compare the stats before the change (AB) and after the change (AC). In this example, the preview was updated on June 2, 2025. The preview effectiveness went from 11% to 21%. The data is too small to be conclusive, but it looks like things are going in the right direction.

Self Serve Data Tool - Advanced View

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

The Advanced "Fix This" table allows you to compare the stats that matter. Find your top selling resources that have an above-average preview effectiveness. Study those previews—what do they share that turns viewers into buyers?

Self Serve Data Tool - Advanced Fix This

The horizontal bar graph shows where you're losing the most water. Each teacher who lands on your product page is a chance to make a sale. Where are you leaking the most? Don’t forget—this shows the lifetime performance of the product. Things might have improved or gotten worse recently, but that can get hidden when everything is averaged over time.

Self Serve Data Tool - View Data

Product Rules let TPT push some products to the top or remove them from search. Right now, it looks like TPT is pinning certain resources to page one for some keywords—no matter their sales, SEO score, or attractiveness (i.e. dynamic re-ranking.)

Use the custom trained GPT to create four phrases about your product, focusing on benefits, features and pain points. Use the best phrases in your thumbnails to get teachers to want to check out the preview to learn more!

Get TPT Seller Tip 017

To be honest, I don't understand the difference between "exact" and "words". They both seem to count the number of words in the search phrase that you have in your product title (or description). I think "words" is the number of matched words (including typos or partials). But "exact" counts the number of matched words with exact spelling. What do you think?

Use the custom trained GPT to create a quick draft for your description. I find I still have to carefully edit the response to make sure it doesn't sound too much like AI. I also have to make sure it's not hallucinating and adding features to the product that don't exist.

Get TPT Seller Tip 017

Go to the "Upload Data" page. Then click the link to download your TPT product stats file.

Self Serve Data Tool - Upload Data

A typo is an extra character, a missing character, or a different character. For example, if the word is "Mike", then "Mik" has one typo and "Mic" has two typos.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

You can look up keywords for any product, but fixing the product page may boost sales more. New keywords won’t help if shoppers still skip your listing.

Learn more about fixing the leaking bucks on your TPT store.

Check your stats to figure out which products need better keywords (because your previews and your product pages are above average!)

Self Serve Data Tool - Advanced Fix This

Watch this YouTube video to learn how I use a free Chrome extension to save my work and track changes. TPT Seller Tip 011 includes an easy video tutorial and the special code you can copy and paste.

Get TPT Seller Tip 011

When a teacher clicks on the top menu, TPT automatically turns on the category filter. Does your product match the search filter used by the teacher?

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

If you uploaded one Product Stats CSV file, you can view your lifetime stats now. To see recent changes in performance, you’ll need to upload at least two CSV files.

Self Serve Data Tool - Upload Data

View Data

Use this mode to check how your product is doing lately. But don’t get confused—when it says “Last 28 days,” it doesn’t show the real last 28 days. It just looks at the first and last product stats files you uploaded during that time. Then it compares them to see the changes. This is a do-it-yourself tool, so if you don’t upload multiple files, it won’t work.

Self Serve Data Tool - View Data

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

The Advanced "Fix This" table allows you to compare the stats that matter. Find your top selling resources that have an above-average preview rate. Study those product pages (i.e. thumbnails / descriptions) —what do they share that influence teachers to look at the preview?

Self Serve Data Tool - Advanced Fix This

This video shows how to calculate your proximity score if you have multiple words in the keyword phrase. A lower proximity score is better.

Use the keyword research tool to get a sense of the search volume and competition on TPT specifically. This is based on live data from the TPT website.

Download PRO keyword tool

Watch this YouTube video to learn how I use a free Chrome extension to save my work and track changes. TPT Seller Tip 011 includes an easy video tutorial and the special code you can copy and paste.

Download TPT Seller Tip 011

TPT uses the Algolia search algorithm which uses a "bucket" system to rank results

Start by telling the system what you think is a “good” preview rate and preview effectiveness. This helps it suggest what to fix. Then look for outliers—why do some products have really high preview rates or preview effectiveness?

Self Serve Data Tool - Advanced (Fix This)

How do I fix...

Ideally, you want to use all of the words in the keyword phrase in your product title and description. The number of words matters!

This video shows how to calculate your proximity score if you have multiple words in the keyword phrase. A lower proximity score is better.

Use the custom trained GPT Keyword Rank Position Tool to create four phrases about your product, focusing on benefits, features and pain points. Use the best phrases in your preview to speak directly to your ideal customer avatar.

Get TPT Seller Tip 017

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Download your Product Stats CSV file from TPT. I recommend adding the date to the filename, like this: "MyProductStats 2025-07-06.csv".

Go to TPT Product Statistics

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Use the AI tool to find keyword ideas that fit your product—you might discover great ones you hadn’t thought of. This tool uses a lot of your Google Sheets search power so if it gets stuck on the "loading..." sign, come back later for the results to load.

PRO Keyword Tool

Can you get on page one for that keyword? Use this tool to check how many resources already exist. The more you use this tool, the slower Google Sheets may get—Google sets some limits. If it says “loading...,” wait an hour and try again.

PRO Keyword Tool

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Can you get on page one for that keyword? Use this tool to check how many resources already exist. The more you use this tool, the slower Google Sheets may get—Google sets some limits. If it says “loading...,” wait an hour and try again.

PRO Keyword Tool

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.

Once you're in the final bucket, TPT needs a way to sort the tied products. That’s where the secret TPT SEO score comes in. It’s based on a hidden formula, but likely includes things like units sold, reviews, conversion events, and recent sales.