Here's an quick walkthrough of how to create a basic tool for writers to pull keyword data from Google Search Console using Google Data Studio in order to refresh content for SEO (that can be embedded in @NotionHQ):
loom.com/share/a8fed8c3… Unfortunately, the data studio template breaks when you try to duplicate it, and you have to add API connections and change the settings of the advanced filter as well, so it's not exactly plug and play, but it is very handy!

Something that I am explaining to a lot of seed stage companies:

The effort required to be successful in SEO for an early stage co is several orders of magnitude greater than it is for established incumbents. The game is rigged, and you have to obliterate status quo to win. Here's content from WeWork that ranks well for "how to prioritize work" it is garbage fluff that doesn't actually help people solve their problems wework.com/ideas/professi… Their domain is dripping with authority in the eyes of search engines though, so they get a pass.

When the pandemic first started, I saw a bunch of stuff (i think from conductor?) about how businesses were so happy to have invested in organic search and still have this traffic... as if SEO takes years to work. This might get me in some trouble.... but... (1/2) The commonly accepted "SEO takes years" maxim is primarily for 1) new businesses or 2) businesses that don't have brands and are tough to promote.

I worked with one established SaaS company, and most of the less competitive stuff they published using our research is 1-4 already