I hope this counts as strike related, since I'm sharing this with other shops that are striking. I'm quite good with spreadsheets, and like to make them for all sorts of things.
To help people make up the shortfall after the strike, I'm sharing a tool I made for myself to use with erank. When testing a new search term, I put it in column A, and the item in column B. After entering the term in erank, I put in the average searches, average clicks, and the Etsy competition. This tells me the most important thing, which is items per search. Basically, for every person that searches for a term, how many items are there? It helps me find out where the over and under-saturated markets are. In my case, most of what I sell is for the queer community. For the term Gay, there are 33 items for every search, for lesbian 11, and for bisexual 6. So I'm better off making products targeting bisexuals, because there's less supply for the demand. So you can look for a variety of terms that might fit your product, as well as what they tend to get searched with.
I also added a pivot table, which will group your search terms together by item.
The sheet will do the math for you for 500 searches.
Link to doc. Please make your own copy under File>Make A Copy