{"gallery_project_data":{"gallery_project":{"featured":false,"gallery_project_category":{"id":1,"name":"General","slug":"general","created_at":"2017-03-14T16:56:43.926-04:00","updated_at":"2017-03-24T11:30:10.745-04:00","description":"There are no limits to the type of content generated with Wordsmith. See examples from many verticals, and find one that fits your content needs. Don't see a project that matches your needs? Contact us and we'll help get you started. "},"id":59,"image_url":"https://dj65vgnq591pm.cloudfront.net/projects/crm-summary/images/image.png?1749744962","project_name":"CRM Summary","project_id":24999,"project_slug":"crm-summary","project_description":"Give your sales team an in-depth summary of each member’s monthly, quarterly, or annual performance.","template_image_url":"https://dj65vgnq591pm.cloudfront.net/projects/crm-summary/images/template_image.png?1749744962","metadata":{"featuredColumns":[1,3,4,9,10],"scenarios":[{"name":"Strong Sales","row":1},{"name":"Down Month","row":3},{"name":"Yearly Record","row":9}],"segmentTotals":{"synonym":139,"branch":24,"datavar":102}}},"project":{"id":24999,"name":"CRM Summary","organization_id":4439,"created_at":"2017-10-31T09:00:36.647-04:00","updated_at":"2019-03-04T08:19:36.876-05:00","deleted_at":null,"slug":"crm-summary","archived":false,"raw_csv_filename":"crm-summary.csv","description":"Give your sales team an in-depth summary of each member’s monthly, quarterly, or annual performance.","creator_id":1565,"editor_id":6456,"project_type":"gallery","source_id":null,"encrypted_csv_id":"148ddc02ffe8286ef2bf2956d2208d20c34d77efd45ea0a047e8a35b505a","api_project_id":null,"encrypted_data_id":"b42b9f2a03fec2ec737ce179d02f0639626aa7dddad2d265fedf33147f3f","integration_type":null,"reference_id":"8ccd87c9e8b84366ec120de0646ef8b2","external_tool":null,"visualization_url":null,"wordsmith_integration":false,"ds_integration_id":null},"dataset":{"columns":[{"name":"name","type":"String","example":["Jim","Mark","Roy"],"index":0,"value":"name"},{"name":"report_month","type":"String","example":["February","March","January"],"index":1,"value":"report_month"},{"max":150.0,"min":65.0,"sum":1041.0,"name":"current_calls","type":"Number","average":104.1,"example":["115","87","90"],"index":2,"value":"current_calls"},{"max":124.0,"min":87.0,"sum":1047.0,"name":"previous_calls","type":"Number","average":104.7,"example":["102","95","102"],"index":3,"value":"previous_calls"},{"max":0.38,"min":0.21,"sum":3.12,"name":"call_to_opp_ratio","type":"Number","average":0.312,"example":["0.34","0.35","0.27"],"index":4,"value":"call_to_opp_ratio"},{"max":0.4,"min":0.19,"sum":3.07,"name":"previous_call_to_opp_ratio","type":"Number","average":0.307,"example":["0.31","0.35","0.31"],"index":5,"value":"previous_call_to_opp_ratio"},{"max":0.37,"min":0.2,"sum":2.97,"name":"call_to_opp_ratio_average","type":"Number","average":0.297,"example":["0.3","0.28","0.34"],"index":6,"value":"call_to_opp_ratio_average"},{"max":0.37,"min":0.24,"sum":3.01,"name":"call_to_opp_department_average","type":"Number","average":0.301,"example":["0.25","0.31","0.37"],"index":7,"value":"call_to_opp_department_average"},{"name":"top_vertical","type":"String","example":["E-commerce","Business Intelligence","Software"],"index":8,"value":"top_vertical"},{"max":0.6,"min":0.25,"sum":4.01,"name":"top_vertical_call_to_opp_ratio","type":"Number","average":0.401,"example":["0.6","0.48","0.38"],"index":9,"value":"top_vertical_call_to_opp_ratio"},{"max":0.41,"min":0.23,"sum":3.08,"name":"top_vertical_department_call_to_opp_ratio","type":"Number","average":0.308,"example":["0.32","0.36","0.41"],"index":10,"value":"top_vertical_department_call_to_opp_ratio"},{"name":"bottom_vertical","type":"String","example":["Financial Services","Media","E-commerce"],"index":11,"value":"bottom_vertical"},{"max":0.25,"min":0.08,"sum":1.6,"name":"bottom_vertical_call_to_opp_ratio","type":"Number","average":0.16,"example":["0.15","0.08","0.12"],"index":12,"value":"bottom_vertical_call_to_opp_ratio"},{"max":0.29,"min":0.2,"sum":2.46,"name":"bottom_vertical_department_call_to_opp_ratio","type":"Number","average":0.246,"example":["0.27","0.24","0.29"],"index":13,"value":"bottom_vertical_department_call_to_opp_ratio"},{"name":"bottom_vertical_leader","type":"String","example":["Dustin","Robert","Billy"],"index":14,"value":"bottom_vertical_leader"},{"max":10.0,"min":0.0,"sum":32.0,"name":"quarter_deals","type":"Number","average":3.2,"example":["3","1","2"],"index":15,"value":"quarter_deals"},{"max":120000.0,"min":0.0,"sum":321900.0,"name":"quarter_deals_ltv","type":"Number","average":32190.0,"example":["120000","45000","25000"],"index":16,"value":"quarter_deals_ltv"},{"max":0.46,"min":0.0,"sum":1.85,"name":"quota_percent","type":"Number","average":0.185,"example":["0.22","0.15","0.12"],"index":17,"value":"quota_percent"},{"max":310.0,"min":0.0,"sum":1593.0,"name":"monthly_calls_needed_at_avg_call_to_opp_ratio","type":"Number","average":159.3,"example":["200","225","160"],"index":18,"value":"monthly_calls_needed_at_avg_call_to_opp_ratio"}],"data":[{"name":"Jim","report_month":"February","current_calls":"115","previous_calls":"102","call_to_opp_ratio":"0.34","previous_call_to_opp_ratio":"0.31","call_to_opp_ratio_average":"0.3","call_to_opp_department_average":"0.25","top_vertical":"E-commerce","top_vertical_call_to_opp_ratio":"0.6","top_vertical_department_call_to_opp_ratio":"0.32","bottom_vertical":"Financial Services","bottom_vertical_call_to_opp_ratio":"0.15","bottom_vertical_department_call_to_opp_ratio":"0.27","bottom_vertical_leader":"Dustin","quarter_deals":"3","quarter_deals_ltv":"120000","quota_percent":"0.22","monthly_calls_needed_at_avg_call_to_opp_ratio":"200"},{"name":"Mark","report_month":"March","current_calls":"87","previous_calls":"95","call_to_opp_ratio":"0.35","previous_call_to_opp_ratio":"0.35","call_to_opp_ratio_average":"0.28","call_to_opp_department_average":"0.31","top_vertical":"Business Intelligence","top_vertical_call_to_opp_ratio":"0.48","top_vertical_department_call_to_opp_ratio":"0.36","bottom_vertical":"Media","bottom_vertical_call_to_opp_ratio":"0.08","bottom_vertical_department_call_to_opp_ratio":"0.24","bottom_vertical_leader":"Robert","quarter_deals":"1","quarter_deals_ltv":"45000","quota_percent":"0.15","monthly_calls_needed_at_avg_call_to_opp_ratio":"225"},{"name":"Roy","report_month":"January","current_calls":"90","previous_calls":"102","call_to_opp_ratio":"0.27","previous_call_to_opp_ratio":"0.31","call_to_opp_ratio_average":"0.34","call_to_opp_department_average":"0.37","top_vertical":"Software","top_vertical_call_to_opp_ratio":"0.38","top_vertical_department_call_to_opp_ratio":"0.41","bottom_vertical":"E-commerce","bottom_vertical_call_to_opp_ratio":"0.12","bottom_vertical_department_call_to_opp_ratio":"0.29","bottom_vertical_leader":"Billy","quarter_deals":"2","quarter_deals_ltv":"25000","quota_percent":"0.12","monthly_calls_needed_at_avg_call_to_opp_ratio":"160"},{"name":"Lisa","report_month":"April","current_calls":"105","previous_calls":"100","call_to_opp_ratio":"0.38","previous_call_to_opp_ratio":"0.4","call_to_opp_ratio_average":"0.37","call_to_opp_department_average":"0.35","top_vertical":"Financial Services","top_vertical_call_to_opp_ratio":"0.45","top_vertical_department_call_to_opp_ratio":"0.36","bottom_vertical":"Business Intelligence","bottom_vertical_call_to_opp_ratio":"0.21","bottom_vertical_department_call_to_opp_ratio":"0.25","bottom_vertical_leader":"Michael","quarter_deals":"0","quarter_deals_ltv":"0","quota_percent":"0","monthly_calls_needed_at_avg_call_to_opp_ratio":""},{"name":"Locky","report_month":"January","current_calls":"65","previous_calls":"87","call_to_opp_ratio":"0.21","previous_call_to_opp_ratio":"0.19","call_to_opp_ratio_average":"0.2","call_to_opp_department_average":"0.31","top_vertical":"E-commerce","top_vertical_call_to_opp_ratio":"0.25","top_vertical_department_call_to_opp_ratio":"0.27","bottom_vertical":"Software","bottom_vertical_call_to_opp_ratio":"0.08","bottom_vertical_department_call_to_opp_ratio":"0.21","bottom_vertical_leader":"Nick","quarter_deals":"1","quarter_deals_ltv":"12000","quota_percent":"0.08","monthly_calls_needed_at_avg_call_to_opp_ratio":"310"},{"name":"Nick","report_month":"March","current_calls":"105","previous_calls":"105","call_to_opp_ratio":"0.27","previous_call_to_opp_ratio":"0.25","call_to_opp_ratio_average":"0.25","call_to_opp_department_average":"0.27","top_vertical":"Media","top_vertical_call_to_opp_ratio":"0.32","top_vertical_department_call_to_opp_ratio":"0.26","bottom_vertical":"Financial Services","bottom_vertical_call_to_opp_ratio":"0.15","bottom_vertical_department_call_to_opp_ratio":"0.26","bottom_vertical_leader":"Matt","quarter_deals":"2","quarter_deals_ltv":"25000","quota_percent":"0.16","monthly_calls_needed_at_avg_call_to_opp_ratio":"240"},{"name":"Kate","report_month":"February","current_calls":"110","previous_calls":"120","call_to_opp_ratio":"0.34","previous_call_to_opp_ratio":"0.34","call_to_opp_ratio_average":"0.31","call_to_opp_department_average":"0.3","top_vertical":"Financial Services","top_vertical_call_to_opp_ratio":"0.38","top_vertical_department_call_to_opp_ratio":"0.27","bottom_vertical":"Media","bottom_vertical_call_to_opp_ratio":"0.17","bottom_vertical_department_call_to_opp_ratio":"0.2","bottom_vertical_leader":"Laura","quarter_deals":"4","quarter_deals_ltv":"35000","quota_percent":"0.32","monthly_calls_needed_at_avg_call_to_opp_ratio":"125"},{"name":"William","report_month":"January","current_calls":"102","previous_calls":"102","call_to_opp_ratio":"0.32","previous_call_to_opp_ratio":"0.32","call_to_opp_ratio_average":"0.32","call_to_opp_department_average":"0.32","top_vertical":"E-commerce","top_vertical_call_to_opp_ratio":"0.35","top_vertical_department_call_to_opp_ratio":"0.28","bottom_vertical":"Financial Services","bottom_vertical_call_to_opp_ratio":"0.25","bottom_vertical_department_call_to_opp_ratio":"0.25","bottom_vertical_leader":"Lisa","quarter_deals":"2","quarter_deals_ltv":"9500","quota_percent":"0.11","monthly_calls_needed_at_avg_call_to_opp_ratio":"78"},{"name":"Cheryl","report_month":"March","current_calls":"150","previous_calls":"110","call_to_opp_ratio":"0.36","previous_call_to_opp_ratio":"0.29","call_to_opp_ratio_average":"0.31","call_to_opp_department_average":"0.24","top_vertical":"Media","top_vertical_call_to_opp_ratio":"0.45","top_vertical_department_call_to_opp_ratio":"0.23","bottom_vertical":"E-commerce","bottom_vertical_call_to_opp_ratio":"0.21","bottom_vertical_department_call_to_opp_ratio":"0.2","bottom_vertical_leader":"Charles","quarter_deals":"10","quarter_deals_ltv":"2400","quota_percent":"0.23","monthly_calls_needed_at_avg_call_to_opp_ratio":"135"},{"name":"Kim","report_month":"May","current_calls":"112","previous_calls":"124","call_to_opp_ratio":"0.28","previous_call_to_opp_ratio":"0.31","call_to_opp_ratio_average":"0.29","call_to_opp_department_average":"0.29","top_vertical":"Business Intelligence","top_vertical_call_to_opp_ratio":"0.35","top_vertical_department_call_to_opp_ratio":"0.32","bottom_vertical":"Software","bottom_vertical_call_to_opp_ratio":"0.18","bottom_vertical_department_call_to_opp_ratio":"0.29","bottom_vertical_leader":"Miles","quarter_deals":"7","quarter_deals_ltv":"48000","quota_percent":"0.46","monthly_calls_needed_at_avg_call_to_opp_ratio":"120"}],"total":10,"formulas":[{"name":"call_difference","type":"Number","example":[13,-8,-12],"formula_id":101802,"ancestor_ids":[101802],"has_error":false},{"name":"calls_percent_change","type":"Number","example":[0.1274509803921569,-0.08421052631578947,-0.1176470588235294],"formula_id":101803,"ancestor_ids":[101803],"has_error":false}]},"row_count":10,"col_count":19}}