BLACK BEAR DINER GOOGLE MAPS PACKAGE INSTRUCTIONS
The spreadsheet is what creates the Google Maps package. The spreadsheet is uploaded directly to Google Maps to create the sites and their corresponding information.
It is if the upmost importance that you go through the spreadsheet and proofread it for accuracy’s sake, but also for grammatical and formatting’s sake (commas where they should be, appropriate labels for traffic counts, sizes, pricing, etc.) before the due date.
Work to have as complete of a package done by the indicated due date, however we will still be able to add additional sites as we become award of them. When a new site needs to be added, fill out the information on the existing sheet, but highlight the row to indicate that is new. Once it has been added to the package, we will remove the highlight.
This is where the site name will go. If it is a part of a shopping center, use that name. If it was formerly another use it could be referred to as “Former [previous use name]”. It could be named the address, or whatever else you feel is the best way of identifying this site.
It is of the utmost importance that you are providing a latitude and longitude for the site that points to the exact location of the site. Use a decimal point format that uses positive and negative instead of North, East, South, and West. Have the two numbers separated by a comma in the same cell
The easiest way to find latitude and longitude is with our friend, Google Maps:
Right click on the location for which you need the latitude and longitude.
Select “What’s Here?”
Then a box will show up at the bottom center of the window. The last line (highlighted blue on the second image) is the latitude and longitude. Just copy and paste that number straight into the cell and you are golden.
Provide street address
Don’t include city in the address box, instead in this column
As with city, don’t include in the address cell
Include proposed square footage or lot size. If there are multiple options, include a range or indicate “Multiple Opportunities”
For lease rates, use an annual amount. Indicate that it is a per year figure.
Enter the primary street traffic counts in the first column and the secondary in the second. Include the street name followed by a hyphen and then the traffic count. Label the count as ADT, CPD, VPD or any other appropriate label.
Include commentary on the site. This is the area to indicate any information from the listing broker. It is also a place to list factors that make the site good and factors that hinder the site. It is also a space where any of the previously listed pieces of information can be further explained. This is where we really shine!
Flyer & Street View
Steve & his team will add the flyer and street view to the package. Cobroker, though, is to provide the flyers, site plans, or any other supplemental information. If Cobroker has any photos of the site they are encouraged to include them so that they can contribute to the creation of a complete and fully informative package.
To submit flyers, site plans, and photos, there are a couple of options:
Create a Dropbox folder with the materials inside. Name the files so that they have the same name as the site they are in reference to. Their names need to exactly reflect the name of the site as was entered into column 1 of the spreadsheet. Then enter the Dropbox link for the folder into the cell B1, next to “Link to Flyers”. Click here for an example.
Do the same as above, but with Google Drive. Copy and paste the link to the folder into cell B1.
Questions? Call or email Kelsie Bowler at 801.947.8353 or firstname.lastname@example.org