Workflows · Track and forecast · Opening soon
Tracking and forecasting workflows
The number you report every month, rebuilt from the latest export, plus the forecast that follows from it. Each one rebuilds its result every time your data refreshes.
Team
Data in
138 workflows
- Customer lifetime value by cohortWork out customer lifetime value by signup month cohort from Shopify customers and orders exports, with revenue per customer and average order count.See the workflow Built by the agent
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template
- Customer segmentation by revenueSegment Stripe customers into revenue tiers from exported customer, charge, and threshold files, then count customers and revenue in each tier.See the workflow Built by the agent
- Market basket analysisEvery pair of products bought together, with support, confidence and liftSee the workflow Template
- Customer acquisition cost by channelCalculate customer acquisition cost by channel each month from HubSpot exports, with CAC rounded to whole dollars and a simple status.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- ARPU by monthCalculate average revenue per user each month from Stripe invoices and active customers.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent
- Net revenue retentionNet and gross revenue retention for every monthSee the workflow Template
- Funnel analysisHow many people reach each step of your funnel, in order, and where they drop offSee the workflow Template
- ROAS by campaignCalculate ROAS by campaign from Google Ads and Shopify exports, matched by week and utm campaign.See the workflow Built by the agent
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- Demand forecast by SKUForecast next month’s demand for each SKU from your Shopify order line export using recent monthly averages and trend.See the workflow Built by the agent
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the workflow Template
- Content auditEvery page's clicks now and before, and a keep, update or prune callSee the workflow Template
- ABC analysisRank Shopify SKU revenue into A, B, and C tiers from an export, using yearly revenue and an 80/15 split.See the workflow Built by the agent
- Dead stock reportList SKUs with stock on hand, no sales in 90 days, and tied-up inventory value from Shopify product and order exports.See the workflow Built by the agent
- Keyword rankings changeCompare this month's average position with last month from Search Console and see which keywords moved up or down in a keyword ranking report.See the workflow Built by the agent
- Sell-through rateEach product's units received, units sold, what is left and its sell-through rateSee the workflow Template
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- Repeat purchase rateEach month's new customers and the share who ordered again within 90 daysSee the workflow Template
- Cycle count varianceCompare cycle count results to inventory balances by item and location, and calculate unit and value variance.See the workflow Built by the agent
- Sales forecast from pipelineBuild a quarterly sales forecast from exported deals, with won deals counted in full and open deals weighted by stage probability.See the workflow Built by the agent
- Flux analysisEvery account's last month against the month before, with moves over your limits flaggedSee the workflow Template
- Safety stock by SKUCalculate safety stock and reorder point for each SKU from Shopify exports and supplier lead times.See the workflow Built by the agent
- Budget vs actualBudget, actual and variance for every account and monthSee the workflow Template
- Marketing ROI by campaignCalculate marketing ROI for each campaign from HubSpot exports, using won deal revenue and campaign spend.See the workflow Built by the agent
- Chronic absenteeism reportList students who missed 10% or more of the school days they were enrolled, grouped by grade, from a PowerSchool attendance export.See the workflow Built by the agent
- First pass yield by lineCalculate first pass yield for each production line and week from an Excel export of your production log.See the workflow Built by the agent
- Loss run summary by policy yearSummarize loss runs by policy year and coverage from an Excel export, including claim count, paid, reserved, incurred losses, and loss ratio.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Standards-based grading reportTurn a PowerSchool gradebook export into a standards based report with each student's latest level per standard and unmet standards.See the workflow Built by the agent
- Average order value by channelCalculate average order value by sales channel and month from your exported Shopify orders, using paid orders only.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent
- Churn rateEach month: customers at the start, how many were lost, and the churn rateSee the workflow Template
- Price-volume-mix analysisThe change in revenue for each product, split into price, volume and mixSee the workflow Template
- Cash flow forecast from AR and APBuild a 13-week cash flow forecast from QuickBooks exports, starting from today’s bank balance and grouped by due date.See the workflow Built by the agent
- Stockout reportList the SKUs that ran out of stock in the last 30 days, how long they were out, and the sales you likely missed.See the workflow Built by the agent
- Customer churn analysisAnalyze customer churn by month from a Stripe subscriptions export, with starting customers, customers lost, churn rate, and MRR lost.See the workflow Built by the agent
- Gross revenue retentionCalculate gross revenue retention by month from Stripe subscription MRR, counting churn and downgrades but not expansion.See the workflow Built by the agent
- Hotel occupancy and ADRCalculate occupancy rate, ADR and RevPAR by property and month from exported Excel reservations and property lists.See the workflow Built by the agent
- Inventory shrinkage by locationCompare expected stock to counted stock by store from Lightspeed exports, then show shrinkage units, value, and rate.See the workflow Built by the agent
- Restaurant sales by menu itemRank Toast menu items by quantity sold and gross profit, then label stars, plowhorses, puzzles, and dogs.See the workflow Built by the agent
- Survey results analysisSummarize Typeform survey responses by question and respondent segment, with score averages and response counts.See the workflow Built by the agent
- Time to first valueMeasure how many days new accounts take to reach their first key action, grouped by signup week, from a Mixpanel events export.See the workflow Built by the agent
- Working capital by monthCalculate monthly working capital from a QuickBooks balance sheet, with month-over-month change and status labels.See the workflow Built by the agent
- Month-end close checklist statusShow a month-end close checklist by owner, with done, late, and open tasks based on completed date and due day.See the workflow Built by the agent
- Search Console keyword reportSee Search Console keywords on page 2, ranked by impressions and grouped by page.See the workflow Built by the agent
- Training completionUse your Excel export to track training completion by department and course, with assigned, completed, overdue, and a 1 decimal completion rate.See the workflow Built by the agent
- Cost per lead by channelCalculate cost per lead by channel each month from HubSpot exports for ad spend, new leads, and source mapping.See the workflow Built by the agent
- Landing page conversion ratesCalculate landing page conversion rate by week from a Google Analytics export, using conversions divided by sessions.See the workflow Built by the agent
- Annual recurring revenue by customerCalculate annual recurring revenue by customer from Stripe exports, using active subscriptions and monthly prices times 12.See the workflow Built by the agent
- Content performance by authorRank blog authors by page views, average engagement time and conversions from Google Analytics exports.See the workflow Built by the agent
- Inventory valuation reportValue inventory on hand by item and warehouse at average cost, then total it by category from your NetSuite export.See the workflow Built by the agent
- Shopify sales by productBuild weekly Shopify sales by product from orders and refunds exports. See gross sales, discounts, refunds, net sales, and status by SKU.See the workflow Built by the agent
- Time to hire by roleCalculate time to hire by role and department from Greenhouse exports, using application dates and accepted offers.See the workflow Built by the agent
- Cart abandonment rateCalculate cart abandonment rate from a Shopify analytics export by day and device, using checkouts started and orders completed.See the workflow Built by the agent
- Economic nexus by stateTotal sales and orders by state over the last 12 months, compare them to nexus thresholds, and flag each state from a Shopify export.See the workflow Built by the agent
- Email campaign performanceCompare Mailchimp campaign exports by open rate, click rate, unsubscribe rate, and revenue in one email marketing report.See the workflow Built by the agent
- Customer health scoreScore customers on logins, open support tickets, and days to renewal from HubSpot exports, then list the ones at risk.See the workflow Built by the agent
- Feature adoptionCompare feature adoption this month and last month from a Mixpanel export. See which features held, dropped, or shifted.See the workflow Built by the agent
- Involuntary churn and failed payment recoveryTrack failed subscription payments, retries, and churn from Stripe exports, with invoice and subscription status for this month.See the workflow Built by the agent
- Product return rateCalculate return rate by product and reason from Shopify exports, using closed returns only.See the workflow Built by the agent
- MRR movementEach month's recurring revenue: start, new, expansion, contraction, churned, endSee the workflow Template
- Grant spending trackerTrack grant spending by category from QuickBooks exports, include bills and expenses, and see what is left to spend.See the workflow Built by the agent
- Pipeline coverageCalculate pipeline coverage per rep from Salesforce Opportunities and Quarterly Quotas exports.See the workflow Built by the agent
- Pipeline velocityExport HubSpot deals and review pipeline velocity by month using your chosen rule for open deals, win rate, deal size and cycle days.See the workflow Built by the agent
- Recruiting funnel by sourceShow the recruiting funnel by source from Greenhouse exports, with applied, screened, interviewed, offered, and hired counts and conversion rates.See the workflow Built by the agent
- Retention curve by signup weekBuild a retention curve by signup week from Mixpanel exports. Calculate weekly active share by signup cohort.See the workflow Built by the agent
- Absenteeism rateCalculate absenteeism rate by department and month from a BambooHR export of absence days and scheduled workdays.See the workflow Built by the agent
- Expansion and contraction MRRBreak down MRR change from a Chargebee export into new, expansion, contraction, and churned MRR by month and customer.See the workflow Built by the agent
- First response time by agentCalculate weekly median first response time by agent and priority from your Zendesk ticket export.See the workflow Built by the agent
- Sales cycle lengthMeasure sales cycle length from your HubSpot deals export by rep and source, using closed-won deals from the last 6 months.See the workflow Built by the agent
- Shopify inventory reportBuild a Shopify inventory report with on hand, last 4 weeks of sales, and weeks of cover for each product and location.See the workflow Built by the agent
- Warehouse pick rateCalculate pick rate per picker per hour by day from ShipBob pick logs.See the workflow Built by the agent
- Activation rateCalculate activation rate by signup week from Mixpanel exports, using signup week, activation events, and a 7 day window.See the workflow Built by the agent
- Amazon sales by ASINSummarize your Amazon sales report by ASIN and month, with units, revenue, refunds and fees from an export file.See the workflow Built by the agent
- Clinic patient no-show rateCalculate clinic no show rate by provider from an Excel export, for the last 8 weeks, with a status column based on a 20% threshold.See the workflow Built by the agent
- Commission statements by repCreate a monthly commission statement for each rep from Salesforce exports, with deals closed, commission rate, and commission earned.See the workflow Built by the agent
- Lead response timeCalculate lead response time from exported HubSpot contacts, grouped by rep and lead source.See the workflow Built by the agent
- Repeat customer rateUse your Shopify orders export to count monthly customers, repeat customers, and repeat customer rate by month.See the workflow Built by the agent
- Sales pipeline reportBuild a weekly sales pipeline report from Salesforce exports, grouped by rep and stage, with stage changes and past-due deals.See the workflow Built by the agent
- Sales tax by stateCreate a sales tax report from your Shopify orders by state and month, with taxable sales, tax collected, and undercollection flags.See the workflow Built by the agent
- School attendance reportTurn a Google Sheets export into an attendance report by student and class, with students under 90% flagged.See the workflow Built by the agent
- App store reviews by ratingSummarize exported App Store Connect reviews by rating, app version and month, with average rating.See the workflow Built by the agent
- Claim denial rate by payerShow claim denial rate by payer and denial reason from an Excel remittance export, with denied dollars and a simple status flag.See the workflow Built by the agent
- Contribution margin by productCalculate contribution margin by product from QuickBooks exports, using revenue and variable costs to get margin and margin percentage.See the workflow Built by the agent
- Driver settlement reportWork out each driver's weekly settlement from Excel exports, using loads, drivers, and deductions to get net pay and status.See the workflow Built by the agent
- Effective labor rateCalculate effective labor rate by service advisor and technician from a Tekmetric repair orders export.See the workflow Built by the agent
- Expense allocation by departmentAllocate rent and software by department, using month-end headcount from QuickBooks exports and monthly expense totals.See the workflow Built by the agent
- Headcount reportBuild a monthly headcount report from a BambooHR employees export, grouped by department and location, with hires and leavers.See the workflow Built by the agent
- Labor burden rateCalculate each employee's labor burden rate from Gusto exports, with payroll taxes, benefits, workers comp, and burdened hourly cost.See the workflow Built by the agent
- Law firm realization rateCalculate realization rate by attorney and matter from Clio exports, comparing standard value, billed fees, and collected payments.See the workflow Built by the agent
- Machine downtime reportBuild a month to date machine downtime report from Excel exports, grouped by machine and reason, with planned production time lost.See the workflow Built by the agent
- Meta ads performance by ad setCompare Meta ad sets by spend, CPM, click-through rate, cost per purchase, and ROAS from an exported ads file.See the workflow Built by the agent
- Net collection rateCalculate net collection rate by payer and month from an Excel claims export, using payments, charges, and contractual adjustments.See the workflow Built by the agent
- Stripe failed payments, weeklyList failed Stripe payments each week, with decline reason and whether the customer paid later.See the workflow Built by the agent
- TikTok ads performanceExport TikTok Ads and compare campaign performance by week, including spend, cost per click, conversions, and cost per conversion.See the workflow Built by the agent
- Volunteer hours reportTurn your Excel sign-in sheet into a quarterly volunteer hours report by program, with hours and value at 30 dollars an hour.See the workflow Built by the agent
- Sales activity report by repCount calls, emails and meetings by sales rep and week from a Salesforce activity export.See the workflow Built by the agent
- Days of supply by SKUCalculate days of supply for each SKU from Shopify products and orders exports using stock on hand and average daily sales.See the workflow Built by the agent
- Refund rate by productCalculate refund rate by product from Shopify orders and refunds exports for the last 90 days, sorted highest first.See the workflow Built by the agent
- Win rate by rep and sourceCalculate win rate from a Salesforce opportunities export by rep and lead source for the last two quarters.See the workflow Built by the agent
- Supplier lead time analysisCalculate average and worst lead time by supplier from NetSuite purchase orders and item receipts.See the workflow Built by the agent
- Territory performanceCompare sales territories by revenue, deals won, and win rate against target this quarter from Salesforce exports.See the workflow Built by the agent
- Backorder reportCreate a backorder report from a NetSuite sales order export. Group orders by item and customer, with quantity backordered and days waiting.See the workflow Built by the agent
- Month over month growthCalculate month over month revenue growth by product line from Stripe exports, using paid invoices and line items by invoice created date.See the workflow Built by the agent
- Shopify customer cohortsGroup Shopify customers by first order month and show how many order again in each of the next 12 months.See the workflow Built by the agent
- 1099 vendor payments reportSee what you paid each contractor this year and flag the ones over $600 who need a 1099 and are missing a tax ID, from QuickBooks exports.See the workflow Built by the agent
- CSAT by agentBuild a CSAT report from Zendesk solved tickets, grouped by support agent and month.See the workflow Built by the agent
- Stripe MRR by planShow MRR by plan each month from your Stripe subscriptions export, with customer counts and row checks.See the workflow Built by the agent
- Year-over-year growth by product lineCompare each month this year to the same month last year, with growth % and a status for product line sales exported from QuickBooks.See the workflow Built by the agent
- Gross margin by productWork out gross margin by product from Shopify exports. Use order and product files to calculate net sales, cost, and margin percent.See the workflow Built by the agent
- Overtime reportBuild an overtime report from Gusto timesheets, employees, and departments. Show hours, pay, and a status for each employee and pay period.See the workflow Built by the agent
- UTM campaign reportGroup sessions and conversions by utm source, medium, and campaign from a Google Analytics export.See the workflow Built by the agent
- Ad spend pacing against budgetCompare month to date Google Ads spend to monthly budget by campaign and project month end spend.See the workflow Built by the agent
- Webinar attendance to pipelineTurn your webinar report export into a list of registrants, attendees, and deals created after each webinar.See the workflow Built by the agent
- Discount analysis by repExport Salesforce opportunities and line items, then compare average discount percent by sales rep and product on closed won deals.See the workflow Built by the agent
- Donor retention rateCalculate donor retention rate by year from a Bloomerang donations export, using prior-year donors and next-year returns.See the workflow Built by the agent
- Income statement by departmentBuild a departmental income statement from a QuickBooks general ledger export with department classes.See the workflow Built by the agent
- Payroll variance month over monthCompare this month’s payroll to last month by employee, and see the pay change and what drove it from your Gusto payroll register export.See the workflow Built by the agent
- Price increase impact by customerSee the revenue impact of a price increase by customer from Stripe exports, with old price, new price, and the change.See the workflow Built by the agent
- BambooHR headcount by departmentBuild a monthly headcount by department report from your BambooHR employee export, with joiners and leavers for every available month.See the workflow Built by the agent
- Best sellers by monthBuild a best selling products report from your Shopify Orders export. Rank the top products by units and revenue each month.See the workflow Built by the agent
- Bundle analysisFind which products are most often bought together in Shopify orders, then list the product pairs that appear in at least 2 orders.See the workflow Built by the agent
- Chargebee MRR movementCheck Chargebee monthly MRR movement by customer and subscription, including new, expansion, contraction, churn, and reactivation.See the workflow Built by the agent
- Collections forecast from ARForecast the next 8 weeks of cash collections from QuickBooks open invoices and customer days late data.See the workflow Built by the agent
- Discount code performanceCompare discount codes by orders, revenue, discount given and average order value from a Shopify orders export.See the workflow Built by the agent
- HubSpot leads by source, monthlyTrack new leads per month by original source and count customers from a HubSpot contacts export.See the workflow Built by the agent
- Landed cost by SKUAllocate freight, duty, and fees from Shopify exports by SKU value, and see landed cost per unit with clear status flags.See the workflow Built by the agent
- Operating expenses trendTrack operating expenses by category for the last 12 months, with a month by month trend from your QuickBooks exports.See the workflow Built by the agent
- Recurly churn by cohortSee churn by signup month cohort from exported Recurly subscriptions, with active counts after 1, 3, 6 and 12 months.See the workflow Built by the agent
- Shopify discount codes reportBuild a Shopify discount report from your orders export. See orders, revenue, discount total, and average order value by code.See the workflow Built by the agent
- Shopify returns by productBuild a Shopify returns report by SKU with return reason and return rate from exported orders and returns files.See the workflow Built by the agent
Don't see your job? Describe it.
Tell us the job and we'll email you when you can build it.