Automation Routines

1. 1Ingest previous-day Net Revenue from Shopify.
2. 2Pull dynamic Gross Margin totals (True COGS recalculated).
3. 3Pull multi-channel ad spend from Meta Ads Manager + Google Ads.
4. 4Calculate aMER = New Customer Revenue ÷ Total Ad Spend.
5. 5Calculate New Customer Profit Contribution.
6. 6If aMER drops >15% below baseline → pause low-efficiency test variants.
7. 7Flag issue and log to daily P&L register.

1. 1Pull conversion reports using "Conversion Time" not "Click Time" view.
2. 2Apply 3-7 day data lag offset when reviewing yesterday's ad performance.
3. 3Do not pause ads based on same-day data — minimum 72-hour attribution window.
4. 4Compare current 7-day rolling average to previous 14-day baseline.

1. 1Review frequency metrics per cold-targeting ad set.
2. 2If frequency > 2.0 in cold targeting AND ROAS is declining → flag for hook rotation.
3. 3Output creative brief for the flagged ad set.
4. 4Brief must include: top-performing angle, persona, and a list of 3 adjacent hook directions.

1. 1Export full search term report from Google Shopping + PMAX.
2. 2Filter for zero-conversion queries with ≥10 impressions.
3. 3Add poor-intent queries as negatives (job searches, competitor brand terms, irrelevant variants).
4. 4Update Negative Keyword shared lists across all campaigns.
5. 5Document all new negatives added with date and rationale.

1. 1Review all active test ad sets performance.
2. 2PAUSE RULE: If spend ≥ 3–5× Target CPA AND conversions ≤ 1 → pause the asset immediately.
3. 3SCALE RULE: If conversions ≥ 3 AND CPA ≤ Target → copy Post ID to Scaling CBO campaign.
4. 4CRITICAL: Never modify or pause the original winning testing ad set after copying.
5. 5Log all Post IDs moved to scaling with date, CPA at time of move, and ad set source.

1. 1Query Shopify active stock quantities for all hero SKUs.
2. 2If any hero item stock = 0 → immediately pause ALL matching ad creative across channels.
3. 3Pausing on stock-out protects tracking data integrity and prevents learning phase resets.
4. 4Schedule resume alerts for when stock restocks (threshold: >50 units).
5. 5Update inventory lifecycle routing (Grade A / C / D) based on velocity data.

1. 1Audit platform-reported ROAS against actual bank deposits / P&L.
2. 2Run geo-lift experiment OR Causal Impact model on 1 channel.
3. 3Calculate platform multiplier: True ROAS ÷ Platform-Reported ROAS.
4. 4Recalibrate target ROAS thresholds on all campaigns using true multiplier.
5. 5Document results in monthly calibration log for longitudinal tracking.

1. 1Export contribution profit at individual SKU level from Shopify.
2. 2Filter: SKUs with True Gross Margin < break-even threshold.
3. 3Route failing SKUs to break-even liquidation campaigns (isolated from Grade A).
4. 4Review if any failing SKUs can be repositioned before liquidation.
5. 5Update product tier assignments (Grade A / C / D) for next month.

1. 1Identify top 3 highest-performing consumer personas by aMER.
2. 2Identify top 3 highest-performing creative angles by CPA efficiency.
3. 3Export winning ad scripts / copy from top performers.
4. 4Prompt Design Agent with winning scripts + adjacent angle brief.
5. 5Output target: 20 new creative asset concepts for next production run.
6. 6Assign concept briefs to each of the 4 avatars proportionally by performance data.