Taboola CTR (vCTR)

ctr

Overview

Taboola Viewable Click-Through Rate (CTR, vCTR) represents the percentage of users who clicked on your Taboola ad after viewing it.

📘

Taboola CTR = Taboola Clicks / Taboola 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
Taboola Ads = where channel = 'taboola'

Insights and Actions

Taboola Click-Through Rate (CTR, vCTR) measures the engagement rate of your ads, showing the percentage of users who clicked after viewing them:

• Evaluate Ad Effectiveness: A high CTR suggests your ad resonates with viewers. If CTR is low, consider refining your ad visuals or messaging.
• Test New Creative: Low CTR could indicate that your ad isn't compelling enough. Experiment with new images, copy, or formats to boost engagement.
• Adjust Audience Targeting: If CTR is low in specific segments, refine targeting to focus on users more likely to click.

Related Metrics

• Taboola Impressions: Complements CTR by showing total ad exposure. High impressions with low CTR may signal targeting or creative issues.
• Taboola Clicks: Indicates direct engagement and helps evaluate ad appeal and interaction.
• Taboola Conversion Rate: Helps assess whether high engagement translates into conversions, providing a fuller picture of ad success.

Example Use

Prompt

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

Response

Query

SQL

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