TikTok CTR

ctr

Overview

TikTok Click-Through Rate (CTR) represents the percentage of users who clicked on your TikTok ad after seeing it.

📘

TikTok CTR = TikTok Clicks / TikTok Impressions

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Clicks = SUM(clicks) --> Ads table
Impressions = SUM(impressions) --> Ads table
TikTok Ads = where channel = 'tiktok-ads'

Insights and Actions

TikTok Click-Through Rate (CTR) measures the effectiveness of your TikTok ads in encouraging users to engage by clicking on them.

• Optimize Ad Creatives: Use CTR data to identify which ad creatives resonate most with your audience and drive higher engagement.
• Refine Audience Targeting: Analyze CTR across different audience segments to better understand which groups respond best to your ads.
• Adjust Ad Placement: Experiment with different ad placements on TikTok to see if certain placements lead to higher CTR.
• Monitor Engagement Trends: Regularly track CTR to detect engagement patterns and adjust your ad strategy to maintain or boost performance.

Example Use

Prompt

What's my TikTok CTR for the last 7 days?

Response

Query

SQL

SELECT
  am.channel AS channel,
  COALESCE(
    SUM(am.clicks) / NULLIF(SUM(am.impressions), 0),
    0
  ) AS CTR
FROM
  ads_table AS am
WHERE
  am.channel = 'tiktok-ads'
  AND am.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
GROUP BY
  am.channel;