← Back to glossary

Category: Analytics & Attribution

Frequency

The average number of ad contacts (impressions) per reached user (Impressions / Unique Reach). In tension with Frequency Capping.

Frequency

The average number of ad contacts (impressions) per reached user (Impressions / Unique Reach). In tension with Frequency Capping.

Example

8M impressions / 1.2M unique users = frequency 6.7.

Related Query

Reach & Frequency (Instructional Query) (Instructional Query: Reach and Frequency) 

/* Illustrative template – concept only, NOT Amazon proprietary code */
SELECT campaign_id,
       COUNT(*)                 AS impressions,
       COUNT(DISTINCT user_id)  AS unique_reach,
       COUNT(*) / NULLIF(COUNT(DISTINCT user_id), 0) AS frequency
FROM media_impressions
GROUP BY campaign_id;