# Twitter Ads: Promoted Tweet Report ## Description * Each record in this table represents the daily performance of ads at the account, campaign, line item (ad group), and promoted tweet level, within a placement in Twitter. ## Supported Data Sources * 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 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 | promoted\_tweet\_id | The ID of the promoted tweet that the URL appeared in. | | INTEGER | tweet\_id | The ID of the tweet that the URL appeared in. | | INTEGER | tweet\_name | The name, if provided, of the tweet that the URL appeared in. | | STRING | full\_text | The full text of the tweet that the URL appeared in. | | BOOLEAN | is\_deleted | Whether the record has been deleted or not. | | STRING | promoted\_tweet\_status | The status of the promoted tweet. | | STRING | campaign\_status | The status of the tweet's campaign. | | STRING | line\_item\_status | The status of the tweet's line item. | | STRING | language | Two-letter language code of the tweet. | | STRING | currency | The currency all metrics for the account are set to. | | STRING | approval\_status | The approval status of the promoted tweet. | | STRING | created\_timestamp | The timestamp the account was created. | | STRING | updated\_timestamp | The timestamp the account was last updated. | | INTEGER | clicks | The clicks for the promoted tweet + URL 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 promoted tweet + URL 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 promoted tweet + URL on that day. | | INTEGER | spend\_micro | The spend, in micros, for the tweet + URL on that day. | | INTEGER | url\_clicks | The URL clicks for the promoted tweet + URL 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-promoted-tweet-report.md?ask= ``` 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.