Events

'Events' report looks at all tracked events

This SQL example helps you find # of events, sessions, visitors, contacts and companies

SELECT
  COUNT(DISTINCT(dd_event_id)) AS events,
  COUNT(DISTINCT(dd_session_id)) AS sessions,
  COUNT(DISTINCT(dd_visitor_id)) AS visitors,
  COUNT(DISTINCT(dd_contact_id)) AS contacts,
  COUNT(DISTINCT(dd_company_id)) AS companies
FROM
  `table.events`
WHERE
  EXTRACT(YEAR
  FROM
    timestamp) = EXTRACT(YEAR
  FROM
    CURRENT_DATE())
  AND EXTRACT(MONTH
  FROM
    timestamp) = EXTRACT(MONTH
  FROM
    CURRENT_DATE())

This SQL example helps you find event conversions, influenced prospects and influenced value

WITH
  conversions AS (
  SELECT
    COUNT(*) AS conversions
  FROM
    `table.events`
  WHERE
    event. is_conversion IS TRUE
    AND EXTRACT(YEAR
    FROM
      timestamp) = EXTRACT(YEAR
    FROM
      CURRENT_DATE())
    AND EXTRACT(MONTH
    FROM
      timestamp) = EXTRACT(MONTH
    FROM
      CURRENT_DATE()) ),
  influenced AS (
  SELECT
    COUNT(dd_company_id) AS influenced_prospects,
    SUM(value) AS influenced_value
  FROM
    `table.stages`
  WHERE
    stage_name = 'MQL'
    AND EXTRACT(YEAR
    FROM
      timestamp) = EXTRACT(YEAR
    FROM
      CURRENT_DATE())
    AND EXTRACT(MONTH
    FROM
      timestamp) = EXTRACT(MONTH
    FROM
      CURRENT_DATE()) )
SELECT
  c.conversions,
  i.influenced_prospects,
  i.influenced_value
FROM
  conversions c
CROSS JOIN
  influenced i

This SQL example helps you find # of events grouped by event name

SELECT
  event_name,
  COUNT(DISTINCT(dd_event_id)) AS events
FROM
  `table.events`
WHERE
  EXTRACT(YEAR
  FROM
    timestamp) = EXTRACT(YEAR
  FROM
    CURRENT_DATE())
  AND EXTRACT(MONTH
  FROM
    timestamp) = EXTRACT(MONTH
  FROM
    CURRENT_DATE())
GROUP BY
  event_name
ORDER BY
  events DESC