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 table.

Detailed breakdown

The formula above is derived from the following components:

Ad Spend = SUM(spend) --> Ads table
Channel-Reported Conversions (Purchases) = SUM(conversions) --> Ads 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

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;