Top Funnel Clicks and CPC

Meta's marketing analytics team wants a campaign-level view of top-of-funnel performance across recent ad delivery. Write a SQL query to return top-of-funnel clicks and cost per click (CPC) by campaign for the last 30 days.

Requirements

1. Use only events from the last 30 days relative to DATE '2024-06-30'.
2. Count only clicks where funnel_stage = 'top_of_funnel'.
3. Sum spend from delivery records in the same 30-day window.
4. Return one row per campaign with:
   • campaign_id
   • campaign_name
   • top_funnel_clicks
   • total_spend
   • cpc
5. Include campaigns with spend but no top-of-funnel clicks; in that case, return 0 clicks and NULL CPC.
6. Order results by top_funnel_clicks descending, then campaign_id ascending.