Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| PAGE | Username | username | dim | The alias of the page. e.g. for www.facebook.com/platform the username is 'platform' |
| Name (Profile) | name | dim | Name of the page | |
| Category | category | dim | The page's category. e.g. Product/Service, Computers/Technology | |
| Description | description | dim | The description of the page | |
| Description (translated) | description_translated | dim | The description of the page | |
| General info | general_info | dim | General information provided by the page | |
| About | about | dim | Information about the page | |
| Company overview | company_overview | dim | The company overview. Applicable to company pages | |
| Company overview (translated) | company_overview_translated | dim | The company overview. Applicable to company pages | |
| Link to page | link | dim | The page's Facebook URL | |
| Website | website | dim | The URL of the page's website | |
| Phone | phone | dim | Phone number | |
| Page ID | page_id | dim | Page ID | |
| Awards | awards | dim | The awards information of the film. Applicable to films pages | |
| Year founded | founded | dim | When the company was founded. Applicable to pages in the company category | |
| Products | products | dim | Product list of the company. Applicable to company pages | |
| Mission | mission | dim | Page mission | |
| LOCATION | Location | location_name | dim | Location name |
| Country | location_country | dim | Country | |
| Country code | location_country_code | dim | Country code | |
| City | location_city | dim | City | |
| City ID | location_city_id | dim | City ID | |
| State | location_state | dim | State | |
| Region | location_region | dim | Region | |
| Region ID | location_region_id | dim | Region ID. Specifies a geographic region, such as California | |
| Street address | location_street | dim | Street address | |
| Zip code | location_zip | dim | Zip code | |
| Located in (ID) | location_located_in | dim | The parent location if the location is located within another location | |
| Latitude | location_latitude | dim | Latitude | |
| Longitude | location_longitude | dim | Longitude | |
| Coordinates | location_coordinates | dim | Geographic coordinates (latitude & longitude) | |
| MISCELLANEOUS | Cover link | cover_source | dim | Direct URL for the page's cover photo image |
| Is community page | is_community_page | dim | Indicates whether the page is a community page | |
| Users can post | can_post | dim | Whether the current session user can post on the page | |
| Has added app | has_added_app | dim | Indicates whether the page has added the app making the query in a page tab | |
| Is the page published | is_published | dim | Indicates whether the page is published and visible to non-admins | |
| Is the page verified | is_verified | dim | Indicates whether the page is verified | |
| Name with location descriptor | name_with_location_descriptor | dim | The name of the page with its location and/or global brand descriptor. Only visible to a page admin | |
| PAGE | Likes | fan_count | met | Number of users who like the page. For global pages this is the count for all pages across the brand |
| Page followers | followers_count | met | Number of page followers | |
| Talking about | talking_about_count | met | Number of people talking about the page | |
| Checkins | checkins | met | Number of checkins at a place represented by a page | |
| TIME | Created time | created_time | dim | The time the post was initially published. For a post about a life event, it will be the date & time of the life event |
| Created date | created_date | dim | The date the post was initially published | |
| Updated time | updated_time | dim | Time when the post was created, edited, or commented upon | |
| Updated date | updated_date | dim | Date when the post was created, edited, or commented upon | |
| PAGE | Name (Profile) | name | dim | Name of the page |
| Description | description | dim | The description of the page | |
| Description (translated) | description_translated | dim | The description of the page | |
| Link to page | link | dim | The page's Facebook URL | |
| POST | Post ID | post_id | dim | Post ID |
| Post type | status_type | dim | Post type | |
| Link to post | permalink_url | dim | URL to the permalink page of the post | |
| Content type | type | dim | Indicates the object type of the post | |
| From user ID | from_id | dim | The ID of the user account for the post | |
| From user | from_name | dim | The full name of the user account for the post | |
| Story | story | dim | Text from stories not intentionally generated by users, e.g. when someone else posts on the person's wall | |
| Picture URL | picture | dim | The picture scraped from any link included with the post | |
| Picture URL (full) | full_picture | dim | URL to a higher-quality image used in the post, up to 720x720 in size | |
| Caption | caption | dim | Link caption in post that appears below name | |
| Message | message | dim | The status message in the post | |
| Place | place | dim | Any location information attached to the post | |
| Content source | source | dim | URL to any Flash movie or video file attached to the post | |
| Post link | post_link | dim | The link attached to the post | |
| Application used to post | application_name | dim | The app name the post was published by | |
| Application link | application_link | dim | Link to the app the post was published by | |
| Application category | application_category | dim | Category of the app the post was published by | |
| Story tags | story_tags | dim | List of profiles tagged in the message/story text | |
| POST METRICS | Posts | posts | met | Posts |
| Likes | likes_count | met | Total count post likes | |
| Reactions: Love | reactions_love | met | Total "Love" reactions | |
| Reactions: Wow | reactions_wow | met | Total "Wow" reactions | |
| Reactions: Haha | reactions_haha | met | Total "Haha" reactions | |
| Reactions: Sad | reactions_sad | met | Total "Sad" reactions | |
| Reactions: Angry | reactions_angry | met | Total "Angry" reactions | |
| Reactions: Thankful | reactions_thankful | met | Total "Thankful" reactions | |
| Reactions: Pride | reactions_pride | met | Total "Pride" reactions | |
| Reactions | reactions_count | met | Total count of reactions to the post | |
| Comments | comments_count | met | Total count of comments on the post | |
| Post shares | shares_count | met | Count of post shares | |
| Likes per post | likesPerPost | met | Count of likes per post | |
| Reactions per post | reactionsPerPost | met | Count of reactions per post | |
| Comments per post | commentsPerPost | met | Count of comments per post | |
| Shares per post | sharesPerPost | met | Count of shares per post | |
| TIME | Updated time | og_object_updated_time | dim | URL updated time |
| URL | URL | url | dim | URL |
| URL ID | og_object_id | dim | URL ID | |
| Title | og_object_title | dim | URL title | |
| Type | og_object_type | dim | URL type | |
| Description | og_object_description | dim | URL description | |
| URL METRICS | Comments | comment_count | met | URL comment counts |
| Shares | share_count | met | URL share counts | |
| Reactions | reaction_count | met | URL reaction counts | |
| Comment plugins | comment_plugin_count | met | URL comment plugins counts |