Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Sprout Social connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Sprout Social connector:
Customer Tags
Get the list of message tags created in Sprout Social. It includes all active and archived tags, regardless of when the tag was created. For more information, see Customer Tags Endpoint.
Fields
| Field Name | Data Type |
|---|---|
tag_id | NUMERIC |
any_group | BOOLEAN |
text | STRING |
groups | STRING |
active | BOOLEAN |
Customer Groups
Get the list of groups created in Sprout Social. For more information, see Customer Groups Endpoint.
Fields
| Field Name | Data Type |
|---|---|
group_id | NUMERIC |
name | STRING |
Customer Users
Get the list of users that are active for your customer. For more information, see Customer Users Endpoint.
Fields
| Field Name | Data Type |
|---|---|
id | NUMERIC |
name | STRING |
Customer Profile
Get the list of customer profile IDs you have access to. For more information, see Customer Profiles Endpoint.
Fields
| Field Name | Data Type |
|---|---|
customer_profile_id | NUMERIC |
network_type | STRING |
name | STRING |
native_name | STRING |
link | STRING |
native_id | STRING |
groups | STRING |
Analytics Posts
Used to query for individual sent posts based on specific filter criteria. For more information, see Post Analytics Endpoint.
Fields
| Field Name | Data Type |
|---|---|
text | STRING |
perma_link | STRING |
sent | BOOLEAN |
created_time | TIMESTAMP |
Metrics
For more information, see Metrics & Fields.
| Field Name | Data Type |
|---|---|
lifetime.comments_count | NUMERIC |
lifetime.impressions | NUMERIC |
lifetime.impressions_organic | NUMERIC |
lifetime.impressions_organic_unique | NUMERIC |
lifetime.impressions_unique | NUMERIC |
lifetime.story_taps_back | NUMERIC |
lifetime.story_taps_forward | NUMERIC |
lifetime.story_exits | NUMERIC |
lifetime.likes | NUMERIC |
lifetime.saves | NUMERIC |
lifetime.shares_count | NUMERIC |
lifetime.reactions | NUMERIC |
lifetime.video_views | NUMERIC |
lifetime.video_views_organic | NUMERIC |
lifetime.post_content_clicks | NUMERIC |
lifetime.post_content_clicks_other | NUMERIC |
lifetime.impressions_paid_unique | NUMERIC |
lifetime.impressions_paid | NUMERIC |
video_length | NUMERIC |
lifetime.video_views_p95 | NUMERIC |
lifetime.video_views_30s_complete | NUMERIC |
lifetime.video_views_partial_paid | NUMERIC |
lifetime.video_views_p95_organic | NUMERIC |
lifetime.video_views_p95_paid | NUMERIC |
lifetime.video_views_paid | NUMERIC |
lifetime.video_views_partial_organic | NUMERIC |
lifetime.video_views_partial | NUMERIC |
lifetime.video_views_partial_autoplay | NUMERIC |
lifetime.post_activity_unique | NUMERIC |
lifetime.question_answers_unique | NUMERIC |
lifetime.comments_count_unique | NUMERIC |
lifetime.reactions_unique | NUMERIC |
lifetime.shares_count_unique | NUMERIC |
lifetime.engagements_follower_unique | NUMERIC |
lifetime.engagements_unique | NUMERIC |
lifetime.impressions_follower | NUMERIC |
lifetime.impressions_follower_paid | NUMERIC |
lifetime.impressions_follower_paid_unique | NUMERIC |
lifetime.impressions_follower_unique | NUMERIC |
lifetime.impressions_follower_organic | NUMERIC |
lifetime.impressions_nonfollower | NUMERIC |
lifetime.impressions_nonfollower_organic | NUMERIC |
lifetime.impressions_nonfollower_paid | NUMERIC |
lifetime.impressions_nonviral | NUMERIC |
lifetime.impressions_nonviral_unique | NUMERIC |
lifetime.impressions_viral | NUMERIC |
lifetime.impressions_viral_unique | NUMERIC |
lifetime.negative_feedback | NUMERIC |
lifetime.negative_feedback_unique | NUMERIC |
lifetime.post_video_play_clicks | NUMERIC |
lifetime.post_content_clicks_unique | NUMERIC |
lifetime.post_other_clicks_unique | NUMERIC |
lifetime.post_video_play_clicks_unique | NUMERIC |
lifetime.question_answers | NUMERIC |
lifetime.reactions_angry | NUMERIC |
lifetime.reactions_haha | NUMERIC |
lifetime.reactions_love | NUMERIC |
lifetime.reactions_sad | NUMERIC |
lifetime.reactions_wow | NUMERIC |
lifetime.video_view_time_per_view | NUMERIC |
lifetime.video_view_time | NUMERIC |
lifetime.video_view_time_organic | NUMERIC |
lifetime.video_views_10s | NUMERIC |
lifetime.video_views_10s_autoplay | NUMERIC |
lifetime.video_views_10s_click_to_play | NUMERIC |
lifetime.video_views_10s_organic | NUMERIC |
lifetime.video_views_10s_paid | NUMERIC |
lifetime.video_views_10s_sound_on | NUMERIC |
lifetime.video_views_10s_unique | NUMERIC |
lifetime.video_views_autoplay | NUMERIC |
lifetime.video_views_click_to_play | NUMERIC |
lifetime.video_views_30s_complete_autoplay | NUMERIC |
lifetime.video_views_30s_complete_click_to_play | NUMERIC |
lifetime.video_views_30s_complete_unique | NUMERIC |
lifetime.video_views_30s_complete_organic | NUMERIC |
lifetime.video_views_p95_organic_unique | NUMERIC |
lifetime.video_views_30s_complete_paid | NUMERIC |
lifetime.video_views_p95_paid_unique | NUMERIC |
lifetime.video_views_organic_unique | NUMERIC |
lifetime.video_views_paid_unique | NUMERIC |
lifetime.video_views_sound_on | NUMERIC |
lifetime.video_views_unique | NUMERIC |
lifetime.video_views_sound_off | NUMERIC |
lifetime.video_views_10s_sound_off | NUMERIC |
lifetime.video_view_time_paid | NUMERIC |
lifetime.video_views_partial_click_to_play | NUMERIC |
lifetime.post_photo_view_clicks | NUMERIC |
lifetime.post_photo_view_clicks_unique | NUMERIC |
lifetime.post_link_clicks | NUMERIC |
lifetime.post_link_clicks_unique | NUMERIC |
lifetime.video_views_p100_per_view | NUMERIC |
lifetime.impression_source_for_you | NUMERIC |
lifetime.impression_source_follow | NUMERIC |
lifetime.impression_source_hashtag | NUMERIC |
lifetime.impression_source_personal_profile | NUMERIC |
lifetime.impression_source_sound | NUMERIC |
lifetime.impression_source_unspecified | NUMERIC |
Analytics Profile
Used to query profile-level metrics for a given set of profiles. For more information, see Owned Profile Analytics Endpoint.
Note: This table in Daton doesn't support any primary key.
Fields
| Field Name | Data Type |
|---|---|
dimensions | RECORD |
Metrics
For more information, see Metrics & Fields.
| Field Name | Data Type |
|---|---|
impressions | NUMERIC |
reactions | NUMERIC |
lifetime_snapshot.followers_count | NUMERIC |
net_follower_growth | NUMERIC |
post_media_views | NUMERIC |
video_views | NUMERIC |
likes | NUMERIC |
comments_count | NUMERIC |
shares_count | NUMERIC |
post_content_clicks | NUMERIC |
post_link_clicks | NUMERIC |
post_content_clicks_other | NUMERIC |
post_media_clicks | NUMERIC |
post_hashtag_clicks | NUMERIC |
post_detail_expand_clicks | NUMERIC |
post_profile_clicks | NUMERIC |
engagements_other | NUMERIC |
post_app_engagements | NUMERIC |
post_app_installs | NUMERIC |
post_app_opens | NUMERIC |
posts_sent_count | NUMERIC |
posts_sent_by_post_type | RECORD |
posts_sent_by_content_type | RECORD |
followers_gained | NUMERIC |
followers_gained_organic | NUMERIC |
followers_gained_paid | NUMERIC |
followers_lost | NUMERIC |
impressions_organic | NUMERIC |
impressions_viral | NUMERIC |
impressions_nonviral | NUMERIC |
impressions_paid | NUMERIC |
tab_views | NUMERIC |
tab_views_login | NUMERIC |
tab_views_logout | NUMERIC |
post_impressions | NUMERIC |
post_impressions_organic | NUMERIC |
post_impressions_viral | NUMERIC |
post_impressions_nonviral | NUMERIC |
post_impressions_paid | NUMERIC |
impressions_unique | NUMERIC |
impressions_organic_unique | NUMERIC |
impressions_viral_unique | NUMERIC |
impressions_nonviral_unique | NUMERIC |
impressions_paid_unique | NUMERIC |
profile_views | NUMERIC |
profile_views_login | NUMERIC |
profile_views_logout | NUMERIC |
profile_views_login_unique | NUMERIC |
reactions_love | NUMERIC |
reactions_haha | NUMERIC |
reactions_wow | NUMERIC |
reactions_sad | NUMERIC |
reactions_angry | NUMERIC |
post_photo_view_clicks | NUMERIC |
post_video_play_clicks | NUMERIC |
profile_actions | NUMERIC |
post_engagements | NUMERIC |
cta_clicks_login | NUMERIC |
question_answers | RECORD |
offer_claims | NUMERIC |
positive_feedback_other | NUMERIC |
event_rsvps | NUMERIC |
place_checkins | NUMERIC |
place_checkins_mobile | NUMERIC |
profile_content_activity | NUMERIC |
negative_feedback | NUMERIC |
video_views_organic | NUMERIC |
video_views_paid | NUMERIC |
video_views_autoplay | NUMERIC |
video_views_click_to_play | NUMERIC |
video_views_repeat | NUMERIC |
video_view_time | NUMERIC |
video_views_unique | NUMERIC |
video_views_30s_complete | NUMERIC |
video_views_30s_complete_organic | NUMERIC |
video_views_30s_complete_paid | NUMERIC |
video_views_30s_complete_autoplay | NUMERIC |
video_views_30s_complete_click_to_play | NUMERIC |
video_views_30s_complete_repeat | NUMERIC |
video_views_30s_complete_unique | NUMERIC |
video_views_partial | NUMERIC |
video_views_partial_organic | NUMERIC |
video_views_partial_paid | NUMERIC |
video_views_partial_autoplay | NUMERIC |
video_views_partial_click_to_play | NUMERIC |
video_views_partial_repeat | NUMERIC |
video_views_10s | NUMERIC |
video_views_10s_organic | NUMERIC |
video_views_10s_paid | NUMERIC |
video_views_10s_autoplay | NUMERIC |
video_views_10s_click_to_play | NUMERIC |
video_views_10s_repeat | NUMERIC |
video_views_10s_unique | NUMERIC |
lifetime_snapshot.following_count | NUMERIC |
net_following_growth | NUMERIC |
profile_views_unique | NUMERIC |
saves | NUMERIC |
story_replies | NUMERIC |
email_contacts | NUMERIC |
get_directions_clicks | NUMERIC |
phone_call_clicks | NUMERIC |
text_message_clicks | NUMERIC |
website_clicks | NUMERIC |
pin_count | NUMERIC |
inbox_counts_sent | RECORD |
inbox_received_sent | NUMERIC |
comments_count_total | NUMERIC |
lifetime_snapshot.followers_by_country | RECORD |
lifetime_snapshot.followers_by_gender | RECORD |
lifetime_snapshot.followers_online | NUMERIC |
likes_total | NUMERIC |
profile_views_total | NUMERIC |
shares_count_total | NUMERIC |
video_views_total | NUMERIC |
Messages
Provides detailed data and metadata about your Sprout Social messages. For more information, see Messages Endpoint.
Fields
| Field Name | Data Type |
|---|---|
network | STRING |
activity_metadata.first_like.time_elapsed | ARRAY<MAP> |
created_time | DATE |
post_category | STRING |
post_type | STRING |
perma_link | STRING |
text | STRING |
from | MAP |
profile_guid | STRING |
internal.tags.id | ARRAY<NUMBER> |
internal.sent_by.id | NUMBER |
internal.sent_by.email | STRING |
content_category | STRING |
from.guid | STRING |
from.name | STRING |
from.profile_picture | STRING |
from.screen_name | STRING |
guid | STRING |
customer_profile_id | STRING |
internal | MAP |
internal.sent_by.first_name | STRING |
internal.sent_by.last_name | STRING |
sent | BOOLEAN |
inbox_permalink | STRING |
title | STRING |
clickthrough_link | MAP |
clickthrough_link.name | STRING |
clickthrough_link.long | STRING |
clickthrough_link.short | STRING |
hashtags | ARRAY<STRING> |
visual_media | ARRAY<MAP> |
pinterest.board_name | STRING |
activity_metadata | ARRAY<MAP> |
Last updated