TikTok CPC

cpc

Overview

TikTok Cost Per Click (TikTok CPC) refers to the TikTok-reported cost for each click on a TikTok ad.

📘

TikTok CPC = TikTok Ad Spend / TikTok Ad Clicks

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(clicks) --> Ads table
TikTok Ads = where channel = 'tiktok-ads'

Insights and Actions

TikTok Cost Per Click (TikTok CPC) measures how much you pay for each click on your TikTok ads, offering insights into the efficiency of your ad spend.

• Optimize Ad Performance: Monitor CPC to ensure you're getting the most value from your ad spend. If CPC is high, consider refining your ad content or targeting.
• Budget Allocation: Use CPC data to allocate budget toward campaigns and audience segments that yield the lowest cost per click.
• Refine Targeting: Adjust targeting strategies to focus on the demographics and interests that result in lower CPC and higher engagement.
• Test Ad Variations: Continuously test different ad creatives to find those that drive clicks at a lower cost.

Example Use

Prompt

What was my TikTok CPC for yesterday?

Response

Query

SQL

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