One Simple Prompt To Improve Your Lead To Admission Conversion

1. SQL Query: Segment Your Leads

SELECT
    city,
    lead_stage,
    programme,
    COUNT(*) AS total_leads
FROM leads
WHERE city IS NOT NULL
GROUP BY
    city,
    lead_stage,
    programme
ORDER BY total_leads DESC;

This query groups leads by city, admission stage and programme, helping you identify segments that may need different communication. Adapt the table and column names to your database.

2. GPT Prompt: Create Relevant Emails

You are an expert in university admissions marketing and lead nurturing.

I will share anonymised student lead data, including city, programme of interest and current admission stage.

For each meaningful segment, provide:
1. Segment description
2. Likely student concerns (label these as hypotheses if not supported by data)
3. A relevant email subject line
4. A short, personalised email body
5. Recommended next action

Avoid sending the same generic message to everyone. Consider how students from different cities, programmes and admission stages may have different information needs.

Use only verified university information. Do not invent statistics, testimonials or claims. Flag missing information instead of making it up.

Keep the emails short, natural and student-friendly.

Lead segment data:
[PASTE SQL OUTPUT HERE]

Verified university information:
[PASTE RELEVANT DETAILS HERE]