SQL · Case 05

Average Ticket
by Segment

Financial intelligence applied to marketing and sales: AVG() grouped by sector to identify the most profitable market segments.

+40% Tech ticket vs. average
R$12.5K Tech average ticket
AVG() Main function
Context

Use of financial intelligence applied to marketing and sales to identify the most profitable market segments.

About the case

The company was planning its market expansion but struggled to decide which industry should receive the largest paid media investment. I used the AVG() function grouped by industry to calculate the average contract value. Results showed that Technology had a ticket 40% above the average of the other segments, making it the strategic focus for annual expansion.

SQL
-- Identificar rentabilidade por segmento via ticket médio

SELECT
    setor,
    ROUND(AVG(valor_contrato), 2) AS ticket_medio,
    COUNT(id) AS volume_vendas
FROM
    vendas
GROUP BY
    setor
ORDER BY
    ticket_medio DESC;
Process visualization
Business explanation

Not every customer has the same revenue impact. This analysis precisely defines the Sales Mix strategy, ensuring that acquisition budget and sales effort are channeled primarily to market niches with the highest contribution margin and return on investment.