When an organic TikTok post becomes a Spark ad, its data includes both organic and paid results. To report on organic results only, use custom fields and data blending to separate them. This article shows you how.
Before you begin
For this workaround, you need access to both TikTok Ads and TikTok Organic.
You also need a Supermetrics subscription with access to the Custom fields and Data blending features.
Data blending and Custom fields are available only in the Enterprise package. To get the most out of your data with these data transformations, contact us to upgrade your Supermetrics subscription to the Enterprise package.
Instructions
Step 1: Create a new join blend using TikTok Ads and TikTok Organic
On the Supermetrics Hub, go to Data blending under Manage.
Select the TikTok Ads connector and the account to use.
Select the Post ID dimension and Video views metric.
Select the TikTok Organic connector and the account to use.
Select the Video performance query type and the Video ID dimension and the Video views metric.
Hover over the Video views field name and click the pencil icon to change the display names of the fields so that the Video views for TikTok Ads is renamed to Video views (ads) and the field for TikTok Organic is renamed Video views (organic).
Click Next step.
Select the Post ID and Video ID dimensions as the join keys, and select the Inner join option. Once done, click Next step.
Give your blend a name, and an optional description.
Click Create blend.
Step 2: Create a custom field using the blended data source
In this step, create a custom field that subtracts Video views from TikTok Ads from Video views from TikTok Organic.
On the Supermetrics Hub, go to Custom fields under Manage.
Click New custom field.
Select metric and click Next.
Select the Data blending data source and the blend you just created, and click Next.
Select Function as your transformation type.
Select the Subtract function.
In the Value of field, select Video views (organic).
In the minus field, select Video views (ads), and click Next.
Give a name for your custom field, and click Create custom field.
Step 3: Use your custom field in your queries
In your data destination, select the Data blending data source.
Select the blend you just created.
As metrics, select the custom field you created, as well as the Video views (ads) and Video views (organic) metrics.
Select the Post ID dimension.
Run your query.