Builds an audience of Acquired Users, defined as users who were acquired via a specific marketing campaign source, medium, and name.

Schema

This reference describes a query pattern and does not map to a single database schema.

Common query patterns

/**
 * Builds an audience of Acquired Users.
 *
 * Acquired Users = users who were acquired via some Source/Medium/Campaign.
 */
 
SELECT
  COUNT(DISTINCT user_id) AS acquired_users_count
FROM
  `YOUR_TABLE.events_*`
WHERE
  traffic_source.source = 'google'
  AND traffic_source.medium = 'cpc'
  AND traffic_source.name = 'VTA-Test-Android'
  AND _TABLE_SUFFIX BETWEEN '20180521' AND '20240131';

[sample_queries]

[sample_queries]: Google Analytics Help: Sample queries for audiences based on BigQuery data