---
title: "How to get pure organic data from TikTok Organic"
slug: "how-to-get-pure-organic-data-from-tiktok-organic"
description: "Learn how to get pure TikTok Organic data using a workaround with custom fields and data blending."
updated: 2026-03-10T14:03:23Z
published: 2026-03-10T14:03:23Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to get pure organic data from TikTok Organic

The TikTok Organic data source connector has a known issue that if an organic post becomes a Spark ad, then this connector returns both organic and paid data.

To get pure organic data, you can use a workaround with custom fields and data blending.

## 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](https://supermetrics.com/enterprise-contact?pid=HUB).

## Instructions

### Step 1: Create a new join blend using TikTok Ads and TikTok Organic

1. On the [Supermetrics Hub](https://hub.supermetrics.com), go to **Data blending** under **Manage**.
2. Select the TikTok Ads connector and the account to use.
3. Select the Post ID dimension and Video views metric.
4. Select the TikTok Organic connector and the account to use.
5. Select the Video performance query type and the Video ID dimension and the Video views metric.
6. 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).
7. Click **Next step**.
8. Select the Post ID and Video ID dimensions as the join keys, and select the Inner join option. Once done, click **Next step**.
9. Give your blend a name, and an optional description.
10. 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.

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Custom fields** under **Manage**.
2. Click **New custom field**.
3. Select metric and click **Next**.
4. Select the Data blending data source and the blend you just created, and click **Next**.
5. Select **Function** as your transformation type.
6. Select the **Subtract** function.
7. In the **Value of** field, select Video views (organic).
8. In the **minus** field, select Video views (ads), and click **Next**.
9. Give a name for your custom field, and click **Create custom field**.

### Step 3: Use your custom field in your queries

1. In your data destination, select the Data blending data source.
2. Select the blend you just created.
3. As metrics, select the custom field you created, as well as the Video views (ads) and Video views (organic) metrics.
4. Select the Post ID dimension.
5. Run your query.