Skip to main content

Peliqan

Try for free
Request a demo

Analyze user acquisition by channel

SQL query for Google Analytics

Get user acquisition data by channel from Google Analytics tables.

SELECT channel, COUNT(user_id) AS total_users FROM GoogleAnalyticsTable GROUP BY channel ORDER BY total_users DESC

Try this query now in Google Analytics

Google Analytics data model

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed