Clicks, Likes and Shares in VAL

June 22, 2020

In our previous article on Clicks, Likes and Shares we have highlighted the basic data you would need to identify the amount of engagement taking place for the content you have posted to assess its effectiveness. This is usually a process where you have to log into each and every social media analytics to identify the results and downloading the data to combine that data with other social media data to have a holistic view. A process that is pretty much waste of time At ThinkVAL, we used VAL for that purpose freeing time up for doing analysis and fine-tuning our strategy instead of wasting it on copy, paste and vlookup.

We utilize the integration API from linkedin analytics and facebook insights to load the data into VAL.

In VAL, we have three tables created.

FI - Post: Store the analytics data for post in Facebook (this is stored at a lifetime aggregated view level as thats what facebook provide as of the moment)

LA - Post: Store the analytics data for post in LinkedIn (this is stored based on daily engagement, allowing us to have a better day to day view of engagement)

Marketing Metrics - Aggregate the data from FI - Post and LA - Post to have an overview of SNS metrics across both platform

On the back of the data, we created a dashboard to visualize the data. Below is an explanation of each of the widget defined, we have created the example based on Facebook and LinkedIn.

Dashboard

Overview across all social media channels

Dashboard

Title: # Impressions

Widget Type: Big Number

Period: Inception till date

Purpose: Shows the total posts’ impressions across both Facebook and LinkedIn

Title: # Clicks

Widget Type: Big Number

Period: Inception till date

Purpose: Shows the total posts’ clicks across both Facebook and LinkedIn

Title: # Likes

Widget Type: Big Number

Period: Inception till date

Purpose: Shows the total posts’ likes across both Facebook and LinkedIn

Title: # Shares

Widget Type: Big Number

Period: Inception till date

Purpose: Shows the total posts’ shares likes across both Facebook and LinkedIn

Title: SNS Post Trend

Widget: Multi-series Line chart

Period: Inception till date (Group Weekly)

Purpose: Shows the number of post published weekly in each social platform

Title: Impressions, Clicks, Likes and Shares by SNS

Widget: Multi-series Grouped Bar Chart

Period: Current

Purpose: Shows the number of posts’ impressions, clicks, likes and shares in each platform.

Facebook and LinkedIn Post Details

Dashboard

Title: # Impressions (LinkedIn, Facebook)

Widget Type: Big Number

Period: Inception till date

Purpose: Shows the total posts’ impressions in each of the social platform

Title: # Clicks (LinkedIn, Facebook)

Widget Type: Big Number

Period: Inception till date

Purpose: Shows the total posts’ clicks in each of the social platform

Title: # Likes (LinkedIn, Facebook)

Widget Type: Big Number

Period: Inception till date

Purpose: Shows the total posts’ likes in each of the social platform

Title: # Shares (LinkedIn, Facebook)

Widget Type: Big Number

Period: Inception till date

Purpose: Shows the total shares’ clicks in each of the social platform

Title: # Social Platform Impressions, Clicks, Likes and Shares Trend (LinkedIn)

Widget Type: Multi-series Line Chart

Period: Inception till date (Group Weekly)

Purpose: Shows the trend of engagement on all LinkedIn posts on a weekly basis

Title: # Social Platform Impressions, Clicks, Likes and Shares (Facebook)

Widget Type: Bar Chart

Period: Current

Purpose: Shows the life-time impressions, clicks, likes and shares in Facebook

Title: Social Platform Post Trends (LinkedIn, Facebook)

Widget Type: Line Chart

Period: Inception till date

Purpose: Shows the number of post published weekly in each of the social platform

Title: 5 Most Recent Social Platform Posts (LinkedIn, Facebook)

Widget Type: Tables

Period: Current

Purpose: List the recent 5 posts and its current engagement level

Dashboard

Derived Insight

So what does all these different visualization tells me?

All of the above quantifies the engagement you are attracting from the content you are posting and also the level of engagement. A couple of questions and actions might arise from here:

Are your post just appearing in front of user and thus impression is increasing? Or are there actual engagement with your post?

  • Impressions are typically not a good indicator of effectiveness. It gives you how many have seen or browse through it but not the level of engagement
  • The clicks, likes and shares provide you with an insights on the type of reader you have. By performing any of those action, its one step further in engagement, however are you able to identify the people who are liking and sharing your post as those are your allies.

Are you posting enough and are there posts on published generating a spike in activity?

So till date we have covered the basics of google analytics and social media analytics. In our next post we will start looking into basic ads analytics and we will start progressing into how we bring all these data together and create actionable metrics out of it.

Till then have a 🎉 good week ahead!

If you will like to get your hands on the above data and dashboard, signup for VAL and we send you an invite to your email to join the demo environment. So signup now

If you want us to help you create the base to get started, fill up our short questionaire or reach out to us at friends@thinkval.com. We would do that for you at no extra cost.


About the author

Melvin is the founder of ThinkVAL. He believes that everything has to be done with a purpose and an intent, thats the only way to create true value.