Sprout Social

Sprout Social is a social media management platform used to publish content, manage the social inbox, and handle customer care cases across networks. With Weld you can sync your Sprout Social messages, cases, profiles, tags, groups and users into your data warehouse and combine them with your ad platform and web analytics data to report on social engagement and support workload.

Features

Feature nameSupported
Column HashingTrueColumn level
BlockingTrueColumn level
IncrementalTrue
Custom dataFalse
HistoryTrue
ReSyncTrueTable level
TemplatesFalse

Data Schema

Setup Guide - ELT

Prerequisites

You need a Sprout Social API token. Weld only reads from Sprout Social — it never writes back. The token must give access to at least one Sprout Social customer account, otherwise the connection cannot be created.

Step 1 - Create your Sprout Social API token

  1. Sign in to Sprout Social with an account that can manage your account's settings.
  2. Go to Settings → Global Features → API → API Token Management.
  3. Generate a new API token for Weld.
  4. Copy the token.

Step 2 - Create the connection

  1. In the Weld app, navigate to Connections and click + New Connection.
  2. Search for Sprout Social and select it.
  3. Enter the destination schema name of your choice. This name is used to identify the connection in future syncs.
  4. Paste your API Token.
  5. Click Connect to validate the token and establish the connection.

Step 3 - Data To Sync

Select the tables you wish to include in the sync. You can view the schema, remove columns or hash sensitive information.

If your token has access to more than one Sprout Social customer account, Weld syncs all of them. Every table except message and cases includes a customer_id column that tells you which customer account a row belongs to.

The connector offers 6 tables:

  • Messages and cases — message (posts and inbox messages, with their network, text, hashtags, tags and the team member who sent them) and cases (customer care cases with their status, priority, type, queue and assignee)
  • Account setup — profile (the social profiles connected to Sprout Social), group (your profile groups), tag and user

The tables are independent — selecting one does not bring any other along with it.

Step 4 - Configure sync

  1. Select how often you would like the data to sync.
  2. Provide a unique destination table name.

The first sync loads all the messages and cases Sprout Social has for your account, so it can take a while if you have a long history. After that, each sync only picks up new messages and recently updated cases. profile, group, tag and user are small and are refreshed in full on every sync.

Weld will take over from here and commence syncing data from your Sprout Social account.

Was this page helpful?