Workflows ยท Marketing and sales ยท Opening soon
Workflows for marketing, sales and agencies
Campaigns, pipeline, hours and client profit, from your ads, CRM and time exports.
Match two lists
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Project budget vs actual hoursTrack project budget hours against actual time in Harvest exports, and show percent used and remaining for each project.See the workflow Built by the agent
- Google Ads auditAudit Google Ads keywords from an exported file. See campaign, quality score, click-through rate, and a status for each keyword.See the workflow Built by the agent
- Three-way trust reconciliationCheck a trust account three ways from QuickBooks exports: client ledger balances, trust ledger entries, and the bank statement ending balance.See the workflow Built by the agent
- HubSpot deals vs Stripe invoicesCheck closed won HubSpot deals against Stripe invoices by amount, and list the ones that do not match.See the workflow Built by the agent
- Reconcile ADP payroll to the GLCompare ADP payroll register totals by pay date to payroll expense in the general ledger and flag differences.See the workflow Built by the agent
- Reconcile Gusto payroll to QuickBooksMatch Gusto payroll run totals to QuickBooks payroll journal entries, compare wages, taxes, and benefits, and flag mismatches.See the workflow Built by the agent
- Salesforce closed-won vs QuickBooks invoicesMatch Salesforce closed-won opportunities to QuickBooks invoices by customer and amount, and flag deals that were never invoiced.See the workflow Built by the agent
Age and chase
Age what is open, and get the list of who to chase, sorted by how late it is.
- Maintenance work orders overdueList open maintenance work orders past due with asset, technician, due date, and days overdue from an Excel export.See the workflow Built by the agent
- Deal aging in pipelineShow how long each open deal has been in its current stage, then flag deals that have stayed too long.See the workflow Built by the agent
Track and forecast
The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.
- 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
- 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
- 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
- Content auditEvery page's clicks now and before, and a keep, update or prune callSee the workflow Template
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- MRR movementEach month's recurring revenue: start, new, expansion, contraction, churned, endSee the workflow Template
- 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
- 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
- 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
- Warehouse pick rateCalculate pick rate per picker per hour by day from ShipBob pick logs.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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- CSAT by agentBuild a CSAT report from Zendesk solved tickets, grouped by support agent and month.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
- 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
- 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
- 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
Calculate
Schedules, commissions, costing and margins, worked out the same way from every new export.
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- Google Ads wasted spendFind search terms with spend and no conversions in the last 30 days, ranked by spend, from a Google Ads export.See the workflow Built by the agent
- Negative keyword finderEvery search term that spent money and never converted, with its share of spendSee the workflow Template
- Multi-touch attributionSplit closed HubSpot deal credit across touchpoints, by touch and by channel, from exported deal, contact, engagement, and channel mapping files.See the workflow Built by the agent
- Content decay: pages losing clicksCompare clicks per page this quarter vs last quarter and list the pages that lost the most in Google Search Console exports.See the workflow Built by the agent
- LTV to CAC ratioMatch Stripe and Google Ads exports by month, calculate CAC and LTV, then show the LTV to CAC ratio.See the workflow Built by the agent
- Affiliate commissionsCalculate affiliate commissions by affiliate and month from Shopify orders, using referral codes, rate tables, and order subtotal.See the workflow Built by the agent
- Lost deal reasonsAnalyze closed lost deals by reason, stage, rep, and lost value from a HubSpot deals export.See the workflow Built by the agent
- Marketing attribution first touch last touchCompare first touch and last touch attribution of won deal revenue by channel from a HubSpot deals export.See the workflow Built by the agent
- Influencer campaign ROIMatch influencer payouts to discount code sales from Shopify exports, then calculate ROI for each influencer.See the workflow Built by the agent
- Labor cost as percent of salesCalculate labor cost as a percentage of sales by location and week from Toast exports.See the workflow Built by the agent
- Lead scoringScore HubSpot contacts by company size, job title, and pages viewed from your points table, then list the leads that match.See the workflow Built by the agent
- Project profitabilityCalculate project profit and margin from Harvest exports, using revenue, labor cost, and expenses by project.See the workflow Built by the agent
- Restaurant tip poolSplit weekly pooled tips by hours worked, using exported Toast tips and timesheet files. See each front of house share.See the workflow Built by the agent
- SLA breaches by priorityCount tickets that breached first reply targets by priority over the last 8 weeks, with breach rate and a status column.See the workflow Built by the agent
- Upsell opportunities from usageFind customers near or over their plan limits from exported Stripe data, so sales can offer the right upgrade.See the workflow Built by the agent
- Gender pay gapCompare average and median pay by gender within each job level and department from a BambooHR export.See the workflow Built by the agent
- Agency client profitabilityCalculate client profit from Harvest client, invoice, and time entry exports. Add fees, subtract staff costs, and get profit by client.See the workflow Built by the agent
- Timesheet hours by projectTurn Harvest time entries into a timesheet report with hours by project, person and week, split into billable and non-billable.See the workflow Built by the agent
- Fleet fuel spendBuild a fuel report from Excel exports. Summarize fuel spend, gallons, miles, and cost per mile by vehicle and month.See the workflow Built by the agent
- Customer support tickets by categoryTurn a Zendesk tickets export into a ticket report by category and week, and see which categories are growing.See the workflow Built by the agent
- Law firm billable hoursTrack billable hours and fees by attorney, client, and matter this month from Clio exports.See the workflow Built by the agent
- Fundraising campaign resultsSummarize each fundraising campaign from Bloomerang exports, including donors, gifts, total raised, average gift, and progress against goal.See the workflow Built by the agent
- Order fulfillment timeCalculate order fulfillment time from ShipStation exports by day and warehouse, with shipment counts, average days to ship, and status.See the workflow Built by the agent
- Search Console clicks by pageShow clicks, impressions, CTR and position by page this month compared with last month from exported Search Console pages data.See the workflow Built by the agent
- Employee overtime costTrack overtime cost and hours by department and week from your ADP export, and flag weeks that move outside the normal range.See the workflow Built by the agent
- Blended ROAS across Google and Meta AdsCombine Google Ads and Meta Ads exports with Shopify orders to see weekly blended ROAS, with duplicate rows flagged first.See the workflow Built by the agent
- LinkedIn Ads cost per leadShow LinkedIn Ads campaign cost per lead by week, sorted highest first, from your exported campaign file.See the workflow Built by the agent
- Meta Ads creative fatigueTrack weekly CTR and frequency by ad creative, and flag ads where CTR drops while frequency rises.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.