{"id":126332,"date":"2018-10-17T09:34:47","date_gmt":"2018-10-17T16:34:47","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcuser&#038;p=126332"},"modified":"2024-12-12T16:54:16","modified_gmt":"2024-12-13T00:54:16","slug":"a-maizing-sales","status":"publish","type":"arcuser","link":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales","title":{"rendered":"A-Maizing Sales"},"author":1432,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","castos_file_data":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","_links_to":"","_links_to_target":""},"categories":[10392],"tags":[295422,295432,285022,101,279572],"arcuser_issues":[130572],"class_list":["post-126332","arcuser","type-arcuser","status-publish","format-standard","hentry","category-arcgis-online","tag-cub-scouts","tag-fundraising","tag-land-mine-mapping","tag-mobile","tag-sales","arcuser_issues-winter-2014"],"acf":{"short_description":"With the advent of ArcGIS Online, GIS can scale down as well as up and improve outcomes for even modest tasks.","pdf":{"host_remotely":false,"file":126582,"file_url":""},"flexible_content":[{"acf_fc_layout":"content","content":"<h2 style=\"text-align: center;\">Managing fund-raising with ArcGIS Online<\/h2>\r\n<em>With the advent of ArcGIS Online, GIS can scale down as well as up and improve outcomes for even modest tasks. The author, a GIS professional, and his son applied ArcGIS Online to a fund-raising activity to get the job done not only efficiently but enjoyably.<\/em>"},{"acf_fc_layout":"image","image":126342,"image_position":"right","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"My nine-year-old son Joshua is in Cub Scouts in Parker, Colorado. Every year, troops sell popcorn to raise money to pay for scout activities. At the sales kickoff meeting, the leader of our group said that he often prints a map of the neighborhoods where his boys are selling popcorn. That way, they can check off which households they sold to, where no sales were made, and where no one was home. He also talked about transposing the paper order sheet into an Microsoft Excel spreadsheet.\r\n\r\nLike any good GIS geek, when I hear the words \"map\" and \"spreadsheet\" together, bells go off. Add collecting data in a mobile environment and this quickly became a great opportunity to teach Joshua about what I do every day.\r\n\r\n&nbsp;"},{"acf_fc_layout":"image","image":126362,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>Managing the Sales Territory<\/h2>\r\nSo Joshua and I headed home to create an ArcGIS Online web map to keep track of where he collected his popcorn orders. We started by creating template comma-separated value (CSV) files for the three categories of events he wanted to enter: Successful Sale; No One Home, Potential Revisit; and Not Interested.\r\n\r\nFor the Successful Sale CSV file, we created fields for name, address, order date, each type of popcorn product, payment type, and a flag to eventually track the deliveries of the product. The goal was for Joshua to be able to capture all the information he needed for each sale and then use that data when delivery time rolled around. This would allow him to cover more ground quickly while capturing the details about each house he visited.\r\n\r\nWe uploaded each CSV file to ArcGIS Online and then created a quick web map. We customized the field aliases to include the prices of products. We also set up some cool symbols, such as bags of popcorn, and then published the map. The entire process took about an hour.\r\n\r\nThe next day, armed with my iPhone, Joshua hit the streets to begin selling popcorn. To collect information in the field and add it to the map we created in ArcGIS Online, I had him use the free Collector for ArcGIS app instead of the basic mobile Esri app because Collector is geared to collecting data in the field and works with ArcGIS Online or Portal for ArcGIS. After downloading Collector for ArcGIS, the app just asks you to sign in to your ArcGIS Online account or a portal."},{"acf_fc_layout":"gallery","gallery_images":[723292,723302,723312,723322]},{"acf_fc_layout":"content","content":"Joshua learned how to use this app more quickly than most adults. We didn't have any of the change management issues sometimes encountered with older workers. The GPS functionality worked well. The app showed him immediately where he was located. As he reached each house, he dropped a pin on the map, and Collector for ArcGIS provided a reverse-geocoded address. This address could be copied into a new record, which was much easier than typing it in. The geocoding worked pretty well but occasionally pulled up a neighbor's address, so we validated the addresses as we went along. Entering a new sale was very easy. Joshua entered the name, date, address, product quantities, and payment details into the form in the app.\r\n\r\nAs Joshua made each entry, the web map was populated with quality data\u2014point features categorized as a Successful Sale, Not Home, or Not Interested. The best part of this quick project was that I got to sit in my comfy, air-conditioned car as Joshua entered the data. I watched his progress in real time via my iPad. As the point data automatically appeared, I was able to do quick quality assurance\/quality control (QA\/QC) of the entries as needed. At one point, I lost Joshua, but I was able to quickly find him by driving a block over to his last entered point."},{"acf_fc_layout":"image","image":126512,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"Finally, to have just a bit more fun, I decided to mash up our targeted sales area with some Esri data available on ArcGIS Online. I pulled up median income for the targeted neighborhood and overlaid it with our initial sales locations. We found that we were in a good area to make sales, as the median income in the neighborhood was greater than $113,000 per year. I'm sure there's some psychological study on the best median income for successful popcorn sales, but that's a bit beyond my expertise. We will certainly use this layer to target Josh's next sales drive.\r\n<h2>Takeaways<\/h2>\r\nThis project makes a pretty strong case for managing data entry from the back office, another mobile location, or really anywhere at all. The Collector for ArcGIS app was a success. It was easy enough for a nine-year-old to use and, based on watching how kids play games, I'd bet kids much younger could become GIS whizzes too.\r\n\r\nWhat was great about working with Esri ArcGIS Online? It gave us a new way to collect, analyze, organize, and empower spatial data that we could deploy on any common mobile device platform. This makes implementation easy and limits change management because just about everyone knows how to use a smartphone these days, even children."},{"acf_fc_layout":"image","image":126532,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"By the end of the day, this experience had offered a great opportunity to teach Joshua a bit about GIS. ArcGIS Online was a natural fit, and we had a lot of fun creating and using the Collector for ArcGIS app with it. We wrapped up the popcorn sales drive this month and will use the Collector for ArcGIS app again to track our delivery progress when the popcorn and other products arrive in a few weeks. We will create a new web map for that using symbols based on the delivery flag for each sale record.\r\n\r\nArcGIS Online provided Joshua with a great first GIS experience and made the collection, analysis, and reporting of the popcorn sales data quick, easy, and\u2014dare I say\u2014outright fun."}],"references":null},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A-Maizing Sales | Winter 2014 | ArcUser<\/title>\n<meta name=\"description\" content=\"With the advent of ArcGIS Online, GIS can scale down as well as up and improve outcomes for even modest tasks.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A-Maizing Sales\" \/>\n<meta property=\"og:description\" content=\"With the advent of ArcGIS Online, GIS can scale down as well as up and improve outcomes for even modest tasks.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales\" \/>\n<meta property=\"og:site_name\" content=\"Esri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-13T00:54:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-dark-grey-card.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@Esri\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales\",\n\t            \"name\": \"A-Maizing Sales | Winter 2014 | ArcUser\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t            },\n\t            \"datePublished\": \"2018-10-17T16:34:47+00:00\",\n\t            \"dateModified\": \"2024-12-13T00:54:16+00:00\",\n\t            \"description\": \"With the advent of ArcGIS Online, GIS can scale down as well as up and improve outcomes for even modest tasks.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales#breadcrumb\",\n\t            \"itemListElement\": [\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 1,\n\t                    \"name\": \"Home\",\n\t                    \"item\": \"https:\/\/www.esri.com\/about\/newsroom\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 2,\n\t                    \"name\": \"A-Maizing Sales\"\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\",\n\t            \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/\",\n\t            \"name\": \"Esri\",\n\t            \"description\": \"Esri Newsroom\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"Person\",\n\t            \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/b7332d419608ac1a0291ec30de119efb\",\n\t            \"name\": \"April Mann\",\n\t            \"image\": {\n\t                \"@type\": \"ImageObject\",\n\t                \"inLanguage\": \"en-US\",\n\t                \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/\",\n\t                \"url\": \"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g\",\n\t                \"contentUrl\": \"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g\",\n\t                \"caption\": \"April Mann\"\n\t            },\n\t            \"url\": \"\"\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"A-Maizing Sales | Winter 2014 | ArcUser","description":"With the advent of ArcGIS Online, GIS can scale down as well as up and improve outcomes for even modest tasks.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales","og_locale":"en_US","og_type":"article","og_title":"A-Maizing Sales","og_description":"With the advent of ArcGIS Online, GIS can scale down as well as up and improve outcomes for even modest tasks.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2024-12-13T00:54:16+00:00","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2019\/09\/topography-dark-grey-card.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@Esri","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales","url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales","name":"A-Maizing Sales | Winter 2014 | ArcUser","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2018-10-17T16:34:47+00:00","dateModified":"2024-12-13T00:54:16+00:00","description":"With the advent of ArcGIS Online, GIS can scale down as well as up and improve outcomes for even modest tasks.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/a-maizing-sales#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"A-Maizing Sales"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/about\/newsroom\/#website","url":"https:\/\/www.esri.com\/about\/newsroom\/","name":"Esri","description":"Esri Newsroom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/b7332d419608ac1a0291ec30de119efb","name":"April Mann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/28d21cf04453f95cd2d8a0f053e5cd18ccf684320f6a4974f358b8109264e80b?s=96&d=blank&r=g","caption":"April Mann"},"url":""}]}},"sort_order":"0","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/126332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser"}],"about":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/types\/arcuser"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/users\/1432"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/126332\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=126332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=126332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=126332"},{"taxonomy":"arcuser_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser_issues?post=126332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}