Sprout Social

Automatic Data Synchronization

The Dataddo Sprout Social connector gives you the ability to sync your data automatically in hourly, daily, weekly, or monthly increments.

Available Endpoints

All available endpoints from the Sprout SociaI are listed here.

Sprout Social API Token and Label

Before accessing the Analytics API, your account must be provisioned for API use by your Sprout account representative. Once the account is provisioned, you must obtain an access token. To do so, the Account Owner must log in to the Sprout web app and obtain the access token via an account settings dialog. The Account Owner can create new access tokens via the dialog, view existing access tokens or invalidate existing tokens (i.e. prevent the tokens from being used for client requests).

Number 1 Log in to Sprout and navigate to Settings.

Number 2

Scroll down to the reporting section and click API Tokens.

Sprout Social- API key 1

Number 3 Accept Sprout’s Analytics API Terms of Service, if you haven’t already.
Number 4 Click Create API Token in the upper left corner.

Sprout Social- API key 2

Number 5 Enter a name for your token.

Sprout Social- API key 3

Number 6 Copy the token for use. Be sure to store this securely.

Twitter Data: Twitter Content End User License Agreement

NOTE: Twitter has additional review and compliance requirements around exposing data through the Sprout Analytics API. You’re required to undergo a brief Twitter review and approval before being able to access their Twitter data through the Sprout Analytics API.

Contact your Sprout Social account representative to initiate the review process with Twitter. After Twitter approves your use case, the Account Owner needs to accept the Analytics API Twitter Content End User License Agreement. This appears at the top of the API Tokens settings page.

  Sprout Social- API key 4

How to create a Sprout Social Source

Number 1

Sign in to your Dataddo account and click on Sources at the top of the page. Home Page - Data Source

Number 2

Click on Create Source in the top right corner.Data Sources - Create Source

Number 3 From the list of sources, choose Sprout Social. You can type the name of the connector into the search bar to find it faster.
Sprout Social - step 3
Number 4

First, select the required Dataset and click on Next.

NOTE: If you are not sure which Dataset you need, but you know which Metrics and Attributes you are looking for, you can use the Search by name or attribute function or you can browse through all the possible Attributes and Metrics for each Dataset by clicking on the specific Dataset.
Sprout Social- step 4

Number 5

From the drop-down menu, choose your Sprout Social Account connected to Dataddo, and then select your Sprout Social Customer. Click on Next to continue with the setup.

Salesforce Marketing Cloud - step 4

a) Add new account
If you want to connect a new Sprout Social Account that is not on the list, click on Add Account. You will be redirected to the sign-in page to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.
Sprout Social- step 5 add new account
Sprout Social - step 5a

NOTE: To find your Label and API token, follow these steps.

b) Authorize Your Account
If you have not authorized your Sprout Social Account with Dataddo, click on Authorize and you will be redirected to the sign-in page to confirm the right account. Fill out the information as in the previous step.
Sprout Social - step 5 authorize
Once you confirm and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.
Number 6

Choose a Name for your Data Source and select the Metrics and Attributes. To continue to the next page, click Next.

NOTE: The Metrics and Attributes depend on the Dataset you selected in the previous step. If you need different Metrics and Attributes, go back two steps and change the Dataset.

Sprout Social- step 6

Number 7

On the Storage selection page, you can set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • A) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • B) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query, or PostgreSQL.
Sprout Social - step 7
Number 8

Configure your snapshotting preferences by choosing your Data range*, Sync type, Sync frequency, Time, and Timezone. Confirm your setup by clicking on Next.

NOTE: *If the Data range is available to select, you can load historical data. Read more about it in our guide.

Salesforce Marketing Cloud - step 7

Number 9 In the last step, you can preview your data. Click on Save and your new Data Source is ready.
Sprout Social - step 9 preview
* Broken view / Error message
If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:
  • Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attributes or breakdowns, or their combination - you may not have any values for them.
Sprout Social - step 9 error

Congratulations, your new Data Source is ready!

Need assistance?

Feel free to contact us or create a ticket and we will help you set up the Data Source.