{"token":"420308f8-ef85-4819-b459-80d5e81c21bf","title":"Marketing Channel Performance \u0026 Budget Efficiency Dashboard","dashboard_str":"{\"items\":[{\"id\":\"3\",\"type\":\"block_filter\",\"startCol\":1,\"rowIndex\":0,\"w\":12,\"loading\":false,\"adaptiveHeight\":false,\"content\":[{\"name\":\"Month\",\"field\":\"Month\",\"type\":\"date\",\"description\":\"Month of the budget period\",\"format\":\"YYYY-MM-DD\"},{\"name\":\"Department\",\"field\":\"Department\",\"type\":\"enum\",\"description\":\"Business department owning the spend\",\"dropmenu\":[\"Engineering\",\"Sales\",\"Marketing\",\"Product\",\"Customer Success\",\"Finance\",\"HR\",\"Operations\"]}]},{\"id\":\"mebqtrvmsv\",\"type\":\"block_core_metrics\",\"startCol\":1,\"w\":4,\"rowIndex\":1,\"adaptiveHeight\":false,\"title\":\"Core Metrics\",\"content\":{\"results\":[{\"name\":\"Total Variance Amount\",\"value\":-399700,\"field_name\":\"Variance_Amount\",\"alias\":\"Total Variance Amount\"}],\"block_id\":\"block_119083\"},\"loading\":false,\"changeCol\":0},{\"id\":\"4\",\"type\":\"block_core_metrics\",\"startCol\":5,\"rowIndex\":1,\"w\":8,\"loading\":false,\"adaptiveHeight\":false,\"content\":{\"results\":[{\"name\":\"Average Spend Per Employee\",\"value\":3148.86,\"field_name\":\"avg_spend_per_employee\",\"alias\":\"Average Spend Per Employee\"},{\"name\":\"Total Monthly Budget \",\"value\":12447000,\"field_name\":\"Budget_Monthly\",\"alias\":\"总月度预算\"},{\"name\":\"Total Monthly Spend\",\"value\":12846700,\"field_name\":\"Actual_Spend\",\"alias\":\"Total Monthly Spend\"}],\"block_id\":\"block_8571\"},\"changeCol\":0},{\"id\":\"6\",\"type\":\"block_chart\",\"startCol\":1,\"rowIndex\":2,\"w\":4,\"loading\":false,\"adaptiveHeight\":false,\"content\":{\"block_id\":\"block_3113\",\"chart\":\"{\\\"legend\\\":{\\\"data\\\":[\\\"Average Variance (%)\\\"],\\\"top\\\":\\\"bottom\\\"},\\\"series\\\":[{\\\"data\\\":[0.4,-1.45,-2,-4.62,-5,-5.57,-9.91,-15.99],\\\"name\\\":\\\"Average Variance (%)\\\",\\\"type\\\":\\\"bar\\\"}],\\\"title\\\":{\\\"text\\\":\\\"\\\"},\\\"tooltip\\\":{\\\"trigger\\\":\\\"axis\\\"},\\\"xAxis\\\":{\\\"data\\\":[\\\"Facilities\\\",\\\"Operations\\\",\\\"Personnel\\\",\\\"Technology\\\",\\\"Advertising\\\",\\\"Marketing\\\",\\\"Professional Services\\\",\\\"Travel\\\"],\\\"type\\\":\\\"category\\\"},\\\"yAxis\\\":{\\\"type\\\":\\\"value\\\"}}\",\"title\":\"Top Under-Budget Categories (Positive Variance %)\"},\"changeCol\":0},{\"id\":\"5\",\"type\":\"block_chart\",\"startCol\":5,\"rowIndex\":2,\"w\":8,\"loading\":false,\"adaptiveHeight\":false,\"content\":{\"block_id\":\"block_3112\",\"chart\":\"{\\\"legend\\\":{\\\"data\\\":[\\\"Budget_Annual\\\",\\\"Actual_Spend\\\"],\\\"top\\\":\\\"bottom\\\"},\\\"series\\\":[{\\\"data\\\":[15480000,8064000,6660000,8424000,20880000,59760000,25560000,4536000],\\\"name\\\":\\\"Budget_Annual\\\",\\\"type\\\":\\\"bar\\\"},{\\\"data\\\":[1351200,690500,557600,700500,1810000,5131000,2206700,399200],\\\"name\\\":\\\"Actual_Spend\\\",\\\"type\\\":\\\"bar\\\"}],\\\"title\\\":{\\\"text\\\":\\\"\\\"},\\\"tooltip\\\":{\\\"trigger\\\":\\\"axis\\\"},\\\"xAxis\\\":{\\\"data\\\":[\\\"Product\\\",\\\"Customer Success\\\",\\\"Finance\\\",\\\"Operations\\\",\\\"Marketing\\\",\\\"Engineering\\\",\\\"Sales\\\",\\\"HR\\\"],\\\"type\\\":\\\"category\\\"},\\\"yAxis\\\":{\\\"type\\\":\\\"value\\\"}}\",\"title\":\"Department Budget vs Actual Expenditures\"},\"changeCol\":0},{\"id\":\"11\",\"type\":\"block_chart\",\"content\":{\"block_id\":\"block_3114\",\"chart\":\"{\\\"legend\\\":{\\\"data\\\":[\\\"Personnel\\\",\\\"Technology\\\",\\\"Advertising\\\",\\\"Professional Services\\\",\\\"Travel\\\",\\\"Operations\\\",\\\"Facilities\\\",\\\"Marketing\\\"],\\\"top\\\":\\\"bottom\\\"},\\\"series\\\":[{\\\"data\\\":[{\\\"name\\\":\\\"Personnel\\\",\\\"value\\\":10453000},{\\\"name\\\":\\\"Technology\\\",\\\"value\\\":771700},{\\\"name\\\":\\\"Advertising\\\",\\\"value\\\":630000},{\\\"name\\\":\\\"Professional Services\\\",\\\"value\\\":339500},{\\\"name\\\":\\\"Travel\\\",\\\"value\\\":281700},{\\\"name\\\":\\\"Operations\\\",\\\"value\\\":156300},{\\\"name\\\":\\\"Facilities\\\",\\\"value\\\":119500},{\\\"name\\\":\\\"Marketing\\\",\\\"value\\\":95000}],\\\"name\\\":\\\"Proportion of Expenditures by Category (Pie)\\\",\\\"radius\\\":\\\"60%\\\",\\\"type\\\":\\\"pie\\\"}],\\\"title\\\":{\\\"text\\\":\\\"\\\"},\\\"tooltip\\\":{\\\"trigger\\\":\\\"item\\\"}}\",\"title\":\"Proportion of Expenditures by Category (Pie)\"},\"startCol\":1,\"rowIndex\":3,\"w\":4,\"loading\":false,\"adaptiveHeight\":false},{\"id\":\"13\",\"type\":\"block_chart\",\"content\":{\"block_id\":\"block_3115\",\"chart\":\"{\\\"legend\\\":{\\\"data\\\":[\\\"Customer Success\\\",\\\"Engineering\\\",\\\"Finance\\\",\\\"HR\\\",\\\"Marketing\\\",\\\"Operations\\\",\\\"Product\\\",\\\"Sales\\\"],\\\"top\\\":\\\"bottom\\\"},\\\"series\\\":[{\\\"data\\\":[[722,-8.3],[12750,-2],[911,-2.5],[10800,-8],[1500,-25],[1111,16.7],[850,-6.3],[688,8.3],[1063,-6.3],[1875,-25],[11667,-5],[700,-16.7]],\\\"name\\\":\\\"HR\\\",\\\"type\\\":\\\"scatter\\\"},{\\\"data\\\":[[421,-6.7],[457,-6.7],[120,16],[431,-3.3],[167,-20],[211,-60],[333,-20],[243,15],[11528,-3.8],[11714,-2.5],[11184,-6.3],[395,-50]],\\\"name\\\":\\\"Product\\\",\\\"type\\\":\\\"scatter\\\"},{\\\"data\\\":[[1500,10],[785,-2],[392,-2],[792,5],[1833,-10],[400,4],[433,-4],[12333,1.3],[12417,0.7],[817,2],[11615,-0.7],[1923,-25]],\\\"name\\\":\\\"Finance\\\",\\\"type\\\":\\\"scatter\\\"},{\\\"data\\\":[[13222,0.8],[622,-12],[320,-6.7],[1156,-30],[316,5.3],[1021,-20],[1100,-37.5],[12979,-1.7],[553,-4],[330,-3.3],[12500,-4.2],[700,-16.7],[711,-6.7],[540,-8],[596,6.7]],\\\"name\\\":\\\"Sales\\\",\\\"type\\\":\\\"scatter\\\"},{\\\"data\\\":[[2025,-1.3],[150,25],[450,10],[1952,-2.5],[400,20],[7400,1.3],[214,-12.5],[7250,3.3],[1600,-6.7],[1900,5],[571,-20],[175,12.5],[1550,-3.3],[7238,-1.3],[1571,-10]],\\\"name\\\":\\\"Operations\\\",\\\"type\\\":\\\"scatter\\\"},{\\\"data\\\":[[344,-10],[6406,-2.5],[193,3.3],[339,-5],[200,-3.3],[367,-10],[317,-18.8],[355,-37.5],[438,-75],[6600,1],[203,-8.3],[6516,-1]],\\\"name\\\":\\\"Customer Success\\\",\\\"type\\\":\\\"scatter\\\"},{\\\"data\\\":[[1000,-25],[556,-50],[8077,-5],[692,10],[11556,-4],[12200,-1.7],[11846,-2.7],[2000,-4],[308,20],[7800,2.5],[8333,-12.5],[1920,4],[480,-20],[815,-10],[2037,-10]],\\\"name\\\":\\\"Marketing\\\",\\\"type\\\":\\\"scatter\\\"},{\\\"data\\\":[[195,16.7],[818,-8],[91,-20],[155,-2.5],[797,-2],[11970,-5.3],[360,-50],[760,5],[68,15],[148,7.5],[59,25],[12160,-1.3],[11992,-2.3],[265,-16.7]],\\\"name\\\":\\\"Engineering\\\",\\\"type\\\":\\\"scatter\\\"}],\\\"title\\\":{\\\"text\\\":\\\"\\\"},\\\"tooltip\\\":{\\\"trigger\\\":\\\"item\\\"},\\\"xAxis\\\":{\\\"type\\\":\\\"value\\\"},\\\"yAxis\\\":{\\\"type\\\":\\\"value\\\"}}\",\"title\":\"Spend per Employee vs Variance (Potential High-ROI Zones)\"},\"startCol\":5,\"rowIndex\":3,\"w\":8,\"loading\":false,\"adaptiveHeight\":false},{\"id\":\"7\",\"type\":\"block_table\",\"startCol\":1,\"rowIndex\":4,\"w\":12,\"loading\":false,\"adaptiveHeight\":false,\"content\":{\"block_id\":\"block_6243\",\"data\":[[\"Department\",\"Category\",\"Total_Budget\",\"Total_Actual_Spend\",\"Total_Variance_Amount\",\"Avg_Variance_Percent\",\"Avg_Spend_Per_Employee\"],[\"Operations\",\"Travel\",12000,11000,1000,8.33,179.67],[\"Engineering\",\"Travel\",30000,28000,2000,6.67,72.67],[\"Operations\",\"Professional Services\",30000,29000,1000,3.33,473.67],[\"Engineering\",\"Operations\",60000,58000,2000,3.33,150.33],[\"Finance\",\"Technology\",30000,29500,500,1.67,798],[\"Operations\",\"Personnel\",450000,445000,5000,1.1,7296],[\"Finance\",\"Personnel\",450000,448000,2000,0.43,12121.67],[\"Operations\",\"Facilities\",120000,119500,500,0.4,1959],[\"Finance\",\"Operations\",15000,15100,-100,-0.67,408.33],[\"Customer Success\",\"Personnel\",600000,605000,-5000,-0.83,6507.33],[\"Sales\",\"Operations\",45000,45700,-700,-1.57,322],[\"Engineering\",\"Technology\",300000,305000,-5000,-1.67,791.67],[\"Sales\",\"Personnel\",1800000,1830000,-30000,-1.7,12900.33],[\"Customer Success\",\"Operations\",18000,18500,-500,-2.77,198.67],[\"Marketing\",\"Personnel\",900000,925000,-25000,-2.8,11867.33],[\"Engineering\",\"Personnel\",4500000,4635000,-135000,-2.97,12040.67],[\"Marketing\",\"Technology\",150000,155000,-5000,-3.33,1985.67],[\"Product\",\"Personnel\",1200000,1250000,-50000,-4.2,11475.33],[\"Marketing\",\"Advertising\",600000,630000,-30000,-5,8070],[\"HR\",\"Personnel\",300000,315000,-15000,-5,11739]],\"title\":\"Top Budget Efficiency by Department and Category\"}}],\"rowHeights\":[128,167,439,424,1022],\"cols\":12,\"gap\":12,\"theme\":\"dreamGradient\",\"title\":\"Marketing Channel Performance \u0026 Budget Efficiency Dashboard\",\"totalFilters\":[{\"name\":\"Month\",\"field\":\"Month\",\"type\":\"date\",\"description\":\"Month of the budget period\",\"format\":\"YYYY-MM-DD\"},{\"name\":\"Department\",\"field\":\"Department\",\"type\":\"enum\",\"description\":\"Business department owning the spend\",\"dropmenu\":[\"Engineering\",\"Sales\",\"Marketing\",\"Product\",\"Customer Success\",\"Finance\",\"HR\",\"Operations\"]},{\"name\":\"Category\",\"field\":\"Category\",\"type\":\"enum\",\"description\":\"Budget spend category\",\"dropmenu\":[\"Personnel\",\"Technology\",\"Professional Services\",\"Travel\",\"Operations\",\"Marketing\",\"Advertising\",\"Facilities\"]},{\"name\":\"Variance Percent\",\"field\":\"Variance_Percent\",\"type\":\"number\",\"description\":\"Budget vs. actual variance in percent (positive = under budget, negative = over budget)\"},{\"name\":\"Headcount\",\"field\":\"Headcount\",\"type\":\"number\",\"description\":\"Number of employees in the department for the given month\"},{\"name\":\"Spend Per Employee\",\"field\":\"Spend_Per_Employee\",\"type\":\"number\",\"description\":\"Actual spend divided by headcount for the given month\"},{\"name\":\"Notes\",\"field\":\"Notes\",\"type\":\"string\",\"description\":\"Keyword search in notes for context (e.g., campaigns, one-offs)\"}],\"viewInfos\":[{\"id\":10977,\"hashId\":\"f14986dc8107bcc6e411c3e1ef8c92cd\",\"file_name\":\"Quarterly Budget Report.xlsx\",\"file_url\":\"https://excelmatic.nyc3.cdn.digitaloceanspaces.com/dashboard/quarterly-budget-report.xlsx\"}],\"query\":\"Transform spreadsheets into dashboards. Visualize channel data by dimension, quickly identify high-ROI channels, and maximize your advertising budget efficiency.\",\"usedFilter\":[]}","updated_at":1765418463}