# Twitter Ads: Line Item Report

## Description

* Each record in this table represents the daily performance of ads at the account, campaign, and line item (ad group) 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 line item's campaign.                                                                                                                                                                                                               |
| STRING   | campaign\_name           | The name of the line item's campaign.                                                                                                                                                                                                             |
| STRING   | line\_item\_id           | The ID of the line item.                                                                                                                                                                                                                          |
| STRING   | line\_item\_name         | The name of the line item.                                                                                                                                                                                                                        |
| BOOLEAN  | is\_deleted              | Whether the record has been deleted or not.                                                                                                                                                                                                       |
| STRING   | line\_item\_status       | The status of the line item.                                                                                                                                                                                                                      |
| STRING   | campaign\_status         | The status of the line item's related campaign.                                                                                                                                                                                                   |
| STRING   | currency                 | The currency in which metrics will be reported.                                                                                                                                                                                                   |
| STRING   | advertiser\_domain       | The website domain for this advertiser, without the protocol specification.                                                                                                                                                                       |
| INTEGER  | advertiser\_user\_id     | The Twitter user identifier for the handle promoting the ad.                                                                                                                                                                                      |
| STRING   | bid\_type                | The bidding mechanism.                                                                                                                                                                                                                            |
| STRING   | bid\_unit                | The bid unit for this line item.                                                                                                                                                                                                                  |
| STRING   | charge\_by               | The unit to charge this line item by.                                                                                                                                                                                                             |
| STRING   | objective                | The campaign objective for this line item.                                                                                                                                                                                                        |
| STRING   | optimization             | The optimization setting to use with this line item.                                                                                                                                                                                              |
| STRING   | product\_type            | The type of promoted product that this line item will contain.                                                                                                                                                                                    |
| INTEGER  | primary\_web\_event\_tag | The identifier of the primary web event tag. Allows more accurate tracking of engagements for the campaign pertaining to this line item.                                                                                                          |
| STRING   | creative\_source         | The source of the creatives for the line item.                                                                                                                                                                                                    |
| INTEGER  | start\_timestamp         | The timestamp at which the line item will start being served.                                                                                                                                                                                     |
| INTEGER  | end\_timestamp           | The timestamp at which the line item will stop being served.                                                                                                                                                                                      |
| STRING   | created\_timestamp       | The timestamp the account was created.                                                                                                                                                                                                            |
| STRING   | updated\_timestamp       | The timestamp the account was last updated.                                                                                                                                                                                                       |
| INTEGER  | target\_cpa              | The target cost per acquisition for the line item.                                                                                                                                                                                                |
| INTEGER  | total\_budget\_amount    | The total budget amount to be allocated to the campaign.                                                                                                                                                                                          |
| INTEGER  | bid\_amount              | The bid amount to be associated with this line item.                                                                                                                                                                                              |
| 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-line-item-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.