DTC Brand Founders

Pull yesterday's Shopify revenue, AOV, and conversion rate, compare them against last week and last month, and flag any metric that's moved more than 10% — give me a one-paragraph diagnosis I can share in the team Slack.

Find every customer who bought in the last 90 days but hasn't opened a single Klaviyo email since — build a win-back segment and draft a subject-line-plus-preview-text for a re-engagement campaign.

Calculate LTV by acquisition cohort for the last 12 months — pull order data from Shopify, group by first-purchase month, and show me average orders per customer, AOV over time, and cumulative revenue per cohort.

Identify our top 5 SKUs by return rate in Shopify, pull the return reason tags, and draft a product-page update for each that addresses the top complaint directly — so we stop losing that conversion quietly.

Build a 60-day inventory forecast for all active SKUs — use the last 90 days of Shopify velocity, apply our expected paid traffic increase from the Google Sheets media plan, and flag which SKUs will stock out first.

Scan our Brex transactions for the last 30 days, break out paid media spend by platform, compare to our CAC targets in Google Sheets, and flag any channel where CAC is more than 20% over target.

Draft a quarterly investor update — pull net revenue and MRR from Stripe, top-line Shopify metrics (orders, AOV, return rate), and cash position from Brex, then write it as a clean three-paragraph email in our brand voice.

Find every customer who left a review mentioning fit or sizing in Shopify or Gmail, compile the common themes, and draft a sizing-guide copy update plus a product-description note we can add to the top three affected SKUs.