# Twitter Ads: Campaign Report

## Description

* Each record in this table represents the daily performance of ads at the account and campaign level, within a placement in Twitter.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/twitter/resources/twitter_ads.svg" alt="" data-size="line"> Twitter 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.                                                                                                                                            |
| DATETIME | date\_day               | The date of the performance.                                                                                                                                                                                                                      |
| STRING   | placement               | Where on Twitter the ad is being displayed. Possible values include 'ALL\_ON\_TWITTER', 'PUBLISHER\_NETWORK', 'TWITTER\_PROFILE', 'TWITTER\_SEARCH', 'TWITTER\_TIMELINE', and 'TAP\_\*', which are more granular options for `PUBLISHER_NETWORK`. |
| STRING   | account\_id             | The ID of the related account.                                                                                                                                                                                                                    |
| STRING   | account\_name           | The name of the related account.                                                                                                                                                                                                                  |
| STRING   | campaign\_id            | The ID of the campaign.                                                                                                                                                                                                                           |
| STRING   | campaign\_name          | The name of the campaign.                                                                                                                                                                                                                         |
| BOOLEAN  | is\_deleted             | Whether the record has been deleted or not.                                                                                                                                                                                                       |
| STRING   | campaign\_status        | The status of the campaign.                                                                                                                                                                                                                       |
| STRING   | currency                | The currency all metrics for the account are set to.                                                                                                                                                                                              |
| BOOLEAN  | is\_servable            | Whether the campaign is in a state to be actively served to users.                                                                                                                                                                                |
| BOOLEAN  | is\_standard\_delivery  | Whether standard delivery is enabled (vs accelerated delivery).                                                                                                                                                                                   |
| INTEGER  | frequency\_cap          | The maximum number of times an ad could be delivered to a user.                                                                                                                                                                                   |
| STRING   | start\_timestamp        | The time the campaign will start.                                                                                                                                                                                                                 |
| STRING   | end\_timestamp          | The time the campaign will end                                                                                                                                                                                                                    |
| STRING   | created\_timestamp      | The timestamp the account was created.                                                                                                                                                                                                            |
| STRING   | updated\_timestamp      | The timestamp the account was last updated.                                                                                                                                                                                                       |
| STRING   | funding\_instrument\_id | Reference to the funding instrument.                                                                                                                                                                                                              |
| INTEGER  | daily\_budget\_amount   | The daily budget amount to be allocated to the campaign. The currency associated with the specified funding instrument will be used.                                                                                                              |
| INTEGER  | total\_budget\_amount   | The total budget amount to be allocated to the campaign.                                                                                                                                                                                          |
| INTEGER  | clicks                  | The number of clicks on that date. Includes clicks on the URL (shortened or regular links), profile pic, screen name, username, detail, hashtags, and likes.                                                                                      |
| INTEGER  | impressions             | The number of impressions on that date. This is the number of users who see a Promoted Ad either in their home timeline or search results.                                                                                                        |
| INTEGER  | spend                   | The amount of spend on that date.                                                                                                                                                                                                                 |
| INTEGER  | spend\_micro            | The amount of spend, in micros, on that date.                                                                                                                                                                                                     |
| INTEGER  | url\_clicks             | The number of URL clicks on that date.                                                                                                                                                                                                            |


---

# 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/twitter-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.
