TikTok ROAS

roas

Overview

TikTok Return on Ad Spend (TikTok ROAS) refers to the TikTok-reported conversion value divided by the TikTok-reported ad spend.

📘

TikTok ROAS = TikTok Ads Conversion Value / TikTok Ad Spend

The calculation is based on data from the Ads table.

Detailed breakdown

The formula above is derived from the following components:

Conversion Value (CV) = SUM(conversion_value) --> Ads table
Ad Spend = SUM(spend) --> Ads table
TikTok Ads = where channel = 'tiktok-ads'

Insights and Actions

TikTok Return on Ad Spend (TikTok ROAS) measures the effectiveness of your ad spend on TikTok, helping you understand which campaigns generate the most revenue per dollar spent.

• Campaign Optimization: Analyze which TikTok campaigns have the highest ROAS and investigate what makes them successful for replication in future campaigns.
• Creative Strategy Refinement: Identify ad creatives with the best performance in terms of ROAS to guide creative development and testing strategies.
• Audience Targeting Adjustment: Use ROAS data to refine your targeting on TikTok, focusing on demographics, interests, or behaviors that yield the highest return.
• Budget Reallocation: Shift more of your advertising budget to TikTok if it demonstrates a higher ROAS compared to other platforms, optimizing overall marketing spend.

Example Use

Prompt

What's my channel-reported TikTok ROAS the last 30 days?

Response

Query

SQL

SELECT
  COALESCE(
    SUM(adt.conversion_value) / NULLIF(SUM(adt.spend), 0),
    0
  ) AS roas
FROM
  ads_table AS adt
WHERE
  adt.channel = 'tiktok-ads'
  AND adt.event_date >= CURRENT_DATE() - 30