Generate a customized sales tracker with deal tracking fields, activity logs, rep performance dashboards, and goal-versus-quota views to manage daily pipeline operations
You are a senior sales operations analyst who has built tracking systems for teams ranging from five-person startup squads to two-hundred-rep enterprise organizations. You understand that a great sales tracker is not a static spreadsheet people fill in reluctantly on Fridays but the operational nerve center reps open every morning to see which deals need attention, which activities to prioritize, and where they stand against their number. I need you to design a complete sales tracker for [COMPANY_NAME] used by [TEAM_SIZE:select:Solo sales rep,Small team of 2-5 reps,Mid-size team of 6-15 reps,Large team of 16-50 reps,Enterprise organization with 50+ reps] selling [PRODUCT_OR_SERVICE] through a [SALES_MOTION:select:High-velocity transactional under 30-day cycles,Inside sales consultative with 30-90 day cycles,Field sales enterprise with 3-6 month cycles,Product-led growth with sales-assisted expansion,Channel and partner-driven indirect sales] model. Average deal size is approximately [AVG_DEAL_SIZE] with [DEALS_PER_REP:number:5-200] active deals per rep. Quota structure is [QUOTA_STRUCTURE:select:Monthly individual quotas,Quarterly individual quotas,Annual quotas broken into quarterly targets,Team-based shared quota] at [QUOTA_TARGET] per period. Primary lead sources are [LEAD_SOURCES:select:Inbound marketing,Outbound prospecting,Partner and channel referrals,Customer expansion and upsell,Mixed across all sources] and the CRM environment is [CRM_ENVIRONMENT:select:Salesforce,HubSpot,Pipedrive,Zoho CRM,Spreadsheets only,Other platform]. Our pipeline stages are [PIPELINE_STAGES?] and leadership-required KPIs: [REQUIRED_KPIS?] Design the tracker as a structured system a rep or manager can implement immediately. Start with a deal and opportunity tracker specifying fields for deal name, account, contact name and role, deal value, stage, probability percentage, expected and actual close dates, lead source category, days in current stage, total deal age, next action and date, competitor involved, and win or loss reason, briefly explaining each field's purpose. Follow with an activity tracking section logging daily rep activities with fields for date, rep name, activity type covering calls, emails, meetings, demos, proposals, and social touches, associated deal, outcome, follow-up flag, and follow-up date. Provide daily activity targets calibrated to the sales motion specified. Build a rep performance scorecard showing quota target, closed-won revenue, pipeline value, weighted pipeline, attainment percentage, coverage ratio, win rate, average deal size, average cycle length, and activities versus targets in a single rolling view. Include goal tracking that breaks the quota period into weekly increments with cumulative target alongside actual revenue, variance to plan, and deals needed to close the gap. Flag when a rep falls more than ten percent behind pace. Design three time-based views. The daily view surfaces scheduled follow-ups, overdue actions, new leads requiring first contact, and activity counts versus targets. The weekly view rolls up activities, shows pipeline movement including deals advanced, stalled, and lost, highlights top deals closing within fourteen days, and compares revenue to pacing. The monthly view presents pipeline health metrics, revenue totals, win-loss summary with reason categorization, and lead source performance showing conversion rate, deal size, and revenue contribution per channel. Add a pipeline hygiene section flagging deals with no activity in the past [STALE_THRESHOLD:select:3 days,5 days,7 days,10 days,14 days], expired close dates, and deals stuck beyond average stage duration, with a fifteen-minute weekly cleanup routine. Close with dashboard recommendations for the most critical visualizations including pipeline by stage, revenue pacing versus target, activity trends, win-loss ratio, source mix, rep attainment comparison, and follow-up compliance, explaining what each reveals and what corrective action to take when trends shift. Prioritize daily usability over exhaustive coverage, because a focused tracker every rep maintains in five minutes beats a comprehensive one nobody updates.
Range: 5 - 200
Use this prompt anywhere
10,000+ expert prompts for ChatGPT, Claude, Gemini, and wherever you use AI.
Get Early AccessDeals slip through the cracks when reps track activity in their heads instead of a shared system. A sales tracker template gives your team one place to log every call, email, meeting, and deal update so nothing goes stale and no follow-up gets missed. It turns scattered notes into an operational dashboard where managers can spot stuck deals, measure rep performance against quota, and keep pipeline hygiene tight.
This sales tracker template builds a customized tracking system around your actual workflow. Enter your [COMPANY_NAME] and [PRODUCT_OR_SERVICE] to set the context, then select your [SALES_MOTION] and [QUOTA_STRUCTURE] so the tracker reflects how your team really sells. The generated output includes deal tracking fields, daily activity logs, rep performance dashboards, goal-versus-quota views, and stale deal alerts based on your [STALE_THRESHOLD] setting.
Unlike a sales report template that analyzes past performance or a sales pipeline template that defines stage architecture, this tracker focuses on day-to-day operations. It captures what happened today, what needs to happen tomorrow, and where each deal stands right now. Pair it with a sales forecast template to turn your live tracking data into forward-looking projections, or use a commission calculator to show reps exactly how pipeline movement translates into earnings. Open the Dock Editor to generate a tracker fitted to your team in minutes.
Enter your [COMPANY_NAME] and [PRODUCT_OR_SERVICE] so the tracker uses the right terminology and deal fields. Select your [TEAM_SIZE] to scale the template for solo reps, small pods, or full sales floors.
Choose your [SALES_MOTION] from options like inbound, outbound, or hybrid. Then select the [QUOTA_STRUCTURE] and enter your [QUOTA_TARGET] so the tracker can build goal-versus-actual views that match how your team gets measured.
Select your primary [LEAD_SOURCES] and [CRM_ENVIRONMENT]. If your stages differ from the default, add custom [PIPELINE_STAGES] so the deal tracker mirrors your actual process from first touch to closed-won.
Choose a [STALE_THRESHOLD] to flag deals that sit too long without activity. Add any [REQUIRED_KPIS] like calls per day, meetings booked, or win rate so the dashboard highlights the metrics your managers review most.
Run the prompt to receive your complete tracker with deal fields, activity logs, performance dashboards, and follow-up alerts. Distribute it to reps with a quick walkthrough on daily logging expectations.
Monitor daily rep activity and deal progression across the entire team from a single dashboard. Identify coaching opportunities by spotting reps with high activity but low conversion or deals stuck past the stale threshold.
Keep a running log of every call, email, and meeting tied to each deal. Track personal quota attainment in real time and use follow-up alerts to make sure no prospect goes cold between touches.
Standardize tracking practices across territories and teams by deploying a consistent template fitted to the company's CRM environment, pipeline stages, and KPI requirements.
Replace ad-hoc spreadsheets with a structured tracker that covers deal details, activity history, and quota progress without needing a full CRM subscription or dedicated operations staff.
Discover more prompts that could help with your workflow.
Generate a structured discovery call script with qualification questions, rapport-building openers, pain discovery sequences, and clear next steps tailored to your prospect and sales methodology
Craft a genuine, personalized win-back email that re-engages lost prospects or churned customers by acknowledging the gap and presenting fresh reasons to reconnect
Generate a professional service contract or agreement customized for your specific business relationship and terms
10,000+ expert-curated prompts for ChatGPT, Claude, Gemini, and wherever you use AI. Our extension helps any prompt deliver better results.