wilco-ad-setup

Wilco Ad Setup

Inputs

Ask once for:

• main keyword
• product SKU
• optional product name
• optional budget level
• optional output path

Defaults:

• budget level: conservative
• output directory: ./artifacts/launchfast/campaigns/

Strategy

Wilco’s model favors:

• exact match only for manual keyword campaigns
• tight budget isolation
• proven converting keywords
• strong emphasis on purchase rate and competitor coverage

Workflow

1. Market research

Run:

research_products(keyword="<main_keyword>", focus="balanced", product_limit=20)

Capture top 10-12 ASINs and market context.

2. Keyword research

• batch ASINs in groups of 3-4
• prefer parallel tool calls when practical
• do not require delegation

Use:

amazon_keyword_research(asins=[...], limit=50, min_search_volume=300)

3. Score keywords

Rank keywords with a weighted score based on:

• purchase rate
• competitor coverage
• search volume
• relevance

Prioritize keywords where multiple competitors already rank well.

Select:

• Exact A: top converters
• Exact B: volume converters
• Exact C: niche converters
• Product targets: top competitor ASINs

4. Generate bulksheet

Create:

• Auto campaign
• Product targeting campaign
• 3 exact-match manual campaigns

Use Python csv.writer and write to:

Use this exact Amazon Bulksheets 2.0 header and column order:

Product,Entity,Operation,Campaign Id,Ad Group Id,Portfolio Id,Ad Id,Keyword Id,Product Targeting Id,Campaign Name,Ad Group Name,Start Date,End Date,Targeting Type,State,Daily Budget,sku,asin,Ad Group Default Bid,Bid,Keyword Text,Match Type,Bidding Strategy,Placement,Percentage,Product Targeting Expression,Audience ID,Shopper Cohort Percentage,Shopper Cohort Type

Deterministic campaign layout:

• Auto: 1 campaign, 1 ad group, 1 product ad, 4 auto targeting rows
• Product targeting: 1 campaign, 1 ad group, 1 product ad, up to 10 ASIN target rows
• Exact A: 1 campaign, 1 ad group, 1 product ad, up to 5 exact-match keywords
• Exact B: 1 campaign, 1 ad group, 1 product ad, up to 5 exact-match keywords
• Exact C: 1 campaign, 1 ad group, 1 product ad, up to 5 exact-match keywords

Required defaults:

• start date: current date in YYYYMMDD
• bidding strategy: Dynamic bids - down only
• one ad group per campaign
• exact match for all three manual keyword campaigns

./artifacts/launchfast/campaigns/[product-name]-wilco-[YYYY-MM-DD].csv

5. Return summary

Include:

• why Wilco is a better fit or not for this niche
• keyword selection logic
• bids and budget assumptions
• export path