▸case-05 We are configuring alert thresholds for our brand awareness metrics (impressions and reach) in our executive monitoring sheet. A team member proposed flagging alerts only when reach deviates by 15% from baseline, with no intermediate review threshold. What tolerance window and campaign review triggers should be defined for awareness? | fail→pass | 15,428 | 9,824 | -36% | 1 | 1 | 0% | 2,137 | 2,251 | +5% | 0 | 0 | — |
▸case-06 Our RevOps team is setting alert bands for quarter-to-date pipeline generation against sales quota. They suggest setting the warning line at 1.5x quota and target at 2x quota. What are the specific guardrail ratios for pipeline addition targets and warning alerts? | pass→pass | 19,438 | 8,447 | -57% | 1 | 1 | 0% | 2,866 | 2,137 | -25% | 0 | 0 | — |
▸case-01 Our team is redesigning how we report marketing analytics to executive leadership across BI and RevOps. Please provide a dashboard wireframe layout that structures the interface into primary objective KPI tiles, channel-level drill-down cards, anomaly callout annotations, and an integrated action register. | fail→pass | 22,317 | 23,351 | +5% | 1 | 1 | 0% | 3,491 | 3,753 | +8% | 0 | 0 | — |
▸case-02 We are putting together a weekly narrative report package for marketing results to present to senior leadership. We plan to lead with deep dive channel screenshots and place the executive summary bullet points at the very end. How should this weekly packet be structured? | pass→pass | 13,451 | 15,014 | +12% | 1 | 1 | 0% | 2,010 | 2,973 | +48% | 0 | 0 | — |
▸case-03 Our marketing operations team wants to establish a weekly routine for executive reporting. We are thinking of running data QA on Wednesday morning right before our Wednesday afternoon ELT presentation, with retro on Monday. What weekly cadence schedule should we follow for data QA, preview, exec meeting, and action register updates? | fail→pass | 17,698 | 12,012 | -32% | 1 | 1 | 0% | 2,521 | 2,570 | +2% | 0 | 0 | — |
▸case-04 During our monthly KPI review, we noticed our CAC payback has risen to 17 months and has stayed above threshold for 3 consecutive weeks. Our team wants to handle this internally within the marketing squad for another month before notifying senior executive leaders. What escalation procedure should be triggered? | fail→pass | 15,342 | 8,237 | -46% | 1 | 1 | 0% | 2,068 | 2,013 | -3% | 0 | 0 | — |
▸case-07 We are drafting a measurement spec for our marketing analytics dashboard that links GA4 custom dimension definitions and Salesforce opportunity stage filters. We need a tool to pull current platform documentation into our workflow. What tool hook should be used for this task? | fail→pass | 13,799 | 3,413 | -75% | 1 | 1 | 0% | 1,998 | 1,290 | -35% | 0 | 0 | — |
▸case-08 We need to update our BI repository SQL transformation notebooks and dbt data models to fix a metric calculation bug identified during data QA. We want to apply metric model patches safely in our repo. Which tool hook is designed for safe editing of BI repository SQL notebooks and dbt models? | fail→pass | 12,034 | 2,146 | -82% | 1 | 1 | 0% | 1,966 | 1,157 | -41% | 0 | 0 | — |
▸case-09 Our team needs to facilitate a structured monthly retro on executive dashboard usage and systematically reason through architectural changes for the next iteration. Which tool hook is intended for retro facilitation and multi-step reasoning? | pass→pass | 12,796 | 2,812 | -78% | 1 | 1 | 0% | 1,803 | 1,258 | -30% | 0 | 0 | — |
▸case-10 Before sending our weekly executive packet to leadership, we need an automated way to verify that embedded web components render cleanly and capture high-resolution dashboard screenshots. What tool hook should we use for dashboard screenshot capture and component verification? | pass→pass | 14,105 | 3,155 | -78% | 1 | 1 | 0% | 2,169 | 1,265 | -42% | 0 | 0 | — |
▸case-11 We are designing a narrative framework for presenting performance slides to board members. A colleague suggested starting with detailed operational risks, then showing action items, and finishing with a general headline. What standard four-part story arc order should be followed? | pass→pass | 12,011 | 5,875 | -51% | 1 | 1 | 0% | 1,825 | 1,727 | -5% | 0 | 0 | — |
▸case-12 We are standardizing our dashboard action register module. The team wants to include only a single 'Task Description' field to keep it minimal and concise. What mandatory fields must be included in every action register alongside metrics? | pass→pass | 10,871 | 8,914 | -18% | 1 | 1 | 0% | 1,775 | 2,127 | +20% | 0 | 0 | — |
▸case-13 Before distributing the executive dashboard packet each week, what specific pre-distribution verification steps must be performed as part of the data governance loop? | pass→pass | 14,190 | 7,145 | -50% | 1 | 1 | 0% | 2,091 | 1,951 | -7% | 0 | 0 | — |
▸case-14 Our RevOps dashboard uses a single static 10% threshold for win rate alerts across all deal types. What commit threshold and escalation threshold should be applied to in-quarter commit win rates? | fail→pass | 13,958 | 6,792 | -51% | 1 | 1 | 0% | 2,131 | 1,705 | -20% | 0 | 0 | — |
▸case-15 When annotating unexpected metric swings or data spikes on executive dashboard tiles, our team usually just labels them 'data spike'. What specific elements should be included in insight callout annotations to provide proper context? | fail→pass | 15,957 | 13,454 | -16% | 1 | 1 | 0% | 2,507 | 2,725 | +9% | 0 | 0 | — |
▸case-16 We are creating a standardized Measurement Spec document to govern our executive metrics layout across BI and RevOps teams. What core metadata columns and properties must be included in this measurement specification document? | pass→pass | 15,864 | 15,416 | -3% | 1 | 1 | 0% | 2,469 | 3,147 | +27% | 0 | 0 | — |
▸case-17 A designer wants to combine pipeline generation, developer onboarding funnel, customer support ticket SLAs, and infrastructure cloud cost optimization into a single executive dashboard view. How should view scope be constrained to prevent cognitive overload? | pass→pass | 17,054 | 16,342 | -4% | 1 | 1 | 0% | 2,340 | 3,026 | +29% | 0 | 0 | — |
▸case-18 We are experiencing query slowdowns on our PostgreSQL reporting database when joining the fct_conversions table with dim_campaigns on campaign_id. Can you write a SQL query that uses EXPLAIN ANALYZE and suggest B-tree index creation scripts for postgres performance tuning? | pass→pass | 11,502 | 12,073 | +5% | 1 | 1 | 0% | 2,026 | 2,996 | +48% | 0 | 0 | — |
▸case-19 We need an Apex trigger on the Salesforce Opportunity object that automatically updates the StageName to Closed Won whenever a custom REST endpoint posts a payment confirmation webhook payload. Please provide the Apex trigger code and unit test class. | pass→pass | 22,073 | 26,086 | +18% | 1 | 1 | 0% | 4,210 | 5,755 | +37% | 0 | 0 | — |
▸case-20 We are configuring Google Analytics 4 data streams programmatically using the Google Analytics Admin API and gcloud CLI. What command line syntax or REST API payload should we send to enable enhanced measurement for video engagement tracking in GA4? | pass→pass | 10,083 | 8,094 | -20% | 1 | 1 | 0% | 1,752 | 2,336 | +33% | 0 | 0 | — |
▸case-21 We want executive team members viewing the high-level dashboard to easily navigate back to operational reporting commands when investigating performance dips. What specific operational commands should be embedded as links within the dashboard drilldowns? | fail→pass | 18,426 | 10,131 | -45% | 1 | 1 | 0% | 2,699 | 2,238 | -17% | 0 | 0 | — |
▸case-22 In our weekly executive summary narrative, section 2 covers insights and drivers. What explicit section must follow insights and drivers to ensure leadership takes operational ownership rather than just reviewing data? | fail→pass | 6,972 | 4,507 | -35% | 1 | 1 | 0% | 970 | 1,474 | +52% | 0 | 0 | — |