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

# TikTok CPA

cpa

# Overview

TikTok Cost per Acquisition (CPA) measures the total TikTok advertising cost required to acquire one paying customer.

> 📘 TikTok CPA = TikTok Ad Spend / TikTok-Reported Conversions

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\
Channel-Reported Conversions (Purchases) = `SUM(conversions)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table\
TikTok Ads = `where channel = 'tiktok-ads'`

# Insights and Actions

TikTok Cost per Acquisition (CPA) measures how much you’re spending on TikTok ads to convert a user into a paying customer, providing a clear view of your ad efficiency.

* **Optimize Ad Spend**: Track CPA to understand how much you’re spending to acquire each customer and adjust your budgets to lower this cost.
* **Improve Targeting**: Analyze CPA across different audiences to identify segments that convert more cost-effectively, helping you refine targeting.
* **Test Campaign Strategies**: Experiment with ad creatives and messaging to lower your CPA by finding combinations that convert more efficiently.
* **Monitor Campaign Efficiency**: Use CPA trends to spot campaigns with rising costs and adjust tactics to maintain a sustainable acquisition cost.

# Example Use

### Prompt

> What's my channel-reported TikTok CPA over the last 30 days?

### Response

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

### Query

```sql
SELECT
  a.channel AS channel,
  COALESCE(SUM(a.spend) / NULLIF(SUM(a.conversions), 0), 0) AS cpa
FROM
  ads_table AS a
WHERE
  a.channel = 'tiktok-ads'
  AND a.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1
GROUP BY
  a.channel
ORDER BY
  cpa DESC;
```