Social Media Graphext Recipe

filter_duplicates(ds, {
    "columns": [
        "url"
    ]
}) => (ds)

derive_column(ds,
              {
                  "script": "return (row.retweetCount + row.likeCount + row.replyCount) / row.viewCount * 100;",
                  "type": "number"
              }) -> (ds["Engagement Rate"])

derive_column(ds,
              {
                  "script": "return row.retweetCount / row.viewCount * 100;",
                  "type": "number"
              }) -> (ds["Amplification Rate"])

derive_column(ds,
              {
                  "script": "return row.likeCount / row.viewCount * 100;",
                  "type": "number"
              }) -> (ds["Applause Rate"])

derive_column(ds,
              {
                  "script": "return row.replyCount / row.viewCount * 100;",
                  "type": "number"
              }) -> (ds["Conversation Rate"])

derive_column(ds,
              {
                  "script": "return row.retweetCount / row.likeCount * 100;",
                  "type": "number"
              }) -> (ds["Virality Rate"])

derive_column(ds,
              {
                  "script": "return (row.retweetCount + row.likeCount + row.replyCount + row.quoteCount) / row.viewCount * 100;",
                  "type": "number"
              }) -> (ds["Interaction Rate"])

derive_column(ds,
              {
                  "script": "return (row.viewCount / row.authorFollowers) * 100;",
                  "type": "number"
              }) -> (ds["Exposure Rate"])

derive_column(ds,
              {
                  "script": "return (row.retweetCount + row.likeCount + row.replyCount) / row.authorFollowers * 100;",
                  "type": "number"
              }) -> (ds["Engagement per Follower"])

derive_column(ds,
              {
                  "script": "return row.bookmarkCount / row.viewCount * 100;",
                  "type": "number"
              }) -> (ds["Bookmark Rate"])



create_project(ds)