SalesExample data
Q4 Forecast & Pipeline
Q4 commit against target, the pace needed to close the gap, and every deal stuck for 14 days or more.
Prompt
Prompt
Build me a wide Grok Bot Page called "Q4 Forecast & Pipeline" from my CRM. At the top, four numbers: the Q4 target, what is committed, the open pipeline, and how many deals have had no stage change or logged activity for 14 days or more, then a one-line takeaway with the percent of target committed and the weeks left. Then a week-by-week chart of committed revenue against the target line for the 13 weeks of the quarter, with a Show needed pace toggle that draws the pace needed to reach target and a hover or tap readout. Then the deals to watch: name, amount, stage, owner, close date and days since the last change, with a NEW tag on deals added this week and a stuck flag on every deal at 14 days or more. Add a stage filter with counts, a Stuck 14+ days only toggle, a sort by largest or longest without a change, and a Details toggle per deal. The stuck count at the top must match the flagged deals in the list. Every control must really work on the Page; no buttons that do nothing. Anything not connected shows as empty instead of a guess. Then create a routine that refreshes the Page every hour during work hours so it stays live.
How to use it
- Copy the prompt and paste it into a chat with Grok Bot.
- Swap in your own bots, accounts or data sources where the prompt asks for them.
- If the prompt does not create a refresh routine, ask Grok Bot for one.
- To share your version, make a copy with mock data and make that copy public. Then get it listed.
