---
title: "Smarp data warehouse table groups"
slug: "smarp-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Smarp. See all the tables and the fields included in them."
updated: 2026-03-05T14:14:34Z
published: 2026-03-05T14:14:34Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Smarp data warehouse table groups

Search fields<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### Table: CLICK

| \| clicks__count** \| \| --- \| \| \\| Display name \\| Click count \\| \\| --- \\| --- \\| \\| Description \\| Number of times the shared post was clicked. Note that Smarp only counts unique clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Click count \| \| Description \| Number of times the shared post was clicked. Note that Smarp only counts unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| --- |
| clicks__count** |
| \| Display name \| Click count \| \| --- \| --- \| \| Description \| Number of times the shared post was clicked. Note that Smarp only counts unique clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Click count |
| Description | Number of times the shared post was clicked. Note that Smarp only counts unique clicks |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| clicks__created_at** \| \| --- \| \| \\| Display name \\| Click created at \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the click was performed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Click created at \| \| Description \| Date and time when the click was performed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| clicks__created_at** |
| \| Display name \| Click created at \| \| --- \| --- \| \| Description \| Date and time when the click was performed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Click created at |
| Description | Date and time when the click was performed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| clicks__id** \| \| --- \| \| \\| Display name \\| Click ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Click ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__id** |
| \| Display name \| Click ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Click ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__post_id** \| \| --- \| \| \\| Display name \\| Post ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the post \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Post ID \| \| Description \| ID of the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__post_id** |
| \| Display name \| Post ID \| \| --- \| --- \| \| Description \| ID of the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Post ID |
| Description | ID of the post |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__posts__campaigns__id** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__posts__campaigns__id** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__posts__campaigns__name** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__posts__campaigns__name** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Name of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__sharer_id** \| \| --- \| \| \\| Display name \\| Sharer ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the sharer \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Sharer ID \| \| Description \| ID of the sharer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__sharer_id** |
| \| Display name \| Sharer ID \| \| --- \| --- \| \| Description \| ID of the sharer \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Sharer ID |
| Description | ID of the sharer |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__social_network** \| \| --- \| \| \\| Display name \\| Social network \\| \\| --- \\| --- \\| \\| Description \\| Social network where the click was performed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Social network \| \| Description \| Social network where the click was performed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__social_network** |
| \| Display name \| Social network \| \| --- \| --- \| \| Description \| Social network where the click was performed \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Social network |
| Description | Social network where the click was performed |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__users__id** \| \| --- \| \| \\| Display name \\| User ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__users__id** |
| \| Display name \| User ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: POST

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| posts__count** \| \| --- \| \| \\| Display name \\| Post count \\| \\| --- \\| --- \\| \\| Description \\| Number of posts. Note that posts that were published in private channels are not counted \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Post count \| \| Description \| Number of posts. Note that posts that were published in private channels are not counted \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| posts__count** |
| \| Display name \| Post count \| \| --- \| --- \| \| Description \| Number of posts. Note that posts that were published in private channels are not counted \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Post count |
| Description | Number of posts. Note that posts that were published in private channels are not counted |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| posts__date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| posts__date** |
| \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| posts__id** \| \| --- \| \| \\| Display name \\| Post ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Post ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| posts__id** |
| \| Display name \| Post ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Post ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| posts__published_at** \| \| --- \| \| \\| Display name \\| Post published at \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the post was published \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Post published at \| \| Description \| Date and time when the post was published \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| posts__published_at** |
| \| Display name \| Post published at \| \| --- \| --- \| \| Description \| Date and time when the post was published \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Post published at |
| Description | Date and time when the post was published |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| posts__title** \| \| --- \| \| \\| Display name \\| Post title \\| \\| --- \\| --- \\| \\| Description \\| Title of the post \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Post title \| \| Description \| Title of the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| posts__title** |
| \| Display name \| Post title \| \| --- \| --- \| \| Description \| Title of the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Post title |
| Description | Title of the post |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| posts__type** \| \| --- \| \| \\| Display name \\| Post type \\| \\| --- \\| --- \\| \\| Description \\| Type shows whether the post is e.g. link, article, image or video post \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Post type \| \| Description \| Type shows whether the post is e.g. link, article, image or video post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| posts__type** |
| \| Display name \| Post type \| \| --- \| --- \| \| Description \| Type shows whether the post is e.g. link, article, image or video post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Post type |
| Description | Type shows whether the post is e.g. link, article, image or video post |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| posts__url** \| \| --- \| \| \\| Display name \\| Post url \\| \\| --- \\| --- \\| \\| Description \\| URL of the post \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Post url \| \| Description \| URL of the post \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| posts__url** |
| \| Display name \| Post url \| \| --- \| --- \| \| Description \| URL of the post \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Post url |
| Description | URL of the post |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |

### Table: SHARE

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shares__comment_count** \| \| --- \| \| \\| Display name \\| Share comment count \\| \\| --- \\| --- \\| \\| Description \\| Number of comments the shared post has received. Note that Smarp gathers comments from posts for up to a week since it was shared \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Share comment count \| \| Description \| Number of comments the shared post has received. Note that Smarp gathers comments from posts for up to a week since it was shared \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| shares__comment_count** |
| \| Display name \| Share comment count \| \| --- \| --- \| \| Description \| Number of comments the shared post has received. Note that Smarp gathers comments from posts for up to a week since it was shared \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Share comment count |
| Description | Number of comments the shared post has received. Note that Smarp gathers comments from posts for up to a week since it was shared |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| shares__count** \| \| --- \| \| \\| Display name \\| Share count \\| \\| --- \\| --- \\| \\| Description \\| Number of unique times the post has been shared in social media \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Share count \| \| Description \| Number of unique times the post has been shared in social media \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| shares__count** |
| \| Display name \| Share count \| \| --- \| --- \| \| Description \| Number of unique times the post has been shared in social media \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Share count |
| Description | Number of unique times the post has been shared in social media |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| shares__id** \| \| --- \| \| \\| Display name \\| Share ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Share ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shares__id** |
| \| Display name \| Share ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Share ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shares__like_count** \| \| --- \| \| \\| Display name \\| Share like count \\| \\| --- \\| --- \\| \\| Description \\| Number of likes the shared post has received. Note that Smarp gathers likes from posts for up to a week since it was shared \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Share like count \| \| Description \| Number of likes the shared post has received. Note that Smarp gathers likes from posts for up to a week since it was shared \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| shares__like_count** |
| \| Display name \| Share like count \| \| --- \| --- \| \| Description \| Number of likes the shared post has received. Note that Smarp gathers likes from posts for up to a week since it was shared \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Share like count |
| Description | Number of likes the shared post has received. Note that Smarp gathers likes from posts for up to a week since it was shared |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| shares__post_id** \| \| --- \| \| \\| Display name \\| Post ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the post \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Post ID \| \| Description \| ID of the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shares__post_id** |
| \| Display name \| Post ID \| \| --- \| --- \| \| Description \| ID of the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Post ID |
| Description | ID of the post |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shares__posts__campaigns__id** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shares__posts__campaigns__id** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shares__posts__campaigns__name** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shares__posts__campaigns__name** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Name of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shares__resharer_count** \| \| --- \| \| \\| Display name \\| Resharer count \\| \\| --- \\| --- \\| \\| Description \\| Number of times the shared post was retweeted or otherwise reshared \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Resharer count \| \| Description \| Number of times the shared post was retweeted or otherwise reshared \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| shares__resharer_count** |
| \| Display name \| Resharer count \| \| --- \| --- \| \| Description \| Number of times the shared post was retweeted or otherwise reshared \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Resharer count |
| Description | Number of times the shared post was retweeted or otherwise reshared |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| shares__shared_at** \| \| --- \| \| \\| Display name \\| Shared at \\| \\| --- \\| --- \\| \\| Description \\| Date and time when the post was shared, e.g. 2019-08-24T14:15:22Z \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Shared at \| \| Description \| Date and time when the post was shared, e.g. 2019-08-24T14:15:22Z \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| shares__shared_at** |
| \| Display name \| Shared at \| \| --- \| --- \| \| Description \| Date and time when the post was shared, e.g. 2019-08-24T14:15:22Z \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Shared at |
| Description | Date and time when the post was shared, e.g. 2019-08-24T14:15:22Z |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| shares__sharer_id** \| \| --- \| \| \\| Display name \\| Sharer ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the user who shared the post \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Sharer ID \| \| Description \| ID of the user who shared the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shares__sharer_id** |
| \| Display name \| Sharer ID \| \| --- \| --- \| \| Description \| ID of the user who shared the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Sharer ID |
| Description | ID of the user who shared the post |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shares__social_network** \| \| --- \| \| \\| Display name \\| Share social network \\| \\| --- \\| --- \\| \\| Description \\| Name of the social network where the post was shared, e.g. LinkedIn or Facebook \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Share social network \| \| Description \| Name of the social network where the post was shared, e.g. LinkedIn or Facebook \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shares__social_network** |
| \| Display name \| Share social network \| \| --- \| --- \| \| Description \| Name of the social network where the post was shared, e.g. LinkedIn or Facebook \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Share social network |
| Description | Name of the social network where the post was shared, e.g. LinkedIn or Facebook |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| shares__unique_click_count** \| \| --- \| \| \\| Display name \\| Share unique click count \\| \\| --- \\| --- \\| \\| Description \\| Number of unique clicks on the shared post. No clicks are recorded for image posts \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Share unique click count \| \| Description \| Number of unique clicks on the shared post. No clicks are recorded for image posts \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| shares__unique_click_count** |
| \| Display name \| Share unique click count \| \| --- \| --- \| \| Description \| Number of unique clicks on the shared post. No clicks are recorded for image posts \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Share unique click count |
| Description | Number of unique clicks on the shared post. No clicks are recorded for image posts |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| shares__users__id** \| \| --- \| \| \\| Display name \\| User ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| shares__users__id** |
| \| Display name \| User ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: CAMPAIGN

| \| campaigns__id** \| \| --- \| \| \\| Display name \\| Campaign ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| campaigns__id** |
| \| Display name \| Campaign ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| campaigns__name** \| \| --- \| \| \\| Display name \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Campaign name \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| campaigns__name** |
| \| Display name \| Campaign name \| \| --- \| --- \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Campaign name |
| Description | Name of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: USER

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| users__count** \| \| --- \| \| \\| Display name \\| User count \\| \\| --- \\| --- \\| \\| Description \\| Number of Smarp users \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| User count \| \| Description \| Number of Smarp users \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| users__count** |
| \| Display name \| User count \| \| --- \| --- \| \| Description \| Number of Smarp users \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | User count |
| Description | Number of Smarp users |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| users__first_name** \| \| --- \| \| \\| Display name \\| User first name \\| \\| --- \\| --- \\| \\| Description \\| First name of the user \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User first name \| \| Description \| First name of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| users__first_name** |
| \| Display name \| User first name \| \| --- \| --- \| \| Description \| First name of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User first name |
| Description | First name of the user |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| users__group_id** \| \| --- \| \| \\| Display name \\| User group ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the group to which the user belongs to \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User group ID \| \| Description \| ID of the group to which the user belongs to \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| users__group_id** |
| \| Display name \| User group ID \| \| --- \| --- \| \| Description \| ID of the group to which the user belongs to \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User group ID |
| Description | ID of the group to which the user belongs to |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| users__groups__name** \| \| --- \| \| \\| Display name \\| Group name \\| \\| --- \\| --- \\| \\| Description \\| Name of the group, e.g. based on geography or departments \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Group name \| \| Description \| Name of the group, e.g. based on geography or departments \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| users__groups__name** |
| \| Display name \| Group name \| \| --- \| --- \| \| Description \| Name of the group, e.g. based on geography or departments \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Group name |
| Description | Name of the group, e.g. based on geography or departments |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| users__id** \| \| --- \| \| \\| Display name \\| User ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| users__id** |
| \| Display name \| User ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| users__last_name** \| \| --- \| \| \\| Display name \\| User last name \\| \\| --- \\| --- \\| \\| Description \\| Last name of the user \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User last name \| \| Description \| Last name of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| users__last_name** |
| \| Display name \| User last name \| \| --- \| --- \| \| Description \| Last name of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User last name |
| Description | Last name of the user |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| users__linkedin_connections** \| \| --- \| \| \\| Display name \\| LinkedIn connections \\| \\| --- \\| --- \\| \\| Description \\| The amount of LinkedIn connections user has \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| LinkedIn connections \| \| Description \| The amount of LinkedIn connections user has \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| users__linkedin_connections** |
| \| Display name \| LinkedIn connections \| \| --- \| --- \| \| Description \| The amount of LinkedIn connections user has \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | LinkedIn connections |
| Description | The amount of LinkedIn connections user has |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| users__phone_number** \| \| --- \| \| \\| Display name \\| User phone number \\| \\| --- \\| --- \\| \\| Description \\| Phone number of the user \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User phone number \| \| Description \| Phone number of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| users__phone_number** |
| \| Display name \| User phone number \| \| --- \| --- \| \| Description \| Phone number of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User phone number |
| Description | Phone number of the user |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| users__total_connections** \| \| --- \| \| \\| Display name \\| Total connections \\| \\| --- \\| --- \\| \\| Description \\| The total amount of connections user has. This includes Twitter and LinkedIn \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Total connections \| \| Description \| The total amount of connections user has. This includes Twitter and LinkedIn \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| users__total_connections** |
| \| Display name \| Total connections \| \| --- \| --- \| \| Description \| The total amount of connections user has. This includes Twitter and LinkedIn \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Total connections |
| Description | The total amount of connections user has. This includes Twitter and LinkedIn |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| users__twitter_connections** \| \| --- \| \| \\| Display name \\| Twitter connections \\| \\| --- \\| --- \\| \\| Description \\| The amount of Twitter connections user has \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Twitter connections \| \| Description \| The amount of Twitter connections user has \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| users__twitter_connections** |
| \| Display name \| Twitter connections \| \| --- \| --- \| \| Description \| The amount of Twitter connections user has \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Twitter connections |
| Description | The amount of Twitter connections user has |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |

### Table: TEAM

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| teams__group_id** \| \| --- \| \| \\| Display name \\| Team group ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the team \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Team group ID \| \| Description \| ID of the team \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| teams__group_id** |
| \| Display name \| Team group ID \| \| --- \| --- \| \| Description \| ID of the team \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Team group ID |
| Description | ID of the team |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| teams__id** \| \| --- \| \| \\| Display name \\| Team ID \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Team ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| teams__id** |
| \| Display name \| Team ID \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Team ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| teams__name** \| \| --- \| \| \\| Display name \\| Team name \\| \\| --- \\| --- \\| \\| Description \\| Name of the team, e.g. Sales. Teams in Smarp can be used as a way to segment users \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Team name \| \| Description \| Name of the team, e.g. Sales. Teams in Smarp can be used as a way to segment users \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| teams__name** |
| \| Display name \| Team name \| \| --- \| --- \| \| Description \| Name of the team, e.g. Sales. Teams in Smarp can be used as a way to segment users \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Team name |
| Description | Name of the team, e.g. Sales. Teams in Smarp can be used as a way to segment users |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |