---
updatedAt: 2025-01-29T10:30:40.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# TikTok Conversions (Purchases)

conversions

# Overview

TikTok Conversions (Purchases) represent the total number of purchases as reported by TikTok.

> 📘 TikTok Conversions = Number of Purchases Reported by TikTok

The calculation is based on data from the [Ads](https://triplewhale.readme.io/docs/ads-table) table.

### Detailed Breakdown

The formula above is derived from the following components:

Conversions = `SUM(conversions)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table\
TikTok Ads = `where channel = 'tiktok-ads'`

# Insights and Actions

TikTok Conversions (Purchases) track the number of purchases attributed to TikTok ads, providing insight into the effectiveness of your campaigns on the platform.

* **Evaluate Campaign Success**: Monitor TikTok conversions to assess how well your ads are converting views into purchases, giving you a clear measure of success.
* **Optimize Ads**: Use conversion data to identify high-performing ads and double down on those strategies to maximize purchases.
* **Target Audience Refinement**: Analyze conversion trends to refine your audience targeting, focusing on segments that are most likely to convert.
* **Compare Channel Effectiveness**: Compare TikTok conversions to other platforms to determine where to focus your ad budget for the best results.

# Example Use

### Prompt

> How many TikTok-reported conversions were there yesterday?

### Response

![](https://files.readme.io/b9ab38911e70c25b0337cc2fb8ed9197fde7a8e578b75e65bad38b520f249688-image.png)

### Query

```sql
SELECT
  SUM(adt.conversions) AS conversions
FROM
  ads_table AS adt
WHERE
  adt.channel = 'tiktok-ads'
  AND adt.event_date = '2024-09-28';
```