# Twitter Organic: Tweets

## Description

* Each record represents the daily performance of a tweet.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/twitter/resources/twitter_ads.svg" alt="" data-size="line"> Twitter Organic

## Columns

| Type     | Name                         | Description                                                                    |
| -------- | ---------------------------- | ------------------------------------------------------------------------------ |
| DATETIME | date\_day                    | Date of the report                                                             |
| INTEGER  | organic\_tweet\_id           | The unique ID of the tweet                                                     |
| DATETIME | created\_timestamp           | Date and time when the tweet was created                                       |
| STRING   | tweet\_text                  | The full text of the tweet                                                     |
| STRING   | account\_id                  | ID of the associated account in Twitter                                        |
| STRING   | post\_url                    | URL of the tweet                                                               |
| STRING   | account\_name                | Name of the account in Twitter                                                 |
| INTEGER  | user\_id                     | The ID of the user in Twitter                                                  |
| STRING   | user\_name                   | The name of the user                                                           |
| STRING   | source\_relation             | The source of the record, if the unioning functionality is being used.         |
| INTEGER  | app\_clicks                  | Number of clicks on app install campaigns                                      |
| INTEGER  | card\_engagements            | Number of engagements on cards                                                 |
| INTEGER  | carousel\_swipes             | Number of swipes on carousels                                                  |
| INTEGER  | clicks                       | Number of clicks on tweet                                                      |
| INTEGER  | engagements                  | Number of engagements on tweet                                                 |
| INTEGER  | follows                      | Number of follows as a result of the tweet                                     |
| INTEGER  | impressions                  | Number of impressions on tweet                                                 |
| INTEGER  | likes                        | Number of likes on tweet                                                       |
| INTEGER  | poll\_card\_vote             | Number of votes on poll cards                                                  |
| INTEGER  | qualified\_impressions       | Number of qualified impressions on tweet                                       |
| INTEGER  | replies                      | Number of replies on tweet                                                     |
| INTEGER  | retweets                     | Number of retweets on tweet                                                    |
| INTEGER  | unfollows                    | Number of unfollows as a result of the tweet                                   |
| INTEGER  | url\_clicks                  | Number of clicks on URLs in tweet                                              |
| INTEGER  | video\_15\_s\_views          | Number of 15-second views on video                                             |
| INTEGER  | video\_3\_s\_100\_pct\_views | Total number of views where at least 3 seconds were played while 100% in view. |
| INTEGER  | video\_6\_s\_views           | Number of 6-second views on video                                              |
| INTEGER  | video\_content\_starts       | Number of times the video content started                                      |
| INTEGER  | video\_cta\_clicks           | Number of clicks on tweet call-to-actions                                      |
| INTEGER  | video\_total\_views          | Total number of views on video                                                 |
| INTEGER  | video\_views\_100            | Total number of views where at least 100% of the video was viewed.             |
| INTEGER  | video\_views\_25             | Total number of views where at least 25% of the video was viewed.              |
| INTEGER  | video\_views\_50             | Total number of views where at least 50% of the video was viewed.              |
| INTEGER  | video\_views\_75             | Total number of views where at least 75% of the video was viewed.              |


---

# 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-organic-tweets.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.