Overview

TikTok Ad Spend refers to the total amount of money spent on advertising on TikTok.

📘

TikTok Ad Spend = Ad Spend on TikTok Ads

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

Insights and Actions

TikTok Ad Spend is an important metric for evaluating your investment in TikTok’s advertising platform and refining your marketing strategy:

• Evaluate Campaign ROI: Compare your TikTok Ad Spend with the revenue generated from TikTok ads to measure the effectiveness and ROI of your campaigns. Adjust strategies to improve performance where needed.
• Optimize Budget Allocation: Identify which TikTok campaigns are delivering the best results and allocate more budget to those, while reducing spend on underperforming campaigns.
• Refine Targeting and Bidding: Combine spend data with conversion metrics to optimize targeting and bidding strategies, boosting your return on investment.
• Enhance Ad Creatives and Landing Pages: Analyze how different ad creatives and landing pages affect spend and adjust them to reduce costs or improve results.

Example Use

Prompt

What's my spend on TikTok for the last 7 days?

Response

Query

SELECT
  am.channel AS channel,
  COALESCE(SUM(am.spend), 0) AS total_spend
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
ORDER BY
  total_spend DESC;