Competitive Intelligence Master Template Creation
Budget: €30 – €250 EUR
I need a high-end, automated Competitive Intelligence Master Template built in Looker Studio.
IThis report must use ONLY Semrush Domain Analytics API.
This is a "Prospecting/Spying" tool.
CORE REQUIREMENTS:
• Theme: Dark Mode (Edge Theme). High-end Agency look (Black/Gold/White).
• Dynamic Functionality: I need a Domain Input Box (Parameter). I must be able to type a new domain and have the entire 15-page report update instantly for that domain.
• Competitor Benchmarking: The report must compare 1 Main Target Domain vs. up to 4 Competitors simultaneously.
KEY PAGES TO BUILD (Semrush Data Only):
1. Market Dominance Overview: Authority Score comparison, Organic Traffic trends (Time Series), and total Keywords count.
2. The Keyword Gap: A "Battleground" table showing keywords where competitors rank in Top 10 and the Main Target is missing or below page 5.
3. Traffic Share Analysis: A Pie Chart or Bar Chart showing the estimated market share of the 5 domains in the Palermo area.
4. Backlink & Trust Profile: Comparison of Referring Domains and overall Domain Trust.
5. Top Content Spying: A table showing the most successful pages (by traffic) of the comp
PAGE 1: COVER ( Branding, Project Name, Confidentiality Note).
• PAGE 2: EXECUTIVE SUMMARY (Use Scorecards for: Estimated Monthly Traffic, Total Keywords, and Authority Score).
• PAGE 3: HISTORICAL TRAFFIC ANALYSIS (Time Series Chart comparing Main Domain vs. 4 Competitors - last 12-24 months).
• PAGE 4: MARKET SHARE (Pie Chart showing the % of organic traffic share between the 5 domains).
• PAGE 5: AUTHORITY BENCHMARKING (Bar Chart comparing Authority Scores of all 5 domains).
• PAGE 6: KEYWORD BATTLEGROUND (Detailed Table: Keyword, Search Volume, Competitor Position, Target Domain Position).
• PAGE 7: KEYWORD GAP ANALYSIS (Venn Diagram or Table showing unique vs. shared keywords).
• PAGE 8-10: COMPETITOR SPYING (TOP PAGES) (One page for each main competitor showing their top-performing URLs by traffic).
• PAGE 11: BACKLINK PROFILE (Bar Chart comparing the number of Referring Domains for all 5 sites).
• PAGE 12: SITE HEALTH SCORE (Gauge Chart showing the Site Audit Health Score from 0 to 100).
• PAGE 13: TOP TECHNICAL ISSUES (Table listing the most critical SEO errors found via Semrush Site Audit).
• PAGE 14: STRATEGIC ROADMAP (Static page with text placeholders for Phase 1, 2, and 3 of the UBIMAJOR Protocol).
• PAGE 15: CONCLUSION & CONTACTS (Closing statement and Agency contact details).
IThis report must use ONLY Semrush Domain Analytics API.
This is a "Prospecting/Spying" tool.
CORE REQUIREMENTS:
• Theme: Dark Mode (Edge Theme). High-end Agency look (Black/Gold/White).
• Dynamic Functionality: I need a Domain Input Box (Parameter). I must be able to type a new domain and have the entire 15-page report update instantly for that domain.
• Competitor Benchmarking: The report must compare 1 Main Target Domain vs. up to 4 Competitors simultaneously.
KEY PAGES TO BUILD (Semrush Data Only):
1. Market Dominance Overview: Authority Score comparison, Organic Traffic trends (Time Series), and total Keywords count.
2. The Keyword Gap: A "Battleground" table showing keywords where competitors rank in Top 10 and the Main Target is missing or below page 5.
3. Traffic Share Analysis: A Pie Chart or Bar Chart showing the estimated market share of the 5 domains in the Palermo area.
4. Backlink & Trust Profile: Comparison of Referring Domains and overall Domain Trust.
5. Top Content Spying: A table showing the most successful pages (by traffic) of the comp
PAGE 1: COVER ( Branding, Project Name, Confidentiality Note).
• PAGE 2: EXECUTIVE SUMMARY (Use Scorecards for: Estimated Monthly Traffic, Total Keywords, and Authority Score).
• PAGE 3: HISTORICAL TRAFFIC ANALYSIS (Time Series Chart comparing Main Domain vs. 4 Competitors - last 12-24 months).
• PAGE 4: MARKET SHARE (Pie Chart showing the % of organic traffic share between the 5 domains).
• PAGE 5: AUTHORITY BENCHMARKING (Bar Chart comparing Authority Scores of all 5 domains).
• PAGE 6: KEYWORD BATTLEGROUND (Detailed Table: Keyword, Search Volume, Competitor Position, Target Domain Position).
• PAGE 7: KEYWORD GAP ANALYSIS (Venn Diagram or Table showing unique vs. shared keywords).
• PAGE 8-10: COMPETITOR SPYING (TOP PAGES) (One page for each main competitor showing their top-performing URLs by traffic).
• PAGE 11: BACKLINK PROFILE (Bar Chart comparing the number of Referring Domains for all 5 sites).
• PAGE 12: SITE HEALTH SCORE (Gauge Chart showing the Site Audit Health Score from 0 to 100).
• PAGE 13: TOP TECHNICAL ISSUES (Table listing the most critical SEO errors found via Semrush Site Audit).
• PAGE 14: STRATEGIC ROADMAP (Static page with text placeholders for Phase 1, 2, and 3 of the UBIMAJOR Protocol).
• PAGE 15: CONCLUSION & CONTACTS (Closing statement and Agency contact details).