--- schema_version: "1" id: 7ebf3604b07bee4d62e9101d9c56a261d8fac3ca7565593f739d896e7aaa9900 title: Use Scheduled Reports to Integrate Social Studio with Marketing Cloud Intelligence Data Pipelines collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_data_streams_api_connect_socialstudio_reports.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_streams_api_connect_socialstudio_reports.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 07520394bf358220522a9708d490fb43029a527d539f6fce8933a0a367911d72 description: Salesforce Social Studio is a Management Center and Social Listening Platform for owned social accounts on popular social networks, such as Facebook, LinkedIn, Twitter, Instagram, Pinterest. products: - Marketing - Marketing Cloud Intelligence release: "264" --- # Use Scheduled Reports to Integrate Social Studio with Marketing Cloud Intelligence Data Pipelines Salesforce Social Studio is a Management Center and Social Listening Platform for owned social accounts on popular social networks, such as Facebook, LinkedIn, Twitter, Instagram, Pinterest. This article goes over the recommended approach when using scheduled reports to push Social Studio data into Marketing Cloud Intelligence Data Pipelines using TotalConnect. ## Social Studio API Versus Scheduled Reports **Social Studio API** - Data ingested via the dedicated Social Studio API returns mentions over the past 30 days as a lifetime measurement. - You would need dedicated Topic Profiles for Social Studio/Intelligence analysis, which would result in double consumption of Social Studio EMV. - Keyed off Social Post ID, which means a 1:1 ratio of mentions vs. row consumption Intelligence Data Pipelines (expensive). **Scheduled Reports from Social Studio** - Greater control on data entering Marketing Cloud Intelligence Data Pipelines - Can be scheduled from a Keyword Group level, rather than the entire Topic profile. - Historical data can be consumed on the day the mentioned happened allowing for trending analysis. - Custom key aggregating post count at the day and custom dimension level - significant reduction in row consumption. - Scheduled reports allow you to pull in the data at a Keyword Group level (KWG), which allows for Share of Voice or Category trending that the API approach doesn't allow. The data on this dashboard for scheduled reports is represented by the green segment, whereas the data returned from an API connection returns all KWGs. ## Social Studio Report Data Points Let’s go over the setup on Social Studio’s end first. To provide the maximum amount of control for data pushed into Marketing Cloud Intelligence Data Pipelines, we’d recommend using Social Studio reports. Using scheduled reports gives you greater control over the data ingested into Intelligence Data Pipelines, which then impacts the volume of rows consumed. **Data Selection from Social Studio** Selecting ‘CSV’ as the export format of your report allows you to customize the fields that you want set as part of your report. Here’s a breakdown of the suggested Social Studio Report Data Points and what they represent: | **Social Studio Report Data Points** | **What this data point represents** | | --- | --- | | Language | The language the post has been classified | | Media Provider of Post | Media origin | | Post Type | Type of engagement, limited to tweets (retweets, quotes, replies - and so on) | | Published Date | The date the post/content was published, different to harvest date that represents when Social Studio ingested the post into our database. | | Region | Country of origin | | Sentiment | Sentiment as classified in Social Studio | | Workflow - Author Tag | Tags applied via social automate or manually inside Social Studio engage or analyze. | | Workflow - Post Tag | Tags applied via social automate or manually inside Social Studio engage or analyze. | Within the ‘filters’ section we would then set up an individual report for each of the keyword groups that are set up inside of that topic profile. A topic profile is a social media search tool created in Social Studio, you can learn more about it here. It may also be that you don’t want all of the keyword group mentions being passed through into Marketing Cloud Intelligence Data Pipelines and this will be a great way of controlling that data flow without having to build dedicated Topic Profiles inside of Social Studio which will cause duplicate mentions (which is one of the primary license charges for Social Studio). Within the ‘filters’ section we would then set up an individual report for each of the keyword groups that are set up inside of that topic profile. A topic profile is a social media search tool created in Social Studio, you can learn more about it here. It may also be that you don’t want all of the keyword group mentions being passed through into Marketing Cloud Intelligence Data Pipelines and this will be a great way of controlling that data flow without having to build dedicated Topic Profiles inside of Social Studio, which will cause duplicate mentions (which is one of the primary license charges for Social Studio). ## Marketing Cloud Intelligence Data Pipelines Now that we know how to configure our reports in Social Studio, let’s look at how to ingest those reports in Intelligence Data Pipelines. **Initial Data Mapping in Marketing Cloud Intelligence Data Pipelines** If you’ve built your Social Studio reports as suggested above, we’d recommend the following mapping logic in Intelligence Data Pipelines. Select TotalConnect and choose the ‘Social Listening’ data stream type. Important: In case you have a Social Studio environment that operates across multiple timezones, ensure that your data load mode is set to ‘Upsert’. The reason for this is that your Social Studio tenant may have a different timezone set than the country you work in. As a result you’re likely to get some overlap of data day-on-day, using upsert will overlook data matches and only update new data points. This is also particularly useful if changes are made to the data inside of Social Studio. Maybe new labels, author tags or sentiment changes have been made since the initial upload. Having your Social Studio report set to the last 7 days and the data mode set to upsert, will accommodate these changes to the data set for the rolling period. The following table shows the fields from Social Studio and how they should be mapped to Intelligence Data Pipelines's data model fields:
Social Studio Intelligence Model Additional Formula
Not available in raw Social Studio data, needs to be created in Intelligence Data Pipelines Social Mention Key

var formatedDate = FORMATDATE(csv['PUBLISH_DATE'],"MM/dd/yy");

formatedDate+'-'+csv['REGION']+'-'+csv['LANGUAGE']+'-'+csv['MEDIA_PROVIDER']+'-'+csv['POST_TYPE']+'-'+csv['SENTIMENT']+'-'+csv['WORKFLOW_AUTHORTAGS']+'-'+csv['WORKFLOW_BLOGPOSTTAGS']
Language Social Mention Language  
Media Provider of Post Social Mention Name  
Post Type Social Mention Type  
Published Date Day  
Region Country  
Sentiment Social Mention Sentiment  
Workflow - Author Tag Social Mention Custom Attribute 1  
Workflow - Post Tag Social Mention Custom Attribute 2  
N/A Social Mention Count See note below
**Note on Social Mention Key mapping formula:** Using the ‘FORMATDATE’ function strips out the timestamp, which is part of the Publish\_Date dimension. If you want to view the data on an hourly basis, you can leave this format function out and just concatenate all Social Mention Fields. However, this would result in a significant increase in row consumption, which will likely be 1:1 (1 SS mention = 1 Intelligence Data Pipelines row). If you do apply the ‘FORMATDATE’ function, the result would be, for example, 4.5 K mentions over a 7 day period = 321 Intelligence Data Pipelines rows. If you want to represent multiple keyword groups separately you need to schedule individual reports by Keyword Group. ## Data Warnings - Max download allowance in Social Studio is 500 K posts in one data pull, you may need to refine your Keyword Groups if you hit this limit. - Even without Post ID you'll still return a row per mention