{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Report","Pivot"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Report","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,1,7,3]]}
["Regular Expression Examples"]
[]
[]
[]
[]
[]
[]
[null,"Dimensions"]
[]
["Campaign","Product","Brand","Distribution","Impressions","Clicks","Cost"]
["Product(Road Bike)",{"$f":"IFERROR(regexfind($A11,B$10&\"\\(([^\\)]+)\\)\"),\"\")","v":"Road Bike"},{"$f":"IFERROR(regexfind($A11,C$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},{"$f":"IFERROR(regexfind($A11,D$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},{"$f":"RANDBETWEEN(50000,2987545)","v":1705071},{"$f":"(RANDBETWEEN(0.2,3.7)/100)*E11","v":34101.42},{"$f":"RANDBETWEEN(1,2.5)*F11","v":68202.84}]
["Product(Road Bike) Distribution(Content)",{"$f":"IFERROR(regexfind($A12,B$10&\"\\(([^\\)]+)\\)\"),\"\")","v":"Road Bike"},{"$f":"IFERROR(regexfind($A12,C$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},{"$f":"IFERROR(regexfind($A12,D$10&\"\\(([^\\)]+)\\)\"),\"\")","v":"Content"},{"$f":"RANDBETWEEN(50000,2987545)","v":1381247},{"$f":"(RANDBETWEEN(0.2,3.7)/100)*E12","v":13812.470000000001},{"$f":"RANDBETWEEN(1,2.5)*F12","v":13812.470000000001}]
["Product(Mountain Bike)",{"$f":"IFERROR(regexfind($A13,B$10&\"\\(([^\\)]+)\\)\"),\"\")","v":"Mountain Bike"},{"$f":"IFERROR(regexfind($A13,C$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},{"$f":"IFERROR(regexfind($A13,D$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},1391691,41750.729999999996,83501.459999999992]
["Product(Mountain Bike) Distribution(Content)",{"$f":"IFERROR(regexfind($A14,B$10&\"\\(([^\\)]+)\\)\"),\"\")","v":"Mountain Bike"},{"$f":"IFERROR(regexfind($A14,C$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},{"$f":"IFERROR(regexfind($A14,D$10&\"\\(([^\\)]+)\\)\"),\"\")","v":"Content"},1546110,15461.1,15461.1]
["Brand(ACME Bikes)",{"$f":"IFERROR(regexfind($A15,B$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},{"$f":"IFERROR(regexfind($A15,C$10&\"\\(([^\\)]+)\\)\"),\"\")","v":"ACME Bikes"},{"$f":"IFERROR(regexfind($A15,D$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},2046187,40923.74,81847.48]
["Product(Other)",{"$f":"IFERROR(regexfind($A16,B$10&\"\\(([^\\)]+)\\)\"),\"\")","v":"Other"},{"$f":"IFERROR(regexfind($A16,C$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},{"$f":"IFERROR(regexfind($A16,D$10&\"\\(([^\\)]+)\\)\"),\"\")","v":""},1627190,32543.8,32543.8]

{"sheet":"Pivot","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Product","Sum of Impressions","Sum of Clicks","Sum of Cost"]
["",5377243,132455.19,237016.97]
[null,1799012,53970.36,107940.72]
["Mountain Bike",2529571,50591.42,101182.84]
["Other",692021,20760.63,20760.63]
["Road Bike",356639,7132.78,7132.78]
["Content",3459976,49398.36,98796.72]
["Mountain Bike",739930,22197.899999999998,44395.799999999996]
["Road Bike",2720046,27200.46,54400.92]
["Grand Total",8837219,181853.55,335813.69]