AI Prompts

Goal: transform raw Search Console data into a single-page, client-friendly HTML report that communicates performance at-a-glance and supports deeper drilldowns.

Deliverables

A single index.html (self-contained or with separate minified JS/CSS) ready to paste into Google Sites embed widget.

Modern, professional UI: large KPIs, trend charts, compact tables, contextual tooltips, and a short executive summary.

Export options: Print/PDF and CSV export for each table.

Mobile-responsive layout and accessible color contrast.

Layout & Components

Header: Client name, site, date range selector (last 7/28/90/365 days + custom), export buttons.

Executive Summary card (3 bullets): top wins, top risks, one recommended action.

KPI row: Clicks, Impressions, CTR, Avg position (big numbers + mini sparklines).

Main left column:

• Time-series area chart: clicks & impressions stacked, hover crosshair, zoom by brushing.

• Compare toggle (previous period % change).

Main right column:

• Top Queries (table with clicks/impr/ctr/position + small trend sparkline).

• Top Pages (sortable).

• Countries & Devices (pie/bar small multiples).

Coverage / Issues card: show error counts, broken pages, and quick remediation steps.

Footer: data timestamp, generated-by, and legend.

Visual style

Clean, airy card layout; 8–12px rounded corners; 16px base font; clear hierarchy.

Use a neutral palette plus one accent color. Provide color tokens for accessibility and print.

Use icons sparingly (SVG).

Microcopy & Insights

For each chart include a one-line takeaway and 1–2 suggested actions (e.g., “Query X rising — consider landing page optimization”).

Interaction & behavior

Hover tooltips, sortable tables, search/filter queries.

Date-range controls that update all charts.

Lightweight: use charting library with small bundle footprint.

Data Inputs

Accept CSV or JSON with columns: date, query, page, clicks, impressions, ctr, position, country, device, countryCode.

Map fields automatically; handle missing values.

Acceptance criteria

Single HTML that embeds in Google Sites iframe and renders correctly.

Works offline (no external CDNs) OR document which small libs are required.

Accessible (ARIA labels + keyboard navigation) and printable.

You are an advanced SEO analyst with deep understanding of Google Core Updates.

I am sharing Google Search Console performance data comparing:

- Period A: Previous 28 days

- Period B: Last 28 days (Core Update impact period)

The data includes:

Query | Page URL | Clicks | Impressions | CTR | Average Position

Your job is to analyze performance degradation caused by a Core Update

and give a precise, URL-level recovery plan.

DO ALL TASKS BELOW:

────────────────────────

1️⃣ DROPPED KEYWORD IDENTIFICATION

────────────────────────

- Find keywords that:

  - Lost clicks (>20%)

  - Lost impressions (>20%)

  - Dropped average position by 3+ places

- Separate losses into:

  - Ranking drop

  - CTR drop

  - Demand drop (search interest / SERP shift)

- Flag keywords affected by:

  - AI Overview / SERP feature takeover

  - Intent change (article replaced by tool, video, forum, etc.)

  - Keyword cannibalization between URLs

────────────────────────

2️⃣ URL DAMAGE ANALYSIS (CRITICAL)

────────────────────────

For each affected URL, calculate:

- Total keywords lost

- Click loss %

- Impression loss %

- Avg position change

Classify each URL into ONE primary issue:

- Content depth / usefulness issue

- Search intent mismatch

- Authority / E-E-A-T weakness

- Internal linking weakness

- Technical / indexing issue

- Over-optimization / spam signals

────────────────────────

3️⃣ CORE UPDATE SIGNAL CHECK

────────────────────────

Check for algorithmic quality signals:

- Thin or repetitive content

- Lack of first-hand experience

- Poor topical coverage vs competitors

- Outdated content

- Weak author trust / entity signals

- Title clickbait vs content mismatch

────────────────────────

4️⃣ URL-WISE FIXING PLAN (MOST IMPORTANT)

────────────────────────

For EACH damaged URL, give:

A. WHAT WENT WRONG (Data-based)

B. WHAT GOOGLE EXPECTS INSTEAD

C. EXACT FIXES:

   - Sections to add / expand / remove

   - Keyword clusters to remap

   - Internal links to add (from what type of pages)

   - Schema improvements (FAQ, HowTo, Author, Review)

   - Media improvements (tables, examples, visuals)

D. PRIORITY LEVEL:

   - High (quick recovery possible)

   - Medium

   - Low (needs authority growth)

────────────────────────

5️⃣ QUICK WINS DETECTION

────────────────────────

Identify URLs where:

- Impressions are stable but CTR dropped

- Position is stable but clicks dropped

Suggest:

- Title & meta rewrites

- Snippet optimization ideas

- SERP alignment tweaks

────────────────────────

6️⃣ RECOVERY ROADMAP

────────────────────────

- What this Core Update is likely punishing

- What competitors are doing better

- 30 / 60 / 90 day recovery action plan

- What NOT to change right now (risk control)

────────────────────────

OUTPUT RULES (STRICT)

────────────────────────

- Use clear section headings

- Use tables where helpful

- URL-wise bullet point fixes

- No generic SEO advice

- Fully data-driven insights only

Think like Google.

Be brutally honest.

Focus on recovery, not theory.

 You are an advanced SEO analyst with deep understanding of Google Core Updates.

I am sharing Google Search Console performance data comparing:

- Period A: Previous 28 days

- Period B: Last 28 days (Core Update impact period)

The data includes:

Query | Page URL | Clicks | Impressions | CTR | Average Position

Your job is to analyze performance degradation caused by a Core Update

and give a precise, URL-level recovery plan.

DO ALL TASKS BELOW:

────────────────────────

1️⃣ DROPPED KEYWORD IDENTIFICATION

────────────────────────

- Find keywords that:

  - Lost clicks (>20%)

  - Lost impressions (>20%)

  - Dropped average position by 3+ places

- Separate losses into:

  - Ranking drop

  - CTR drop

  - Demand drop (search interest / SERP shift)

- Flag keywords affected by:

  - AI Overview / SERP feature takeover

  - Intent change (article replaced by tool, video, forum, etc.)

  - Keyword cannibalization between URLs

────────────────────────

2️⃣ URL DAMAGE ANALYSIS (CRITICAL)

────────────────────────

For each affected URL, calculate:

- Total keywords lost

- Click loss %

- Impression loss %

- Avg position change

Classify each URL into ONE primary issue:

- Content depth / usefulness issue

- Search intent mismatch

- Authority / E-E-A-T weakness

- Internal linking weakness

- Technical / indexing issue

- Over-optimization / spam signals

────────────────────────

3️⃣ CORE UPDATE SIGNAL CHECK

────────────────────────

Check for algorithmic quality signals:

- Thin or repetitive content

- Lack of first-hand experience

- Poor topical coverage vs competitors

- Outdated content

- Weak author trust / entity signals

- Title clickbait vs content mismatch

────────────────────────

4️⃣ URL-WISE FIXING PLAN (MOST IMPORTANT)

────────────────────────

For EACH damaged URL, give:

A. WHAT WENT WRONG (Data-based)

B. WHAT GOOGLE EXPECTS INSTEAD

C. EXACT FIXES:

   - Sections to add / expand / remove

   - Keyword clusters to remap

   - Internal links to add (from what type of pages)

   - Schema improvements (FAQ, HowTo, Author, Review)

   - Media improvements (tables, examples, visuals)

D. PRIORITY LEVEL:

   - High (quick recovery possible)

   - Medium

   - Low (needs authority growth)

────────────────────────

5️⃣ QUICK WINS DETECTION

────────────────────────

Identify URLs where:

- Impressions are stable but CTR dropped

- Position is stable but clicks dropped

Suggest:

- Title & meta rewrites

- Snippet optimization ideas

- SERP alignment tweaks

────────────────────────

6️⃣ RECOVERY ROADMAP

────────────────────────

- What this Core Update is likely punishing

- What competitors are doing better

- 30 / 60 / 90 day recovery action plan

- What NOT to change right now (risk control)

────────────────────────

OUTPUT RULES (STRICT)

────────────────────────

- Use clear section headings

- Use tables where helpful

- URL-wise bullet point fixes

- No generic SEO advice

- Fully data-driven insights only

Think like Google.

Be brutally honest.

Focus on recovery, not theory.

Prompt - Create proper 1400 words article for me in english, make it clean, readable, and with proper structure. you have to act as a seo expert and by following google's ranking guidelines you have to prepare article for me. Add humour and logics, use facts and stay away from fake data. My article paragraphs should be short, clear and must be good for search engines and ai engines. You have write article with the help of valid and trusted sources, dont add random things or data on my article. I want to add everything real, dont radomly write extra info from yourself. Dont use passive voice above 10%, also i want article with good readability. Now you have to write like a human, you have to follow all patterns that human uses while writing, use your human writing behaviour database and write like a real human witth mix tones. You to use header tags in a smart way, add my keywords smartly, make my article professional and friendly for my users. Don't over optimize my article, use keywords in proper density suggested by google, all my keywords should pe placed naturally. i want to build and improve my web trust, so you have to add sources where needed, you have to impress google that we are using genuine data, we have clear everything in a professional way, cover all topics in a clear way.  Here is my article topic - topic

https://youtu.be/_ZrpMU_g_LY?si=vqGokpN-CdgvUxMB

https://docs.google.com/presentation/d/1o9LkhsQ_ZvyGwpM5bGKRRvd1tnlPY6AbF9ido1V1-pk/edit?usp=sharing