\n $\"${Series1}$ \n

\n

\n\n","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"c65d1ca2-4","type":"html_data","dstContext":{"kid":"a5e99afa9619fd463982e2f825e272d1","id":"dstc65d1ca24"}}],"overflow":"ns","displayName":"Logo","id":"408318bb-3","type":"html_tpl2","dstContext":{"id":"dst408318bb3"},"renamed":true},{"layoutConfig":{"x":7.0,"y":0.0},"vis":false,"components":[{"role":"values","data":[["This Week","Last Week","This Month","Last Month","This Quarter","Last Quarter","This Year","Last Year","Last 7 Days","Last 30 Days","Last 365 Days"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"array(\"This Week\",\"Last Week\",\"This Month\",\"Last Month\",\"This Quarter\",\"Last Quarter\",\"This Year\",\"Last Year\",\"Last 7 Days\", \"Last 30 Days\", \"Last 365 Days\")","ver":2.0}],"autoFmt":false,"id":"0afe3d96","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"bd700b96","type":"proxy"}],"displayName":"User Input Control 2 Copy","scope":2.0,"inputLabel":"Date Range","controlHidden":"hidden","inputType":1.0,"id":"c344e36a","type":"input","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dstc344e36a"},"propName":""},{"layoutConfig":{"x":1.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["d"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",\"d\",\"Yesterday\",\"d\",\"This Week\",\"d\",\"Last Week\",\"d\",\"This Month\",\"d\",\"Last Month\",\"d\",\"This Quarter\",\"m\",\"Last Quarter\",\"m\",\"This Year\",\"m\",\"Last Year\",\"m\",\"Last 7 Days\",\"d\", \"Last 30 Days\",\"d\", \"Last 365 Days\",\"m\")","ver":2.0}],"autoFmt":false,"id":"6c144227","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"8e236155","type":"proxy"}],"displayName":"User Input Control 5 Copy","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"a996613c","type":"input","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dsta996613c"},"propName":""},{"layoutConfig":{"x":2.0,"y":1.0},"tpl":"

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"3196fe1d-2","type":"html_data","dstContext":{"id":"dst3196fe1d2"}}],"overflow":"ns","displayName":"HTML Template 2","id":"c98139ff-1","type":"html_tpl2","dstContext":{"id":"dstc98139ff1"}},{"layoutConfig":{"x":3.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1654005600"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",DATE_STARTOF(today(),\"4\",0),\"Last Week\",DATE_STARTOF(today(),\"4\",-1),\"This Month\",DATE_STARTOF(today(),\"3\",0),\"Last Month\",DATE_STARTOF(today(),\"3\",-1),\"This Quarter\",DATE_STARTOF(today(),\"2\",0),\"Last Quarter\",DATE_STARTOF(today(),\"2\",-1),\"This Year\",DATE_STARTOF(today(),\"1\",0),\"Last Year\",DATE_STARTOF(today(),\"1\",-1),\"Last 7 Days\",DATE_ADD(today(),\"5\",-7), \"Last 30 Days\",DATE_ADD(today(),\"5\",-30), \"Last 365 Days\",DATE_ADD(today(),\"5\",-365))","ver":2.0}],"autoFmt":false,"id":"12b91e77","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"bbd7f3d9","type":"proxy"}],"displayName":"User Input Control 3 Copy","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"808e6b72","type":"input","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dst808e6b72"},"propName":""},{"layoutConfig":{"x":4.0,"y":1.0},"tpl":"

\nhttps://dashboardmagic.com.au/\n

\n +613 9917 3737\n

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"fc1b399e-4","type":"html_data","dstContext":{"kid":"a5e99afa9619fd463982e2f825e272d1","id":"dstfc1b399e4"}}],"displayName":"HTML Template 3","id":"89189951-3","type":"html_tpl2","dstContext":{"id":"dst891899513"}},{"layoutConfig":{"x":7.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1656511200"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",today(),\"Last Week\",DATE_ENDOF(today(),\"4\",-1),\"This Month\",today(),\"Last Month\",DATE_ENDOF(today(),\"3\",-1),\"This Quarter\",today(),\"Last Quarter\",DATE_ENDOF(today(),\"2\",-1),\"This Year\",today(),\"Last Year\",DATE_ENDOF(today(),\"1\",-1),\"Last 7 Days\",today(), \"Last 30 Days\",today(), \"Last 365 Days\",today())","ver":2.0}],"autoFmt":false,"id":"aeec633a","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"da6439b1","type":"proxy"}],"displayName":"User Input Control 4 Copy","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"76da41b1","type":"input","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dst76da41b1"},"propName":""}],"displayName":"Layout Grid 2","widths":[{"w":"5%","x":8.0},{"w":"5%","x":0.0},{"w":"20%","x":4.0},{"w":"20%","x":2.0},{"w":"20%","x":6.0}],"id":"d87da40f-1","cellData":[{"x":7.0,"y":0.0,"alignment":1.0},{"x":8.0,"y":0.0},{"x":4.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":0.0},{"x":3.0,"y":0.0},{"x":4.0,"y":1.0,"alignment":2.0},{"w":5.0,"x":2.0,"y":0.0},{"x":2.0,"y":1.0,"alignment":2.0},{"x":6.0,"y":1.0,"alignment":2.0},{"x":3.0,"y":1.0,"alignment":1.0},{"x":5.0,"y":1.0}],"type":"panel_grid","rows":2.0,"cols":9.0}],"containerClassName":"logo","isForked":false,"id":"16f1840f8503a883f1eaabe4c70d3283","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"685ef16df9cbec639ecf20b110cf9882"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","57dd9357fe0a39ed5a4e95efb33bdf31"],"dimensions":{"w":869.0}},"components":[{"size":"xx-small","data":[["Filter all data on the dashboard based on employee and date"]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Filter all data on the dashboard based on employee and date\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"a7ae1a14","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"be40568904eceb9ed3a044b7ee35456e","id":"dsta7ae1a14"},"wrap":true},{"components":[{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"values","data":[["Affiliate","Display","Email","Google Search","Paid Search","Referral","Social Media"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"group(slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,H:H;))","ver":2.0}],"autoFmt":false,"id":"3613ba92","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"2c7192fd","type":"proxy"}],"displayName":"User Input Control","scope":2.0,"inputLabel":"Channel","inputType":1.0,"id":"0b3c6aab","includeAllData":true,"type":"input","dstContext":{"kid":"be40568904eceb9ed3a044b7ee35456e","id":"dst0b3c6aab"},"propName":"channelFilter"},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[["This Week","Last Week","This Month","Last Month","This Quarter","Last Quarter","This Year","Last Year","Last 7 Days","Last 30 Days","Last 365 Days"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"array(\"This Week\",\"Last Week\",\"This Month\",\"Last Month\",\"This Quarter\",\"Last Quarter\",\"This Year\",\"Last Year\",\"Last 7 Days\", \"Last 30 Days\", \"Last 365 Days\")","ver":2.0}],"autoFmt":false,"id":"46049576","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"5ab7e74f","type":"proxy"}],"displayName":"User Input Control 2","scope":2.0,"inputLabel":"Date Range","inputType":1.0,"id":"a4aebef4","type":"input","dstContext":{"kid":"be40568904eceb9ed3a044b7ee35456e","id":"dsta4aebef4"},"propName":"TM_DateSelector"},{"layoutConfig":{"x":0.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["d"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($TM_DateSelector,\"Today\",\"d\",\"Yesterday\",\"d\",\"This Week\",\"d\",\"Last Week\",\"d\",\"This Month\",\"d\",\"Last Month\",\"d\",\"This Quarter\",\"m\",\"Last Quarter\",\"m\",\"This Year\",\"m\",\"Last Year\",\"m\",\"Last 7 Days\",\"d\", \"Last 30 Days\",\"d\", \"Last 365 Days\",\"m\")","ver":2.0}],"autoFmt":false,"id":"b22d6e04","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"a5bfb14b","type":"proxy"}],"displayName":"User Input Control 5","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"4461f7af","type":"input","dstContext":{"kid":"be40568904eceb9ed3a044b7ee35456e","id":"dst4461f7af"},"propName":"dateGroup"},{"layoutConfig":{"x":1.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1605963600"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($TM_DateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",DATE_STARTOF(today(),\"4\",0),\"Last Week\",DATE_STARTOF(today(),\"4\",-1),\"This Month\",DATE_STARTOF(today(),\"3\",0),\"Last Month\",DATE_STARTOF(today(),\"3\",-1),\"This Quarter\",DATE_STARTOF(today(),\"2\",0),\"Last Quarter\",DATE_STARTOF(today(),\"2\",-1),\"This Year\",DATE_STARTOF(today(),\"1\",0),\"Last Year\",DATE_STARTOF(today(),\"1\",-1),\"Last 7 Days\",DATE_ADD(today(),\"5\",-7), \"Last 30 Days\",DATE_ADD(today(),\"5\",-30), \"Last 365 Days\",DATE_ADD(today(),\"5\",-365))","ver":2.0}],"autoFmt":false,"id":"d9214308","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"746a4cee","type":"proxy"}],"displayName":"User Input Control 3","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"e2250e4c","type":"input","dstContext":{"kid":"be40568904eceb9ed3a044b7ee35456e","id":"dste2250e4c"},"propName":"dateStart"},{"layoutConfig":{"x":2.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1606136400"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($TM_DateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",today(),\"Last Week\",DATE_ENDOF(today(),\"4\",-1),\"This Month\",today(),\"Last Month\",DATE_ENDOF(today(),\"3\",-1),\"This Quarter\",today(),\"Last Quarter\",DATE_ENDOF(today(),\"2\",-1),\"This Year\",today(),\"Last Year\",DATE_ENDOF(today(),\"1\",-1),\"Last 7 Days\",today(), \"Last 30 Days\",today(), \"Last 365 Days\",today())","ver":2.0}],"autoFmt":false,"id":"15ffbaf8","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"8b9386e2","type":"proxy"}],"displayName":"User Input Control 4","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"e8c1c8be","type":"input","dstContext":{"kid":"be40568904eceb9ed3a044b7ee35456e","id":"dste8c1c8be"},"propName":"dateEnd"}],"displayName":"Layout Grid","id":"d16d585f","type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"bc3511fa737619e52907ff13d6a83400","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Filters","usesSampleData":false,"master":"be40568904eceb9ed3a044b7ee35456e"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","57dd9357fe0a39ed5a4e95efb33bdf31"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["Displays the average number of products that are viewed each time someone visits the website."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Displays the average number of products that are viewed each time someone visits the website.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"cc40f7ca","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"71038d619107ab339b32ab0d6fc584f2","id":"dstcc40f7ca"},"wrap":true},{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","data":[[3.68999511002445]],"displayName":"Primary Value1","formulas":[{"txt":"SUM(SELECT(&'85607397',BETWEEN(&'9e1f3e9c',$dateStart,$dateEnd)))/SUM(SELECT(&'3f8ee369',BETWEEN(&'ee499b3d',$dateStart,$dateEnd)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"num","dstContext":{"kid":"71038d619107ab339b32ab0d6fc584f2","id":"dste2b5f3b3"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"2","suffix":""},"id":"e2b5f3b3","renamed":true},{"role":"secondary","data":[["Average Product Views per Session"]],"displayName":"Secondary Value","formulas":[{"txt":"\"Average Product Views per Session\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"71038d619107ab339b32ab0d6fc584f2","id":"dst5801bacd"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"5801bacd"}],"displayName":"Value Pair","id":"6da5bcc1","type":"simple_value","dstContext":{"id":"dst6da5bcc1"}},{"components":[{"role":"primary","data":[[4.058994621026896]],"displayName":"Primary Value","formulas":[{"txt":"SUM(SELECT(&'85607397',BETWEEN(&'9e1f3e9c',$dateStart,$dateEnd)))/SUM(SELECT(&'3f8ee369',BETWEEN(&'ee499b3d',$dateStart,$dateEnd)))*1.1","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"71038d619107ab339b32ab0d6fc584f2","id":"dst8a0f221982"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"prefix":"Target: ","autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"precision":"2"},"id":"8a0f2219-82","conditions":[{"predicates":[{"left":{"cx":"e2b5f3b3"},"right":{"raw":"4.45"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-yellow","isScalar":true}]},{"predicates":[{"left":{"cx":"e2b5f3b3"},"right":{"raw":"4.89"},"type":"gteq"}],"reactions":[{"type":"icon","value":"ind-triangle-up-green"}]}]},{"role":"secondary","size":"xx-small","data":[],"displayName":"Secondary Value","fmtArgs":{"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[],"autoFmt":true,"id":"64f93533-83","type":"label","fmt":"txt","dstContext":{"kid":"71038d619107ab339b32ab0d6fc584f2","id":"dst64f9353383"}}],"displayName":"Value Pair 2","id":"8e09fe8a-81","type":"simple_value","dstContext":{"id":"dst8e09fe8a81"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["997597/4/27","816693/7/14","1342830/10/7","60850/5/21","248411/5/24","202475/1/21","1996854/2/18","882455/9/12","2064507/3/29","1230682/2/8","542889/6/9","1142626/4/13","137598/1/31","740805/12/30","36907/6/10","2087205/4/26","1420373/9/16","2697093/2/11","1017412/4/1","243362/1/15","1928109/10/12","686840/9/12","2375294/12/9","1492890/2/14","2313289/6/15","2687447/1/3","2646072/10/14","1330380/6/11","146789/5/22","1119780/12/22","2441326/3/2","2553784/11/22","2060834/8/20","1895528/4/23","2024165/1/24","1853341/9/30","2261294/4/10","1722832/6/12","1287279/4/3","99239/10/25","954592/6/4","2131046/12/7","1441256/9/19","2428755/9/13","819279/1/2","42850/7/23","648349/1/11","849457/4/17","1033685/4/28","1971310/12/16","436290/11/1","2515250/11/19","2325101/3/23","224804/5/10","648242/6/3","2127652/7/17","682009/3/21","460211/10/2","1341352/7/23","598254/4/13","1905066/7/25","157669/7/14","730916/7/19","1833540/10/30","1559273/5/9","2514260/3/6","378462/10/12","1791882/2/17","1034918/2/18","825755/7/8","2048402/11/24","750333/12/19","1894627/4/5","355311/11/18","2586395/11/13","2424091/9/8","975266/12/21","1034269/1/16","1128280/12/19","260817/1/9","2488939/10/8","834009/7/20","2456135/11/12","925112/6/3","2141305/2/14","2453537/2/2","1468298/7/2","2726807/7/7","1325183/4/23","1402135/2/11","1004237/4/4","1327687/5/13","609370/2/22","1958011/10/25","1710110/8/9","691760/6/9","225467/3/15","369937/7/11","2227815/12/20","1359292/11/15"]],"displayName":"ID","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,A:A;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"yyyy/M/d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"yyyy/M/d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"ID","id":"211de959"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5834132E9,1.5881688E9,1.5768468E9,1.5826356E9,1.593612E9,1.6013016E9,1.5964632E9,1.6029396E9,1.576242E9,1.5894648E9,1.6038036E9,1.5854868E9,1.5756372E9,1.604322E9,1.6039764E9,1.5989688E9,1.5772788E9,1.6054452E9,1.5998328E9,1.5974136E9,1.5876504E9,1.5826356E9,1.5906744E9,1.6011288E9,1.5902424E9,1.5815124E9,1.5819444E9,1.5813396E9,1.6059636E9,1.5837588E9,1.5851412E9,1.58886E9,1.5765876E9,1.5880824E9,1.5878232E9,1.5965496E9,1.5748596E9,1.5956856E9,1.5790068E9,1.5955128E9,1.5932664E9,1.5964632E9,1.5855732E9,1.5892056E9,1.5937848E9,1.5872184E9,1.5920568E9,1.5763284E9,1.5968952E9,1.58886E9,1.5837588E9,1.5898104E9,1.5751188E9,1.5968952E9,1.5825492E9,1.5961176E9,1.583154E9,1.5911928E9,1.5783156E9,1.5886872E9,1.5885144E9,1.5813396E9,1.598364E9,1.5998328E9,1.6036308E9,1.5855732E9,1.5767604E9,1.5954264E9,1.5997464E9,1.6011288E9,1.6027668E9,1.5769332E9,1.6033716E9,1.591452E9,1.6037172E9,1.5898104E9,1.5837588E9,1.6026804E9,1.6018164E9,1.587996E9,1.5807348E9,1.5954264E9,1.585314E9,1.587564E9,1.5987096E9,1.5999192E9,1.5895512E9,1.6026804E9,1.5752916E9,1.6028532E9,1.6044084E9,1.6054452E9,1.6022484E9,1.5834132E9,1.5913656E9,1.5963768E9,1.5985368E9,1.5799572E9,1.6007832E9,1.6039764E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,B:B;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"9e1f3e9c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["6 Mar 2020","30 Apr 2020","21 Dec 2019","26 Feb 2020","2 Jul 2020","29 Sep 2020","4 Aug 2020","18 Oct 2020","14 Dec 2019","15 May 2020","28 Oct 2020","30 Mar 2020","7 Dec 2019","3 Nov 2020","30 Oct 2020","2 Sep 2020","26 Dec 2019","16 Nov 2020","12 Sep 2020","15 Aug 2020","24 Apr 2020","26 Feb 2020","29 May 2020","27 Sep 2020","24 May 2020","13 Feb 2020","18 Feb 2020","11 Feb 2020","22 Nov 2020","10 Mar 2020","26 Mar 2020","8 May 2020","18 Dec 2019","29 Apr 2020","26 Apr 2020","5 Aug 2020","28 Nov 2019","26 Jul 2020","15 Jan 2020","24 Jul 2020","28 Jun 2020","4 Aug 2020","31 Mar 2020","12 May 2020","4 Jul 2020","19 Apr 2020","14 Jun 2020","15 Dec 2019","9 Aug 2020","8 May 2020","10 Mar 2020","19 May 2020","1 Dec 2019","9 Aug 2020","25 Feb 2020","31 Jul 2020","3 Mar 2020","4 Jun 2020","7 Jan 2020","6 May 2020","4 May 2020","11 Feb 2020","26 Aug 2020","12 Sep 2020","26 Oct 2020","31 Mar 2020","20 Dec 2019","23 Jul 2020","11 Sep 2020","27 Sep 2020","16 Oct 2020","22 Dec 2019","23 Oct 2020","7 Jun 2020","27 Oct 2020","19 May 2020","10 Mar 2020","15 Oct 2020","5 Oct 2020","28 Apr 2020","4 Feb 2020","23 Jul 2020","28 Mar 2020","23 Apr 2020","30 Aug 2020","13 Sep 2020","16 May 2020","15 Oct 2020","3 Dec 2019","17 Oct 2020","4 Nov 2020","16 Nov 2020","10 Oct 2020","6 Mar 2020","6 Jun 2020","3 Aug 2020","28 Aug 2020","26 Jan 2020","23 Sep 2020","30 Oct 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'9e1f3e9c',\"d MMM yyyy\"),\"m\",DATEVALUE(!'9e1f3e9c',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"943e97db"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Google Search","Display","Display","Google Search","Affiliate","Email","Email","Google Search","Email","Google Search","Referral","Social Media","Affiliate","Social Media","Referral","Affiliate","Paid Search","Paid Search","Paid Search","Email","Google Search","Affiliate","Google Search","Social Media","Affiliate","Social Media","Social Media","Referral","Affiliate","Paid Search","Affiliate","Social Media","Email","Email","Email","Display","Google Search","Google Search","Display","Email","Google Search","Paid Search","Paid Search","Social Media","Google Search","Email","Email","Google Search","Google Search","Email","Google Search","Display","Paid Search","Display","Social Media","Google Search","Google Search","Email","Google Search","Paid Search","Affiliate","Google Search","Email","Affiliate","Display","Social Media","Affiliate","Email","Display","Google Search","Affiliate","Google Search","Affiliate","Google Search","Paid Search","Social Media","Affiliate","Paid Search","Email","Paid Search","Google Search","Google Search","Paid Search","Social Media","Email","Paid Search","Social Media","Google Search","Paid Search","Social Media","Paid Search","Display","Referral","Email","Affiliate","Display","Google Search","Affiliate","Social Media","Email"]],"displayName":"Channel","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,H:H;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Channel","id":"f1c8ab58"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New"]],"displayName":"User Type","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,I:I;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"User Type","id":"b7402ec7"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["411.08","1817.24","4979","2052.88","887.7","1085.8","2458.62","777.36","171.36","1834.56","1914.39","856.8","7471.1","748.89","3103.51","639.84","668.59","1412.4","741.6","5058.02","1240.41","850.64","3707.7","1201.98","268.85","1258.02","375.36","4197.94","3177.27","4058.4","8091.72","4825.28","1166.16","906.87","3372.39","4087.89","1314.72","795.24","3765.54","2743","2376","1326.06","1017.5","3150.4","1705.22","1677.45","1123.44","4797.37","2566.8","5741.88","5256.2","3653","4731.56","1221.28","1805.44","4544.94","461.44","6818.56","990.36","3160.92","6400.81","2145.5","1707.52","4932.55","3785.61","5828.94","3930.08","57.6","3306.5","191.16","5289.78","883.52","3248.29","1081.44","723.34","1717","3717.35","1895.4","3736.26","2340.76","128.1","1331.76","399.1","2474.91","4581.46","1120.1","2222","1046.48","2398.34","226.2","2299.08","3357.9","430.44","1874.4","463.64","1892.8","1863.61","1866.24","2518.5","1887.48"]],"displayName":"Sales Value","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,F:F;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"85607397"}],"displayName":"Table","id":"e476acc1","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"f1c8ab58"},{"var":"channelFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"f1c8ab58","variation":"condition"},{"p":{"args":[{"dim":"b7402ec7"},{"args":[{"value":"\"New\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"b7402ec7","variation":"member"}],"kid":"71038d619107ab339b32ab0d6fc584f2","id":"dste476acc1"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6062228E9,1.6062228E9,1.6062228E9,1.6062228E9,1.6062228E9,1.6062228E9,1.6061364E9,1.6061364E9,1.6061364E9,1.6061364E9,1.6061364E9,1.6061364E9,1.60605E9,1.60605E9,1.60605E9,1.60605E9,1.60605E9,1.60605E9,1.6059636E9,1.6059636E9,1.6059636E9,1.6059636E9,1.6059636E9,1.6059636E9,1.6058772E9,1.6058772E9,1.6058772E9,1.6058772E9,1.6058772E9,1.6058772E9,1.6057908E9,1.6057908E9,1.6057908E9,1.6057908E9,1.6057908E9,1.6057908E9,1.6057044E9,1.6057044E9,1.6057044E9,1.6057044E9,1.6057044E9,1.6057044E9,1.605618E9,1.605618E9,1.605618E9,1.605618E9,1.605618E9,1.605618E9,1.6055316E9,1.6055316E9,1.6055316E9,1.6055316E9,1.6055316E9,1.6055316E9,1.6054452E9,1.6054452E9,1.6054452E9,1.6054452E9,1.6054452E9,1.6054452E9,1.6053588E9,1.6053588E9,1.6053588E9,1.6053588E9,1.6053588E9,1.6053588E9,1.6052724E9,1.6052724E9,1.6052724E9,1.6052724E9,1.6052724E9,1.6052724E9,1.605186E9,1.605186E9,1.605186E9,1.605186E9,1.605186E9,1.605186E9,1.6050996E9,1.6050996E9,1.6050996E9,1.6050996E9,1.6050996E9,1.6050996E9,1.6050132E9,1.6050132E9,1.6050132E9,1.6050132E9,1.6050132E9,1.6050132E9,1.6049268E9,1.6049268E9,1.6049268E9,1.6049268E9,1.6049268E9,1.6049268E9,1.6048404E9,1.6048404E9,1.6048404E9,1.6048404E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(57dd9357fe0a39ed5a4e95efb33bdf31@Marketing Spend,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"ee499b3d"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["25 Nov 2020","25 Nov 2020","25 Nov 2020","25 Nov 2020","25 Nov 2020","25 Nov 2020","24 Nov 2020","24 Nov 2020","24 Nov 2020","24 Nov 2020","24 Nov 2020","24 Nov 2020","23 Nov 2020","23 Nov 2020","23 Nov 2020","23 Nov 2020","23 Nov 2020","23 Nov 2020","22 Nov 2020","22 Nov 2020","22 Nov 2020","22 Nov 2020","22 Nov 2020","22 Nov 2020","21 Nov 2020","21 Nov 2020","21 Nov 2020","21 Nov 2020","21 Nov 2020","21 Nov 2020","20 Nov 2020","20 Nov 2020","20 Nov 2020","20 Nov 2020","20 Nov 2020","20 Nov 2020","19 Nov 2020","19 Nov 2020","19 Nov 2020","19 Nov 2020","19 Nov 2020","19 Nov 2020","18 Nov 2020","18 Nov 2020","18 Nov 2020","18 Nov 2020","18 Nov 2020","18 Nov 2020","17 Nov 2020","17 Nov 2020","17 Nov 2020","17 Nov 2020","17 Nov 2020","17 Nov 2020","16 Nov 2020","16 Nov 2020","16 Nov 2020","16 Nov 2020","16 Nov 2020","16 Nov 2020","15 Nov 2020","15 Nov 2020","15 Nov 2020","15 Nov 2020","15 Nov 2020","15 Nov 2020","14 Nov 2020","14 Nov 2020","14 Nov 2020","14 Nov 2020","14 Nov 2020","14 Nov 2020","13 Nov 2020","13 Nov 2020","13 Nov 2020","13 Nov 2020","13 Nov 2020","13 Nov 2020","12 Nov 2020","12 Nov 2020","12 Nov 2020","12 Nov 2020","12 Nov 2020","12 Nov 2020","11 Nov 2020","11 Nov 2020","11 Nov 2020","11 Nov 2020","11 Nov 2020","11 Nov 2020","10 Nov 2020","10 Nov 2020","10 Nov 2020","10 Nov 2020","10 Nov 2020","10 Nov 2020","9 Nov 2020","9 Nov 2020","9 Nov 2020","9 Nov 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'ee499b3d',\"d MMM yyyy\"),\"m\",DATEVALUE(!'ee499b3d',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"5995161c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate"]],"displayName":"Channel","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Marketing Spend,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Channel","id":"96fa2e8e"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["219.00","88.00","279.00","95.00","0.00","116.00","164.00","67.00","259.00","46.00","0.00","82.00","142.00","80.00","209.00","65.00","0.00","140.00","243.00","88.00","253.00","91.00","0.00","116.00","190.00","62.00","207.00","21.00","158.00","147.00","168.00","74.00","241.00","90.00","483.00","108.00","155.00","77.00","249.00","64.00","0.00","131.00","277.00","58.00","224.00","81.00","0.00","142.00","210.00","82.00","253.00","64.00","0.00","84.00","268.00","94.00","203.00","84.00","0.00","137.00","204.00","74.00","209.00","56.00","0.00","143.00","234.00","75.00","292.00","73.00","337.00","124.00","201.00","66.00","293.00","91.00","0.00","79.00","201.00","61.00","231.00","25.00","412.00","124.00","140.00","70.00","299.00","68.00","0.00","92.00","163.00","77.00","280.00","61.00","0.00","126.00","277.00","61.00","229.00","56.00"]],"displayName":"Visits","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Marketing Spend,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Visits","id":"3f8ee369"}],"displayName":"Table Copy","id":"141ade85","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"96fa2e8e"},{"var":"channelFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"96fa2e8e","variation":"condition"}],"kid":"71038d619107ab339b32ab0d6fc584f2","id":"dst141ade85"}}],"isForked":false,"id":"27a54cfbe924020d6d4d40a6a318ff0a","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Product Views per Session","usesSampleData":false,"master":"71038d619107ab339b32ab0d6fc584f2"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","57dd9357fe0a39ed5a4e95efb33bdf31"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["Track the number of users that buy items on their first visit to your site."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Track the number of users that buy items on their first visit to your site.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"1d147fac","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"974e09c5b01e0d700d26328240063c78","id":"dst1d147fac"},"wrap":true},{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","data":[[0.014669926650366746]],"displayName":"Primary Value1","formulas":[{"txt":"count(SELECT(&'77ab7775',BETWEEN(&'f8b64967',$dateStart,$dateEnd)))/SUM(SELECT(&'612d4d47',BETWEEN(&'bc5c0e37',$dateStart,$dateEnd)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"pct","dstContext":{"kid":"974e09c5b01e0d700d26328240063c78","id":"dst47de4b4f"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"2","suffix":""},"id":"47de4b4f","renamed":true},{"role":"secondary","data":[["New Visitor Conversion Rate"]],"displayName":"Secondary Value","formulas":[{"txt":"\"New Visitor Conversion Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"974e09c5b01e0d700d26328240063c78","id":"dst4b04c2d8"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"4b04c2d8"}],"displayName":"Value Pair","id":"4befd60f","type":"simple_value","dstContext":{"id":"dst4befd60f"}},{"components":[{"role":"primary","data":[[0.036674816625916866]],"displayName":"Primary Value","formulas":[{"txt":"count(SELECT(&'77ab7775',BETWEEN(&'f8b64967',$dateStart,$dateEnd)))/SUM(SELECT(&'612d4d47',BETWEEN(&'bc5c0e37',$dateStart,$dateEnd)))*2.5","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"pct","dstContext":{"kid":"974e09c5b01e0d700d26328240063c78","id":"dstd547266682"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"prefix":"Target: ","precision":"2"},"id":"d5472666-82","conditions":[{"predicates":[{"left":{"cx":"47de4b4f"},"right":{"raw":"0.50"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-green","isScalar":true}]},{"predicates":[{"left":{"cx":"47de4b4f"},"right":{"raw":"0.50"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]},{"role":"secondary","size":"xx-small","data":[[]],"displayName":"Secondary Value","fmtArgs":{"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[],"autoFmt":true,"id":"a43c1f27-83","type":"label","fmt":"txt","dstContext":{"kid":"974e09c5b01e0d700d26328240063c78","id":"dsta43c1f2783"}}],"displayName":"Value Pair 2","id":"44e2ed80-81","type":"simple_value","dstContext":{"id":"dst44e2ed8081"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["997597/4/27","816693/7/14","1342830/10/7","60850/5/21","248411/5/24","202475/1/21","1996854/2/18","882455/9/12","2064507/3/29","1230682/2/8","542889/6/9","1142626/4/13","137598/1/31","740805/12/30","36907/6/10","2087205/4/26","1420373/9/16","2697093/2/11","1017412/4/1","243362/1/15","1928109/10/12","686840/9/12","2375294/12/9","1492890/2/14","2313289/6/15","2687447/1/3","2646072/10/14","1330380/6/11","146789/5/22","1119780/12/22","2441326/3/2","2553784/11/22","2060834/8/20","1895528/4/23","2024165/1/24","1853341/9/30","2261294/4/10","1722832/6/12","1287279/4/3","99239/10/25","954592/6/4","2131046/12/7","1441256/9/19","2428755/9/13","819279/1/2","42850/7/23","648349/1/11","849457/4/17","1033685/4/28","1971310/12/16","436290/11/1","2515250/11/19","2325101/3/23","224804/5/10","648242/6/3","2127652/7/17","682009/3/21","460211/10/2","1341352/7/23","598254/4/13","1905066/7/25","157669/7/14","730916/7/19","1833540/10/30","1559273/5/9","2514260/3/6","378462/10/12","1791882/2/17","1034918/2/18","825755/7/8","2048402/11/24","750333/12/19","1894627/4/5","355311/11/18","2586395/11/13","2424091/9/8","975266/12/21","1034269/1/16","1128280/12/19","260817/1/9","2488939/10/8","834009/7/20","2456135/11/12","925112/6/3","2141305/2/14","2453537/2/2","1468298/7/2","2726807/7/7","1325183/4/23","1402135/2/11","1004237/4/4","1327687/5/13","609370/2/22","1958011/10/25","1710110/8/9","691760/6/9","225467/3/15","369937/7/11","2227815/12/20","1359292/11/15"]],"displayName":"ID","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,A:A;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"yyyy/M/d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"yyyy/M/d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"ID","id":"d795d000"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5834132E9,1.5881688E9,1.5768468E9,1.5826356E9,1.593612E9,1.6013016E9,1.5964632E9,1.6029396E9,1.576242E9,1.5894648E9,1.6038036E9,1.5854868E9,1.5756372E9,1.604322E9,1.6039764E9,1.5989688E9,1.5772788E9,1.6054452E9,1.5998328E9,1.5974136E9,1.5876504E9,1.5826356E9,1.5906744E9,1.6011288E9,1.5902424E9,1.5815124E9,1.5819444E9,1.5813396E9,1.6059636E9,1.5837588E9,1.5851412E9,1.58886E9,1.5765876E9,1.5880824E9,1.5878232E9,1.5965496E9,1.5748596E9,1.5956856E9,1.5790068E9,1.5955128E9,1.5932664E9,1.5964632E9,1.5855732E9,1.5892056E9,1.5937848E9,1.5872184E9,1.5920568E9,1.5763284E9,1.5968952E9,1.58886E9,1.5837588E9,1.5898104E9,1.5751188E9,1.5968952E9,1.5825492E9,1.5961176E9,1.583154E9,1.5911928E9,1.5783156E9,1.5886872E9,1.5885144E9,1.5813396E9,1.598364E9,1.5998328E9,1.6036308E9,1.5855732E9,1.5767604E9,1.5954264E9,1.5997464E9,1.6011288E9,1.6027668E9,1.5769332E9,1.6033716E9,1.591452E9,1.6037172E9,1.5898104E9,1.5837588E9,1.6026804E9,1.6018164E9,1.587996E9,1.5807348E9,1.5954264E9,1.585314E9,1.587564E9,1.5987096E9,1.5999192E9,1.5895512E9,1.6026804E9,1.5752916E9,1.6028532E9,1.6044084E9,1.6054452E9,1.6022484E9,1.5834132E9,1.5913656E9,1.5963768E9,1.5985368E9,1.5799572E9,1.6007832E9,1.6039764E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,B:B;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"f8b64967"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["6 Mar 2020","30 Apr 2020","21 Dec 2019","26 Feb 2020","2 Jul 2020","29 Sep 2020","4 Aug 2020","18 Oct 2020","14 Dec 2019","15 May 2020","28 Oct 2020","30 Mar 2020","7 Dec 2019","3 Nov 2020","30 Oct 2020","2 Sep 2020","26 Dec 2019","16 Nov 2020","12 Sep 2020","15 Aug 2020","24 Apr 2020","26 Feb 2020","29 May 2020","27 Sep 2020","24 May 2020","13 Feb 2020","18 Feb 2020","11 Feb 2020","22 Nov 2020","10 Mar 2020","26 Mar 2020","8 May 2020","18 Dec 2019","29 Apr 2020","26 Apr 2020","5 Aug 2020","28 Nov 2019","26 Jul 2020","15 Jan 2020","24 Jul 2020","28 Jun 2020","4 Aug 2020","31 Mar 2020","12 May 2020","4 Jul 2020","19 Apr 2020","14 Jun 2020","15 Dec 2019","9 Aug 2020","8 May 2020","10 Mar 2020","19 May 2020","1 Dec 2019","9 Aug 2020","25 Feb 2020","31 Jul 2020","3 Mar 2020","4 Jun 2020","7 Jan 2020","6 May 2020","4 May 2020","11 Feb 2020","26 Aug 2020","12 Sep 2020","26 Oct 2020","31 Mar 2020","20 Dec 2019","23 Jul 2020","11 Sep 2020","27 Sep 2020","16 Oct 2020","22 Dec 2019","23 Oct 2020","7 Jun 2020","27 Oct 2020","19 May 2020","10 Mar 2020","15 Oct 2020","5 Oct 2020","28 Apr 2020","4 Feb 2020","23 Jul 2020","28 Mar 2020","23 Apr 2020","30 Aug 2020","13 Sep 2020","16 May 2020","15 Oct 2020","3 Dec 2019","17 Oct 2020","4 Nov 2020","16 Nov 2020","10 Oct 2020","6 Mar 2020","6 Jun 2020","3 Aug 2020","28 Aug 2020","26 Jan 2020","23 Sep 2020","30 Oct 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'f8b64967',\"d MMM yyyy\"),\"m\",DATEVALUE(!'f8b64967',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"6e4b3bf8"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Google Search","Display","Display","Google Search","Affiliate","Email","Email","Google Search","Email","Google Search","Referral","Social Media","Affiliate","Social Media","Referral","Affiliate","Paid Search","Paid Search","Paid Search","Email","Google Search","Affiliate","Google Search","Social Media","Affiliate","Social Media","Social Media","Referral","Affiliate","Paid Search","Affiliate","Social Media","Email","Email","Email","Display","Google Search","Google Search","Display","Email","Google Search","Paid Search","Paid Search","Social Media","Google Search","Email","Email","Google Search","Google Search","Email","Google Search","Display","Paid Search","Display","Social Media","Google Search","Google Search","Email","Google Search","Paid Search","Affiliate","Google Search","Email","Affiliate","Display","Social Media","Affiliate","Email","Display","Google Search","Affiliate","Google Search","Affiliate","Google Search","Paid Search","Social Media","Affiliate","Paid Search","Email","Paid Search","Google Search","Google Search","Paid Search","Social Media","Email","Paid Search","Social Media","Google Search","Paid Search","Social Media","Paid Search","Display","Referral","Email","Affiliate","Display","Google Search","Affiliate","Social Media","Email"]],"displayName":"Channel","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,H:H;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Channel","id":"ca918e08"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New","New"]],"displayName":"User Type","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,I:I;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"User Type","id":"941d30f9-41"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["411.08","1817.24","4979","2052.88","887.7","1085.8","2458.62","777.36","171.36","1834.56","1914.39","856.8","7471.1","748.89","3103.51","639.84","668.59","1412.4","741.6","5058.02","1240.41","850.64","3707.7","1201.98","268.85","1258.02","375.36","4197.94","3177.27","4058.4","8091.72","4825.28","1166.16","906.87","3372.39","4087.89","1314.72","795.24","3765.54","2743","2376","1326.06","1017.5","3150.4","1705.22","1677.45","1123.44","4797.37","2566.8","5741.88","5256.2","3653","4731.56","1221.28","1805.44","4544.94","461.44","6818.56","990.36","3160.92","6400.81","2145.5","1707.52","4932.55","3785.61","5828.94","3930.08","57.6","3306.5","191.16","5289.78","883.52","3248.29","1081.44","723.34","1717","3717.35","1895.4","3736.26","2340.76","128.1","1331.76","399.1","2474.91","4581.46","1120.1","2222","1046.48","2398.34","226.2","2299.08","3357.9","430.44","1874.4","463.64","1892.8","1863.61","1866.24","2518.5","1887.48"]],"displayName":"Sales Value","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Sales,F:F;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"77ab7775"}],"displayName":"Table","id":"176ad1d5","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"ca918e08"},{"var":"channelFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"ca918e08","variation":"condition"},{"p":{"args":[{"dim":"941d30f941"},{"args":[{"value":"\"New\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"941d30f941","variation":"member"}],"kid":"974e09c5b01e0d700d26328240063c78","id":"dst176ad1d5"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6062228E9,1.6062228E9,1.6062228E9,1.6062228E9,1.6062228E9,1.6062228E9,1.6061364E9,1.6061364E9,1.6061364E9,1.6061364E9,1.6061364E9,1.6061364E9,1.60605E9,1.60605E9,1.60605E9,1.60605E9,1.60605E9,1.60605E9,1.6059636E9,1.6059636E9,1.6059636E9,1.6059636E9,1.6059636E9,1.6059636E9,1.6058772E9,1.6058772E9,1.6058772E9,1.6058772E9,1.6058772E9,1.6058772E9,1.6057908E9,1.6057908E9,1.6057908E9,1.6057908E9,1.6057908E9,1.6057908E9,1.6057044E9,1.6057044E9,1.6057044E9,1.6057044E9,1.6057044E9,1.6057044E9,1.605618E9,1.605618E9,1.605618E9,1.605618E9,1.605618E9,1.605618E9,1.6055316E9,1.6055316E9,1.6055316E9,1.6055316E9,1.6055316E9,1.6055316E9,1.6054452E9,1.6054452E9,1.6054452E9,1.6054452E9,1.6054452E9,1.6054452E9,1.6053588E9,1.6053588E9,1.6053588E9,1.6053588E9,1.6053588E9,1.6053588E9,1.6052724E9,1.6052724E9,1.6052724E9,1.6052724E9,1.6052724E9,1.6052724E9,1.605186E9,1.605186E9,1.605186E9,1.605186E9,1.605186E9,1.605186E9,1.6050996E9,1.6050996E9,1.6050996E9,1.6050996E9,1.6050996E9,1.6050996E9,1.6050132E9,1.6050132E9,1.6050132E9,1.6050132E9,1.6050132E9,1.6050132E9,1.6049268E9,1.6049268E9,1.6049268E9,1.6049268E9,1.6049268E9,1.6049268E9,1.6048404E9,1.6048404E9,1.6048404E9,1.6048404E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(57dd9357fe0a39ed5a4e95efb33bdf31@Marketing Spend,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"bc5c0e37"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["25 Nov 2020","25 Nov 2020","25 Nov 2020","25 Nov 2020","25 Nov 2020","25 Nov 2020","24 Nov 2020","24 Nov 2020","24 Nov 2020","24 Nov 2020","24 Nov 2020","24 Nov 2020","23 Nov 2020","23 Nov 2020","23 Nov 2020","23 Nov 2020","23 Nov 2020","23 Nov 2020","22 Nov 2020","22 Nov 2020","22 Nov 2020","22 Nov 2020","22 Nov 2020","22 Nov 2020","21 Nov 2020","21 Nov 2020","21 Nov 2020","21 Nov 2020","21 Nov 2020","21 Nov 2020","20 Nov 2020","20 Nov 2020","20 Nov 2020","20 Nov 2020","20 Nov 2020","20 Nov 2020","19 Nov 2020","19 Nov 2020","19 Nov 2020","19 Nov 2020","19 Nov 2020","19 Nov 2020","18 Nov 2020","18 Nov 2020","18 Nov 2020","18 Nov 2020","18 Nov 2020","18 Nov 2020","17 Nov 2020","17 Nov 2020","17 Nov 2020","17 Nov 2020","17 Nov 2020","17 Nov 2020","16 Nov 2020","16 Nov 2020","16 Nov 2020","16 Nov 2020","16 Nov 2020","16 Nov 2020","15 Nov 2020","15 Nov 2020","15 Nov 2020","15 Nov 2020","15 Nov 2020","15 Nov 2020","14 Nov 2020","14 Nov 2020","14 Nov 2020","14 Nov 2020","14 Nov 2020","14 Nov 2020","13 Nov 2020","13 Nov 2020","13 Nov 2020","13 Nov 2020","13 Nov 2020","13 Nov 2020","12 Nov 2020","12 Nov 2020","12 Nov 2020","12 Nov 2020","12 Nov 2020","12 Nov 2020","11 Nov 2020","11 Nov 2020","11 Nov 2020","11 Nov 2020","11 Nov 2020","11 Nov 2020","10 Nov 2020","10 Nov 2020","10 Nov 2020","10 Nov 2020","10 Nov 2020","10 Nov 2020","9 Nov 2020","9 Nov 2020","9 Nov 2020","9 Nov 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'bc5c0e37',\"d MMM yyyy\"),\"m\",DATEVALUE(!'bc5c0e37',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"afd762b4"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate","Email","Display","Google Search","Social Media","Paid Search","Affiliate"]],"displayName":"Channel","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Marketing Spend,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Channel","id":"832e6b77"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[21.900000000000002,8.8,27.900000000000002,9.5,0.0,11.600000000000001,16.400000000000002,6.7,25.900000000000002,4.6000000000000005,0.0,8.200000000000001,14.200000000000001,8.0,20.900000000000002,6.5,0.0,14.0,24.3,8.8,25.3,9.1,0.0,11.600000000000001,19.0,6.2,20.700000000000003,2.1,15.8,14.700000000000001,16.8,7.4,24.1,9.0,48.300000000000004,10.8,15.5,7.7,24.900000000000002,6.4,0.0,13.100000000000001,27.700000000000003,5.800000000000001,22.400000000000002,8.1,0.0,14.200000000000001,21.0,8.200000000000001,25.3,6.4,0.0,8.4,26.8,9.4,20.3,8.4,0.0,13.700000000000001,20.400000000000002,7.4,20.900000000000002,5.6000000000000005,0.0,14.3,23.400000000000002,7.5,29.200000000000003,7.300000000000001,33.7,12.4,20.1,6.6000000000000005,29.3,9.1,0.0,7.9,20.1,6.1000000000000005,23.1,2.5,41.2,12.4,14.0,7.0,29.900000000000002,6.800000000000001,0.0,9.200000000000001,16.3,7.7,28.0,6.1000000000000005,0.0,12.600000000000001,27.700000000000003,6.1000000000000005,22.900000000000002,5.6000000000000005]],"displayName":"Visits","formulas":[{"txt":"slice(57dd9357fe0a39ed5a4e95efb33bdf31@Marketing Spend,D:D;)*0.1","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Visits","id":"612d4d47"}],"displayName":"Table Copy","id":"3d5bdc8e","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"832e6b77"},{"var":"channelFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"832e6b77","variation":"condition"}],"kid":"974e09c5b01e0d700d26328240063c78","id":"dst3d5bdc8e"}}],"isForked":false,"id":"a93d084060514742eac2be3781d07d70","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"New Customer on First Visit","usesSampleData":false,"master":"974e09c5b01e0d700d26328240063c78"}]}]