CRM & sales ops21 categories
Write the SOQL for this question
A Salesforce question you can describe in a sentence but not write as a query.
Write a SOQL query answering the question below. Respect Salesforce's limits: no arbitrary joins, relationship queries only one level up and one level down, aggregate rules, and selective filters on indexed fields where possible. Return the query, a plain-English description of exactly what it counts, and any records it deliberately excludes. If the question cannot be answered in one SOQL query, say so and give the smallest set that answers it. Objects and fields available: Question:
Making it yours
- Paste your own material where the prompt asks for it. Everything above that line is instruction, not content.
- Delete any rule that does not apply to you. A shorter prompt that fits beats a thorough one that does not.
- If the answer comes back vague, add a line saying what you do not want. Constraints work better than encouragement.
Reports and forecasting. Turning a question about the business into a report, a query, or a number you can defend.
Related prompts
Turn this question into a report specSomeone asked for a dashboard and described a feeling rather than a metric.Stress-test this forecastA committed number you have to defend at the end of the week.Pin down what this metric actually meansWhen two teams report different numbers for the same thing and both are right.Build this as a HubSpot reportKnowing the number you want and not which HubSpot report type produces it.Work out retention from this customer exportRenewal and churn data in a spreadsheet, and a question about whether it is getting worse.Summarise this pipeline for someone with two minutesA weekly update for a manager who does not want the deal-by-deal walkthrough.
Keep this one
Phrasery saves prompts with a right-click and puts them back the same way. Add this to your own library in one click.
Add to your browser — free