
The connector only reads data. It never answers, classifies, tags or changes anything in Stilingue.
Before you start
- The API module must be contracted. Ask your Stilingue CSM to enable API access for the search (panel) you want to sync.
- One token per search. Stilingue creates the API token for one search, and the same token reads that search’s Listening, Owned Metrics and Smart Care. To sync several searches, create one Nekt source per search.
- Only a Master user can create the token. In Warroom, open Otimizar > Editar pesquisa (or
https://warroom.stilingue.com.br/editarpesquisa/ACCOUNT_ID/PANEL_ID), find the section Crie a API-Token para essa pesquisa and click Criar API-Token. If the section does not appear, the API module is not contracted for that search. - Stilingue may delete tokens that are not used for a while. If the sync log says the token was rejected, create a new one and update the source.
Configuring Stilingue as a Source
In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the Stilingue option from the list of connectors. Click Next and you’ll be prompted to add your access.1. Add account access
The following configurations are available:- API Token: The API token of the Stilingue search, created as described above.
- Start Date: The earliest date read on the first sync and on full syncs. We recommend at most 90 days back (see the tip below).
- Lookback Days (advanced, default 3): How many days before the last sync are read again on every sync, so late changes reach your tables (posts collected or reclassified later, Smart Care cases updated). Owned post metrics and owned daily charts are always refreshed for the last 30 days.
Once you’re done, click Next.
2. Select streams
Choose which data streams you want to sync. For faster extractions, select only the streams that are relevant to your analysis. You can select entire groups of streams or pick specific ones.Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
3. Configure data streams
Customize how you want your data to appear in your catalog. Select the desired layer where the data will be placed, a folder to organize it inside the layer, a name for each table (which will effectively contain the fetched data) and the type of sync.- Layer: choose between the existing layers on your catalog. This is where you will find your new extracted tables as the extraction runs successfully.
- Folder: a folder can be created inside the selected layer to group all tables being created from this new data source.
- Table name: we suggest a name, but feel free to customize it. You have the option to add a prefix to all tables at once and make this process faster!
- Sync Type: you can choose between INCREMENTAL and FULL_TABLE.
- Incremental: every time the extraction happens, we’ll get only the new data, which is good if, for example, you want to keep every record ever fetched.
- Full table: every time the extraction happens, we’ll get the current state of the data, which is good if, for example, you don’t want to have deleted data in your catalog.
4. Configure data source
Describe your data source for easy identification within your organization, not exceeding 140 characters. To define your Trigger, consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times). Optionally, you can define some additional settings:- Configure Delta Log Retention and determine for how long we should store old states of this table as it gets updated. Read more about this resource here.
- Determine when to execute an Additional Full Sync. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while.
5. Check your new source
You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.Streams and Fields
Available streams
The table below lists every stream and its slug (the exact identifier to pass when creating the source via API).Things to know
- Days. Daily tables have one row per Brasília calendar day (
report_date). Today is read too, and read again on the next sync. Each sync reads the last Lookback Days again, because Stilingue keeps collecting and classifying posts after they are published. - Owned metrics keep changing for 30 days. Stilingue updates post metrics for 30 days and credits interactions to the day the post was published, so
owned_postsandowned_page_daily_metricsre-read the last 30 days on every sync. - Owned charts per channel.
owned_page_daily_metricsreads, for Facebook pages: posts x interactions, fan base, organic and paid impressions, interactions, page likes, interaction rate, reach and engagement, activated posts, paid vs organic posts and the Facebook page metrics (Meta metric names, such aspage_impressions); for Instagram: posts x interactions, interactions volume, fan base, reach, impressions and views over time (split by post type) and story interactions (Instagram keeps only the last 30 days); for LinkedIn, YouTube, Twitter and TikTok: posts x interactions and interactions volume. A chart that Stilingue does not provide or does not allow for a page is left out (the sync log says so). Averages over a period shown in Warroom are not loaded; compute them from the daily rows. - Smart Care cases are figures of the day. Cases and conversations come from the Smart Care report of each day, so their key includes
report_date. Their status is the status when the report was read; days with cases still open are read again on later syncs (for up to 30 days) until those cases are closed or ignored. A case closed after that still appears insmartcare_status_changes, as the status change that closed it (on the day of the change); a Full sync also refreshes the older days ofsmartcare_casesandsmartcare_conversations. - Listening posts can be many. A search that collects a lot of posts produces a large
listening_poststable, and posts come back every time Stilingue updates their metrics. Select it only if you need the posts themselves; the daily report tables already summarize them. - Not available through the API. Benchmarks, and the Warroom charts that only rearrange data already in these tables (Onde/Quando estão falando, Ranking Evolutivo, Temas e Tópicos, Termos correlacionados), are not synced.
- Personal data. Stilingue removes some personal data of social network users for compliance (some fields are always empty). Smart Care tables include data of your customers (names, usernames, messages). Handle them according to your data protection policies.
Fields by stream
Below you’ll find all available data streams from Stilingue and their corresponding fields:Listening Posts
Listening Posts
Stream
listening_posts. Incremental on updated_at; key pid.pid- Unique identifier of the post (pid); comments, mentions and inbox messages are posts tooupdated_at- Last time Stilingue changed the post (metrics, classification, tags, annotations), from long_updated_atposted_at- When the post was published on the social network (UTC)crawled_at- When Stilingue collected the post (UTC)metrics_updated_at- Last time the post’s metrics were updated (UTC)long_posted_at- Publication time as a UNIX timestamp in millisecondslong_updated_at- Last update time as a UNIX timestamp in millisecondsaaa_score- Stilingue’s AAA score: relevance of the author as a potential influenceranonymous_user- Whether the author is anonymousattachments- Media attached to the post (videos, images): id, name, size, media_type, type, url, storage_url (JSON)channel- Source channel of the post (e.g. Twitter, Instagram, InstagramComments, Facebook, FacebookComments, YouTube, News, Blogs, Linkedin, Tiktok)primary_channel- Social network where the post was made (Twitter, Instagram, Facebook, YouTube, News, Blogs, Linkedin)title- Title of the post (may be empty)text- Text content of the posttext_append- Additional information about the post or interaction (e.g. ‘Comentado em: [video name]’ for YouTube comments)type- Type of the post: video, image, carrossel (Instagram only) or postlang- Language of the post: pt, en, espost_url- URL of the root postpost_id- Root post id when this post is an interaction on another post (e.g. a comment)root_id- Id of the root (main) publicationreply_pid- pid of the post this post replied to (for a reply to a comment, the comment’s pid)is_root- Whether this is the main message of the conversationuid- Identifier of the author (user) of the postusername- Username of the account that made the postname- Name of the author (available only for some channels)gender- Gender of the author: empty, Homem, Mulher or Marca (brand)verified- Whether the author’s account is verifiedfollowers- Number of followers of the author or pagelocation- Location of the authoruser_url- URL of the author’s accountuser_image_url- URL of the author’s profile picturepost_user_image_url- URL of the profile picture of the page that made the postimage_url- URL of the post’s imageurl_content- Direct URL of the post’s video (when type is video)comments- Number of comments on the postlikes- Number of likes on the postdislikes- Number of dislikes on the postshares- Number of shares of the postreactions- Number of reactions to the postinteractions- Total interactions on the post (comments, likes, shares, etc.)videoplays- Number of times the video was played (when type is video)reaction_like- Facebook ‘like’ reactionsreaction_love- Facebook ‘love’ reactionsreaction_haha- Facebook ‘haha’ reactionsreaction_wow- Facebook ‘wow’ reactionsreaction_sad- Facebook ‘sad’ reactionsreaction_angry- Facebook ‘angry’ reactionsreaction_pride- Facebook ‘pride’ reactionsreaction_thankful- Facebook ‘thankful’ reactionsreaction_total- Total Facebook reactionssentiment- Sentiment of the post: -1 negative, 0 neutral, 1 positivecritical_level- Criticality level assigned to the posthot- Internal score of how much the post keeps resonating on the networkhot_post- Whether the post is among the 20 hottest postsgroups- Search groups associated with the postthemes- Themes associated with the posttags- Tags applied to the posthashtags- Hashtags in the postmentions- Usernames mentioned in the postinterests- Interests of the author (e.g. Tecnologia & Computação)features- Internal processing markers (FEED, REELS)contact_reasons- Contact reasons assigned to the post (only for some accounts)pages- Ids of the connected pages the post belongs topage_id- Id of the connected owned page that made the postpage_comment- Whether the interaction or post was made by the pageinteracted_page_id- Id of the page that interacted with the postinteracted_page_name- Name of the page that interacted with the postprocessed_by_performance- True for owned posts (connected pages), false for listening postsfb_pid- Facebook id of the postfb_uid- Facebook id of the authorfavorite- Whether the post is marked as checked in Warroomspam- Whether the post was marked to be deleted (spam)hidden_by_user- Whether the message was hidden by the useris_hidden- Whether the post is privateis_dynamic_post- Whether the post is dynamicstatus- Conversation status: Ignorado, Pendente, Aberto, Em Espera, Respondido, Fechadosac_type- Conversation type: posts, comentarios, inbox, postvisitantes, comentariosvisitantes, reviews, comentariosreview, mentions, comentariosmentionssac_call_id- Stilingue internal id of the main interaction of the conversationtalk_id- Conversation idoperator_id- Id of the Smart Care operator who answered the conversationoperator_name- Name of the Smart Care operator who answered the conversationreplier- Who answered the conversationreplier_name- Name of who answered the conversationreceiver- Recipient/sender of an inbox message: id, email, name, image_url (JSON)to- Recipient of the message (inbox)update_time_ago- How long ago the post was edited (or ‘Nunca editado’)machine_learning- Machine-learning data associated with the post (JSON)emotion- Deprecated emotion value (unused since 2018)extra_fields- Fields the API returned that this connector does not map to a column yet, keyed by their original names (JSON)
Listening Press Posts
Listening Press Posts
Stream
listening_press_posts. Incremental on posted_at; key pid.pid- Unique identifier of the post (pid); comments, mentions and inbox messages are posts tooupdated_at- Last time Stilingue changed the post (metrics, classification, tags, annotations), from long_updated_atposted_at- When the post was published on the social network (UTC)crawled_at- When Stilingue collected the post (UTC)metrics_updated_at- Last time the post’s metrics were updated (UTC)long_posted_at- Publication time as a UNIX timestamp in millisecondslong_updated_at- Last update time as a UNIX timestamp in millisecondsaaa_score- Stilingue’s AAA score: relevance of the author as a potential influenceranonymous_user- Whether the author is anonymousattachments- Media attached to the post (videos, images): id, name, size, media_type, type, url, storage_url (JSON)channel- Source channel of the post (e.g. Twitter, Instagram, InstagramComments, Facebook, FacebookComments, YouTube, News, Blogs, Linkedin, Tiktok)primary_channel- Social network where the post was made (Twitter, Instagram, Facebook, YouTube, News, Blogs, Linkedin)title- Title of the post (may be empty)text- Text content of the posttext_append- Additional information about the post or interaction (e.g. ‘Comentado em: [video name]’ for YouTube comments)type- Type of the post: video, image, carrossel (Instagram only) or postlang- Language of the post: pt, en, espost_url- URL of the root postpost_id- Root post id when this post is an interaction on another post (e.g. a comment)root_id- Id of the root (main) publicationreply_pid- pid of the post this post replied to (for a reply to a comment, the comment’s pid)is_root- Whether this is the main message of the conversationuid- Identifier of the author (user) of the postusername- Username of the account that made the postname- Name of the author (available only for some channels)gender- Gender of the author: empty, Homem, Mulher or Marca (brand)verified- Whether the author’s account is verifiedfollowers- Number of followers of the author or pagelocation- Location of the authoruser_url- URL of the author’s accountuser_image_url- URL of the author’s profile picturepost_user_image_url- URL of the profile picture of the page that made the postimage_url- URL of the post’s imageurl_content- Direct URL of the post’s video (when type is video)comments- Number of comments on the postlikes- Number of likes on the postdislikes- Number of dislikes on the postshares- Number of shares of the postreactions- Number of reactions to the postinteractions- Total interactions on the post (comments, likes, shares, etc.)videoplays- Number of times the video was played (when type is video)reaction_like- Facebook ‘like’ reactionsreaction_love- Facebook ‘love’ reactionsreaction_haha- Facebook ‘haha’ reactionsreaction_wow- Facebook ‘wow’ reactionsreaction_sad- Facebook ‘sad’ reactionsreaction_angry- Facebook ‘angry’ reactionsreaction_pride- Facebook ‘pride’ reactionsreaction_thankful- Facebook ‘thankful’ reactionsreaction_total- Total Facebook reactionssentiment- Sentiment of the post: -1 negative, 0 neutral, 1 positivecritical_level- Criticality level assigned to the posthot- Internal score of how much the post keeps resonating on the networkhot_post- Whether the post is among the 20 hottest postsgroups- Search groups associated with the postthemes- Themes associated with the posttags- Tags applied to the posthashtags- Hashtags in the postmentions- Usernames mentioned in the postinterests- Interests of the author (e.g. Tecnologia & Computação)features- Internal processing markers (FEED, REELS)contact_reasons- Contact reasons assigned to the post (only for some accounts)pages- Ids of the connected pages the post belongs topage_id- Id of the connected owned page that made the postpage_comment- Whether the interaction or post was made by the pageinteracted_page_id- Id of the page that interacted with the postinteracted_page_name- Name of the page that interacted with the postprocessed_by_performance- True for owned posts (connected pages), false for listening postsfb_pid- Facebook id of the postfb_uid- Facebook id of the authorfavorite- Whether the post is marked as checked in Warroomspam- Whether the post was marked to be deleted (spam)hidden_by_user- Whether the message was hidden by the useris_hidden- Whether the post is privateis_dynamic_post- Whether the post is dynamicstatus- Conversation status: Ignorado, Pendente, Aberto, Em Espera, Respondido, Fechadosac_type- Conversation type: posts, comentarios, inbox, postvisitantes, comentariosvisitantes, reviews, comentariosreview, mentions, comentariosmentionssac_call_id- Stilingue internal id of the main interaction of the conversationtalk_id- Conversation idoperator_id- Id of the Smart Care operator who answered the conversationoperator_name- Name of the Smart Care operator who answered the conversationreplier- Who answered the conversationreplier_name- Name of who answered the conversationreceiver- Recipient/sender of an inbox message: id, email, name, image_url (JSON)to- Recipient of the message (inbox)update_time_ago- How long ago the post was edited (or ‘Nunca editado’)machine_learning- Machine-learning data associated with the post (JSON)emotion- Deprecated emotion value (unused since 2018)summary_text- HTML content of the publication’s textcomputer_vision- Text found in images of the publication, when any (JSON)extra_fields- Fields the API returned that this connector does not map to a column yet, keyed by their original names (JSON)
Listening Overview
Listening Overview
Stream
listening_overview. Incremental on report_date; key report_date.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keydate_range- Date range echoed by Stilingue for the request (AAAAMMDDHHmm|AAAAMMDDHHmm)collected_mentions- Number of posts collected in the daycollected_mentions_variation- Variation (%) of collected posts against the previous period of the same lengthprevious_collected_mentions- Posts collected in the previous periodprevious_date_range- Date range of the previous period used for the variationstotal_localized_mentions- Number of collected posts with a locationtotal_users- Total number of distinct userstotal_users_variation- Variation (%) of the total users against the previous periodpotential_reach- Potential reachpotential_reach_variation- Variation (%) of the potential reach against the previous periodprevious_potential_reach- Potential reach of the previous periodnet_promoter_score- Sentiment indexnet_promoter_score_variation- Variation (%) of the sentiment index against the previous periodprevious_net_promoter_score- Sentiment index of the previous periodnet_sentiment- Net sentiment (positive minus negative posts)net_sentiment_score- Net sentiment scorenet_sentiment_score_variation- Variation (%) of the net sentiment score against the previous periodprevious_net_sentiment- Net sentiment of the previous periodprevious_net_sentiment_score- Net sentiment score of the previous periodchannels- Posts per channel (JSON)general_sentiment- Distribution of sentiment: positive_value, negative_value, neutral_value, not_classified_value (JSON)influencers_list- Influencer ranking shown in the overview (JSON)influencers_static- Internal flag of the influencer listtalking_about- Distribution of posts by device, gender and interest (JSON)
Listening Posts Over Time
Listening Posts Over Time
Stream
listening_posts_over_time. Incremental on report_date; key report_date.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keyposts_count- Number of posts collected for the day
Listening Sentiment By Themes
Listening Sentiment By Themes
Stream
listening_sentiment_by_themes. Incremental on report_date; key report_date, channel, name.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keychannel- Channel the figures refer to, as Stilingue names it (‘all’ sums every channel)name- Name of the themepositive- Posts with positive sentiment for the themenegative- Posts with negative sentiment for the themeneutral- Posts with neutral sentiment for the themenot_classified- Posts without a sentiment classification for the themetotal- Total posts for the themetotal_polarity_classified- Posts of the theme with a sentiment classificationtotal_posts- Total posts of the day in the search (all items)
Listening Sentiment By Groups
Listening Sentiment By Groups
Stream
listening_sentiment_by_groups. Incremental on report_date; key report_date, channel, name.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keychannel- Channel the figures refer to, as Stilingue names it (‘all’ sums every channel)name- Name of the grouppositive- Posts with positive sentiment for the groupnegative- Posts with negative sentiment for the groupneutral- Posts with neutral sentiment for the groupnot_classified- Posts without a sentiment classification for the grouptotal- Total posts for the grouptotal_polarity_classified- Posts of the group with a sentiment classificationtotal_posts- Total posts of the day in the search (all items)
Listening Sentiment By Searches
Listening Sentiment By Searches
Stream
listening_sentiment_by_searches. Incremental on report_date; key report_date, channel, name.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keychannel- Channel the figures refer to, as Stilingue names it (‘all’ sums every channel)name- Name of the searchpositive- Posts with positive sentiment for the searchnegative- Posts with negative sentiment for the searchneutral- Posts with neutral sentiment for the searchnot_classified- Posts without a sentiment classification for the searchtotal- Total posts for the searchtotal_polarity_classified- Posts of the search with a sentiment classificationtotal_posts- Total posts of the day in the search (all items)
Listening Sentiment By Domains
Listening Sentiment By Domains
Stream
listening_sentiment_by_domains. Incremental on report_date; key report_date, channel, name.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keychannel- Channel the figures refer to, as Stilingue names it (‘all’ sums every channel)name- Name of the domainpositive- Posts with positive sentiment for the domainnegative- Posts with negative sentiment for the domainneutral- Posts with neutral sentiment for the domainnot_classified- Posts without a sentiment classification for the domaintotal- Total posts for the domaintotal_polarity_classified- Posts of the domain with a sentiment classificationtotal_posts- Total posts of the day in the search (all items)
Listening Sentiment By Links
Listening Sentiment By Links
Stream
listening_sentiment_by_links. Incremental on report_date; key report_date, channel, name.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keychannel- Channel the figures refer to, as Stilingue names it (‘all’ sums every channel)name- Name of the linkpositive- Posts with positive sentiment for the linknegative- Posts with negative sentiment for the linkneutral- Posts with neutral sentiment for the linknot_classified- Posts without a sentiment classification for the linktotal- Total posts for the linktotal_polarity_classified- Posts of the link with a sentiment classificationtotal_posts- Total posts of the day in the search (all items)
Listening Sentiment By Terms
Listening Sentiment By Terms
Stream
listening_sentiment_by_terms. Incremental on report_date; key report_date, channel, name.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keychannel- Channel the figures refer to, as Stilingue names it (‘all’ sums every channel)name- Name of the termpositive- Posts with positive sentiment for the termnegative- Posts with negative sentiment for the termneutral- Posts with neutral sentiment for the termnot_classified- Posts without a sentiment classification for the termtotal- Total posts for the termtotal_polarity_classified- Posts of the term with a sentiment classificationtotal_posts- Total posts of the day in the search (all items)absorbed_names- Similar words counted together with this term
Listening Sentiment By Regions
Listening Sentiment By Regions
Stream
listening_sentiment_by_regions. Incremental on report_date; key report_date, region_level, name.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keyregion_level- Level of the region as Stilingue names it (Países, Regiões, Estados, Mesorregiões, Cidades…)name- Name of the regionpositive- Posts classified as positivenegative- Posts classified as negativeneutral- Posts classified as neutraltotal- Total posts of the regiontotal_classified- Posts of the region with a sentiment classificationtotal_posts- Total posts of the day in the search
Listening Top Influencers
Listening Top Influencers
Stream
listening_top_influencers. Incremental on report_date; key report_date, channel, uid.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keychannel- Channel of the influencer’s profileuid- Identifier of the influencer’s profilename- Name of the influencer’s profileusername- Username of the influencer’s profileurl- URL of the influencer’s profileis_verified- Whether the profile is verifiedoccupation- Interest/occupation of the influencerposition- Position of the profile in the rankingrank- Order of the profile in the day’s answer (1 = first)followers- Number of followers of the influencerposts_count- Number of posts of the influencer in the daygroups- Search groups the influencer’s posts matchedranking_3as- AAA ranking scoreranking_harmonic_mean- AAA ranking (harmonic mean)afinity_score- Internal affinity scoreafinity_normalized- Affinity score normalized for the Warroomassertiviness_score- Sum of the virality of the posts divided by log10 of the followersfollowers_score- Internal score of how engaged the followers arereach_score- Square root of the number of followersreach_normalized- Reach normalized for the Warroomvirality_score- Internal score of how viral the posts areviralization_normalized- Virality normalized for the Warroom
Listening Headlines
Listening Headlines
Stream
listening_headlines. Incremental on report_date; key report_date, channel, uid, published_at_raw, title.report_date- Day the figures refer to (a Brasília calendar day, asked as that whole day); used as the incremental replication keypublished_at_raw- Publication time exactly as Stilingue sends it (dd/MM/aaaa HH:mm); part of the keychannel- Channel where the headline was shared (Facebook or Twitter)uid- Identifier of the user that published the headlineuser- Name of the user that published the headlinetitle- Title of the shared headlinepublished_at- When the headline was published (UTC)sentiment- Sentiment of the headline: -1 negative, 0 neutral, 1 positiveweight- Weight of the headline in the rankingreal_weight- Real weight of the headlineavailable_time- Time the headline has been available
Owned Pages
Owned Pages
Stream
owned_pages. Full table; key channel, id.id- Identifier of the connected page on its social networkchannel- Social network of the page, as Stilingue names it (e.g. Facebook, Instagram, TikTok)username- Username of the page on that social networkpath_channel- Lowercase channel used by this connector to read the page’s posts and charts (empty when the channel is not supported)
Owned Posts
Owned Posts
Stream
owned_posts. Incremental on posted_at; key pid.pid- Unique identifier of the post (pid); comments, mentions and inbox messages are posts tooupdated_at- Last time Stilingue changed the post (metrics, classification, tags, annotations), from long_updated_atposted_at- When the post was published on the social network (UTC)crawled_at- When Stilingue collected the post (UTC)metrics_updated_at- Last time the post’s metrics were updated (UTC)long_posted_at- Publication time as a UNIX timestamp in millisecondslong_updated_at- Last update time as a UNIX timestamp in millisecondsaaa_score- Stilingue’s AAA score: relevance of the author as a potential influenceranonymous_user- Whether the author is anonymousattachments- Media attached to the post (videos, images): id, name, size, media_type, type, url, storage_url (JSON)channel- Source channel of the post (e.g. Twitter, Instagram, InstagramComments, Facebook, FacebookComments, YouTube, News, Blogs, Linkedin, Tiktok)primary_channel- Social network where the post was made (Twitter, Instagram, Facebook, YouTube, News, Blogs, Linkedin)title- Title of the post (may be empty)text- Text content of the posttext_append- Additional information about the post or interaction (e.g. ‘Comentado em: [video name]’ for YouTube comments)type- Type of the post: video, image, carrossel (Instagram only) or postlang- Language of the post: pt, en, espost_url- URL of the root postpost_id- Root post id when this post is an interaction on another post (e.g. a comment)root_id- Id of the root (main) publicationreply_pid- pid of the post this post replied to (for a reply to a comment, the comment’s pid)is_root- Whether this is the main message of the conversationuid- Identifier of the author (user) of the postusername- Username of the account that made the postname- Name of the author (available only for some channels)gender- Gender of the author: empty, Homem, Mulher or Marca (brand)verified- Whether the author’s account is verifiedfollowers- Number of followers of the author or pagelocation- Location of the authoruser_url- URL of the author’s accountuser_image_url- URL of the author’s profile picturepost_user_image_url- URL of the profile picture of the page that made the postimage_url- URL of the post’s imageurl_content- Direct URL of the post’s video (when type is video)comments- Number of comments on the postlikes- Number of likes on the postdislikes- Number of dislikes on the postshares- Number of shares of the postreactions- Number of reactions to the postinteractions- Total interactions on the post (comments, likes, shares, etc.)videoplays- Number of times the video was played (when type is video)reaction_like- Facebook ‘like’ reactionsreaction_love- Facebook ‘love’ reactionsreaction_haha- Facebook ‘haha’ reactionsreaction_wow- Facebook ‘wow’ reactionsreaction_sad- Facebook ‘sad’ reactionsreaction_angry- Facebook ‘angry’ reactionsreaction_pride- Facebook ‘pride’ reactionsreaction_thankful- Facebook ‘thankful’ reactionsreaction_total- Total Facebook reactionssentiment- Sentiment of the post: -1 negative, 0 neutral, 1 positivecritical_level- Criticality level assigned to the posthot- Internal score of how much the post keeps resonating on the networkhot_post- Whether the post is among the 20 hottest postsgroups- Search groups associated with the postthemes- Themes associated with the posttags- Tags applied to the posthashtags- Hashtags in the postmentions- Usernames mentioned in the postinterests- Interests of the author (e.g. Tecnologia & Computação)features- Internal processing markers (FEED, REELS)contact_reasons- Contact reasons assigned to the post (only for some accounts)pages- Ids of the connected pages the post belongs topage_id- Id of the connected owned page that made the postpage_comment- Whether the interaction or post was made by the pageinteracted_page_id- Id of the page that interacted with the postinteracted_page_name- Name of the page that interacted with the postprocessed_by_performance- True for owned posts (connected pages), false for listening postsfb_pid- Facebook id of the postfb_uid- Facebook id of the authorfavorite- Whether the post is marked as checked in Warroomspam- Whether the post was marked to be deleted (spam)hidden_by_user- Whether the message was hidden by the useris_hidden- Whether the post is privateis_dynamic_post- Whether the post is dynamicstatus- Conversation status: Ignorado, Pendente, Aberto, Em Espera, Respondido, Fechadosac_type- Conversation type: posts, comentarios, inbox, postvisitantes, comentariosvisitantes, reviews, comentariosreview, mentions, comentariosmentionssac_call_id- Stilingue internal id of the main interaction of the conversationtalk_id- Conversation idoperator_id- Id of the Smart Care operator who answered the conversationoperator_name- Name of the Smart Care operator who answered the conversationreplier- Who answered the conversationreplier_name- Name of who answered the conversationreceiver- Recipient/sender of an inbox message: id, email, name, image_url (JSON)to- Recipient of the message (inbox)update_time_ago- How long ago the post was edited (or ‘Nunca editado’)machine_learning- Machine-learning data associated with the post (JSON)emotion- Deprecated emotion value (unused since 2018)page_channel- Channel of the connected page the post was read for (lowercase, as used in the API path)ig_pid- Instagram id of the postfb_impressions- Facebook impressions of the postfb_reach- Facebook reach of the postkpi_engagement- Total interactions on the postkpi_saved- Number of times the post was savedis_ads- True for a paid (dark) post, false for an organic postcomments_answers- Comments answered by the page and comments with answers: answered, total (JSON)comments_polarities- Percentage of positive, neutral and negative comments (JSON)cvtags- Tags associated with the post (different from hashtags)integration_name- Name of the integration the publication came fromtext_header- Header text of the postreclame_aqui- Reclame Aqui data of the post (JSON)same_text- Number of posts with the same text as this onesame_text_posts- Ids of posts with the same text as this onesame_user_posts- Ids of posts made by the same authorextra_fields- Fields the API returned that this connector does not map to a column yet, keyed by their original names (JSON)
Owned Page Daily Metrics
Owned Page Daily Metrics
Stream
owned_page_daily_metrics. Incremental on metric_date; key page_id, report, metric, breakdown, metric_date.page_id- Identifier of the connected pagepage_channel- Channel of the page (lowercase, as used in the API path)report- Owned chart the value comes from (e.g. interactions, page_likes, reach_over_time, page_metrics)metric- Metric name as Stilingue returns it (e.g. Reações, Novos Fãs (Orgânicos), page_impressions)breakdown- Post type the value is split by (posts, carousels, reels, stories, dark_posts) or ‘total’metric_date- Day of the value; used as the incremental replication keyvalue- Value of the metric on the day
Smart Care Cases
Smart Care Cases
Stream
smartcare_cases. Incremental on report_date; key report_date, case_id.report_date- Day of the Smart Care report the row comes from (a Brasília calendar day); used as the incremental replication keycase_id- Identifier of the case: the conversation id plus the case number within the day’s reportconversation_id- Identifier of the conversationchannel- Channel of the pagepage_id- Identifier of the connected owned pagepage_name- Name of the connected owned pagestatus- Status of the case when the report was read (Aberto, Pendente, Em Espera, Respondido, Fechado, Ignorado)interaction_type- Type of interaction (Comentário, Menção, Inbox, Publicação de visitante…)init_at- When the case started (first interaction, or reopening)end_at- When the case was closed or ignoredtime_to_first_answer- Seconds until the first status change to Respondidotime_to_close- Seconds until the case was closed (sum of the times of every status change)first_answer_configured_sla_time_seconds- First-answer SLA configured, in secondsfirst_answer_is_inside_sla_time- Whether the first answer was within the configured SLAextra_fields- Fields the API returned that this connector does not map to a column yet, keyed by their original names (JSON)
Smart Care Conversations
Smart Care Conversations
Stream
smartcare_conversations. Incremental on report_date; key report_date, conversation_id.report_date- Day of the Smart Care report the row comes from (a Brasília calendar day); used as the incremental replication keyconversation_id- Identifier of the conversationchannel- Social network of the conversationpage_id- Identifier of the connected owned pagepage_name- Name of the connected owned pagestatus- Current status of the conversation when the report was readinteraction_type- Type of interaction (Comentário, Menção, Inbox, Publicação de visitante…)interactions_size- Total interactions (owned and not owned) of the conversation, whatever their dateinit_at- First interaction of the conversation in the dayend_at- Last status change to Fechado or Ignorado in the daytime_to_first_answer- Seconds until the first status change to Respondido or Fechado in the daytime_to_close- Sum of the times of the status changes, when one of them closed or ignored the conversationfirst_answer_configured_sla_time_seconds- First-answer SLA configured, in secondsfirst_answer_is_inside_sla_time- Whether the first answer was within the configured SLAextra_fields- Fields the API returned that this connector does not map to a column yet, keyed by their original names (JSON)
Smart Care Interactions
Smart Care Interactions
Stream
smartcare_interactions. Incremental on report_date; key pid, conversation_id.report_date- Day of the Smart Care report the row comes from (a Brasília calendar day); used as the incremental replication keypid- Unique identifier of the interactionconversation_id- Conversation the interaction belongs to (empty when the report gives none)conversation_ids- Every conversation the interaction belongs tocase_id- Case the interaction belongs toconversation_status- Status of the conversationchannel- Channel of the interactionoriginal_channel- Original channel of the interactionpage_id- Identifier of the connected owned pagepage_name- Name of the connected owned pageposted_at- When the interaction was madeprocessed_at- When Stilingue collected and processed the interactionupdated_at- Last update of the interaction in Stilinguenormalized_updated_at- Last update as AAAAMMDDHHmm, as Stilingue sends itnormalized_metrics_updated_at- Last metrics update as AAAAMMDDHHmm, as Stilingue sends ittext- Text of the interactionpost_url- URL of the interaction (sometimes the publication’s URL)proprietary- Whether the interaction was made by the owned page itselfpolarity- Sentiment of the interaction: Positivo, Neutro, Negativooperator_name- Smart Care operator who answered (the name at the time)user_id- Identifier of the social network user who made the interactionuser_name- Name of the user who made the interactionuser_username- Username of the user who made the interactionuser_gender- Gender of the user who made the interactionuser_followers- Followers of the user who made the interactionuser_crm_user_id- CRM identifier of the usertags- Tags classified on the interactionthemes- Themes classified on the interactiongroups- Search groups of the interactionhashtags- Hashtags of the interactioninteraction_type- Type of interaction (Comentário, Menção, Inbox…)from_promoted- Whether the interaction is on a boosted publicationbelongs_to_sac_call- Whether the interaction belongs to a Smart Care callroot- Whether the interaction is the root of the conversationroot_id- Identifier of the root interactionduplicated- Whether the interaction is a duplicatehidden_by_user- Whether the interaction was hidden by the useris_hidden- Whether the interaction is privateverified- Whether the author is verifiedoutside_date_range- Whether the interaction is outside the day asked (included because of its conversation)delay- Time until collection (in days, as Stilingue reports it)reaction- Reaction data of the interaction (JSON)extra_fields- Fields the API returned that this connector does not map to a column yet, keyed by their original names (JSON)
Smart Care Status Changes
Smart Care Status Changes
Stream
smartcare_status_changes. Incremental on report_date; key id.report_date- Day of the Smart Care report the row comes from (a Brasília calendar day); used as the incremental replication keyid- Identifier of the status changeconversation_id- Conversation whose status changedcomment_id- Identifier of the comment of the conversationcase_id- Case of the status changecase_init_at- When the case of this status change startedchannel- Channel of the conversationpage_id- Identifier of the connected owned pagepage_name- Name of the connected owned pageoperator_id- Identifier of the Smart Care operator who made the changeoperator_name- Name of the Smart Care operator who made the changeold_value- Status before the changenew_value- Status after the changecreated_at- When the status change was madetime_to_status_change- Seconds until the status change, by the SLA rulesconfigured_sla_time_seconds- SLA configured for this change, in secondsinside_sla_time- Whether the change was within the configured SLAfirst_answer- Whether this change was the first answerending_status- Whether the new status ends the caseinteraction_type- Type of interaction (Comentário, Menção, Inbox…)calendar_id- Identifier of the SLA calendarrelative_posted_at- Publication time of the related interactionrelative_processed_at- Processing time of the related interactionextra_fields- Fields the API returned that this connector does not map to a column yet, keyed by their original names (JSON)