TEAM MESSAGEWhich advert brought in the most qualified leads?
APPROVED VIEW / READ-ONLYCheck access. Read the agreed view.
QUERY PLANSELECT ONLY
SELECT advert, COUNT(*) AS qualified_leads
FROM approved_leads_view WHERE qualified = TRUE
GROUP BY advert ORDER BY qualified_leads DESC;
No changes to the source system.
DATA DESK / RESULTSearch A leads
Qualified leads · example figures
- Search A54
- Social B41
- Display C27
SOURCE / Approved leads view · read-only
TEAM MESSAGEWho is the top-performing salesperson this quarter?
APPROVED VIEW / READ-ONLYCheck access. Read the agreed view.
QUERY PLANSELECT ONLY
SELECT salesperson, SUM(booked_revenue) AS revenue
FROM approved_sales_view
WHERE sale_date >= DATE_TRUNC('quarter', CURRENT_DATE)
GROUP BY salesperson ORDER BY revenue DESC;
No changes to the source system.
DATA DESK / RESULTRep A leads this quarter
Booked revenue · example figures in £k
- Rep A£82k
- Rep B£71k
- Rep C£64k
SOURCE / Approved sales view · read-only
TEAM MESSAGEWhich orders need a dispatch review?
APPROVED VIEW / READ-ONLYCheck access. Read the agreed view.
QUERY PLANSELECT ONLY
SELECT order_ref, review_reason
FROM approved_dispatch_view
WHERE review_required = TRUE;
No changes to the source system.
DATA DESK / RESULTOrders needing review
Fictional example orders| Order | Reason |
|---|
| ORD-101 | Late scan |
|---|
| ORD-102 | Missing proof |
|---|
| ORD-103 | Address check |
|---|
SOURCE / Approved dispatch view · read-only