---
updatedAt: 2025-01-29T10:30:35.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# 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](https://triplewhale.readme.io/docs/ads-table) table.

### Detailed Breakdown

The formula above is derived from the following components:

Ad Spend = `SUM(spend)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table\
Clicks = `SUM(impressions)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) 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

![](https://files.readme.io/b1bf416463062b0a55796c17e07532c7e7bd54d5923654538f0d5f573a3c384f-image.png)

### 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;
```