TikTok CPM

cpm

Overview

TikTok Cost Per Mille (TikTok CPM) measures the TikTok-reported cost per 1,000 TikTok ad impressions.

📘

TikTok CPM = (TikTok Ad Spend / TikTok Impressions) x 1000

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Ad Spend = SUM(spend) --> Ads table
Clicks = SUM(impressions) --> Ads table
TikTok Ads = where channel = 'tiktok-ads'

Insights and Actions

TikTok Cost Per Mille (TikTok CPM) measures how much you spend to reach 1,000 users with your TikTok ads, providing insights into the cost-efficiency of your campaigns.

• Evaluate Ad Efficiency: Track TikTok CPM to understand how cost-effective your campaigns are at reaching a broad audience.
• Optimize Budget: Use CPM data to allocate budget towards ad formats or times of day when you achieve the lowest CPM and maximum reach.
• Adjust Targeting: Refine targeting strategies to improve CPM by focusing on audience segments that deliver better cost efficiency.
• Monitor Ad Delivery Trends: Analyze CPM trends to identify shifts in ad delivery costs and adjust your strategy to maintain cost-effective reach.

Example Use

Prompt

What's my TikTok CPM for yesterday?

Response

Query

SQL

SELECT
  COALESCE(
    SUM(adt.spend) / NULLIF(SUM(adt.impressions), 0),
    0
  ) * 1000 AS tiktok_cpm
FROM
  ads_table AS adt
WHERE
  adt.channel = 'tiktok-ads'
  AND adt.event_date = CURRENT_DATE() - 1;