{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Activity by Day"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Activity by Day","index":0,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,8,2,10],[1,1,1,6],[2,1,3,6],[2,7,3,7],[4,1,4,6],[4,8,4,10],[6,1,6,10],[8,8,8,10],[37,1,37,12]]}
[null,"HL Retail - North America - Activity by Day - MTD",{"$nulls":5},""]
[null,"Advertiser: Malformed Industries",{"$nulls":5},""]
[null,"Campaign: Example malformed data.",{"$nulls":5},""]
[]
[null,"Dates: 06/01/16 - 06/25/16","","","","","","","","",""]
[]
[null,""]
[]
[null,"","","","","","","","Attributable Sales","","",""]
[null,"Date","Campaign","Impressions","Clicks","CTR","Avg. CPC","Spend","Sales Units","Sales","ROAS",""]
[null,"06/25/16","Malformed Campaign",3599619,13351,0.00370900364733045,2.6303323046962774324020672609,35117.5666,58,16751.5900,0.4770145434849121920651529426,"*"]
[null,"06/24/16","Malformed Campaign",3688128,12660,0.00343263574366183,2.7596118641390205371248025276,34936.6862,91,22754.2200,0.6512987485344274008449032582,""]
[null,"06/23/16","Malformed Campaign",4506078,13630,0.00302480338777979,2.6481353484959647835656639765,36094.0848,82,20118.3800,0.5573871760837665012633870689,""]
[null,"06/22/16","Malformed Campaign",2444290,6813,0.00278731247110613,2.7685859973579920739762219287,18862.3764,68,17344.0800,0.9195066216577037451124133012,""]
[null,"06/21/16","Malformed Campaign",2232153,6702,0.00300248235672017,2.5169007758877946881527902119,16868.2690,78,23181.8000,1.3742844627388856556650833586,""]
[null,"06/20/16","Malformed Campaign",4766064,11247,0.00235980884855931,2.9917941317684715924246465724,33648.7086,53,14909.3400,0.4430880298330379312090449736,""]
[null,"06/19/16","Malformed Campaign",3503360,12064,0.00344355133357691,3.2881205072944297082228116711,39667.8858,64,18297.8600,0.4612764111567549183576604932,""]
[null,"06/18/16","Malformed Campaign",4131727,12606,0.00305102442634763,3.1588001903855306996668253213,39819.8352,55,13080.8000,0.3284996016256742318210297365,""]
[null,"06/17/16","Malformed Campaign",6020217,13099,0.00217583518999398,2.9371894495763035346209634323,38474.2446,56,13509.1300,0.3511213836801359837484632512,""]
[null,"06/16/16","Malformed Campaign",1350670,6244,0.0046228908615724,2.1014361306854580397181294042,13121.3672,75,16224.9500,1.2365289190291084910724851904,""]
[null,"06/15/16","Malformed Campaign",1662016,5752,0.00346085717586353,1.9258735396383866481223922114,11077.6246,53,14934.5500,1.3481726037186708782314215631,""]
[null,"06/14/16","Malformed Campaign",1022998,3542,0.00346237236045427,1.771755223037831733483907397,6275.5570,48,14744.7400,2.349550804813022971506752309,""]
[null,"06/13/16","Malformed Campaign",371016,1721,0.00463861396813075,1.2973929110981987216734456711,2232.8132,68,37202.3100,16.66163116556279764021459565,""]
[null,"06/12/16","Malformed Campaign",2889080,10379,0.00359249311199413,1.1641249253299932556122940553,12082.4526,56,19530.3900,1.616425956432057511237412179,""]
[null,"06/11/16","Malformed Campaign",3312938,10145,0.00306223660086606,1.2316004337111877772301626417,12494.5864,78,22285.8900,1.7836436746717762502326607626,""]
[null,"06/10/16","Malformed Campaign",2780063,7863,0.00282835317041376,1.3514768409004196871423120946,10626.6624,63,16151.5800,1.5199108988349907493061979648,""]
[null,"06/09/16","Malformed Campaign",2126902,5313,0.00249799943767978,1.680911236589497459062676454,8930.6814,73,17947.5900,2.0096551647223693367899116858,""]
[null,"06/08/16","Malformed Campaign",1381539,5430,0.00393039935897575,1.8784226519337016574585635359,10199.8350,82,19813.8100,1.9425618159509443044912001027,""]
[null,"06/07/16","Malformed Campaign",3413896,13221,0.00387270145311984,1.7110887678692988427501701838,22622.3046,131,32385.7800,1.4315862407758403182317684822,""]
[null,"06/06/16","Malformed Campaign",4744718,21883,0.00461207599692964,1.7127016314033724809212630809,37479.0498,117,28151.6600,0.7511305689505500750448587947,""]
[null,"06/05/16","Malformed Campaign",4339346,20049,0.0046202814894226,1.8114824180757144994762831064,36318.4110,96,22960.9100,0.6322113046190264216129940266,""]
[null,"06/04/16","Malformed Campaign",4836674,20885,0.00431804996574092,1.6621265405793631793152980608,34713.5128,75,17711.0300,0.5102056395744541301507233229,""]
[null,"06/03/16","Malformed Campaign",5688996,20861,0.00366690361533037,1.6587493888116581180192704089,34603.1710,108,29560.9800,0.8542852907902573437561546021,""]
[null,"06/02/16","Malformed Campaign",3335349,11699,0.00350757896699866,1.665314847422856654414907257,19482.5184,72,17209.0500,0.883307262781797244446590642,""]
[null,"06/01/16","Malformed Campaign",2400137,7374,0.00307232462146952,1.3173998101437483048548955791,9714.5062,62,14186.2600,1.4603171492134103532714817764,""]
[null,"Total",1,80547974,274533,0.00340831663872762,2.09615860679773,575464.7108,1862,500948.6800,0.8705115545722877712903885678,""]
[]
[null,"Notes:\n                        â�¢ ROAS reporting in Grey and Italics represents that there is not enough data to confidently measure ROAS for this time period.\n                        â�¢ Lines with a * represent that sales data could still be pending. Sales data may take up to 36 hours to be fully reported."]