Home / Internet Marketing News / Getting Granular With Message Data Using Sprout’s Inbox Export  

Getting Granular With Message Data Using Sprout’s Inbox Export  

Sometimes crunching numbers and performing deep quantitative analysis doesn’t give you all the insights you need. That’s why it’s important to also understand the context of your brand’s social conversations.

With Sprout’s Smart Inbox, it’s simple to monitor conversations happening in real-time, on all social profiles, across each social channel. It’s quick access to rich message-level data that helps you leverage the analytics in your Reporting Suite. For instance, utilizing the tagging workflow in the inbox in tandem with your Tag Report gives you quantifiable insight into the impact of messages and helps you discover volume, new themes and performance patterns.

For an understanding of social conversations that goes beyond numbers, Sprout users in the Enterprise plan can now utilize Sprout’s Inbox Export to perform deeper, contextual analysis of message content by exporting incoming and sent messages directly from the Smart Inbox.

Configure Your Smart Inbox

Before exporting any content, it’s important to note that messages can be easily configured in the Smart InboxDepending on the particular message data you’re interested in viewing, there are a couple of different approaches you can take to organizing your inbox.

Message filters allow you to isolate and sort messages to focus on exactly what you’re looking for. Select the exact profiles, message types and keywords that matter most to you.

Alternatively, you can choose to export all messages from a specific time frame. Check Select All in the message filters and then select a date range from the inbox chart to drill into message activity between particular dates.

Analyze Message Quality With CSV Sort & Filter

With Inbox Export, social media pros can effectively hone in on social messages from their Smart Inbox. This makes it easy to compare and evaluate the context of engagement around tags, events, campaigns and other social initiatives. By digging into a message’s content, you can start to unpack the quality of messages.

Below are a variety of ways you can sort and filter your CSV file to get the most out of Inbox Export.

Sort or filter by:

  • Brand Keywords: Compare activity happening across brand keywords for a specified time frame. Sort the Message Types column by Brand Keyword to gauge sentiment and tone about specific keywords used frequently with your brand name on social, as well as uncover any patterns in keyword usage. You can also sum rows with specific brand keywords to determine the share of volume over a specific time period. #SproutTip: Sprout’s Twitter Listening Report—available in Corporate and Enterprise plans—is a great tool for analyzing share of voice and growth trends across a group of keywords.
  • Tags: Tags are a great way to stay organized and focused when responding to the daily flood of incoming messages. Using the Tag Report, you can filter a feed of tagged messages to view the conversations labeled under that specific tag. When you export messages from the Smart Inbox, you can perform advanced sorting and filtering in the CSV.  Sort by Tags and attribute tags to specific networks to compare usage across channels.
  • Ad Comments: Evaluate the ROI of paid campaigns and measure how consumers are responding to your ads. Sort by Message Types and filter Ad Comments to compare the quality of engagement across different Facebook and Instagram ads and date ranges. Add an additional column to label responses as Active vs. Passive, or Positive vs. Negative, to better inform your brand engagement strategy on paid social ads.
  • Private and Direct Messages: There’s a stark contrast in how consumers engage your brand publicly vs. privately. Sort by Message Types and isolate Private and Direct Messages to shed light on the main differences between public and private message content. Identify trends in private messages and then use those insights to build out automated conversational workflows with Sprout’s Bot Builder.
  • Sent From Messages: Who exactly is talking to or about your brand on social? How often are they engaging and what are they saying? Using the People & Brands Frequently Talking About section in the Twitter Trends Report, you’re able to see users that frequently mention you on Twitter on a month-by-month basis. Inbox Export allows you to see advocates and influencers on networks other than Twitter and offers the flexibility to slice and dice dates to analyze at a more granular level. Sort by From Name to identify your most active consumers on social.

Gain Deeper Context With CSV Search

When viewing exported messages, users can easily search the CSV file to pinpoint specific keywords and glean further insights on message activity. Speedily reference keywords, phrases or dates to note important trends and gain deeper context around specific campaigns or activity in a particular time frame.

  • Messages containing a specific word: Retrace mentions of a specific word–perhaps you remember seeing it in a previous conversation or maybe you’re looking to identify negative or positive reactions. Search by a specific word and then quickly skim the CSV file to highlight pertinent messages.
  • Product names: Whether it’s to compile specific product questions or gather feedback about a new feature launch, searching a product name can help you more efficiently deliver information to customer support and product teams.
  • Specific users: Connect the dots throughout your customer journey when you search specific users or influencers. Trace high-value conversions (or even unsuccessful ones) back to the conversation’s origin. Take note at how it unfolds. If they’re negative, use that data to develop proactive measures in your customer care strategy. If they’re positive, identify patterns and leverage this information (as well as these individuals) for social marketing opportunities.
  • Specific dates: With the Smart Inbox, users can easily adjust dates based on several preset time periods and drill the feed down as far as a 24-hour bucket. Then take advantage of Inbox Export to customize your search, drilling into specific dates and narrowing in on the precise moment a trend was born, or even get an overview of activity and message content around a significant event.

Excel Best Practices

Information from your CSV file will prove to be especially valuable, particularly when equipped with a few simple Excel tricks. Below are some tips on how to use Excel to make sure you’re getting the most out of Inbox Export.

Apply Filters: You can apply filters to columns to eliminate specific information.

  1. Select a column. In the Data tab, select Filters.
  2. Click on drop-down arrow shown at the top corner of the first cell in the column.
  3. Filter by keyword, date or month. Or check off specific keywords or phrases from individual cells.

Sum: After filtering you can quickly add up items under a particular column to gauge volume for a message type, keyword or tag.

  1. Select a cell, then hold down shift to select all the items you’d like to sum.
  2. Find the total, in the bottom bar labeled Count.

If Contains: You can also count the number of times a keyword or tag is mentioned in a specific column with an “If Contains” formula.

Enter =COUNTIF(COLUMN:COLUMN,”*tag_name*”) in a cell just below a particular column.

For example, if you’d like to know how many messages were tagged under “billing” enter =COUNTIF(J:J,”*billing*”).

Note: You can also use “If Contains”  to search for a specific word in messages.

Comma Delimited: If you have multiple tags assigned to a message, they will all appear in the same column. In order to separate each tag into its own column, you can separate each value using Comma Delimited.

  1. Select Tags column.
  2. Click the Data tab. Select Text to Columns.
  3. Select Delimited. Then, click Next.
  4. Check Comma. Click Next.
  5. Click Finish.

Compare Tags: If you’d like to compare tags across all messages, you can manually separate them out using a combination of filters and marking columns.

  1. Add a filter to the Tags column, “J”.
  2. Filter by a specific tag.
  3. Add a column to the right. Label it with the tag name.
  4. Enter an X or another symbol to each row in the tag_name column.
  5. Select Clear Filter.
  6. Repeat for other Tags.

Sprout’s Inbox Export tool drives insights beyond performance and raw data. It gives brands a deeper understanding of context and the quality of their social communication. Inbox Export helps make it possible to surface meaningful insights about audience, team and social presence, ultimately informing overall business objectives.

If you have any other best practices for sorting content, feel free to comment below and share!

This post Getting Granular With Message Data Using Sprout’s Inbox Export   originally appeared on Sprout Social.

Click Here For Original Source Of The Article

Ads by WOW Trk

About Daniel Rodgers

Daniel Rodgers
A lot of news that you will not see in the paper. A lot of technology that is coming out that will not see in the paper.

Check Also

Digital Marketing News: Alignment Challenges, Instagram’s ‘Collection’ & Amp for Email

The Top Three Reasons Sales and Marketing Alignment Is Off [Infographic]
Communication, broken processes and disconnected metrics are the top three reasons that sales and marketing alignment is off. Is it an issue of focus, priorities, or something else? MarketingProfs

Instagram Gives Brands New Way to Sell In 'Collection' Ads
Instagram launched "collection" ads, which allow users to shop and purchase directly through the Instagram platform. AdAge

Google Announces Amp For Email – Delivering Accelerated Mobile Pages Experiences To Your Inbox
The new spec is available today through the Gmail Developer Preview, with support in Gmail slated for later this year. MarketingLand

Instagram Tests Its Version Of The Retweet But Thru Stories
Instagram has begun testing a new feature that would allow users to share public posts from other profiles to their own followers through the Stories feature. MarketingLand

Nielsen Creates New Metric to Measure the Effectiveness of Product Integrations
Nielsen is launching a new metric that may help marketers and publishers standardize brand mentions across platforms, like TV, short-form video and subscription-video-on-demand services. AdWeek

Google Launches New Look For ‘People Also Search For’ Search Refinements
Go to a search result, click on a listing, and then click back to the search results page on Google to trigger this on Google desktop search. Search Engine Land

Breaking Up With Facebook: Users Confess They're Spending Less Time
Mark Zuckerberg says recent changes have reduced the amount of time users spend on Facebook by 50 million hours each day, but those changes aren't the only reasons, according to users. USA Today

How Facebook Is Changing the Way It Reports Organic Reach for Page Posts
A redesign of Page Insights began rolling out this week for iOS and Android, along with a more accurate way for page admins to determine the effectiveness of their organic posts. AdWeek

New Research: Account-Based Marketing Trends: Top Channels, Priorities, and Challenges
New research indicates that the top challenges and priorities for account based marketing are the same – aligning sales and marketing, attributing marketing efforts to revenue and scoring and targeting ideal accounts. MarketingProfs

Snapchat Is Opening Up Its Marketing Platform to All Ad-Tech Players and Agencies
Snapchat is opening up their API to allow companies more access to their ad buying platform, and potentially more data. AdWeek

Google Sets Deadline for HTTPS and Warns Publishers to Upgrade Soon
If you haven’t made the switch on your site from http to https, it’s time to get started. Google has set a deadline of July 2018, after which Chrome will begin warning users explicitly if a site is insecure. Search Engine Journal

Statistics on Personalized Content

On the Lighter Side:
Google Launches 2018 Winter Olympics Features Across Search Results - Search Engine Journal
McDonald’s Absurdly Lavish ‘Bling Mac’ Ring Could Be Yours, If You Love It Enough - AdWeek
Over 150 New Emojis to Be Released on iPhone and Android This Year - Independent

TopRank Marketing (And Clients) In the News:
Rachel Miller & Lee Odden - Top 100 Social Media and Marketing Influencers - Digital Scouting
Lee Odden -  37 Digital Marketing Conference Speakers Who Will Inspire Your Marketing Programs - Outbrain
Lee Odden - Who Were The Top CMO Influencers Of 2017?  - Forbes
Lee Odden - 16 Digital Rockstars you Need to Follow - neilmchugh

We'll be back next week with more digital marketing news! In the meantime, quench your digital marketing thirst by checking out TopRank Marketing on YouTube and Twitter!

The post Digital Marketing News: Alignment Challenges, Instagram’s ‘Collection’ & Amp for Email appeared first on Online Marketing Blog - TopRank®.

Leave a Reply

Your email address will not be published. Required fields are marked *