Automated TPT Product FIX THIS suggestion formula

How does the advanced self serve data tool spreadsheet know what to fix on our TPT product?

Here’s the formula we use.

What’s supposed to happen:

If either preview rate or preview effectiveness is missing, show “null.”
If both preview rate and preview effectiveness are good, show:
“1. Fix Cover / Title; Keywords / Eyeballs”
If the preview rate OR preview effectiveness are not good, figure out what to fix:
- If preview rate is higher than preview effectiveness:
  → Probably a preview problem → “3. Fix Preview”
  → BUT if preview effectiveness is still good → “2. Fix Page”
  → AND if both are actually good → “1. Fix Cover / Title; Keywords / Eyeballs”
- If preview effectiveness is higher than preview rate:
  → Probably a page problem → “2. Fix Page”
  → BUT if preview rate is good → “3. Fix Preview”
  → AND if both are actually good → “1. Fix Cover / Title; Keywords / Eyeballs”
If the preview rate IS THE SAME as the preview effectiveness, figure out what to fix:
- If the preview rate AND the preview effectiveness are good, show:
  “1. Fix Cover / Title; Keywords / Eyeballs”
- If preview rate is higher than preview effectiveness:
  → Probably a preview problem → “3. Fix Preview”
- If preview effectiveness is higher than preview rate:
  → Probably a page problem → “2. Fix Page”

If the preview rate looks like it’s exactly the “good” preview rate threshold, it may not be.
Pretend your good preview rate is 56.1%
If resource #231 has a preview rate of 56.09% it will display as 56.1% in the spreadsheet. But in calculations, the formula will use 56.09% (which is less than 56.10%)
So then it might look like the preview rate is good, but it actually is slightly below. (You just can’t see because of the rounding)

This “new” formula came into effect on Apr 15, 2025

The older formula:

If the preview rate was better than the preview effectiveness, it would suggest fixing the preview (even if the preview effectiveness was good.)
If the preview effectiveness was better than the preview rate, it would suggest fixing the page (even if the preview rate was good.)