Join our Community in its new Home - The Datorama Trailblazer Community Group!

It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.

We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.

We can’t wait to see you there!

How to measure the Social Engagement?

Salomon_AcrichSalomon_Acrich SYS_ADMIN IMG42
edited May 2018 in Show & Tell

Trying to get insights from Social data is always a tough battle. Each Social platforms provides different metrics, some of them in a Lifetime basis, some of them in a daily basis… Does it mean there is no way to cross data between all my Social platforms? Of course not, today we are going to show you how to win this battle to Social data.

Let's do it!

  1. Define what we consider "Engagement". In this case, we defined the formula as the "user interactions" divided by the "total reach".
  2. Select the relevant metrics of each of the platforms and create the calculated measurements:

User Interactions

  • Facebook: Social Post Likes + Social Post Comments + Social Post Shares
  • Instagram: Social Post Likes + Social Post Comments
  • LinkedIn: Social Post Likes + Social Post Comments + Social Post Shares
  • Twitter: Social Post Likes + Social Post Clicks
  • YouTube: Shares + Comments

In order to be able to cross them, we will create a calculated measurement turning all of them to a Lifetime basis:

  1. Set the Aggregation Function as Lifetime.
  2. Set the lowest level we want to set the Lifetime basis.
  3. Set SUM as Total Aggregation Function to sum the engagement of the different platforms.

Total Reach We leave the definiton to you, who are the experts ;)

  1. Create a report with all the historical data for these two measures (+desired dimensions) and re-immerse it.

Once you map the file, set the aggregation of the two measurements as Lifetime.

Finally, use these two measurements to calculate the "Total Engagement"!

  1. Get Insights from your Social data!

Sign In or Register to comment.