This is not a blog post condensed into a PDF. This is an operating system for building an AI-powered e-commerce optimization agency from zero to ₦15,000,000/month in recurring revenue. Every module contains exact procedures — not theories, not possibilities, not “consider doing X.” You will do X, in this order, with these tools, and you will verify it worked before moving on.
34 procedures. 10 modules. 8+ hours of reading and execution. If you complete every procedure, you will have a functioning e-commerce optimization agency with paying clients, automated product content pipelines, and a scaling roadmap. If you skip procedures, you will have a folder of half-configured tools and no revenue. The choice is yours.
MODULE 1: FOUNDATION — YOUR E-COMMERCE OPTIMIZATION AGENCY OPERATING SYSTEM
Overview
Before you touch a single Shopify store, you need the infrastructure that runs your agency. This module sets up your project management, documentation, client portal, financial tracking, and communication systems. These are not optional. Every successful e-commerce optimization operator has these systems in place before their first client call. Every failed operator skipped them.
Time to complete: 3-4 hours
Tools needed:
Notion
(free), Google Workspace (₦3,600/mo), Paystack (free to set up)
Procedure 1.1: Create Your Agency Command Center in Notion
Open your browser and go to notion.so. Sign in or create a free account. You should see the Notion dashboard — a clean sidebar on the left and a main area with a “New page” button.
Click New page in the left sidebar. Name it: [Your Agency Name] Command Center. This is the single source of truth for your entire business.
Inside this page, create seven sub-pages by typing /page and naming each one:
- Clients — Every client, their store URL, product count, status, revenue, and optimization progress
- SOPs — Standard Operating Procedures for every repeatable optimization process
- Prompt Library — Every AI prompt your agency uses, organized by service type
- Product Audits — Organized audit data by client, including quality scores and optimization status
- Templates — Client-facing documents, proposals, contracts, reports
- Finance — Revenue tracking, expense tracking, margin analysis
- Pipeline — Prospects, leads, and their position in your sales process
The Clients Database
Open the Clients sub-page. Type /table and select Table — Full page. Name it Client Roster.
Add these columns (click the + button at the right end of the header row):
| Column Name | Type | Description |
|---|
| Client Name | Title | The business name |
| Status | Select: Active, Onboarding, Paused, Churned | Current relationship state |
| Tier | Select: Starter, Growth, Enterprise | Service tier |
| Monthly Revenue | Number | Retainer amount in Naira |
| Setup Fee | Number | One-time setup fee in Naira |
| Store URL | URL | Shopify store URL |
| Product Count | Number | Total products in catalog |
| Products Optimized | Number | Products with optimized listings |
| Optimization Score | Number | Average quality score across products |
| Start Date | Date | When the engagement began |
| Next Delivery | Date | When the next deliverable is due |
| Health Score | Select: Green, Yellow, Red | Relationship health |
Add one test row: Client Name = “Test Client,” Status = “Active,” Tier = “Starter,” Monthly Revenue = 500000, Setup Fee = 300000, Product Count = 50, Products Optimized = 0, Optimization Score = 2.1. Fill in all remaining fields.
Procedure 1.2: Set Up Your Financial Infrastructure
Paystack for Naira Payments
Go to paystack.com and create a business account. Complete the business verification — you will need your BVN, a valid ID, and a corporate bank account. Paystack processes Naira payments directly, supports recurring billing, and charges 1.5% + ₦100 per transaction (capped at ₦2,000).
Once approved, navigate to Products in the Paystack dashboard. Create three products:
Product 1: Starter Setup Fee
- Name:
E-commerce Optimization Setup - Price: ₦500,000 (One time)
- Description: “One-time setup fee for Starter tier e-commerce optimization engagement”
Product 2: Starter Monthly Retainer
- Name:
Starter Monthly Optimization - Price: ₦500,000/month (Recurring)
- Description: “Monthly retainer for Starter tier e-commerce optimization services”
Product 3: Growth Setup Fee
- Name:
Growth Optimization Setup - Price: ₦1,500,000 (One time)
Product 4: Growth Monthly Retainer
- Name:
Growth Monthly Optimization - Price: ₦1,500,000/month (Recurring)
Product 5: Enterprise Setup Fee
- Name:
Enterprise Optimization Setup - Price: ₦3,500,000 (One time)
Product 6: Enterprise Monthly Retainer
- Name:
Enterprise Monthly Optimization - Price: ₦3,500,000/month (Recurring)
Generate payment links for each product. Save all links in your Notion Templates page under “Payment Links.”
Revenue Tracking
In your Notion Finance page, create a table called Revenue Tracker with these columns:
| Column Name | Type |
|---|
| Month | Title (e.g., “May 2026”) |
| Total MRR | Number (Monthly Recurring Revenue in ₦) |
| Setup Fees | Number |
| Total Revenue | Formula: Total MRR + Setup Fees |
| Expenses | Number |
| Net Profit | Formula: Total Revenue - Expenses |
| Active Clients | Number |
| Average Revenue Per Client | Formula: Total MRR / Active Clients |
Business Email
Go to workspace.google.com and sign up for the Business Starter plan ($6/mo). Register a domain that matches your agency name. Create your email: hello@youragency.com or yourname@youragency.com. Do not use a personal Gmail address for client communication.
Client Booking Calendar
Go to cal.com and create a free account. Set up two meeting types:
- E-commerce Optimization Discovery Call — 30 minutes, available Monday through Friday, 9 AM to 5 PM WAT
- Weekly Check-in — 15 minutes, recurring, for active clients only
Connect your
Google
Calendar. Copy your booking link and save it in Notion Templates.
HACK: Set your Cal.com minimum scheduling notice to 2 hours. This prevents prospects from booking a call 5 minutes from now when you are unprepared. First impressions are everything — a frantic, unprepared discovery call kills deals before they start.
Check-In: Module 1 Complete
Count your checkmarks. You need all 6. Do not proceed to Module 2 with an incomplete foundation.
MODULE 2: TECH STACK — YOUR E-COMMERCE OPTIMIZATION ARSENAL
Overview
Your agency runs on tools. This module sets up every tool you need — Shopify Partner, Make.com, OpenAI API, Semrush,
Hotjar
— connects them, and verifies each connection. Total cost: under ₦200,000/month at full capacity, but most tools are free or discounted until you have paying clients.
Time to complete: 4-5 hours
Tools needed: Shopify Partner (free), Make.com (free tier), OpenAI API ($5 credit), Semrush (7-day trial), Hotjar (free tier)
Go to partners.shopify.com and sign up for a free Partner account. Complete the profile with your agency details.
Create a development store: Click Stores → Add store → Create development store → Name it “optimization-demo” → Select “Development” plan (free).
Add 20 test products to this store with deliberately poor descriptions: manufacturer copy, no keywords, generic titles, missing specifications. This store is your portfolio — you’ll show the “before” and “after” to prospects. Make the “before” realistic (use actual manufacturer descriptions from real products — don’t make them worse than what real stores use).
Create a custom app in the development store: Apps → App and sales channel settings → Develop apps → Allow custom app development → Create an app → Name it “Optimization Engine” → Enable permissions: read_products, write_products, read_product_listings, read_inventory, read_orders, read_customers → Install app → Copy the Admin API access token.
Save the token in a password manager. Test it by navigating to: https://optimization-demo.myshopify.com/admin/api/2024-01/products.json with the header X-Shopify-Access-Token: [your_token]. You should see JSON product data.
Go to make.com and sign up for the Free plan (1,000 operations/month).
Click your profile icon → Connections → Add connection. Connect these services:
- Google Sheets — Authorize with your Google account
- HTTP (Make a request) — Built-in, no connection needed
OpenAI
(ChatGPT) — Enter your API key- Notion — Authorize with your Notion account
Slack
— Create a workspace if needed, then authorize
Verify all 5 connected services show a green “Connected” status.
Procedure 2.3: Set Up OpenAI API
Go to platform.openai.com. Navigate to API Keys and create a new key. Copy it immediately — you cannot view it again. Store it in a password manager.
Navigate to Billing and add $10 in credit. Set a monthly limit of $100. This prevents a buggy automation from draining your account overnight.
Test the API with a simple product description generation:
Prompt: "Write a product description for 'Premium Bamboo Cutting Board Set' targeting the keyword 'bamboo cutting board'. The product includes 3 sizes, is dishwasher safe, and has juice grooves. Customers love the durability and eco-friendly materials. Some mention it's heavier than expected. 200 words."
If the output is a well-structured product description that includes the keyword, addresses the weight concern, and highlights the positive features, your API is working correctly.
Go to semrush.com and start a 7-day free trial of the Pro plan.
After signing in, you should see the Semrush dashboard with a domain search bar at the top. Enter your development store’s domain (or any e-commerce site for practice).
Set up your first project with these modules:
1. Position Tracking
- Keywords: Add 30 e-commerce keywords (e.g., “buy [product] online,” “best [product] for [use case]”)
- Location: Select your target country
- Device: Desktop + Mobile
- Frequency: Daily
2. Site Audit
- Crawl limit: 500 pages
- Crawl frequency: Weekly
- Enable JavaScript rendering (critical for modern Shopify stores)
3. On-Page SEO Checker
- Click Start — Semrush will analyze and generate recommendations
Procedure 2.5: Set Up Hotjar for Conversion Insights
Go to hotjar.com and create a free account. Install the Hotjar tracking code on your development store (add the script to your Shopify theme’s <head> section).
Configure:
- Heatmaps: Enable on the top 10 product pages
- Session Recordings: Enable with 35 recordings/day (free tier limit)
- Surveys: Create an exit-intent survey: “What stopped you from completing your purchase today?”
The heatmap data will inform your optimization strategy. Even on your demo store, having a Hotjar setup to show prospects demonstrates professionalism and data-driven methodology.
HACK: During sales calls, share your screen and show the Hotjar heatmap of your demo store. Seeing a heatmap with real click data and scroll depth is visceral — prospects immediately understand that optimization is about data, not guesswork. This single demo has closed more deals for me than any slide deck.
Check-In: Module 2 Complete
6 checkmarks required. Do you have all 6?
MODULE 3: PRODUCT AUDIT SYSTEM — THE INTELLIGENCE ENGINE
Overview
Before you can optimize a product listing, you need to know what’s wrong with it. This module gives you a systematic audit process that scores every product on your client’s store and identifies the highest-impact optimization opportunities. A thorough audit is what separates professional optimization agencies from amateurs who just run product descriptions through ChatGPT and call it optimized.
Time to complete: 4-6 hours (first time), 2-3 hours per client after system is built
Procedure 3.1: Build the Product Audit Framework
Open a new Google Sheet. Name it “Product Audit Template.” Create these columns:
| Column | Description | How to Assess |
|---|
| Product Name | Product title as it appears on the store | Shopify API export |
| Title Quality | 1-5 score | 5 = Brand + Name + Key Attribute + Keyword; 1 = Generic/No keyword |
| Description Quality | 1-5 score | 5 = 300+ words, keyword-rich, addresses objections; 1 = Manufacturer copy |
| Bullet Points | Yes/No | Are there feature-benefit bullet points? |
| Meta Title | Present/Missing/Optimized | Check page source for title tag |
| Meta Description | Present/Missing/Optimized | Check page source for meta description |
| Image Quality | 1-5 score | 5 = Professional, multiple angles, lifestyle; 1 = Stock/supplier image |
| Alt Text | Yes/No | Are image alt tags present and descriptive? |
| Schema Markup | Yes/No | Is Product schema implemented? Check with Rich Results Test |
| Reviews Count | Number | How many reviews does this product have? |
| Average Rating | Number | Average star rating |
| Competitor Keywords | Number | Keywords competitors rank for that this product doesn’t |
| Revenue Potential | High/Medium/Low | Based on search volume × price × conversion potential |
| Priority Score | Formula | (10 - Title Quality) + (10 - Description Quality) + (Meta Title = Missing? 5:0) + (Revenue Potential = High? 5:0) |
Sort by Priority Score descending. The products at the top are your highest-impact optimization targets.
Procedure 3.2: Automate the Audit with Make.com
Create a Make.com scenario called “Product Audit Automation.”
Module 1: HTTP — Shopify API Product List
- URL:
https://[STORE_NAME].myshopify.com/admin/api/2024-01/products.json?limit=250&status=active - Method: GET
- Headers:
X-Shopify-Access-Token: [YOUR_TOKEN]
Module 2: Iterator
- Array:
products[] from the API response
Module 3: OpenAI — Score Product Quality
- Model: gpt-4o
- System prompt: “You are an e-commerce listing quality auditor. Score this product listing on these criteria: Title Quality (1-5), Description Quality (1-5). Also assess: Does the description read like manufacturer copy or custom content? Does the title include keywords a shopper would search for? Output as JSON: {title_quality: number, description_quality: number, is_manufacturer_copy: boolean, has_keywords: boolean, issues: [string]}”
- User message: Map the product title and body_html
Module 4: Google Sheets — Add Rows
- Map the product data and AI scores to the Product Audit template
Module 5: HTTP — Check Schema Markup
- URL:
https://[STORE_NAME].myshopify.com/products/[product_handle] - Parse the HTML for
application/ld+json script tags containing “Product” schema - Set Schema Markup = Yes if found, No if not
Procedure 3.3: The Keyword Gap Analysis
This is the most valuable part of the audit — showing clients what keywords they’re missing.
Open Semrush. Enter your client’s domain. Navigate to Keyword Gap (under Competitive Intelligence).
Enter 3-5 competitor domains. Click Compare.
Filter for: Missing keywords — keywords where ALL competitors rank but your client does not. These are the easiest opportunities because they represent search demand that competitors are already capturing.
Export the missing keywords. Add them to your Product Audit sheet. For each keyword, identify which product page should target it. This creates your optimization priority map: the highest-priority products are those with the most missing keyword opportunities.
HACK: Create a “Quick Win” sheet for each client containing the top 20 missing keywords with search volume >100 and keyword difficulty <40. These are keywords you can rank for with optimized content alone — no link building required. Optimizing for these 20 keywords in the first month generates visible results that build client confidence and buy you time for the bigger strategic plays.
Check-In: Module 3 Complete
6 checkmarks. The Quick Win sheet is your most powerful sales tool — show it to prospects and they’ll understand exactly what they’re missing.
MODULE 4: AI CONTENT ENGINE — THE PRODUCTION PIPELINE
Overview
Content production is where most e-commerce optimization agencies fail. They either produce thin descriptions that don’t rank, or they spend ₦15,000+ per product on human copywriters and cannot maintain margins. This module gives you an AI-powered content pipeline that produces optimized product listings at scale while maintaining quality. You will produce 100+ optimized listings per month per Growth client while spending less than ₦3,000 per product on AI costs.
Time to complete: 5-6 hours to build the pipeline, then 15-30 minutes per product
Procedure 4.1: Create the Master Prompt System
Open your Notion Prompt Library. Create these prompt templates:
Prompt 1: Full Product Listing Optimization
You are an expert e-commerce copywriter specializing in conversion-optimized product listings for [INDUSTRY/NICHE].
PRODUCT DATA:
- Name: {product_title}
- Category: {product_type}
- Vendor: {vendor}
- Current Description: {body_html}
- Key Specifications: {specs}
- Price: {price}
- Variants: {variant_info}
CUSTOMER INSIGHTS (from review analysis):
- Top 5 Things Customers Love: {positive_themes}
- Top 3 Concerns: {negative_themes}
- Customer Language: {customer_phrases}
SEO REQUIREMENTS:
- Primary Keyword: {primary_keyword}
- Secondary Keywords: {secondary_keywords}
- Missing Keywords to Include: {competitor_keywords}
OUTPUT (follow this exact structure):
1. PRODUCT TITLE (under 70 characters): Brand + Product Name + Key Attribute + Primary Keyword
2. PRODUCT DESCRIPTION (250-400 words):
- Opening paragraph: Hook with primary keyword, state the key benefit
- 2-3 body paragraphs: Features explained as benefits, address top concern proactively, incorporate customer language
- Closing paragraph: Call to action with urgency
3. BULLET POINTS (5 items, feature + benefit format, each 15-25 words)
4. META TITLE (under 60 characters, includes primary keyword)
5. META DESCRIPTION (under 155 characters, includes primary keyword and CTA)
6. PRODUCT TAGS (10 tags for Shopify internal search)
CRITICAL RULES:
- Do NOT invent specifications not in PRODUCT DATA
- Do NOT make health, safety, FDA, or medical claims
- Mirror exact customer language from CUSTOMER INSIGHTS
- Address the top concern proactively in paragraph 2
- Use short paragraphs (2-3 sentences max)
- Write at Flesch-Kincaid grade 7-8
- No exclamation marks in the description
- Include primary keyword 2-3 times naturally
Prompt 2: Review Sentiment Analyzer
Analyze these customer reviews for {product_name}. Output as JSON:
{
"positive_themes": [{"theme": "...", "frequency": N, "sample_phrases": ["...", "..."]}],
"negative_themes": [{"theme": "...", "frequency": N, "severity": "low/medium/high"}],
"customer_language": ["phrase1", "phrase2", ...],
"feature_requests": ["request1", "request2", ...],
"sentiment_trend": "improving/declining/stable",
"objection_handlers": [{"objection": "...", "recommended_response": "..."}],
"cross_sell_opportunities": ["opportunity1", "opportunity2", ...]
}
Reviews:
{reviews_text}
Procedure 4.2: Build the Bulk Optimization Pipeline
Create a Make.com scenario called “Bulk Listing Optimizer.”
Module 1: Google Sheets — Watch Rows
- Spreadsheet: “Product Audit — [Client Name]”
- Filter: Priority Score ≥ 10 AND Optimization Status = “Pending”
Module 2: OpenAI — Generate Optimized Listing
- Model: gpt-4o
- System prompt: Your Full Product Listing Optimization prompt
- User message: Map product data from the sheet
Module 3: OpenAI — Quality Gate
- Model: gpt-4o
- System prompt: “You are a QA reviewer for e-commerce product listings. Check: (1) No fabricated specifications? (2) No health/safety claims? (3) Title under 70 chars? (4) Description 250-400 words? (5) 5 bullet points? (6) Meta title under 60 chars? (7) Meta description under 155 chars? Reply PASS or FAIL with specific issues.”
Module 4: Router
- PASS → Set Optimization Status to “Approved”
- FAIL → Set Optimization Status to “Revision-Needed”, log QA feedback
Module 5: Google Sheets — Update Row
- Write optimized content (title, description, bullets, meta tags, tags) to columns
- Update status based on QA result
Procedure 4.3: Human QA Protocol
For the first 100 products per client, review every “Approved” listing manually:
- Specification accuracy check — Compare every factual claim against the source product data. AI hallucinates features like “waterproof” or “organic” at a rate of approximately 3-5% of listings. Catching these prevents customer complaints and returns.
- Brand voice check — Read 3 optimized listings in a row. Do they sound like they’re from the same brand? If not, adjust the prompt’s tone instructions.
- Competitive differentiation — Search the primary keyword on Google. Does your listing offer something the top 3 results don’t? If it’s just a rephrased version of what’s already ranking, it won’t win.
- Compliance review — No “FDA approved,” “cures,” “treats,” “100% natural” (unless certified), no unsubstantiated superlatives.
After 100 products, switch to 10% random sampling per batch. If the error rate stays below 2%, reduce to 5%. If it climbs above 5%, return to 100% review until the prompt is fixed.
Procedure 4.4: Build the Publishing Pipeline
Create a Make.com scenario called “Shopify Content Publisher.”
Module 1: Google Sheets — Watch Rows
- Spreadsheet: “Product Audit — [Client Name]”
- Filter: Optimization Status = “Approved” AND Publish Status ≠ “Published”
Module 2: HTTP — Shopify API Update
- URL:
https://[STORE_NAME].myshopify.com/admin/api/2024-01/products/{product_id}.json - Method: PUT
- Body:
{
"product": {
"id": "{{product_id}}",
"title": "{{optimized_title}}",
"body_html": "{{optimized_description_with_bullets}}",
"metafields_global_title_tag": "{{optimized_meta_title}}",
"metafields_global_description_tag": "{{optimized_meta_description}}",
"tags": "{{optimized_tags}}"
}
}
Module 3: Error Handler
- Log errors to “Publish Errors” sheet
- Set Publish Status to “Error”
Module 4: Delay — 2 seconds (Shopify API rate limit)
Module 5: Google Sheets — Update Row
- Set Publish Status to “Published”
- Record timestamp
HACK: Before publishing to a client’s live store, publish to your development store first. Create a mirror of the client’s product catalog on your dev store, publish the optimized listings there, and share the preview URLs with the client for approval. This “staging environment” approach prevents live-store disasters and gives clients a safe space to review content before it goes public. Professional agencies don’t push unreviewed content to production.
Check-In: Module 4 Complete
6 checkmarks. The Quality Gate is non-negotiable — one hallucinated specification on a live store can destroy a client relationship permanently.
MODULE 5: REVIEW INTELLIGENCE — THE FEEDBACK LOOP
Overview
Customer reviews are the most underutilized data asset in e-commerce. This module builds a system that continuously extracts insights from reviews and feeds them back into product listings, creating a virtuous cycle: better listings generate more sales, more sales generate more reviews, more reviews generate better listings.
Time to complete: 3-4 hours to build, then runs automatically
Procedure 5.1: Build the Review Collection Pipeline
For Shopify stores using the native review system:
Create a Make.com scenario called “Review Collector.”
Module 1: Schedule Trigger
- Weekly, Sunday at 10:00 PM WAT
Module 2: HTTP — Shopify Reviews API
- URL:
https://[STORE_NAME].myshopify.com/admin/api/2024-01/products.json?limit=250&fields=id,handle,title - Method: GET
- Parse response: Yes
Module 3: Iterator — Process each product
Module 4: HTTP — Get Reviews for Product
- URL:
https://[STORE_NAME].myshopify.com/admin/api/2024-01/products/{product_id}/reviews.json - Method: GET
For stores using Judge.me, Loox, or Yotpo, use their respective API endpoints instead. Document the correct API for each review app in your SOPs.
Procedure 5.2: Sentiment Analysis Engine
Module 5: OpenAI — Review Analysis
- Model: gpt-4o
- System prompt: Your Review Sentiment Analyzer prompt from the Prompt Library
- User message: Map the week’s reviews for each product
Module 6: Google Sheets — Update Review Dashboard
- Create a sheet called “Review Intelligence — [Client Name]”
- For each product: update positive themes, negative themes, customer language, sentiment trend
- Flag products with new negative themes (severity: medium or high) for immediate listing updates
Module 7: Conditional Router
- New negative themes → Generate “Objection Handler” update for product description
- New positive themes → Add customer language to product description
- Sentiment declining → Flag for client review (product quality issue?)
- No significant changes → Log as “No action needed”
Procedure 5.3: The “Review-to-Listing” Feedback Loop
Create a Make.com scenario called “Review Feedback Loop.”
Module 1: Trigger — When Review Intelligence sheet has new “Action Needed” items
Module 2: OpenAI — Generate Description Update
- Model: gpt-4o
- Prompt: “Given this product’s current optimized description and these new review insights, suggest specific additions or modifications to the description. Only modify the sections affected by the new insights — do not rewrite the entire description. Output the modified description in full.”
Module 3: Quality Gate — Same QA process as Module 4
Module 4: Shopify Content Publisher — Push the updated description
This feedback loop is your secret weapon. It means your clients’ product listings get better every single month, not just on the initial optimization pass. Clients who see continuous improvement rarely cancel.
Check-In: Module 5 Complete
6 checkmarks. The Review Feedback Loop is what turns a one-time optimization into an ongoing service that justifies monthly retainers.
MODULE 6: E-COMMERCE SEO — THE VISIBILITY ENGINE
Overview
Optimized product content only matters if people can find it. This module builds your e-commerce SEO system: product keyword mapping, Google Shopping feed optimization, schema markup implementation, and technical SEO fixes specific to Shopify stores.
Time to complete: 4-6 hours initial setup, 2-3 hours per client per month
Procedure 6.1: Build the Keyword-Product Map
Open Semrush. Use the Keyword Magic Tool with your client’s primary product categories as seed keywords. Apply filters: Volume > 50, KD < 60, Intent = Transactional or Commercial.
Export the keywords. In a Google Sheet, create a “Keyword-Product Map”:
| Keyword | Search Volume | KD | Intent | Target Product Page | Current Position | Priority |
|---|
| buy organic cotton t-shirt | 1,200 | 35 | Transactional | /products/organic-cotton-tee | Not ranking | P1 |
| organic cotton t-shirt men | 890 | 28 | Commercial | /products/organic-cotton-tee | 45 | P1 |
For each keyword, identify the best product page to target it. One product page can target 3-5 related keywords (primary + secondary variations). Map every keyword to a page before you start optimizing.
Most Shopify stores use the Google Channel app to generate their Shopping feed. The default feed is almost always suboptimal.
Log into the client’s Google Merchant Center. Review the feed diagnostics:
Title issues — Product titles in Shopping ads should follow: Brand + Product Name + Key Attribute + Size/Color + Gender. Most Shopify stores just use the product title, which is often too short or missing attributes. Update titles specifically for the feed (you can set feed-specific titles without changing the on-site title).
Category issues — Google requires products to be categorized using their product taxonomy. Miscategorized products get lower impressions. Map each product to the most specific Google product category available.
Missing identifiers — GTIN (barcode), MPN (manufacturer part number), and brand are required for many product categories. Products missing these get disapproved. Work with the client to add these to their product data.
Image quality — Google requires minimum 100x100 pixel images (500x500 recommended). Lifestyle images should not be the main feed image — use clean product-on-white images for the feed.
Procedure 6.3: Product Schema Markup Implementation
Every product page needs Product schema. For Shopify stores, add this to the theme’s product template (main-product.liquid or equivalent):
<script type="application/ld+json">
{
"@context": "https://schema.org",
"@type": "Product",
"name": "{{ product.title | escape }}",
"description": "{{ product.description | strip_html | truncate: 500 | escape }}",
"image": "{{ product.featured_image | image_url: width: 1200 }}",
"brand": {
"@type": "Brand",
"name": "{{ product.vendor | escape }}"
},
"offers": {
"@type": "Offer",
"url": "{{ shop.url }}{{ product.url }}",
"priceCurrency": "{{ shop.currency }}",
"price": "{{ product.selected_or_first_available_variant.price | money_without_currency }}",
"availability": "{% if product.available %}https://schema.org/InStock{% else %}https://schema.org/OutOfStock{% endif %}",
"seller": {
"@type": "Organization",
"name": "{{ shop.name | escape }}"
}
}
{% if product.metafields.reviews.rating.value %}
,"aggregateRating": {
"@type": "AggregateRating",
"ratingValue": "{{ product.metafields.reviews.rating.value }}",
"reviewCount": "{{ product.metafields.reviews.rating_count }}"
}
{% endif %}
}
</script>
Verify with Google’s Rich Results Test tool. Rich snippets (star ratings, prices, availability) increase click-through rates by 20-35%.
Check-In: Module 6 Complete
6 checkmarks. The Keyword-Product Map is your strategic compass — every optimization decision flows from it.
MODULE 7: CONVERSION OPTIMIZATION — THE REVENUE MULTIPLIER
Overview
Traffic without conversion is just expensive bandwidth. This module builds your conversion optimization system: heatmap analysis, A/B testing, and UX improvements that turn visitors into buyers. A 1% improvement in conversion rate on a store doing ₦50M/month in revenue is worth ₦25M/year.
Time to complete: 3-4 hours per audit, ongoing testing
Procedure 7.1: Heatmap Analysis Protocol
Open
Hotjar
and review the latest heatmap data for each client’s top 20 product pages.
Click Maps reveal where users interact:
- Users clicking non-clickable elements → Design fix needed
- Users ignoring the “Add to Cart” button → CTA needs repositioning/contrast
- Users clicking images expecting zoom → Implement image zoom feature
Scroll Maps reveal content visibility:
- Users never scrolling past 50% → Key information is buried too deep
- Users scrolling to bottom but not converting → Missing trust signals near CTA
- Mobile scroll patterns differ from desktop → Mobile-specific layout needed
Move Maps reveal attention patterns:
- High mouse activity on specifications → Users are comparing specs; make them more prominent
- Low activity on descriptions → Descriptions aren’t being read; improve formatting
Document findings in a “Conversion Insights” section of the client’s Notion page. Prioritize by estimated revenue impact.
Procedure 7.2: A/B Testing Framework
For each conversion insight, create a hypothesis and test:
Hypothesis format: “If we [change], then [metric] will [improve] by [amount], because [reason].”
Example: “If we move the ‘Add to Cart’ button above the fold on mobile, then mobile conversion rate will increase by 15%, because heatmap data shows 70% of mobile users never scroll to the current button position.”
Implement using Shopify’s theme editor or a testing app. Measure for 2-4 weeks depending on traffic volume. A valid test needs at least 1,000 visitors per variant to reach statistical significance.
Procedure 7.3: The “Quick Conversion Wins” Checklist
Apply these to every new client in the first week:
- Add trust badges below the Add to Cart button (secure checkout, free shipping, returns policy)
- Show delivery estimates (“Order within 2h 34min for delivery by Thursday”)
- Display social proof near CTA (“247 people bought this in the last 30 days”)
- Add urgency indicators where genuine (“Only 3 left in stock”)
- Implement sticky Add to Cart on mobile (button follows the user as they scroll)
- Add product Q&A section (reduces pre-purchase uncertainty)
These quick wins typically improve conversion by 10-20% within the first month.
HACK: The “Review Snippet” CTA boost. Take the single most persuasive quote from customer reviews and display it prominently near the Add to Cart button. Example: “Best running shoes I’ve ever owned — ran my first marathon in them” — Sarah K. This micro-social-proof technique increases add-to-cart rates by 8-15% because it provides specific, credible validation at the decision point.
Check-In: Module 7 Complete
6 checkmarks. The Quick Conversion Wins are your first-month impact play — they generate visible results that justify your retainer.
MODULE 8: CLIENT ACQUISITION — THE GROWTH ENGINE
Overview
You can have the best optimization system in the world, but if you can’t get clients, you have an expensive hobby. This module gives you three client acquisition methods ranked by conversion rate, plus the scripts, templates, and follow-up sequences that turn prospects into paying clients.
Time to complete: 4-5 hours to build assets, ongoing execution
Procedure 8.1: The Free Store Audit (20-25% conversion rate)
Build your audit delivery system:
- Audit Template — Google Docs template with your branding, containing: Executive Summary, Product Listing Quality Scores, Missing Keywords Report, Competitor Analysis, Google Shopping Feed Issues, Review Intelligence Preview, and 5 Sample Optimized Listings
- Loom Walkthrough — Record a 10-minute video walking through the audit findings. Personalize the first 30 seconds: “Hi [Name], I analyzed [Store Name] and found some things that are costing you revenue…”
- Sample Optimizations — Optimize the prospect’s top 5 products and include the optimized versions in the audit. Give them permission to use these whether they hire you or not.
Send 15-20 audits per month. Each takes 2-3 hours to produce. At a 20% conversion rate, that’s 3-4 new clients per month.
Procedure 8.2: The “Ad Spend Efficiency” Cold Email
Create an
Apollo
saved search: E-commerce managers, Shopify store owners, Heads of Digital at brands with 20-500 employees. Filter for companies spending $5,000+/month on Google Ads.
Email template:
Subject: Your [product category] listings are invisible on Google
Hi [First Name],
I analyzed [Store Name]'s product listings and found that you're ranking for only [X] of the [Y] keywords your top 3 competitors are capturing. That's [Z] potential customers finding your competitors instead of you every month.
Quick numbers:
- Your top 3 competitors rank for [N] keywords you're missing
- Your product descriptions are manufacturer copy (I checked 10 random listings)
- Your Google Shopping feed is missing product categories and identifiers
I put together a free audit showing exactly what's missing and how to fix it. Want me to send it over?
[Your name]
Send 200 emails per week. Expected open rate: 35-45%. Expected reply rate: 8-12%. Expected conversion from reply to call: 40-50%.
Procedure 8.3: Vertical Specialization Playbook
Pick one e-commerce vertical and become the authority:
- Build a vertical-specific landing page on your site: “E-commerce Optimization for [Beauty/Fashion/Home/Fitness] Brands”
- Create 3 vertical-specific case studies (use your development store if you don’t have real clients yet — show the before-and-after with real optimization examples)
- Write vertical-specific content on LinkedIn: “5 Things Every [Beauty] Brand Gets Wrong on Shopify” or “Why [Fitness] Product Listings Fail on Google Shopping”
- Join vertical-specific communities — Facebook groups, Slack communities, and forums where your target vertical hangs out. Answer questions, provide value, and mention your services when relevant.
Within 90 days of consistent vertical content, you’ll be perceived as the specialist. Prospects will come to you.
Check-In: Module 8 Complete
6 checkmarks. The Free Store Audit is your highest-converting acquisition channel — invest the most time here.
MODULE 9: SCALING — FROM SOLO TO TEAM
Overview
At $10,000-15,000/month in revenue, you’ll hit a ceiling as a solo operator. This module gives you the hiring, training, and delegation framework to scale beyond your personal bandwidth without sacrificing quality.
Time to complete: Ongoing
Procedure 9.1: The First Hire — Optimization Specialist
Your first hire should be an Optimization Specialist who handles the human QA, client communication, and manual optimization passes that AI can’t do alone.
Role requirements:
- Strong written English (they’ll be reviewing AI-generated product descriptions)
- E-commerce experience (has managed a Shopify store or worked in e-commerce)
- Detail-oriented (QA is 80% of this role)
- Comfortable with AI tools (ChatGPT, Make.com)
Training program (2 weeks):
- Week 1: Shadow you on 2 active clients. Learn the audit process, prompt system, QA protocol, and client communication style.
- Week 2: Handle QA and client communication for 1 client under your supervision. You review their work daily.
Compensation: ₦150,000-250,000/month (Nigerian market). This is the highest-ROI hire you’ll ever make — it frees you to focus on sales and strategy while they maintain quality across existing clients.
Procedure 9.2: The Capacity Model
| Team Size | Max Clients | Monthly Revenue | Key Constraint |
|---|
| Solo | 5-6 | ₦4.5M-9M | Your personal bandwidth |
| +1 Specialist | 10-12 | ₦9M-18M | QA throughput |
| +2 Specialists | 18-20 | ₦15M-30M | Client acquisition |
| +1 Sales | 25-30 | ₦20M-45M | Operational complexity |
Each specialist can handle 5-6 clients. Add specialists before you feel the pain — waiting until quality slips costs more than hiring early.
Procedure 9.3: SOPs for Delegation
Document every process as an SOP in your Notion SOPs page:
- New Client Onboarding SOP — From signed contract to first audit delivery (16 steps)
- Product Optimization SOP — From audit data to published optimized listings (8 steps)
- Review Intelligence SOP — From weekly review pull to listing update (6 steps)
- Monthly Reporting SOP — From data collection to client report delivery (10 steps)
- QA Protocol SOP — From AI output to approved-for-publishing (4 steps)
Each SOP should be detailed enough that a new hire can follow it without asking you questions. If you find yourself answering the same question twice, the SOP isn’t detailed enough.
Check-In: Module 9 Complete
6 checkmarks. The SOPs are the most critical — without them, delegation becomes “just do what I do” and quality collapses.
MODULE 10: LAUNCH PLAN — YOUR FIRST 90 DAYS
Overview
This is your execution roadmap. No more planning, no more research. Follow this day-by-day plan to launch your agency and land your first paying client.
Procedure 10.1: Days 1-30 — Build and Prepare
Week 1:
- Day 1-2: Complete Module 1 (Foundation)
- Day 3-4: Complete Module 2 (Tech Stack)
- Day 5: Complete Module 3 (Audit System)
Week 2:
- Day 6-7: Complete Module 4 (Content Engine)
- Day 8-9: Complete Module 5 (Review Intelligence)
- Day 10: Complete Module 6 (E-commerce SEO)
Week 3:
- Day 11-12: Complete Module 7 (Conversion Optimization)
- Day 13-14: Complete Module 8 (Client Acquisition assets)
- Day 15: Optimize your development store as a portfolio piece
Week 4:
- Day 16-20: Send 5 free store audits per day to prospects found through Apollo and Semrush
- Day 21-25: Follow up on audit sends, book discovery calls
- Day 26-30: Close first client
Procedure 10.2: Days 31-60 — Execute and Prove
Week 5-6:
- Onboard first client (follow Onboarding SOP)
- Deliver comprehensive audit within 48 hours
- Optimize top 20 products within first week
Week 7-8:
- Complete full catalog optimization for Starter tier client
- Set up Review Intelligence pipeline
- Deliver first monthly report showing before-and-after metrics
- Send 3 more free audits per day to maintain pipeline
Procedure 10.3: Days 61-90 — Scale and Systematize
Week 9-10:
- Close second and third clients
- Begin training first Optimization Specialist (if revenue supports it)
- Refine prompts based on QA feedback from first 30 days
Week 11-12:
- All three clients onboarded and in optimization cycle
- Revenue target: ₦3M-4.5M/month
- Begin vertical specialization content marketing
- Hire Optimization Specialist if at 4+ clients
Procedure 10.4: The Revenue Roadmap
| Month | Clients | Revenue | Team | Focus |
|---|
| 1 | 1 | ₦500K-1M | Solo | Land first client, deliver exceptional results |
| 2 | 2-3 | ₦1.5M-3M | Solo | Systematize delivery, build pipeline |
| 3 | 3-5 | ₦3M-4.5M | Solo | Refine processes, start specialist hiring |
| 4-6 | 5-8 | ₦4.5M-9M | +1 Specialist | Scale delivery capacity |
| 7-12 | 10-15 | ₦9M-18M | +2 Specialists | Vertical authority, inbound leads |
| 12+ | 20+ | ₦15M+ | Team of 5+ | Multiple verticals, premium pricing |
Final Check-In: Launch Readiness
7 checkmarks. If you have all 7, you are ready to launch. If you’re missing any, go back and complete it. The difference between successful agencies and failed ones is execution, not knowledge. You have the knowledge. Now execute.
| Tool | Purpose | Cost | Essential? |
|---|
| Shopify Partner | Store access, API, development stores | Free | Yes |
| Make.com | Automation, workflows, integrations | $0-49/mo | Yes |
| OpenAI API | Content generation, analysis | $20-150/mo | Yes |
| Semrush | SEO research, keyword tracking, audits | $0-139/mo | Yes |
| Google Sheets | Data management, tracking | Free | Yes |
| Notion | Project management, SOPs, client portal | $0-10/mo | Yes |
| Hotjar | Conversion insights, heatmaps | $0-32/mo | Recommended |
| Canva Pro | Product images, marketing materials | $13/mo | Recommended |
| Apollo.io | Client acquisition, prospect data | $0-49/mo | Recommended |
| Paystack | Payment processing (Naira) | 1.5% + ₦100/tx | Yes |
| Cal.com | Client scheduling | Free | Yes |
| Loom | Video walkthroughs, audit delivery | $0-13/mo | Recommended |
APPENDIX B: SOP INDEX
| SOP | Module | Steps | Time per Execution |
|---|
| New Client Onboarding | 9 | 16 | 2-3 hours |
| Product Optimization | 4 | 8 | 15-30 min/product |
| Review Intelligence | 5 | 6 | Automated after setup |
| Monthly Reporting | 8 | 10 | 2-3 hours |
| QA Protocol | 4 | 4 | 3-5 min/product |
| Store Audit Delivery | 8 | 12 | 2-3 hours |
| Competitor Price Monitor | 3 | 5 | Automated after setup |
| SEO Performance Tracking | 6 | 8 | 1-2 hours/month |
APPENDIX C: REVENUE CALCULATOR
Monthly Revenue = Number of Clients × Average Monthly Retainer
Example Scenarios:
| Clients | Starter (₦500K) | Growth (₦1.5M) | Enterprise (₦3.5M) | Total MRR |
|---|
| 3 Starter, 1 Growth | ₦1.5M | ₦1.5M | — | ₦3M |
| 2 Starter, 3 Growth | ₦1M | ₦4.5M | — | ₦5.5M |
| 2 Growth, 1 Enterprise | — | ₦3M | ₦3.5M | ₦6.5M |
| 4 Growth, 2 Enterprise | — | ₦6M | ₦7M | ₦13M |
Expenses at Scale (5+ clients): ₦200K-350K/month (tools + API + specialist salary)
Target Net Margin: 75-85% (before specialist hiring), 60-70% (after first hire)