New TPT Search Analytics Dashboard – TPT Seller Tip E88
Summary:
This video explains how TPT’s new Search Analytics dashboard works and how sellers can use it without getting overwhelmed or dismissing it as “inaccurate.” Mike Fuchigami shows how to ignore the top-level “pretty circles,” drill into one product, export the keyword data, and use his free Google Sheet tool (TPT Seller Tip #28) to separate “Keyword Sales” from “Keywords Missed Opportunities.”
He clarifies that the dashboard only tracks conversions tied to the first product clicked from a search, so it’s helpful but incomplete. The practical takeaway is to use this proof-of-concept keyword data to refine titles, descriptions, and product strategy for TPT SEO.
Video
Transcript
Hey TPT sellers, I’m super excited because TPT just launched their brand new keyword search analytics dashboard and I already love it. We can finally see which keywords people are using to get to our products, but I think a lot of sellers are going to get overwhelmed or they’re going to look at this keyword dashboard and think it’s inaccurate and then completely dismiss it.
I think this new search analytics dashboard is doing something very specific. It’s giving us proof that some search terms do lead to sales. That’s information we didn’t have before, but I don’t think the dashboard is trying to explain every sale in our store. And once you understand what this search analytics dashboard can do and can’t do, it gets way more useful.
Hi, my name is Mike Fuchigami and I’m the host of the SEOTpreneur YouTube community. In this video, we’re going to look at three things. First, we’re going to ignore the pretty circles and go straight to one product.
Then, we’re going to export the data and use my new Google Sheet tool to spot keyword sales and missed opportunities. Finally, we’ll talk about how this dashboard is helpful but incomplete, so you don’t throw it out and you don’t trust it completely.
Make sure to watch through the end because we’ll connect this to the bigger TPT SEO game and talk about where those keywords belong. Oh, and please subscribe to the channel if you want up-to-date information about TPT SEO and TPT data.
So now when you go to your TPT dashboard, click on the new tab called My Search Analytics. Ignore all of the pretty circles. I know they look nice. They show you which keywords are driving traffic to your store, but that includes your free products. Those circles don’t give us actionable information if you’re trying to decide what to actually fix in a product.
Instead, scroll down and where it says Products, click on My Entire Store. In the drop-down menu, choose one product that you want to focus on. For now, let’s start with your best seller because that gives us the most data.
Once you’ve picked a product, click on the date range. By default, it’s set to the last 30 days. If you’re a bigger seller and you get a lot of traffic, you might use the last 7 days. But for this walk-through, I’m changing it to the last 365 days. Then I’m going to click Save.
Now we get a list of keywords that drove traffic to your best-selling product sorted by page views. If I click on Conversions, I can see which keywords led to sales. If you have one view and a 100% conversion for that keyword, it means someone searched that term, saw your listing in search, clicked on your product, landed on the product page and thought, this is exactly what I need, and then they bought it right away.
This information is way more useful than the pretty circles because now we’re not looking at store noise. We’re looking at one product and figuring out which keywords actually lead to sales. This can help us figure out which search terms to prioritize in our keyword strategy.
But then you hit the next problem. TPT only shows 10 results on a page. I have to click Next Page to see more keywords. It doesn’t give me the big picture at a glance. No problem. Here’s how to get a list of all the keywords that lead to sales and all of the keywords that were missed opportunities.
Click the Download button at the bottom of the screen. Download the keywords stats file to your computer. After you download it, go to TPT Seller Tip Number 28. The link is in the video description. I made this because I wanted something that would cut down the overwhelm and help us focus on what to fix. It’s free until this Sunday, March 29th, 2026.
Download TPT Seller Tip Number 28, open up the PDF, then click on the link to get the Google Sheet tool and make a copy. Now, there’s a tutorial video in here that explains what to do, but I’m going to walk you through the basics. Click in the yellow cell, then click File, click Import, click Upload, click Browse, find that keywords stats file you just downloaded.
Then, when the import box shows up, change the import location from Create New Spreadsheet to Replace Current Sheet Cell. Then click Import Data. And that’s it. At the bottom of the sheet, click on tab number two, Keyword Sales.
This shows all of the keywords during that time period that led to a sale and it’s sorted by conversion rate. So right away, we can start seeing what language is connected to buying behavior for this product.
Now, you might not have a lot of keywords that convert into sales even though this product sells a lot. I’m going to talk about that glitch later on. But for right now, let’s talk about what these keywords mean.
When I look at this list, I’m paying attention to those top keywords. Conversion rate tells us how well your product matches buyer intent for that keyword. So, keywords with a 100% conversion rate means your product is exactly what the person wanted when they searched in TPT.
That doesn’t mean it’s the whole story. For example, we don’t have search impressions, which would tell us how many times our product showed up in search for that keyword. Search impressions would tell us how well our cover and snippet were doing. We don’t have that information yet. But the search analytics dashboard does give us proof of concept about what people were looking for when they bought our resource.
Sometimes you’ll even notice your store name in there. That’s awesome. It means someone was looking for your resource specifically. Maybe they had a colleague who was using your stuff and that teacher wanted the exact same resource, so they typed in the name, found your resource and bought it.
Look here on the right side. You can see the number of units sold for each keyword. So for me, 29 people clicked on my resource after searching up “reading comprehension strategies.” Of those 29 people, four of them bought.
Now this is a highly competitive keyword that I can’t rank on page one for. So what this tells me is that people are using search filters, which helps this product get to the top of search.
When we see a keyword in this list, we don’t know what filters that teacher might have used, if they used any at all. So if you see a highly competitive keyword that you don’t normally rank for, it’s not a glitch. It’s probably that the teacher found your product using filters.
This changes the keyword game. In the past, we might not have put a highly competitive keyword in our title because we’ll never get to page one. But now, we have proof of concept that some teachers are using grades or subject filters to find exactly what they want. So in that case, it might make sense to put these out-of-reach keywords in our title.
Now click on tab number three at the bottom, Keywords Missed Opportunities. This tab shows us all the keywords that someone searched for, clicked on our product listing, landed on our product page and then decided, yeah, this isn’t what I need.
If they didn’t buy, it tells us either one, our product doesn’t match the buyer intent for people searching that phrase, or two, our product page isn’t doing a good enough job explaining how our product meets that keyword need.
A 0% conversion rate doesn’t always mean that they didn’t buy from our store. It means they clicked on this product when it showed up in search, but they didn’t buy that specific product immediately. They could have bounced away back to TPT search or they could have clicked on another product in your store and bought that instead.
For example, I see the word “posters” here, but people aren’t buying. So although I might be ranking for posters, this large bundle only includes a few posters. So it might not match what the buyer is searching for. Maybe I need to create a dedicated bundle with just the posters and maybe use that to upsell to this reading bundle.
Sometimes you’ll also see spelling mistakes. We’re not going to optimize for spelling mistakes, but the presence of the spelling mistakes means that this search analytics dashboard is showing us literally what people searched for before landing on our product. So it gives us insight into how the dashboard works.
So now the data is starting to become useful. We can look at the Sales tab and ask, what’s already working? What can I tweak to make a keyword convert even better? Then we can look at the Missed Opportunities tab and ask, where am I attracting the wrong person? Or where am I not explaining the product clearly enough yet? And that’s exciting.
But if you look at these keyword numbers close enough, you start to notice that they don’t match exactly with our sales. What’s going on? If you learned something new, can you please like this video because it encourages me to make more videos like this one.
Now some of you are going to notice that the amount of earnings in the keyword data doesn’t match what you see elsewhere in your dashboard. And then we start to wonder if the tool is broken. What’s the point if it’s not showing me every sale? I’m going to go back to Search Analytics. In a separate browser tab, I’m going to open up my regular dashboard.
In Chrome, I’m going to click one tab and then shift-click the second tab. Then I’m going to right-click and add tab to new split view. So now I can see keyword traffic on one side and the store dashboard on the other side. Now let’s say I choose a big bundle. Under Products, instead of My Entire Store, I’m going to type in my everything bundle. Then I’m going to scroll down and click Save.
I changed the date range to the last 365 days. I hit Save. I hit Apply. Now I can see I’ve sold this bundle and I’ve made some money from it. Great. So now I’m excited. I want to know which keywords brought people to that bundle. If I click into the bundle inside of Search Analytics, suddenly there are only a few results and none of them led to sales. Wait, what?
Here’s what I think. I think this keyword tool works in a very specific way. Someone searches on TPT for a keyword. They click on the listing. That first click gets connected to the keyword. If they buy the product right away in that same visit, then it shows up as a conversion. The keyword gets credit for the sale.
But if they don’t buy that product that showed up in the search listing right away, it counts as a page view for that keyword, but not a sale. So if they add it to cart and come back later, I don’t think the system is going to remember that later sale and associate it with the original keyword click.
If they go on to another product like a bundle, that second product isn’t tied to the original search term because the teacher didn’t see that second product in search. They saw the first product. If they end up buying the bundle, the bundle doesn’t have any keyword associated with it, even though it was purchased due to organic search.
So, it looks like only the first product that the teacher buyer clicked on gets the keyword stats. And once I started thinking about it this way, the tool makes a lot more sense to me.
So, yes, it’s easy to get frustrated and think the search analytics dashboard is broken, and maybe parts of it are still being worked out. We know the data can be delayed by 3 days, but I think the bigger issue here is expectations. We open the dashboard hoping to see keywords for every sale, and I don’t think that’s what it’s built to do.
I think it gives us proof of concept data. It shows us that some search terms do lead directly to visits and sales for some products, but it’s not giving us the full path behind every single sale, and that’s okay. That’s why I don’t want us to dismiss this new search analytics dashboard just because it’s incomplete. And I also don’t want us to trust it completely because it doesn’t tell the whole story. And once you understand these limits, you can start to do some pretty cool things with it.
For example, you can change the date range and look at a seasonal window from last year. So, if you’re planning for April, you can look at April from last year and see which keywords were leading to sales for a specific product during that time. Now, this doesn’t guarantee the same outcome as last year. Search is constantly changing, rankings change, the market changes, the algorithm changes, but it gives us a clue. The keywords give us a place to start.
So, now I can go into my top products one by one, choose a date range, sort by conversions, study the Keyword Sales tab, study the Missed Opportunities tab, and start asking better questions. Which keywords are already leading to sales? Which keywords are getting clicks, but not converting yet? Which phrases belong in the title and description, and which ones maybe should come out?
If you like this video, can you please share it with another TPT seller? At the beginning of the video, I said we would connect this to the bigger TPT SEO game. Figuring out which keywords to go after is the first question. The next question is, where do we put those keywords?
So, I made a little app to help teach TPT SEO. Check out SEOTpreneur.com/game. Type in a search phrase, put in the number of results you want to compete against for that keyword, and then answer a series of questions to see where your product ranks. Have fun playing with the new TPT search analytics dashboard, and I’ll see you at Spring Fling 2026 this weekend. Bye for now.
