7 Claude Scheduled Tasks That Replace Your 3-Hour D2C Morning Routine (Full Setup Guide With Prompts)

Key Takeaways

• 7 Claude scheduled tasks automate the entire D2C morning routine: revenue snapshots, out-of-stock ad alerts, creative fatigue scans, review pattern detection, competitor watching, PDP conversion alerts, and customer feedback to ad angles.

• Before: 3 hours every morning reading 7 dashboards. After: 15 minutes reviewing one consolidated briefing from Claude. The rest of the morning is actually yours again.

• Two data connection options: CSV exports from Shopify, Meta Ads, and review platforms (no setup, manual) or live MCP connectors (automated, one-time setup). Both work. Start with CSV and upgrade later.

• All 7 task prompts are included, copy-paste ready. No coding, no API keys. Just a Claude Pro subscription ($20/month) and 30 minutes to set up.

• The out-of-stock x active ads alert alone has saved over $1,400 in wasted spend by catching ads driving traffic to sold-out products before the weekly audit.

Introduction

Every D2C operator has the same morning routine: open Shopify to check yesterday's revenue, open Ads Manager to check which ads are dying, open Gorgias to triage overnight tickets, check reviews, check stock levels, check competitors, and try to actually start the day by 11 AM. Three hours. Every morning. Before any real work happens.

Claude scheduled tasks kill this routine. Seven tasks run automatically on their own cadences and compile into one consolidated morning briefing. You spend 15 minutes reviewing it instead of 3 hours assembling it yourself.

This guide gives you everything: what each task does, how to set it up from scratch assuming you have nothing, the exact prompts to copy-paste, and two data connection methods. No coding. No API keys. Just Claude Pro and 30 minutes.

What Will You Build?

Seven scheduled tasks covering the full D2C morning checklist:

• Revenue + Margin Snapshot (daily 7 AM) — yesterday's orders, AOV, refund rate, net revenue vs 7-day average

• Out-of-Stock x Active Ads Alert (every 4 hours) — flags ads driving traffic to sold-out products. This task alone has saved over $1,400 in wasted spend.

• Creative Fatigue Scan (daily 8 AM) — tags every active ad as healthy, warning, or critical based on CTR decay, frequency creep, and CPC inflation

• Review + Ticket Pattern Detector (daily 8 AM) — catches when 3+ customers complain about the same issue, detecting product problems 2 weeks earlier than manual review

• Competitor Ad + Content Watch (daily 7 AM) — surfaces new competitor Meta ads, TikToks, hooks, formats, and angles before they scale

• PDP Conversion Drop Alert (daily 9 AM) — finds product pages with traffic but conversion rate 20%+ below site average. That is a PDP problem, not a traffic problem.

• Customer Feedback to Ad Angles (weekly Monday) — takes the week's reviews and ticket themes and generates 5 new ad angles based on actual customer language

Plus an 8th task that compiles all outputs into one consolidated morning briefing you can read in 15 minutes.

What Do You Need Before Starting?

Claude Pro ($20/month) at claude.ai — the free plan does not support scheduled tasks. Claude Desktop app from claude.ai/download — required for local tasks that read CSV files from your computer. Also works through the web at claude.ai/code/scheduled for cloud tasks.

For data, you have two options per tool. Option A (CSV Exports): export data from Shopify, Meta Ads, reviews, and support tools as CSV files. Save them to a consistent folder. No third-party connections. You just export fresh CSVs regularly. Option B (MCP Connectors): connect Claude directly to your tools for live data. One-time setup per tool. Recommended connectors: Adspirer, Pipeboard, or Adzviser for Meta Ads. Check claude.ai > Settings > Integrations for Shopify and other connectors.

Do not let the full list overwhelm you. Start with just 3 tasks (competitor watch, creative fatigue, and revenue snapshot). Add the rest once you are comfortable.

How Do You Set Up Your Data Sources?

CSV Route (no setup needed):

Create a folder structure on your computer: d2c-dashboard/shopify, d2c-dashboard/meta-ads, d2c-dashboard/reviews, d2c-dashboard/support-tickets, and d2c-dashboard/analytics. Export CSVs from each tool: Shopify Admin > Orders > Export for revenue data, Shopify Admin > Products > Export for inventory, Meta Ads Manager > Reports > Export for ad performance, your review platform's export for reviews, and Gorgias or your support tool's export for tickets. Save each to the matching folder. Export fresh CSVs each evening.

MCP Connector Route (automated):

For Meta Ads: go to claude.ai > Settings > Integrations > Add Integration. Paste the connector URL (Adspirer: https://mcp.adspirer.com/mcp, Pipeboard: https://meta-ads.mcp.pipeboard.co/, or Adzviser: https://mcp.adzviser.com/http). Authenticate with Meta. Takes 2-5 minutes. For Shopify: check Claude's integrations for available Shopify connectors, or use the CSV route. For reviews and support: most platforms do not have MCP connectors yet, so use CSV exports.

How Do You Create Scheduled Tasks?

Web interface (cloud tasks): Go to claude.ai/code/scheduled. Click New scheduled task. Enter the task name, paste the prompt from the sections below, set the schedule, ensure your MCP connectors are included. Click Create, then Run Now to test.

Claude Desktop (local tasks with CSV): Open the Claude Desktop app. Click Schedule in the sidebar. Click New task > New local task. Enter name, prompt, and schedule. Save and test with Run Now.

Use cloud tasks if you have MCP connectors (runs 24/7, computer can be off). Use desktop local tasks if reading CSV files (requires computer on and app open). Task 5 (competitor watch) is always a cloud task since it only needs web search.

What Are the 7 Task Prompts?

All 7 prompts below are copy-paste ready. Each includes a CSV instruction at the top — remove it if you are using MCP connectors instead.

Task 1: Revenue + Margin Snapshot — Daily at 7:00 AM

Prompt:

Analyze yesterday's Shopify revenue and order data. [IF USING CSV: Read the most recent CSV file from ~/Documents/d2c-dashboard/shopify/. Use the orders export as the data source.] Calculate and report: Revenue Summary — total gross revenue yesterday, total net revenue (after refunds and discounts), number of orders, average order value (AOV), refund rate (refunds divided by total orders as percentage), discount usage rate (orders with discount code divided by total orders). Comparison to 7-Day Average — for each metric, compare yesterday's value to the 7-day rolling average. Flag any metric that is more than 20% above or below the average with a clear warning. Top Products Yesterday — top 5 products by units sold, top 5 by revenue, any product that had zero orders yesterday but had orders every other day this week. Red Flags — refund rate above 5%, AOV dropped more than 15%, revenue dropped more than 20% vs 7-day average, any single product responsible for more than 30% of refunds. Format as a clean executive summary I can read in 2 minutes. Lead with red flags if any exist. End with a one-line business health assessment: Healthy, Watch, or Alert.

Task 2: Out-of-Stock x Active Ads Alert — Every 4 Hours

Prompt:

Cross-reference my current inventory levels with my active Meta ad campaigns to find ads driving traffic to out-of-stock products. [IF USING CSV: Read the most recent inventory CSV from ~/Documents/d2c-dashboard/shopify/ and the most recent ads CSV from ~/Documents/d2c-dashboard/meta-ads/.] Step 1: Identify all SKUs/products with zero inventory or marked as out-of-stock. Step 2: Identify all active Meta ad sets and the products/URLs they are driving traffic to. Check the ad destination URLs and ad names for product identifiers. Step 3: Cross-reference. Flag any active ad set that is sending traffic to an out-of-stock product. For each flagged ad set, report: ad set name and campaign name, the out-of-stock product it promotes, current daily budget of the ad set, estimated daily wasted spend, how long the product has been out of stock. Urgency rating: CRITICAL if spending more than $20/day on OOS product (pause immediately), WARNING if $5-20/day (pause or redirect), WATCH if under $5/day (monitor). End with total estimated daily wasted spend across all flagged ad sets. If no conflicts found, report All clear.

Task 3: Creative Fatigue Scan — Daily at 8:00 AM

Prompt:

Analyze all my active Meta ads for creative fatigue signals. [IF USING CSV: Read the most recent CSV from ~/Documents/d2c-dashboard/meta-ads/. Use the last 14 days of data.] For each active ad, evaluate: Frequency creep — current frequency vs 7-day average, flag if above 2.5. CTR decay — compare this week's CTR to the previous week, flag if declined more than 10%. CPC inflation — compare this week's CPC to the 7-day average, flag if increased more than 15%. Days active — how long the ad has been running without a refresh. Tag each ad: Healthy (frequency below 2.5, CTR stable or rising, CPC stable), Warning (frequency 2.5-4 OR CTR declined 10-20% OR CPC up 15-25% OR running 14+ days with flat performance), Critical (frequency above 4 OR CTR declined more than 20% OR CPC up more than 25% OR running 21+ days with declining performance). Output a table sorted by severity (Critical first): Ad Name, Campaign, Status, Frequency, CTR Trend, CPC Trend, Days Active, Action. For each Warning and Critical ad, recommend: pause, refresh creative, narrow audience, or reallocate budget. Summary: X healthy, Y warning, Z critical. Total daily budget at risk from warning + critical ads.

Task 4: Review + Ticket Pattern Detector — Daily at 8:00 AM

Prompt:

Analyze overnight customer reviews and support tickets to detect emerging patterns and product issues. [IF USING CSV: Read the most recent files from ~/Documents/d2c-dashboard/reviews/ and ~/Documents/d2c-dashboard/support-tickets/. Focus on the last 48 hours of data.] Review Analysis (last 48 hours): total new reviews and average star rating, breakdown by rating, for every 1-3 star review extract the core complaint in 5-10 words, group complaints by theme (shipping, product quality, sizing, packaging, taste/smell, effectiveness, missing items, wrong item). Support Ticket Analysis (last 48 hours): total new tickets, breakdown by category, for each ticket extract the core issue in 5-10 words, group by theme. Pattern Detection: FLAG any issue theme mentioned by 3 or more customers in the last 48 hours (potential product problem). FLAG any single product receiving 2+ negative reviews in 48 hours (quality alert). FLAG any new issue that did not appear in the previous week (emerging problem). For each flagged pattern: describe the issue, list the specific reviews/tickets that triggered it, rate severity (Low, Medium, High), suggest an immediate action. Positive Patterns: any product receiving 3+ five-star reviews in 48 hours (testimonial opportunity), common praise themes for ad copy. If no concerning patterns found, report no emerging issues detected.

Task 5: Competitor Ad + Content Watch — Daily at 7:00 AM

Prompt:

Research the current Meta advertising and social media activity for these competitors: Competitor 1: [NAME] — website: [URL], Meta page: [PAGE NAME], TikTok: [@handle], Instagram: [@handle]. Competitor 2: [NAME] — same details. Competitor 3: [NAME] — same details. Meta Ad Activity: for each competitor, search the Meta Ad Library and web for estimated number of active ads, any new ads launched in the last 7 days, new hooks or angles they are testing, ad formats (video, static, carousel, UGC), any new offers or promotions. Social Content Activity: new TikToks or Reels posted in the last 7 days, new content themes or formats, any viral content, trending sounds or hooks. Competitive Intelligence Summary: what new angles are competitors testing that we are not, what formats are they doubling down on, any new products or collections being promoted, any pricing or offer changes, two specific ideas I should consider testing. Keep the entire report under 500 words. Lead with the most important finding. IMPORTANT: replace the bracketed competitor details with your actual competitors before using this prompt.

Task 6: PDP Conversion Drop Alert — Daily at 9:00 AM

Prompt:

Analyze product page (PDP) performance to find pages with traffic but below-average conversion rates. [IF USING CSV: Read the most recent analytics CSV from ~/Documents/d2c-dashboard/analytics/ and the Shopify orders CSV from ~/Documents/d2c-dashboard/shopify/.] Step 1: Calculate the site-wide average conversion rate for the last 7 days (total orders divided by total sessions). Step 2: For each product page that received at least 50 sessions yesterday, calculate its individual conversion rate. Step 3: Flag any product page where yesterday's conversion rate is 20% or more below the site-wide average. For each flagged page report: product name and URL, yesterday's sessions, yesterday's conversion rate vs site average, conversion rate trend over the last 7 days, revenue impact estimate ((site average CR minus page CR) times sessions times AOV). Diagnosis suggestions: price issue, content issue, review issue, stock issue, or technical issue. Rank flagged pages by estimated lost revenue (highest first). End with total flagged pages, total estimated daily lost revenue, and top priority fix.

Task 7: Customer Feedback to Ad Angles — Weekly, Monday at 9:00 AM

Prompt:

Analyze this week's customer feedback and generate 5 new ad angles based on actual customer language. [IF USING CSV: Read the most recent files from ~/Documents/d2c-dashboard/reviews/ and ~/Documents/d2c-dashboard/support-tickets/. Focus on the last 7 days.] Step 1 — Extract Customer Voice: from all reviews and tickets this week, identify the exact words customers use to describe their problems BEFORE using the product, the exact words for results AFTER, specific objections or hesitations, unexpected use cases or benefits, and emotional language. Step 2 — Identify the 5 Strongest Themes: group feedback into themes, rank by frequency and emotional intensity, select the top 5. Step 3 — Generate Ad Angles: for each theme, create one ad angle with: angle name, hook headline under 40 characters using actual customer words (put exact phrases in quotes), primary text of 2-3 sentences under 125 characters for the first line, emotional driver (fear, relief, aspiration, validation, curiosity), source quote (the actual review that inspired this angle with name removed), and why this works (one sentence). Step 4 — Creative Direction: for each angle suggest best ad format, visual direction, and target audience. End with: these 5 angles are based on X reviews and Y tickets from the past week. Top recommendation to test first: [angle name] because [reason].

How Do You Consolidate Into One Morning Briefing?

Create an 8th task — the Morning Briefing Compiler — scheduled for 9:30 AM daily (after all other morning tasks complete). This task reviews all outputs from the day's tasks and compiles them into a single brief under 400 words.

The briefing format: Red Flags (act on today) at the top, then Revenue Health (2-3 lines), Ad Performance (fatigue summary + OOS conflicts), Customer Signals (review/ticket patterns), Competitive Intel (top findings), Conversion Opportunities (flagged PDPs), and Today's Top 3 Priorities ranked by impact.

This single briefing replaces opening 7 dashboards. Read it with your coffee. Act on the red flags. Start your real work by 7:30 AM instead of 11.

Where Should You Start?

Do not set up all 7 at once. Follow this 4-week rollout:

Week 1: Set up 3 tasks. Task 5 (Competitor Watch) takes 5 minutes — cloud task, no data connection, just web search. Task 3 (Creative Fatigue) takes 10 minutes — one Meta Ads CSV export or MCP connector. Task 1 (Revenue Snapshot) takes 10 minutes — one Shopify CSV export. Test each with Run Now immediately after creating.

Week 2: Add Task 2 (OOS x Ads Alert) and Task 4 (Review + Ticket Patterns). Week 3: Add Task 6 (PDP Conversion) and Task 7 (Feedback to Angles). Week 4: Add Task 8 (Morning Briefing Compiler) to consolidate everything into one report.

How Do You Customize the Thresholds?

The prompts use default thresholds that work for most D2C brands. Adjust for your business: Revenue snapshot flags a 20% drop — lower to 15% for low-volume stores, raise to 25% for high-volume stores with natural fluctuations. Refund rate flags above 5% — lower to 3% for high-ticket items, raise to 8% for impulse purchases.

Creative fatigue uses frequency 2.5 as warning and 4 as critical. If your ads naturally run longer (evergreen products), raise these. CPC inflation flags at 15% warning and 25% critical. PDP conversion flags at 20% below site average — raise to 30% if you have highly diverse product types.

Run each task for a full week before adjusting. If it flags too many things, loosen the thresholds. If it misses issues you catch manually, tighten them.

What Does This Cost?

Claude Pro: $20/month. MCP connector for Meta Ads (optional): $0-49/month. All CSV exports: free. Total with CSV route: $20/month. Total with paid Meta connector: $69/month.

This replaces 3 hours per morning x 20 working days = 60 hours per month of manual dashboard checking. At any hourly rate, the ROI is immediate. The OOS x Active Ads alert alone saved $1,400+ in one month of wasted ad spend.

Frequently Asked Questions

Do I need to know how to code?

No. Everything uses copy-paste prompts and point-and-click setup. The most technical step is creating folders on your computer and exporting CSVs.

Does my computer need to be on?

For cloud tasks with MCP connectors, no — they run on Anthropic's servers 24/7. For desktop local tasks reading CSV files, yes — your computer and Claude Desktop app must be on.

What if I do not use Shopify?

The prompts work with any e-commerce platform that exports orders as CSV: WooCommerce, BigCommerce, or even a manual spreadsheet. Replace the Shopify-specific language with your platform.

What if I do not use Gorgias?

Replace Gorgias with whatever you use: Zendesk, Freshdesk, Intercom, or a shared email inbox. Export tickets as CSV. The pattern detection prompt works with any ticket data.

How long before I trust the system?

Run everything in parallel with your manual routine for 1 week. Compare Claude's outputs to what you find yourself. Most founders fully rely on the system by week 2.

Can I run this for multiple stores?

Yes. Create separate tasks for each store with separate data folders. Or modify prompts to analyze multiple stores and compare.

Can I add custom tasks?

Absolutely. Common additions: daily social media engagement summary, weekly email marketing report, supplier lead time tracker, influencer content monitoring, and return rate analysis by product.