Medium Performance Breakdown

🥳 Introducing our new Flex Connector! 👉 Learn more Introducing our new Flex Connector!

SELECT
  medium,
  SUM(sessions) sum_sessions,
  SUM(bounces):: float / SUM(sessions) bounce_rate
FROM
  public."google-analytics" -- Table name might be different based on Schema and Destination settings in the data source
WHERE
  datehour > sysdate - 30 -- Value can be changed \ Filter can be removed
GROUP BY
  1
ORDER BY
  2 DESC

Query Results Dictionary

Column	Description
`medium`	The type of referral
`sum_sessions`	Sum of sessions
`bounce_rate`	Sum of bounces divided by sum of sessions

Requirements:

Collect the Panoply Google Analytics data source with the default set of metrics and dimensions. This query uses the medium and datehour dimensions and the sessions and bounces metrics

Usage:

The result of this query can be displayed as a table or also as a bar chart.

Modifications:

The table in the FROM might need to be changed based on Schema and Destination settings in the data source. The columns country or devicecategory can be added to the WHERE as filters or to the SELECT and GROUP BY for an additional level of aggregation granularity.

View Google Analytics docs

Edit on Github

Other Google Analytics queries.

Last 7 Days vs Previous 7 Days

Other queries.

Account to Email Mapping

Action Insights by Ad Format and Optimization Type

Facebook Ad Accounts

Facebook Ads

Facebook Ads Ad Creatives