← ClaudeAtlas

hector-sqp-analysislisted

Use ONLY when the user explicitly asks to run an "SQP analysis", "search query performance analysis", "SQP report", or "search query report" for a named brand or Amazon Ads profile. Trigger phrases include "run SQP analysis for X", "do an SQP report for X", "search query performance for X", "analyse SQP for X", and close paraphrases where "SQP" OR "search query performance" co-occur with a brand name or account. Builds a 6-tab HTML dashboard (Tab 0 = cover/summary, Tabs 1–5 = analysis) and an Excel workbook (5 data sheets) covering: Movers & Shakers (WoW search-volume trend), Top Keywords (brand funnel snapshot), Scale-Up Keywords (dynamic IS% threshold based on brand average), AOV Gap Analysis (brand AOV vs category AOV gap ≥15%), and Funnel Drop-Off (brand funnel stage classification). Token-efficient by design: pulls ONLY the 10 metrics the outputs use, applies server-side metric_filters to drop long-tail terms before they enter context, reads file-offloaded tool results from disk instead of re-transcribin
hectorai-live/hector-amazon-ads · ★ 0 · Data & Documents · score 72
Install: claude install-skill hectorai-live/hector-amazon-ads
# Hector SQP Analysis (v1.2) > ## ⚠️ CRITICAL OBLIGATIONS — READ BEFORE EVERY USE > > 1. **ALWAYS ask the precursor questions before any MCP call.** Account name + country, week window, AND brand token confirmation are REQUIRED. Do not begin pulls until all three are answered. > 2. **NEVER guess the profile_id.** Always resolve via `find_profile_by_name`. If multiple profiles match, list them and wait for the user to pick. If zero match, surface that and stop. > 3. **SQP is weekly and Saturday-aligned. NEVER pass `today` or `yesterday` as `end_date`.** Compute the most recently completed Saturday (≥3 days before today in Asia/Kolkata for IN accounts) locally. Use `week_range` enum when it fits; use explicit `start_date`/`end_date` otherwise. NEVER pass both in the same call. **SQP date resolution is LOCAL — do NOT call `analytics_budget_pacing`.** > 4. **Request ONLY the 10 output metrics** (list in Step 4A). Never request the full 18-metric set — 8 of those fields are never displayed anywhere and roughly double the payload. > 5. **Always apply the server-side `metric_filters` min-volume filter** (`T_Query > min_search_volume`, default 100) on every `analytics_sqp_search_terms` call. Long-tail rows must be dropped on the server, never in context. > 6. **NEVER re-transcribe raw tool data by hand.** If the tool result was file-offloaded to `/mnt/user-data/tool_results/*.json`, merge and process it FROM DISK with Python. If it arrived inline, write it ONCE as a compact TSV (hea