Creating a Beastmode/ Dimension

EMart
EMart 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:

Best Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

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

    CASE 
    
    WHEN `Facebook Engagements` IS NOT NULL OR `Facebook Impressions` IS NOT NULL THEN 'Facebook'
    
    WHEN `Twitter Engagements` IS NOT NULL OR `Twitter Post Impressions` IS NOT NULL THEN 'Twitter'
    
    WHEN `TikTok Engagements` IS NOT NULL OR `TikTok Impressions` IS NOT NULL THEN 'TikTok'
    
    ELSE 'Other'
    
END

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

  • ggenovese
    ggenovese Contributor
    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

  • ArborRose
    ArborRose Coach
    Answer ✓

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

    CASE 
    
    WHEN `Facebook Engagements` IS NOT NULL OR `Facebook Impressions` IS NOT NULL THEN 'Facebook'
    
    WHEN `Twitter Engagements` IS NOT NULL OR `Twitter Post Impressions` IS NOT NULL THEN 'Twitter'
    
    WHEN `TikTok Engagements` IS NOT NULL OR `TikTok Impressions` IS NOT NULL THEN 'TikTok'
    
    ELSE 'Other'
    
END

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

  • EMart
    EMart Member

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

  • EMart
    EMart 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.

  • ggenovese
    ggenovese Contributor
    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!

Categories