Skip to content

    • Beast Mode

    Beast Mode

    Creating a Beastmode/ Dimension

    Member
    in Beast Mode

    I have a set of data that includes columns like " Facebook Engagements, Facebook Impressions, Twitter Engagements, Twitter Post Impressions, TikTok engagements, TikTok Impressions" how do I create a dimension or beastmode where you will be able to filter by platform, e.g.: Facebook, Twitter, TikTok.

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • Coach
      Answer ✓

      Create a platform field formula. Then filter on the new field.

      1. CASE 
      2.     WHEN `Facebook Engagements` IS NOT NULL OR `Facebook Impressions` IS NOT NULL THEN 'Facebook'
      3.     WHEN `Twitter Engagements` IS NOT NULL OR `Twitter Post Impressions` IS NOT NULL THEN 'Twitter'
      4.     WHEN `TikTok Engagements` IS NOT NULL OR `TikTok Impressions` IS NOT NULL THEN 'TikTok'
      5.     ELSE 'Other'
      6. END

      ** Was this post helpful? Click Agree or Like below. **
      ** Did this solve your problem? Accept it as a solution! **

    • Coach
      Answer ✓

      Hi - Is sounds as if your data is not set up for this, I would recommend using Magic ETL.

      The steps would be:

      • Add a Select Columns, choose your conforming dimensions and your Facebook specific columns
        • rename Facebook Engagements as Engagements, rename Facebook Impressions as Impressions, etc.
      • Add a Select Columns for Twitter and TikTok in the same way
      • After each select columns add a Add Constants tile and create a constant column named "Platform" and set the value equal to the platform
      • Then use the Append tile to append the 3 Select Columns together
      • Next add a filter to remove all rows where Impressions AND Engagements are NULL - this step is not required but helps clean up empty space in the data
      • connect the filter to an output dataset and build your cards off of this output.

      Hope that helps!

    Answers

    • Coach
      Answer ✓

      Create a platform field formula. Then filter on the new field.

      1. CASE 
      2.     WHEN `Facebook Engagements` IS NOT NULL OR `Facebook Impressions` IS NOT NULL THEN 'Facebook'
      3.     WHEN `Twitter Engagements` IS NOT NULL OR `Twitter Post Impressions` IS NOT NULL THEN 'Twitter'
      4.     WHEN `TikTok Engagements` IS NOT NULL OR `TikTok Impressions` IS NOT NULL THEN 'TikTok'
      5.     ELSE 'Other'
      6. END

      ** Was this post helpful? Click Agree or Like below. **
      ** Did this solve your problem? Accept it as a solution! **

    • Member

      Thank you so much! I will attempt to build this formula and follow-up if it works! Greatly appreciate the support!

    • Member

      Following up : The only filter showing up is Facebook although there is data across all the other social platforms. To add some context, all the columns are set as dimensions, so we want any dimension (column) that includes the word Facebook to be filtered as "Facebook", all that include the word "Twitter" to be filtered at "Twitter" etc.

    • Coach
      Answer ✓

      Hi - Is sounds as if your data is not set up for this, I would recommend using Magic ETL.

      The steps would be:

      • Add a Select Columns, choose your conforming dimensions and your Facebook specific columns
        • rename Facebook Engagements as Engagements, rename Facebook Impressions as Impressions, etc.
      • Add a Select Columns for Twitter and TikTok in the same way
      • After each select columns add a Add Constants tile and create a constant column named "Platform" and set the value equal to the platform
      • Then use the Append tile to append the 3 Select Columns together
      • Next add a filter to remove all rows where Impressions AND Engagements are NULL - this step is not required but helps clean up empty space in the data
      • connect the filter to an output dataset and build your cards off of this output.

      Hope that helps!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories