# Social Media Reporting: Rollup Report

## Description

* Each record represents a post from a social media account

## Supported Data Sources

* <img src="https://fivetran.com/integrations/facebook/resources/facebook.svg" alt="" data-size="line"> Facebook Pages
* <img src="https://fivetran.com/integrations/linkedin/resources/linkedin_company_pages.svg" alt="" data-size="line"> LinkedIn Company Pages
* <img src="https://fivetran.com/integrations/instagram/resources/instagram.png" alt="" data-size="line"> Instagram Business
* <img src="https://fivetran.com/integrations/twitter/resources/twitter_ads.svg" alt="" data-size="line"> Twitter Organic

## Columns

| Type     | Name                    | Description                                                            |
| -------- | ----------------------- | ---------------------------------------------------------------------- |
| STRING   | \_dbt\_source\_relation |                                                                        |
| DATETIME | created\_timestamp      | The timestamp the post was created                                     |
| STRING   | post\_id                | The ID of the post, from the source platform                           |
| STRING   | post\_message           | The message of the post                                                |
| STRING   | page\_id                | The ID of the page, from the source platform                           |
| STRING   | page\_name              | The name of the page, from the source platform                         |
| STRING   | post\_url               | The URL of the post                                                    |
| STRING   | source\_relation        | The source of the record, if the unioning functionality is being used. |
| STRING   | platform                | The platform the post comes from                                       |
| INTEGER  | clicks                  | The number of clicks on the post                                       |
| INTEGER  | impressions             | The number of impressions on the post                                  |
| INTEGER  | likes                   | The number of likes on the post                                        |
| INTEGER  | shares                  | The number of shares on the post                                       |
| INTEGER  | comments                | The number of comments on 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/social-media-reporting-rollup-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.