HK: PIDS Change Roundup Ranges for CPS 1500-2000-2000+

[jesusitd]

Must change:

• All AdsPerformanceCategories CPS Measures

  VAR _threshold1 = SWITCH ( _leadType, "Talcum", 2000, "Roundup", 1500, "Hernia Mesh", 500, 1000 )
  VAR _threshold2 = SWITCH ( _leadType, "Talcum", 3000, "Roundup", 2000, "Hernia Mesh", 800, 1300 )

• SlicerAdsBucketsTitles query

  let
  Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("rdG9DoIwFAXgV7lpYAPTFokyGgcX/xI1DMhApCKDlJTq89uWUYopcaScL6f3NssQQQE68xaOTNy5eNZNBauygxDWvHkzMYPrC+OIAcW+LXlpQXLwCMZYqU7qBJzqqmHlLxI7E+reMlSSBxmiyu3q0j46iX311U8+GDQzhx6hSTJwJwuJDUkcCDUt1IWYksUA0INHiqVc9D9GXv2mN2DPeiRSmz0I2AhWSFXxfTmbNK84SUaT5XIc6sXMFdfptJYP2HPYsqLs/n6W5x8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Ad Table Bucket Number" = _t, #"Title For Conversion %" = _t, #"Title For Cost Per Signed" = _t, #"Title CPS Roundup" = _t, #"Title CPS Talcum" = _t, #"Title CPS Hernia Mesh" = _t]),
  #"Changed Type" = Table.TransformColumnTypes(Source,{{"Ad Table Bucket Number", Int64.Type}})
  in
  #"Changed Type"

[jesusitd]

• DONE 2000
• DONE 3000
• DONE 6000
• DONE 8000

[jesusitd]

Done.