Computes the audience of purchasers, defined as users who have logged either in_app_purchase or purchase.

Schema

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

Common query patterns

/**
 * Computes the audience of purchasers.
 *
 * Purchasers = users who have logged either in_app_purchase or
 * purchase.
 */
 
SELECT
  COUNT(DISTINCT user_id) AS purchasers_count
FROM
  `YOUR_TABLE.events_*`
WHERE
  event_name IN ('in_app_purchase', 'purchase')
  AND _TABLE_SUFFIX BETWEEN '20180501' AND '20240131';

[sample_queries]

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