# Twitter Ads: Keyword Report

## Description

* Each record in this table represents the daily performance of ads at the account, campaign, line item (ad group), and keyword 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    | Name of the associated account.                                                                                                                                                                                                                   |
| STRING   | campaign\_id     | The ID of the related campaign.                                                                                                                                                                                                                   |
| STRING   | campaign\_name   | The name of the related campaign.                                                                                                                                                                                                                 |
| STRING   | line\_item\_id   | The ID of the related line item (ad group).                                                                                                                                                                                                       |
| STRING   | line\_item\_name | The ID of the related line item.                                                                                                                                                                                                                  |
| STRING   | keyword\_id      | Unique key of the table built from the combination of 'account\_id', 'line\_item\_id', 'segment', and 'placement' fields.                                                                                                                         |
| STRING   | keyword          | The keyword whose performance is being tracked.                                                                                                                                                                                                   |
| STRING   | currency         | The currency all metrics for the account are set to.                                                                                                                                                                                              |
| INTEGER  | clicks           | The clicks for the line item + keyword on that day. Includes clicks on the URL (shortened or regular links), profile pic, screen name, username, detail, hashtags, and likes.                                                                     |
| INTEGER  | impressions      | The impressions for the line item + keyword on that day. This is the number of users who see a Promoted Ad either in their home timeline or search results.                                                                                       |
| INTEGER  | spend            | The spend for the line item + keyword on that day in whichever currency was selected during account creation.                                                                                                                                     |
| INTEGER  | spend\_micro     | The spend for the line item + keyword on that day, in micros and in whichever currency was selected during account creation.                                                                                                                      |
| INTEGER  | url\_clicks      | The url clicks for the line item + keyword on that day.                                                                                                                                                                                           |


---

# 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-keyword-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.