VIEWS: 4 PAGES: 19 POSTED ON: 7/5/2012
Cookie Booth Finder Booth Manager (Admin) Training For Cookie Sale 2009 The Booth Finder will be LIVE March 2, 2008 (1 week before public sale) - March 22, 2008 Website Address www.CookieFinder.org Last Year’s Stats at a Glance • 3,702 Booth Sales in the System • 14,654 Hits on Cookie Finder • 10,077 Unique Visitors to Cookie Finder • 8,604 Searches • 289 Cities Searched How Does it Work? Overview 1) CREATE AN EXCEL SPREADSHEET of “booth locations” and “booth dates & times” in the exact format provided. 2) EMAIL THE SPREADSHEET to email@example.com by February 16, 2009. The FIRST BATCH of booth sales will be ADDED BY COUNCIL. 3) REVIEW, ADD, AND MAKE CHANGES to booth locations and times throughout the sale starting MARCH 3, 2009 1) CREATE AN EXCEL SPREADSHEET Overview Spreadsheet Spreadsheet Template can be downloaded at www.GirlScoutsNorCal.org/boothsetup (use the username and password you are given at the training – or call your local council office to speak to a product sales representative to obtain one) Cells are referenced by their column label Columns are labeled A, B, C, etc…and then their row number Columns Cell “C2” (A, B, C etc…) (Column C, Row 2) Header Row Rows The header row gives each column (1, 2, 3 etc…) a title. Rows are numbered 1, 2, 3, etc… Sheets There are 2 Sheets in this spread sheet. One for “Booth Locations” (addresses), and one for the “Booth Sales” (dates and times) Separate Locations from Dates & Times Since there are MANY BOOTH DATES AND TIMES FOR EACH BOOTH LOCATION, this system separates booth sale locations from booth sale dates & times. The result is a system that is MORE EFFICIENT for the computer that’s powering it, as well as you in terms of data-entry time. You will only have to ENTER THE SPECIFICS OF A LOCATION ONCE (name, address etc.), which will assign it an ID number. You’ll then assign a location to each booth sale by using the location ID number. The next slides explain this process in more detail. Also, ANY CHANGES TO THE LOCATION WILL BE COPIED AUTOMATICALLY across all booth sales at that location. Add Booth Locations to Spreadsheet Start by entering all booth locations onto the “Booth Locations” sheet. Booth Locations NOTE: Use one line per address. For locations with booth sales on multiple floors, sides of an intersection, or common areas like BART Stations use more than one line with a different name on each line, ex: “Powel St. BART - Flower Stall” & “Powel St. BART - North Stairwell”. DO NOT CHANGE THE NUMBER IN THE ID COLUMN For each location enter: • City • Service Unit Name • State • Name of Booth Location • Zip Code (give each location a DIFFERENT name) • Address • DOT NOT CHANGE NUMBER IN THE ID COLUMN Add Booth Sales to Spreadsheet Booth Sales 1) Print Out the “Booth Locations” sheet for reference 2) Click on the “Booth Sales” tab (bottom) to switch to the “Booth Sales” sheet. 3) Type the Location ID number in the column titled “ENTER LOCATION ID” (look-up location ID numbers on your Booth Locations print-out). This will automatically find the Location Name from the “Booth Locations” sheet. 4) Add the booth date, times, and troop number (troop numbers are for your reference only, they will not be posted online) 5) Repeat for all Booth Sales 2) EMAIL THE SPREADSHEET TO firstname.lastname@example.org 3) REVIEW, ADD, AND MAKE CHANGES Starting March 3, 2009 www.GirlScoutsNorCal.org/boothsetup Log In 1. Open your web browser (Internet Explorer, Firefox, Safari, etc.) and go to www.GirlScoutsNorCal.org/boothsetup 2. Type in your username and password. Your username and password will be given to you during training, or you can call your local council office and speak with the product sales representative. The Cookie Booth Set-Up Home Page From the homepage you can Set-up New Booth Locations (most locations should already be set-up by March 3, 2008), Set-Up New Booth Dates/Times, and Edit previously Set-Up Booth Dates/Times or “Check Your Work”. Click the button labeled “Check Your Work” to review booth data Find Cookie Booth Dates/Times 1. Scroll down to the section labeled “Find/Edit Cookie Booth Dates/Times” 2. Choose the dates, service unit, or troop number for which you would like to limit your results. 3. Click on “Find Booth Sales.” The Booth Sale Detail Page You can sort the results by Troop, Service Unit, Location, Date, Start Time & End Time by clicking on the column header Make any changes necessary and click on “Update Booths” Set-Up New Booth Sales & Locations 1. Please check to MAKE SURE the booth sales you want to add are not already in the system. The booth sale spreadsheet you sent to the council will add the bulk of booth sales into the system. If you don’t see booth sales that should already have been added, please email email@example.com 2. Booth Locations only need to be set-up once. This means that if you need to add a booth to a location that you included on your spreadsheet to council, you do not have to set up that location again. 3. To add NEW booth sale locations please follow the instructions on the Cookie Booth Set-Up Instructions (PDF) available at www.GirlScoutsNorCal.org/boothsetup Questions? Local product sales staff members are available to help. OR Email the webmaster Jessica Voytek firstname.lastname@example.org (preferred) or call (510) 562-8470 ext. 160 A copy of this presentation and other documentation will be available for download at www.GirlScoutsNorCal.org/boothsetup Thank YOU for volunteering!
Pages to are hidden for
"2008 Cookie Finder"Please download to view full document