# Facebook Pages: Posts Report

## Description

* Each record represents the daily performance of a Facebook post.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/facebook/resources/facebook.svg" alt="" data-size="line"> Facebook Pages

## Columns

| Type    | Name                      | Description                                                                                                                                                                                                                                |
| ------- | ------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| STRING  | created\_timestamp        | The time the post was initially published. For a post about a life event, this is the date and time of the life event.                                                                                                                     |
| STRING  | post\_id                  | The ID of the post.                                                                                                                                                                                                                        |
| STRING  | post\_message             | The status message in the post.                                                                                                                                                                                                            |
| STRING  | post\_url                 | The URL of the post.                                                                                                                                                                                                                       |
| INTEGER | page\_id                  | The ID of the page that posted the post.                                                                                                                                                                                                   |
| STRING  | page\_name                | The name of the page that posted the post.                                                                                                                                                                                                 |
| STRING  | date\_day                 | The date of the metric performance.                                                                                                                                                                                                        |
| INTEGER | clicks                    | The number of times the post was clicked.                                                                                                                                                                                                  |
| INTEGER | impressions               | The number of times the post was shown to users.                                                                                                                                                                                           |
| INTEGER | video\_avg\_time\_watched | The average amount of time users watched the video.                                                                                                                                                                                        |
| INTEGER | video\_view\_time         | The total amount of time users watched the video.                                                                                                                                                                                          |
| INTEGER | video\_views              | The number of times users watched the video.                                                                                                                                                                                               |
| INTEGER | video\_views\_10s         | The number of times your Page's videos played for at least 10 seconds, or for nearly their total length if they're shorter than 10 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. |
| INTEGER | video\_views\_15s         | The total number of views on the post longer than 15 seconds                                                                                                                                                                               |
| INTEGER | likes                     | The total amount of reactions with type 'like' on the post                                                                                                                                                                                 |
| STRING  | source\_relation          | The source of the record, if the unioning functionality is being used.                                                                                                                                                                     |
| BOOLEAN | is\_most\_recent\_record  | Boolean indicating if the record is the most recent record of the post.                                                                                                                                                                    |


---

# 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/facebook-pages-posts-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.