I do SEO analysis using Metabase (I highly recommend it) but I've come up with a scenario that I'm not sure how to solve.
All of my data is in one table, and yes, the keywords I track are duplicated many, many times but I have a date column that differentiates each duplicate of that keyword and a position column for where that word appears.
So I filter this week or position or contains or what have you.
But I'd like to know what is "new".
What keyword has not appeared before in my data. Which one is brand new right now.
I guess that leads to a knew question: I'd like to see keywords that have disappeared from the data?
Any ideas? I tried searching the forum burt I really couldn't find anything.