Get Acquisition Insights

Get user acquisition insights by discovery source.

Analyzes user distribution across different discovery/acquisition sources:

• Extracts discovery_source from users.persona JSONB field
• Counts DISTINCT users per source
• Calculates percentage against total users
• Includes "Unknown" category for users without discovery source

Data Source:

• users.persona->'discovery_source' (JSONB array)
• Users can have multiple sources (counted per source)

Discovery Source Categories:

• Known sources: Any value in discovery_source array (e.g., "Google", "Facebook", "Friend Referral", "Instagram")
• Unknown: Users with NULL or empty discovery_source array

Use Cases:

• Understand primary user acquisition channels
• Track marketing campaign effectiveness
• Identify most successful discovery sources
• Calculate unknown source rate

Returns: Acquisition source distribution: { "total_users": 10000, "sources": [ { "source": "Google", "user_count": 674, "percentage": 15.4 }, { "source": "Friend Referral", "user_count": 523, "percentage": 12.0 }, { "source": "Unknown", "user_count": 2869, "percentage": 65.6 } ] }