{"gallery_project_data":{"gallery_project":{"featured":false,"gallery_project_category":{"id":4,"name":"Sports","slug":"sports","created_at":"2017-06-04T18:26:24.551-04:00","updated_at":"2017-07-11T09:54:11.483-04:00","description":"Use Wordsmith’s Sports Projects to generate exciting game recaps, player performance summaries, and even personalized health summaries. Whether you’re trying to keep fans updated with how their favorite soccer team is doing or providing a summary of a user’s most recent workout, Wordsmith can write personalized content in the tone and style of your choosing."},"id":61,"image_url":"https://dj65vgnq591pm.cloudfront.net/projects/fitness-tracker/images/image.png?1749744962","project_name":"Fitness Tracker","project_id":25001,"project_slug":"fitness-tracker","project_description":"Turn the activity data from fitness trackers into personal trainers for each of your customers.","template_image_url":"https://dj65vgnq591pm.cloudfront.net/projects/fitness-tracker/images/template_image.png?1749744962","metadata":{"featuredColumns":[1,2,3,4,5],"scenarios":[{"name":"High step count","row":2},{"name":"Recent activity recap","row":4},{"name":"Milestone update","row":7}],"segmentTotals":{"synonym":220,"branch":77,"datavar":87}}},"project":{"id":25001,"name":"Fitness Tracker","organization_id":4439,"created_at":"2017-10-31T09:00:42.063-04:00","updated_at":"2019-03-04T08:19:39.104-05:00","deleted_at":null,"slug":"fitness-tracker","archived":false,"raw_csv_filename":"fitness-tracker.csv","description":"Turn the activity data from fitness trackers into personal trainers for each of your customers.","creator_id":1565,"editor_id":6456,"project_type":"gallery","source_id":null,"encrypted_csv_id":"d8a2c3ca0aa1c5afe45aebd71ead025ad3783e34f459d7ebba41237da5b9","api_project_id":null,"encrypted_data_id":"e96a1afb9885a9c647520a5c4d45f20a7cea9e3d547d42e91a4ae4f10d99","integration_type":null,"reference_id":"ee80f997a6ad7feecc0b78e126122e36","external_tool":null,"visualization_url":null,"wordsmith_integration":false,"ds_integration_id":null},"dataset":{"columns":[{"name":"date","type":"Date","example":["2/8/17","3/15/17","4/25/17"],"index":0,"value":"date"},{"max":15374.0,"min":6379.0,"sum":96487.0,"name":"steps","type":"Number","average":9648.7,"example":["10708","10100","7134"],"index":1,"value":"steps"},{"max":12969.0,"min":5422.0,"sum":93355.0,"name":"steps_prev","type":"Number","average":9335.5,"example":["9508","5422","6682"],"index":2,"value":"steps_prev"},{"max":10822.0,"min":7225.0,"sum":93355.0,"name":"steps_7_avg","type":"Number","average":9335.5,"example":["10367","7858","9707"],"index":3,"value":"steps_7_avg"},{"max":7.0,"min":1.0,"sum":36.0,"name":"steps_7_rank","type":"Number","average":3.6,"example":["2","1","5"],"index":4,"value":"steps_7_rank"},{"max":10659.0,"min":7650.0,"sum":91910.0,"name":"steps_30_avg","type":"Number","average":9191.0,"example":["9393","7801","10659"],"index":5,"value":"steps_30_avg"},{"max":29.0,"min":1.0,"sum":146.0,"name":"steps_30_rank","type":"Number","average":14.6,"example":["12","3","21"],"index":6,"value":"steps_30_rank"},{"max":3110630.0,"min":382033.0,"sum":18050662.0,"name":"steps_since_jan_1","type":"Number","average":1805066.2,"example":["382033","799640","1004423"],"index":7,"value":"steps_since_jan_1"},{"max":8.0,"min":5.5,"sum":71.9,"name":"sleep","type":"Number","average":7.19,"example":["6.8","7.9","7"],"index":8,"value":"sleep"},{"max":7.9,"min":5.5,"sum":68.9,"name":"sleep_prev","type":"Number","average":6.89,"example":["7.7","5.5","6.4"],"index":9,"value":"sleep_prev"},{"max":7.9,"min":6.1,"sum":71.1,"name":"sleep_7_avg","type":"Number","average":7.11,"example":["6.7","7.6","6.7"],"index":10,"value":"sleep_7_avg"},{"max":7.0,"min":1.0,"sum":32.0,"name":"sleep_7_rank","type":"Number","average":3.2,"example":["5","1","3"],"index":11,"value":"sleep_7_rank"},{"max":7.9,"min":6.5,"sum":72.7,"name":"sleep_30_avg","type":"Number","average":7.27,"example":["7.4","6.8","6.5"],"index":12,"value":"sleep_30_avg"},{"max":26.0,"min":2.0,"sum":142.0,"name":"sleep_30_rank","type":"Number","average":14.2,"example":["22","5","8"],"index":13,"value":"sleep_30_rank"},{"max":1.0,"min":0.0,"sum":5.0,"name":"activities_count","type":"Number","average":0.5,"example":["1","0","1"],"index":14,"value":"activities_count"},{"max":3.0,"min":0.0,"sum":16.0,"name":"activities_count_7_day","type":"Number","average":1.6,"example":["2","1","3"],"index":15,"value":"activities_count_7_day"},{"max":7.0,"min":0.0,"sum":29.0,"name":"activities_count_30_day","type":"Number","average":2.9,"example":["3","2","5"],"index":16,"value":"activities_count_30_day"},{"name":"top_activity_30_avg","type":"String","example":["Running","Biking","Strength Training"],"index":17,"value":"top_activity_30_avg"},{"max":340.0,"min":0.0,"sum":2170.0,"name":"top_activity_cals_30_avg","type":"Number","average":217.0,"example":["340","250","210"],"index":18,"value":"top_activity_cals_30_avg"},{"max":155.0,"min":70.0,"sum":1213.0,"name":"top_activity_hr_30_avg","type":"Number","average":121.3,"example":["155","130","120"],"index":19,"value":"top_activity_hr_30_avg"},{"max":82.0,"min":60.0,"sum":692.0,"name":"resting_hr_30_avg","type":"Number","average":69.2,"example":["65","70","75"],"index":20,"value":"resting_hr_30_avg"}],"data":[{"date":"2/8/17","steps":"10708","steps_prev":"9508","steps_7_avg":"10367","steps_7_rank":"2","steps_30_avg":"9393","steps_30_rank":"12","steps_since_jan_1":"382033","sleep":"6.8","sleep_prev":"7.7","sleep_7_avg":"6.7","sleep_7_rank":"5","sleep_30_avg":"7.4","sleep_30_rank":"22","activities_count":"1","activities_count_7_day":"2","activities_count_30_day":"3","top_activity_30_avg":"Running","top_activity_cals_30_avg":"340","top_activity_hr_30_avg":"155","resting_hr_30_avg":"65"},{"date":"3/15/17","steps":"10100","steps_prev":"5422","steps_7_avg":"7858","steps_7_rank":"1","steps_30_avg":"7801","steps_30_rank":"3","steps_since_jan_1":"799640","sleep":"7.9","sleep_prev":"5.5","sleep_7_avg":"7.6","sleep_7_rank":"1","sleep_30_avg":"6.8","sleep_30_rank":"5","activities_count":"0","activities_count_7_day":"1","activities_count_30_day":"2","top_activity_30_avg":"Biking","top_activity_cals_30_avg":"250","top_activity_hr_30_avg":"130","resting_hr_30_avg":"70"},{"date":"4/25/17","steps":"7134","steps_prev":"6682","steps_7_avg":"9707","steps_7_rank":"5","steps_30_avg":"10659","steps_30_rank":"21","steps_since_jan_1":"1004423","sleep":"7","sleep_prev":"6.4","sleep_7_avg":"6.7","sleep_7_rank":"3","sleep_30_avg":"6.5","sleep_30_rank":"8","activities_count":"1","activities_count_7_day":"3","activities_count_30_day":"5","top_activity_30_avg":"Strength Training","top_activity_cals_30_avg":"210","top_activity_hr_30_avg":"120","resting_hr_30_avg":"75"},{"date":"5/8/17","steps":"6379","steps_prev":"9113","steps_7_avg":"9306","steps_7_rank":"7","steps_30_avg":"9630","steps_30_rank":"29","steps_since_jan_1":"1178514","sleep":"6.7","sleep_prev":"7.5","sleep_7_avg":"6.8","sleep_7_rank":"4","sleep_30_avg":"7.9","sleep_30_rank":"17","activities_count":"0","activities_count_7_day":"1","activities_count_30_day":"2","top_activity_30_avg":"Elliptical","top_activity_cals_30_avg":"320","top_activity_hr_30_avg":"145","resting_hr_30_avg":"62"},{"date":"6/20/17","steps":"10924","steps_prev":"9829","steps_7_avg":"8839","steps_7_rank":"1","steps_30_avg":"7650","steps_30_rank":"2","steps_since_jan_1":"1595157","sleep":"5.5","sleep_prev":"7.6","sleep_7_avg":"6.5","sleep_7_rank":"7","sleep_30_avg":"7","sleep_30_rank":"26","activities_count":"1","activities_count_7_day":"1","activities_count_30_day":"2","top_activity_30_avg":"Yoga","top_activity_cals_30_avg":"90","top_activity_hr_30_avg":"100","resting_hr_30_avg":"68"},{"date":"7/13/17","steps":"12615","steps_prev":"10094","steps_7_avg":"10822","steps_7_rank":"2","steps_30_avg":"8547","steps_30_rank":"8","steps_since_jan_1":"2003908","sleep":"7.7","sleep_prev":"7.1","sleep_7_avg":"7.9","sleep_7_rank":"3","sleep_30_avg":"7.8","sleep_30_rank":"16","activities_count":"1","activities_count_7_day":"1","activities_count_30_day":"1","top_activity_30_avg":"Indoor Cycling","top_activity_cals_30_avg":"220","top_activity_hr_30_avg":"120","resting_hr_30_avg":"82"},{"date":"8/2/17","steps":"15374","steps_prev":"12273","steps_7_avg":"8221","steps_7_rank":"1","steps_30_avg":"9062","steps_30_rank":"1","steps_since_jan_1":"2208811","sleep":"7.2","sleep_prev":"6.2","sleep_7_avg":"6.1","sleep_7_rank":"2","sleep_30_avg":"7.6","sleep_30_rank":"20","activities_count":"0","activities_count_7_day":"0","activities_count_30_day":"0","top_activity_30_avg":"none","top_activity_cals_30_avg":"0","top_activity_hr_30_avg":"70","resting_hr_30_avg":"70"},{"date":"9/28/17","steps":"9218","steps_prev":"6387","steps_7_avg":"10762","steps_7_rank":"4","steps_30_avg":"10238","steps_30_rank":"18","steps_since_jan_1":"2766287","sleep":"7.5","sleep_prev":"6.4","sleep_7_avg":"7.8","sleep_7_rank":"4","sleep_30_avg":"7.4","sleep_30_rank":"14","activities_count":"0","activities_count_7_day":"3","activities_count_30_day":"7","top_activity_30_avg":"Calisthenics","top_activity_cals_30_avg":"200","top_activity_hr_30_avg":"118","resting_hr_30_avg":"65"},{"date":"10/23/17","steps":"6902","steps_prev":"11078","steps_7_avg":"7225","steps_7_rank":"7","steps_30_avg":"9090","steps_30_rank":"24","steps_since_jan_1":"3001259","sleep":"8","sleep_prev":"7.9","sleep_7_avg":"7.6","sleep_7_rank":"1","sleep_30_avg":"6.7","sleep_30_rank":"2","activities_count":"1","activities_count_7_day":"1","activities_count_30_day":"4","top_activity_30_avg":"Circuit Training","top_activity_cals_30_avg":"300","top_activity_hr_30_avg":"125","resting_hr_30_avg":"75"},{"date":"11/3/17","steps":"7133","steps_prev":"12969","steps_7_avg":"10248","steps_7_rank":"6","steps_30_avg":"9840","steps_30_rank":"28","steps_since_jan_1":"3110630","sleep":"7.6","sleep_prev":"6.6","sleep_7_avg":"7.4","sleep_7_rank":"2","sleep_30_avg":"7.6","sleep_30_rank":"12","activities_count":"0","activities_count_7_day":"3","activities_count_30_day":"3","top_activity_30_avg":"Aerobics","top_activity_cals_30_avg":"240","top_activity_hr_30_avg":"130","resting_hr_30_avg":"60"}],"total":10,"formulas":[{"name":"step_2_total","type":"Number","example":[20216,15522,13816],"formula_id":101804,"ancestor_ids":[101804],"has_error":false},{"name":"steps_over_steps_30_avg","type":"Number","example":[0.1399978707548174,0.2947058069478272,-0.3307064452575288],"formula_id":101805,"ancestor_ids":[101805],"has_error":false},{"name":"steps_over_steps_7_avg","type":"Number","example":[0.03289283302787692,0.2853143293458895,-0.265066446893994],"formula_id":101806,"ancestor_ids":[101806],"has_error":false},{"name":"steps_over_steps_prev","type":"Number","example":[0.1262095077829196,0.8627812615271118,0.06764441783897036],"formula_id":101807,"ancestor_ids":[101807],"has_error":false},{"name":"activity_hr_over_resting_hr","type":"Number","example":[1.384615384615385,0.8571428571428572,0.6],"formula_id":101808,"ancestor_ids":[101808],"has_error":false},{"name":"sleep_2_avg","type":"Number","example":[7.25,6.7,6.7],"formula_id":101809,"ancestor_ids":[101809],"has_error":false},{"name":"steps_since_jan_1_millions","type":"Number","example":[0.382033,0.79964,1.004423],"formula_id":101810,"ancestor_ids":[101810],"has_error":false},{"name":"steps_since_jan_1_thousands","type":"Number","example":[382.033,799.64,1004.423],"formula_id":101811,"ancestor_ids":[101811],"has_error":false},{"name":"100k_milestone","type":"Boolean","example":[false,false,true],"formula_id":101812,"ancestor_ids":[101812],"has_error":false}]},"row_count":10,"col_count":21}}