My take on subject and how I went about it in last years both at Wise as well as my personal SEO projects

• Programmatic SEO is trending
• What is it?
• Wait.....It's not new
• Core principles of scaling landing pages - kw research pattern, data, template
• Kw research
• Database: CSV, actual DB, APIs 
• How to build templates
• Doing it on different platforms WP all import, strapi, dev + DB
• Starting small get impression clicks
• Sitemaps, internal linking
• CMS vs custom code+db
• Scaling data and maintenance, APIs example if not static DB

First iteration of keyword research

• time vs making pages not perfect
• tools - semrush, ahref, keywordtool.io, keywordinsights.ai
• Structured vs non structured content
• templated content (landing pages, products, directories)
• structured
• competitors architecture
• work by template in a precise way but still reassess in future
• non structured content (blog long form)
• competitors articles + kw tools
• doing vs precision
• refine where to go and optimise kw research by series of articles not one by one
• don't go back until article it's at peak and you have more for the same series

recap

• differentiate by content type the approach
• don't waste too much time on day one vs launching pages
• understand best time for each content format on revisiting the kw research and targeting

After a long break and some exploration I am back on the project. Deciding between search and social it's a topic I went through during this slow phase.

Started from securing social media handles

How I thought about social as opposed to focus on search

Evaluating search vs social opportunity and investment time frame

A run through of social platforms and opportunities

Feed based social platforms vs YouTube

YouTube vs publishing SEO content

Youtube if you plan to be serious about it in parallel with search.