# Instagram Business: Posts

## Description

* Each record represents the daily performance of a post or story.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/instagram/resources/instagram.png" alt="" data-size="line"> Instagram Business

## Columns

| Type     | Name                          | Description                                                                                                                          |
| -------- | ----------------------------- | ------------------------------------------------------------------------------------------------------------------------------------ |
| STRING   | account\_name                 | The name of this user.                                                                                                               |
| INTEGER  | user\_id                      | The ID of this user.                                                                                                                 |
| INTEGER  | post\_caption                 | The caption of the post or story                                                                                                     |
| DATETIME | created\_timestamp            | The timestamp this post or story was created                                                                                         |
| INTEGER  | post\_id                      | The media ID of this post or story                                                                                                   |
| BOOLEAN  | is\_comment\_enabled          | Whether comments are enabled for this post or story                                                                                  |
| BOOLEAN  | is\_story                     | Whether this is a story                                                                                                              |
| STRING   | media\_type                   | Media type. Can be CAROUSEL\_ALBUM, IMAGE, or VIDEO.                                                                                 |
| STRING   | media\_url                    | Media URL. Will be omitted from responses if the media contains copyrighted material, or has been flagged for a copyright violation. |
| STRING   | post\_url                     | Permanent URL to the media.                                                                                                          |
| STRING   | shortcode                     | Shortcode to the media.                                                                                                              |
| INTEGER  | thumbnail\_url                | Media thumbnail URL. Only available on VIDEO media.                                                                                  |
| STRING   | username                      | Username of user who created the media.                                                                                              |
| INTEGER  | carousel\_album\_engagement   | Total number of likes and IG Comments on the album IG Media object.                                                                  |
| INTEGER  | carousel\_album\_impressions  | Total number of times the album IG Media object has been seen                                                                        |
| INTEGER  | carousel\_album\_reach        | Total number of unique Instagram accounts that have seen the album IG Media object.                                                  |
| INTEGER  | carousel\_album\_saved        | Total number of unique Instagram accounts that have saved the album IG Media object.                                                 |
| INTEGER  | carousel\_album\_video\_views | Total number of unique Instagram accounts that have viewed video IG Media within the album.                                          |
| INTEGER  | comment\_count                | Total number of comments on the IG Media object.                                                                                     |
| INTEGER  | like\_count                   | Total number of likes on the IG Media object.                                                                                        |
| INTEGER  | story\_exits                  | Number of times someone exited the story IG Media object.                                                                            |
| INTEGER  | story\_impressions            | Total number of times the story IG Media object has been seen.                                                                       |
| INTEGER  | story\_reach                  | Total number of unique Instagram accounts that have seen the story IG Media object.                                                  |
| INTEGER  | story\_replies                | Total number of replies to the story IG Media object.                                                                                |
| INTEGER  | story\_taps\_back             | Total number of taps to see this story IG Media object's next photo or video.                                                        |
| INTEGER  | story\_taps\_forward          | Total number of taps to see this story IG Media object's previous photo or video.                                                    |
| INTEGER  | video\_photo\_engagement      | Total number of likes and IG Comments on the video IG Media object.                                                                  |
| INTEGER  | video\_photo\_impressions     | Total number of times the video IG Media object has been seen.                                                                       |
| INTEGER  | video\_photo\_reach           | Total number of unique Instagram accounts that have seen the video IG Media object.                                                  |
| INTEGER  | video\_photo\_saved           | Total number of unique Instagram accounts that have saved the video IG Media object.                                                 |
| INTEGER  | video\_views                  | Total number of times the video IG Media object has been viewed.                                                                     |
| INTEGER  | reel\_comments                | Total number of comments on the reel IG Media object.                                                                                |
| INTEGER  | reel\_likes                   | Total number of likes on the reel IG Media object.                                                                                   |
| INTEGER  | reel\_plays                   | Total number of times the reel IG Media object has been played.                                                                      |
| INTEGER  | reel\_reach                   | Total number of unique Instagram accounts that have seen the reel IG Media object.                                                   |
| INTEGER  | reel\_shares                  | Total number of times the reel IG Media object has been shared.                                                                      |
| INTEGER  | reel\_total\_interactions     | Total number of interactions the reel IG Media object had.                                                                           |
| STRING   | source\_relation              | The source of the record, if the unioning functionality is being used.                                                               |


---

# 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/instagram-business-posts.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.
