# Tiktok Ads: Campaign Report

## Description

* Each record in this table represents the daily performance at the campaign level.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/tiktok_ads/resources/tiktok-logo.svg" alt="" data-size="line"> Tiktok Ads

## Columns

| Type    | Name                 | Description                                                                                                                                                                                                                                                                                                                     |
| ------- | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING  | source\_relation     | The source of the record if the unioning functionality is being used. If not this field will be empty.                                                                                                                                                                                                                          |
| DATE    | date\_day            | Day of record                                                                                                                                                                                                                                                                                                                   |
| DECIMAL | advertiser\_id       | Advertiser ID                                                                                                                                                                                                                                                                                                                   |
| STRING  | advertiser\_name     | Advertiser name                                                                                                                                                                                                                                                                                                                 |
| DECIMAL | campaign\_id         | Campaign ID                                                                                                                                                                                                                                                                                                                     |
| STRING  | campaign\_name       | Campaign name                                                                                                                                                                                                                                                                                                                   |
| STRING  | currency             | Advertiser's currency.                                                                                                                                                                                                                                                                                                          |
| INTEGER | impressions          | The number of impressions that occurred on the day of the record.                                                                                                                                                                                                                                                               |
| INTEGER | clicks               | The number of clicks that occurred on the day of the record.                                                                                                                                                                                                                                                                    |
| INTEGER | spend                | The amount of spend that occurred on the day of the record.                                                                                                                                                                                                                                                                     |
| INTEGER | reach                | The number of unique users who saw your ads at least once. This metric is estimated.                                                                                                                                                                                                                                            |
| INTEGER | conversion           | The number of times your ad achieved an outcome, based on the secondary goal you selected. As one campaign may have a number of different secondary goals, this statistic is not supported for campaigns. Please go to ad groups or ads to view. (The total count is calculated based on the time each ad impression occurred.) |
| INTEGER | likes                | The number of likes your video creative received within 1 day of a user seeing a paid ad.                                                                                                                                                                                                                                       |
| INTEGER | comments             | The number of comments your video creative received within 1 day of a user seeing a paid ad.                                                                                                                                                                                                                                    |
| INTEGER | shares               | The number of shares that occurred on the day of the record.                                                                                                                                                                                                                                                                    |
| INTEGER | profile\_visits      | The number of profile visits that occurred on the day of the record.                                                                                                                                                                                                                                                            |
| INTEGER | follows              | The number of follows that occurred on the day of the record.                                                                                                                                                                                                                                                                   |
| INTEGER | video\_watched\_2\_s | The number of times your video played for at least 2 seconds, or completely played. Replays will not be counted.                                                                                                                                                                                                                |
| INTEGER | video\_watched\_6\_s | The number of times your video played for at least 6 seconds, or completely played. Replays will not be counted.                                                                                                                                                                                                                |
| INTEGER | video\_views\_p\_25  | The number of times your video was played at 25% of its length. Replays will not be counted.                                                                                                                                                                                                                                    |
| INTEGER | video\_views\_p\_50  | The number of times your video was played at 50% of its length. Replays will not be counted.                                                                                                                                                                                                                                    |
| INTEGER | video\_views\_p\_75  | The number of times your video was played at 75% of its length. Replays will not be counted.                                                                                                                                                                                                                                    |
| INTEGER | daily\_cpc           | The average amount of money you've spent on a click.                                                                                                                                                                                                                                                                            |
| INTEGER | daily\_cpm           | The average amount of money you've spent per 1,000 impressions.                                                                                                                                                                                                                                                                 |
| INTEGER | daily\_ctr           | The percentage of times people saw your ad and performed a click.                                                                                                                                                                                                                                                               |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/tiktok-ads-campaign-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
