Sobre

- problem statement: **prioritize organic growth opportunities by selecting the correct keywords to compete** - usage routines - frequency: **runs weekly, every friday defines next week content production** - team: **growth** - user stories: **As the head of growth, I want to know the best keywords to compete for, so I can prioritize my content efforts efficiently** - expectations → success metrics (OUTPUT) - **North start: organic traffic growth increase over time (coming from selected keywords → non branded)** - **Weekly delivers a list of 10 keywords to be worked with:** - **Keyword/topic** - **Volume/competitiveness** - **Content Type** - **Hook** - **Reasoning** - **Potential traffic** - data_models (dados) - **keywords_db** - **term** - **volume** - **difficulty** - **SERP_deco** - **SERP_competitors []** - data_sources (integrações) - **Google Analytics MCP** - **DataForSEO** - workflows high-level - **cron: every friday morning** - **step1: fetch/update/index SERP table with 100 selected keywords** - **step2: rank keywords by product positioning value** - **step3: calculate SERP GAP between best competitor positiong SERP and deco's per keyword (top_gap)** - **step4: order_by desc top_gap** - **step5: order_by desc top_gap & desc product_value & volume & difficulty** - **step6: check if we already have a good content for it on blog_db** - **step7: check if we already have a good content for it on documentation codebase** - **step8: classify content by type** - **setp9: render the next content list** - human-in-the-loop (mocked views) → approval flow - **for each suggested keyword** - **edit hook inline** - **black keyword** - **refresh keyword**