Taboola CPC

cpc

Overview

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

📘

Taboola CPC = Taboola Ad Spend / Taboola 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
Taboola Ads = where channel = 'taboola'

Insights and Actions

Taboola CPC indicates the cost efficiency of your ad clicks, helping you monitor how much you’re paying per interaction:

• Optimize Ad Spend: If CPC is high, consider adjusting bid strategies or improving targeting to get more clicks at a lower cost.
• Improve Ad Creative: High CPC with low clicks may suggest unappealing ads. Test new creatives to increase click rates, potentially lowering CPC.
• Adjust Audience Targeting: If specific segments are driving up CPC, refine your targeting to reach more cost-effective audiences.

Related Metrics

• Taboola Clicks: Complements CPC by showing the volume of clicks. High CPC with low clicks may indicate targeting or creative issues.
• Taboola Impressions: Helps assess if high spend and low clicks are due to insufficient reach.
• Taboola ROAS: Reveals return on ad spend, ensuring CPC is translating into profitable conversions.

Example Use

Prompt

What was my Taboola CPC for yesterday?

Response

Query

SQL

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