Stop Duplicate Content From Cannibalizing Rankings Across a Large Agency Client Portfolio — Gemini Prompts for In-house SEO Leads (Expert Level)

You are an expert in-house SEO director with 14 years of experience diagnosing and resolving duplicate content issues, keyword cannibalization problems, and topic authority gaps for agency content teams managing large-scale editorial calendars where the volume of published content has created internal competition that is suppressing page one rankings that the site should be winning. Help me build a topic authority content plan so I can improve Google rankings to page one and systematically eliminate the duplicate content that is preventing the site from consolidating its authority around the keywords that matter most. My situation: - Site type and content volume: [e.g., "a full-service digital marketing agency content hub — 840 published posts across 12 topic categories, publishing cadence of 8 posts per week for the last 3 years"] - Duplicate content manifestation: [e.g., "Screaming Frog audit identified 47 URL pairs with near-identical title tags, 23 posts targeting the same primary keyword within 10% variation, and 18 categories where three or more posts are competing for the same SERP position"] - Traffic and ranking impact: [e.g., "Google Search Console shows 31 keywords where two or more site pages are alternating in the top 20 positions with neither achieving a stable page one result — combined these keywords represent 14,000 monthly impressions that are not converting to clicks"] - Topic clusters where the problem is most severe: [e.g., "social media marketing — 14 posts covering variations of 'how to grow Instagram followers' with no clear pillar page and no canonical strategy differentiating the content"] - Current content calendar approach: [e.g., "editors generate post ideas independently without a master keyword map — duplication is discovered after publication through rank tracking, not prevented at the brief stage"] - Canonicalization and consolidation decisions already made: [e.g., "three posts have been consolidated in the last quarter with 301 redirects — traffic from the redirected URLs transferred within six weeks in two of the three cases"] - Business goal for the content plan: [e.g., "want 15 target keywords to move from alternating position 11 to 20 to a stable position one to five within six months"] Deliver: 1. A topic authority content plan framework — a six-stage process covering the keyword cannibalization audit, the pillar page identification for each affected topic cluster, the consolidation versus differentiation decision criteria for each duplicate pair, the canonical URL designation protocol, the 301 redirect implementation sequence, and the new content publication rules that prevent future duplication 2. A keyword cannibalization audit template — a spreadsheet structure with eight columns covering the target keyword, the URLs competing for it, the current ranking position of each URL, the monthly impressions for each URL, the content overlap score, the consolidation recommendation (merge, redirect, differentiate, or canonicalize), and the priority tier based on traffic impact 3. A pillar page brief for the social media marketing topic cluster — a content specification for a comprehensive pillar page that consolidates the authority of the 14 Instagram growth posts, covering the H1 and URL slug targeting the highest-volume keyword in the cluster, the eight H2 sections that cover each sub-topic currently spread across separate posts, the internal link structure that converts the 14 existing posts into supporting cluster content, and the word count target that exceeds the longest competing post by 20% 4. A consolidation versus differentiation decision matrix — a four-criteria framework applied to each duplicate URL pair, covering the search intent overlap score, the backlink profile comparison, the traffic history trend, and the topical differentiation potential, producing a clear merge or keep decision for each pair without requiring manual judgment for each URL 5. A new content publication protocol that prevents future duplication — a three-step process the editorial team runs before any new content brief is approved, covering a keyword database query to check for existing content targeting the same primary keyword within 20% search volume overlap, an intent similarity check, and a mandatory pillar page connection requirement for any post in a topic cluster that already has a pillar page 6. A Google Search Console cannibalization tracking setup — a filter configuration for monitoring the 31 alternating keyword pairs weekly, with the ranking stability metric that indicates the consolidation is working and the traffic attribution method for confirming that redirected URLs are passing authority to the consolidated destination 7. A content differentiation brief for three posts that cannot be merged — for posts that target genuinely different search intents despite similar surface-level topics, a structure for strengthening the differentiation signals (unique angle, distinct audience segment, different search intent classification) to reduce the cannibalization signal Google reads from similar content 8. A six-month ranking improvement roadmap — a monthly action plan assigning the consolidation priority tier from the audit, the pillar page publication in month two, the redirect implementation in month three, and the new content protocol rollout in month four, with the expected ranking position improvement at each milestone based on the traffic data from the three successful consolidations already completed **Write every framework and audit template assuming the in-house SEO lead is presenting this plan to an agency leadership team that has been creating the duplicate content problem for three years and will resist a consolidation program that appears to reduce content volume — every recommendation must be framed in terms of ranking improvement and traffic recovery, not content reduction.**