# Rsa Single Account > Generate a full Responsive Search Ad set for ONE account — 15 headlines + 4 descriptions per active ad group — from website-verified content plus live SERP competitive analysis and a website→Google-Business-Profile review fallback. Auto-invoke when user says "create RSAs for [account]", "generate RSAs for [account]", or "build RSA copy for [account]". Outputs an import-ready Google Sheet. Read-on… - **Type:** Skill - **Install:** `agentstack add skill-fourteenwm-ppc-ai-skills-rsa-single-account` - **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior - **Seller:** [fourteenwm](https://agentstack.voostack.com/s/fourteenwm) - **Installs:** 0 - **Category:** [Search](https://agentstack.voostack.com/c/search) - **Latest version:** 0.1.0 - **License:** MIT - **Upstream author:** [fourteenwm](https://github.com/fourteenwm) - **Source:** https://github.com/fourteenwm/ppc-ai-skills/tree/main/rsa-single-account ## Install ```sh agentstack add skill-fourteenwm-ppc-ai-skills-rsa-single-account ``` Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent. ## About # RSA Single-Account Generator **Purpose:** Produce a complete, import-ready RSA set for a single account — find its active Search ad groups, scrape its website for verified claims, analyze competitors for differentiation, pull reviews, and generate 15 headlines + 4 descriptions per ad group. Output lands in a Google Sheet ready to copy/paste into Google Ads Editor. **Type:** Read-only generation skill. It does not mutate Google Ads — it writes ad copy to a review Sheet; you import via Editor. --- ## What This Skill Wraps The skill is a procedural wrapper around a handful of small scripts you provide (named generically below). It determines the account, runs each step, and assembles verified copy via two companion skills: - **`ad-copy-verification-standard`** — every claim must come from the website (or a verified review). No "Free" copy. *Empty > Inaccurate.* - **`ad-copy-generation-framework`** — the 23-element framework + the headline/description distribution. **Do not invent business facts.** All USPs, services, hours, credentials, and social proof must be verified from the scrape or reviews. If the scrape fails, STOP — do not fall back to generic copy. --- ## Decisions Baked In | Decision | Choice | |---|---| | Competitive analysis | **Live SERP** competitor messaging + saturation/gap analysis (the differentiator) | | Reviews | Website first → **Google Business Profile fallback** via SERP local results | | Headline distribution | 3 keyword · 2 social proof · 4 generic USP · 2 CTA · 1 pun · 3 flexible | | Descriptions | Formula-composed from verified claims (keyword + USP + CTA), not lifted sentences | | Output | One import-ready Google Sheet, cleared + rewritten each run | --- ## Workflow ### Step 1 — Find the account `check_active_accounts.py` → resolve the account name to a Customer ID (CID). Multiple matches → ask the user. No match → list candidates. ### Step 2 — Get the website URL `get_account_website_url.py` reads the CID from **stdin**, so pipe it: ```bash echo "" | python get_account_website_url.py ``` → business website (from ad final URLs) + business name. No ads found → ask the user for the URL. ### Step 3 — Competitive analysis (the differentiator) `analyze_competitors_for_rsa.py "" "" [--vertical ]` → SERP-based competitor messaging analysis: common USPs (with saturation), services, CTAs, and a **gap analysis** of which of the client's USPs are unique vs. saturated. - Derive **service** from the first active campaign/ad group name; **location** from the account/ad-group names (fallback: ask). - **Strategy:** emphasize USPs competitors *don't* mention; de-emphasize/skip USPs 3+ competitors use; differentiate through specificity. Cache for Step 7. ### Step 4 — Query campaign structure `get_search_campaign_structure.py ` → active Search campaigns (name contains "Search", for production safety) + active ad groups. **The ad group name is the primary keyword** for that RSA. ### Step 5 — Scrape the website (once per account) The scrape uses Firecrawl + an LLM for structured extraction, so it needs `FIRECRAWL_API_KEY` + an LLM API key in the environment: ```bash python scrape_website_firecrawl.py "" ``` → verified business overview, USPs, services, credentials, hours, specializations. Cache and reuse across all ad groups. **If scraping fails → STOP** (no generic fallback). ### Step 6 — Reviews: website → GBP fallback - **Website first:** parse the scrape for testimonials (need ≥2 for social-proof headlines). - **GBP fallback** (if " ""` → rating, review count, recent snippets. - Reviews from website or GBP only — never assumed. ### Step 7 — Generate RSAs (per ad group) Invoke `ad-copy-generation-framework`. Distribution: **Headlines (15):** 3 keyword · 2 social proof · 4 generic USP · 2 CTA · 1 pun · 3 flexible. **Descriptions (4):** 2 = keyword + product USP + CTA · 2 = keyword + generic USPs (no CTA). Composed from verified claims. **Apply competitive insights:** prioritize unique client USPs in the first USP slots; skip claims 3+ competitors use (or only combine them inside descriptions); differentiate through specificity; lead with differentiators. **Verification rules (MANDATORY):** - ALL copy website- or review-verified. - **NO "Free" copy** even if verified on the site (premium-customer avatar filter). - **NO generic placeholders / unverified ratings** ("Rated 5★ By Happy Customers" with no verified count). - **Empty > Inaccurate** — leave a slot empty rather than fabricate. - **No reviews at all (site or GBP):** skip the 2 social-proof headlines, add 2 more **verified** flexible headlines (5 flexible total). Never placeholders. **Validation:** headlines ≤30 chars · descriptions ≤90 chars · Title Case · all claims verified · no "Free" · flag (don't silently drop) any violations for review. ### Step 8 — Write to the Sheet Prepare RSA data as JSON, then: ```bash python write_rsa_to_sheet.py "" rsa_data.json ``` JSON per ad group: `{account_name, campaign_name, ad_group_name, headlines:[15], descriptions:[4]}`. The script clears the Sheet, writes a header row + data, and handles Sheets auth. ### Step 9 — Summary Report ad groups processed (by campaign), the Sheet URL, validation results (within/over limits, flagged), competitive insights applied, and warnings (limited website content, GBP fallback used, no reviews found). --- ## Output Configuration | Setting | Value | |---|---| | Sheet ID | `` | | Columns | A Account · B Campaign · C Ad Group · D–R Headlines 1–15 · S–V Descriptions 1–4 | | Auth | a Sheets OAuth credential you provide | --- ## Error Handling | Symptom | Cause | Fix | |---|---|---| | Account not found | Name mismatch | List candidates, confirm exact name | | Website scrape fails | Firecrawl/key error or empty site | STOP — no generic fallback; recommend manual review | | No reviews (site or GBP) | No testimonials / no local match | Omit social proof, add verified flexible headlines | | Headline >30 / description >90 | Over limit | Flag with location; never auto-truncate | | No active ad groups | Paused / no Search campaigns | Error (criteria: "Search" in name, campaign + ad group ENABLED) | --- ## Worked Example (illustrative — verify against the real site) Ad group **"Auto Repair [City]"**, scrape surfaces *ASE Certified, AAA Approved, NAPA AutoCare, all makes & models, online booking, M-F 8AM-5:30PM* (no reviews found → 5-flexible fallback): - Headlines: `Auto Repair In [City]` · `ASE Certified Technicians` · `AAA Approved Auto Repair` · `NAPA AutoCare Center` · `Book Your Service Today!` · `All Makes & Models Serviced` · `Open Mon-Fri 8AM-5:30PM` · … (15 total) - Description: `Auto Repair In [City] By ASE Certified Techs. AAA Approved. Book Online Today!` Every line traces to a verified site claim; nothing fabricated; no "Free". --- ## Important Notes - **Read-only on Google Ads** — output is a Sheet for review; you import via Editor. - **Verification is non-negotiable** — see `ad-copy-verification-standard`. - Each GBP/SERP lookup costs an API credit; scrape once per account and cache. --- ## License MIT — use freely in your own brain / repo / agency. ## Source & license This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code. - **Author:** [fourteenwm](https://github.com/fourteenwm) - **Source:** [fourteenwm/ppc-ai-skills](https://github.com/fourteenwm/ppc-ai-skills) - **License:** MIT Install and usage instructions live in the source repository linked above. ## Pricing - **Free** — Free ## Security capabilities Automated source analysis of v0.1.0 — what this tool can access: - **Network access:** no - **Filesystem access:** no - **Shell / process execution:** no - **Environment & secrets:** no - **Dynamic code execution:** no *"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.* ## Versions - **0.1.0** — security scan: passed — Imported from the upstream source. ## Links - Listing page: https://agentstack.voostack.com/l/skill-fourteenwm-ppc-ai-skills-rsa-single-account - Seller: https://agentstack.voostack.com/s/fourteenwm - Browse the marketplace: https://agentstack.voostack.com/browse --- Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.