Knowledge Skill Templates

To create a knowledge skill, you upload your data to one or more of the provided data templates. To help you select the correct template for your skill and gather the requirements for that template, review the following template information.

Important: Make sure that your institution's privacy policies allow you to share the information that you provide in the template for the skill.

For general information about knowledge skills, see Knowledge Skill Overview.

General requirements
Template-specific requirements
Related topics

General requirements

The following requirements apply to all templates:

Save your file in CSV format.
Include the required name columns.
Don't include spaces in the CSV column headers. Instead, use underscores ("_").
Don't include capital letters in the CSV column headers.
Be consistent in the way you refer to the same item. For example, if two users in a People Directory are from the United States, don't set the "country" field to "United States" for one user and "USA" for another user.

Although not required, you can also make the following adjustments:

Remove unneeded columns.
Reorder columns.

Template-specific requirements

In addition to the general requirements listed previously, your data must meet the following requirements for the specific template that you use:

Glossary
How To
People Directory
Company Locations
Property Information
Products
Inventory
Events
Menus
Menu Items
Points of Interest
Projects
Policies

Glossary

You use the Glossary template to provide term-definition pairs so that users can ask your skill to define terms.

The following table contains key information about the Glossary template.

Information	Value
Name field	`term`
Alternate name field	`alternate_names`
Example questions	"Define leadership principles." "How is working backward process defined?" "What is the meaning of leadership principles?"
Template ID	`f184839a-c0ff-46d7-84b9-ca557f92519f`

Glossary template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Glossary template:

term (Required)
alternate_names
definition (Required)

term

Required.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	bar raiser leadership principles

Return to Glossary.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	b.r.^br amazon l.p.^amazon l.p.s^amazon leadership principles^l.p.^l.p.s^lp^lps^amazon lps

Return to Glossary.

definition

Required.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	An interviewer at Amazon who is brought into hiring loops to be an objective third party. By bringing in somebody who's not associated with the team, the best long-term hiring decisions are made to ensure the company is always serving, surprising, and innovating for customers. The role of the Bar Raiser is to be a steward of Amazon's 14 Leadership Principles. A set of standards ingrained in Amazon's culture. There are fourteen, including: Customer Obsession, Ownership, Invent and Simplify, Are Right, A Lot, Learn and Be Curious, Hire and Develop the Best, Insist on the Highest Standards, Think Big, Bias for Action, Frugality, Earn Trust, Dive Deep, Have Backbone; Disagree and Commit, and Deliver Results.

Return to Glossary.

How To

You use the How To template to provide instructions for actions.

The following table contains key information about the How To template.

Information	Value
Name field	`action_name`
Alternate name field	`alternate_names`
Example questions	"How can I log on to the WiFi?" "I want to print." "Help me log on to the WiFi."
Template ID	`33d0eb44-2451-457c-8aa0-1a53a7067e8b`

How To template fields

The following list shows the requirements for the columns in your data spreadsheet file for the How To template:

action_name (Required)
alternate_names
instructions (Required)

action_name

Required.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Log on to the WiFi book a conference room

Return to How-To.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol. Trailing ^ values are removed on import.
Example Values	log on to the internet^sign on to the WiFi^sign on the internet^get online^sign online^log on to the web^get on the web^access the internet^get on the WiFi^get on the internet^ reserve a room^book a room^reserve a conference room^book a meeting room^reserve a meeting room^book a meeting^reserve a meeting^

Return to How-To.

instructions

Required.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	To sign on to the WiFi, choose the network NETWORK and enter the password PASSWORD. To reserve a meeting room, visit meetings.corporation.example.com while on the corporate WiFi network.

Return to How-To.

People Directory

You use the People Directory template to provide attributes about employees.

The following table contains key information about the People Directory template.

Information	Value
Name field	`full_name`
Alternate name field	`alternate_names`
Example questions	"How many employees are in North America?" "Is Mary Major a Manager?" "What role does John Public have?" "What employees are in New York City?" "When was John Public born?"
Template ID	`45c2ed23-907b-4eb1-b107-f895c327aea8`

People Directory template fields

The following list shows the requirements for the columns in your data spreadsheet file for the People Directory template:

person_unique_id (Required)
full_name (Required)
first_name
last_name
alternate_names
user_name
description
start_date
end_date
tenure
seniority
contact_information
email
phone_number
phone_extension
cell_number
pager_description
pager_number
manager_email
manager_phone_number
assistant_email
assistant_phone_number
location_description
continent
country
state
city
zipcode
campus
building
floor
room
seat
address
role_description
status
job_type
job_title
job_category
team
department
organization
specialty
vacation_day_balance
manager_name
manager_unique_id
assistant_name
assistant_unique_id
direct_report_names
direct_report_unique_ids
number_of_direct_reports
number_of_indirect_reports
date_of_birth
education_description
role

person_unique_id

Required. Each value must be unique.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	12345 54321

Return to People Directory.

full_name

Required.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Megan Manager Sam Subordinate

Return to People Directory.

first_name

Optional.

Data Type	Text
Max Length/Value	75 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Megan Sam

Return to People Directory.

last_name

Optional.

Data Type	Text
Max Length/Value	75 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Manager Subordinate

Return to People Directory.

alternate_names

Optional.

Data Type	Text
Max Length/Value	250 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol. Trailing ^ values are removed on import.
Example Values	Meg Manager Samuel Subordinate^Sammy Subordinate

Return to People Directory.

user_name

Optional.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values
Formatting Notes	N/A
Example Values	managerm subordinates

Return to People Directory.

description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	Megan Manager is the founder and CEO of XYZ Corp. She has been with XYZ Corp. since September 2015. Her extension is 4566. Sam Subordinate is an Operations Analyst. He has been with XYZ Corp. since October 2015. His extension is 4568.

Return to People Directory.

start_date

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
Example Values	2015-09-15 2015-10-15 00:00:00

Return to People Directory.

end_date

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
Example Values	2019-09-15 2019-10-15 00:00:00

Return to People Directory.

tenure

Optional.

Data Type	Integer
Max Length/Value	65,535
Accepts List Values	No
Formatting Notes	Units are days. Decimal values are not accepted.
Example Values	1115 2085

Return to People Directory.

seniority

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	executive non-executive

Return to People Directory.

contact_information

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	You can reach Megan Manager by contacting her assistant, Alex Assistant. Alex Assistant is available via phone at (123)555-4567 and via email at assistanta@example.com. Sam Subordinate is currently out of the office. For urgent messages, please call or email Jane Junior.

Return to People Directory.

email

Optional.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	managerm@example.com subordinates@example.com

Return to People Directory.

phone_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123)555-1230 123-555-1232

Return to People Directory.

phone_extension

Optional.

Data Type	Text
Max Length/Value	25 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	4566 ext. 4568

Return to People Directory.

cell_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123)555-1230 123-555-1232

Return to People Directory.

pager_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	Megan Manager's pager number is (123) 321-6543. Megan's pager email is page-managerm@example.com. Sam Subordinate is currently out of the office. For urgent issues, please page Jane Junior.

Return to People Directory.

pager_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123)789-1230 123-789-1232

Return to People Directory.

manager_email

Optional.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	managerm@example.com managerm@example.com

Return to People Directory.

manager_phone_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123)789-1230 123-789-1232

Return to People Directory.

assistant_email

Optional.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	assistanta@example.com assistant@example.com

Return to People Directory.

assistant_phone_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123)789-1230 123-789-1232

Return to People Directory.

location_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	Megan Manager is located on the seventh floor of the Headquarters building. Sam Subordinate sits in seat 3 on the seventh floor of the Headquarters building in New York.

Return to People Directory.

continent

Optional.

Data Type	Text
Max Length/Value	25 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	North America

Return to People Directory.

country

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	United States

Return to People Directory.

state

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	California

Return to People Directory.

city

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Santa Barbara

Return to People Directory.

zipcode

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	10019

Return to People Directory.

campus

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	east campus west campus

Return to People Directory.

building

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	headquarters California branch

Return to People Directory.

floor

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	No unit is included, so use your preferred units in your data.
Example Values	ground floor second floor

Return to People Directory.

room

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Because we have not added a unit, use your preferred units in your data.
Example Values	6A engineering pod

Return to People Directory.

seat

Optional.

Data Type	Text
Max Length/Value	25 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	one three

Return to People Directory.

address

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	123 7th Avenue 123 Operations Way

Return to People Directory.

role_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	Megan Manager is the founder and CEO of XYZ Corp. Megan is on the Leadership team and is the company's only manager. Sam Subordinate is a full-time Operations Analyst.

Return to People Directory.

status

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	full-time part-time

Return to People Directory.

job_type

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	manager Individual contributor

Return to People Directory.

job_title

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Founder and CEO Operations Analyst

Return to People Directory.

job_category

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Executive Analyst

Return to People Directory.

team

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Leadership Operations

Return to People Directory.

department

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Senior Management Team Engineering

Return to People Directory.

organization

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Example Corp. Legal

Return to People Directory.

specialty

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol.
Example Values	databases^analytics marketing^account management

Return to People Directory.

vacation_day_balance

Optional.

Data Type	Number
Max Length/Value	99,999
Accepts List Values	No
Formatting Notes	Units are days. Decimal values are permitted.
Example Values	10 3.5

Return to People Directory.

manager_name

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Megan Manager

Return to People Directory.

manager_unique_id

Optional. However, if present, the value must match a person_unique_id value.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	12345

Return to People Directory.

assistant_name

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Alex Assistant

Return to People Directory.

assistant_unique_id

Optional. However, if present, the value must match a person_unique_id value.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	56789

Return to People Directory.

direct_report_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	Alex Assistant^Sam Subordinate^Jane Junior New Nancy

Return to People Directory.

direct_report_unique_ids

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	56789^54321^98765 65734

Return to People Directory.

number_of_direct_reports

Optional.

Data Type	Integer
Max Length/Value	4,294,967,295
Accepts List Values	No
Formatting Notes	Units are employees. Decimal values are not permitted.
Example Values	3 1

Return to People Directory.

number_of_indirect_reports

Optional.

Data Type	Integer
Max Length/Value	4,294,967,295
Accepts List Values	No
Formatting Notes	Units are employees. Decimal values are not permitted.
Example Values	4 1

Return to People Directory.

date_of_birth

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS.
Example Values	9/25/1978 12/28/1987

Return to People Directory.

education_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	Megan Manager received her B.A. from the University of Delaware and her M.B.A. from the Wharton School of the University of Pennsylvania.

Return to People Directory.

role

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	Executive Assistant^ Software Developer^Software Development Engineer^

Return to People Directory.

Company Locations

You use the Company Locations template to provide the location and contact information for company buildings.

The following table contains key information about the Company Locations template.

Information	Value
Name field	`name`
Alternate name field	`alternate_names`
Example questions	"What is the zipcode of Call Center One?" "How many distribution offices are there?" "What office locations are in Any Town?" "What is the city of Headquarters?" "How do I call Warehouse One?"
Template ID	`2d1adc64-be18-4d3e-a385-e6b8a05e07a8`

Company Locations template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Company Locations template:

name (Required)
alternate_names
building_categories
building_type
city
contact_information
country
description
fax_number
location_description
phone_number
state
zipcode

name

Required.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	N/A
Formatting Notes	Each value must be unique.
Example Values	Headquarters Warehouse One

Return to Company Locations.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	HQ^ Fulfillment Center^

Return to Company Locations.

building_categories

Optional.

Data Type	Text
Max Length/Value	250 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	corporate^ distribution^

Return to Company Locations.

building_type

Optional.

Data Type	Text
Max Length/Value	250 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	corporate office distribution center^distribution facility

Return to Company Locations.

city

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Seattle Bellevue

Return to Company Locations.

contact_information

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	To contact the reception of the Headquarters, call (123) 555-0100. To contact the reception of the Warehouse, call (123) 555-0101.

Return to Company Locations.

country

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	the United States

Return to Company Locations.

description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	The Headquarters is the largest AnyCompany location and is home to 300 employees. Teams that work here include Engineering, Product, Sales, and Operations. Warehouse One is the largest distribution center and is home to 1000 Operations employees.

Return to Company Locations.

fax_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123) 555-0199 (123) 555-0198

Return to Company Locations.

location_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	Headquarters is located at 123 Main Street in Any Town, Washington. Warehouse One is located at 123 Any Street in Any Town, Washington.

Return to Company Locations.

phone_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123) 555-0100 (123) 555-0101

Return to Company Locations.

state

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Washington California

Return to Company Locations.

zipcode

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	98121 98402

Return to Company Locations.

Property Information

You use the Property Information template to provide information, such as the location and contact information, of a property.

The following table contains key information about the Property Information template.

Information	Value
Name field	`name`
Alternate name field	`alternate_names`
Example questions	"What are the front desk's business hours?" "How do I reach the front desk?" "What is the description of Room 30?" "How do you get a hold of the front desk?" "How do I call Warehouse One?"
Template ID	`9f3324ac-7619-4785-967c-c006f5e07e33`

Property Information template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Property Information template:

name (Required)
alternate_names
building
business_hours
check_out_time
contact_information
description
directions
email
phone_number
fax_number
address
floor
location_description
wifi_instructions
wifi_network
wifi_password

name

Required.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	Each value must be unique.
Example Values	the pool room 301

Return to Property Information.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	drink^alcohol exercise^workout^yoga^run

Return to Property Information.

building

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	the hotel california the cottages

Return to Property Information.

business_hours

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	Each value must be unique.
Example Values	open 24/7 open weekdays 6am to 10pm

Return to Property Information.

check_out_time

Optional.

Data Type	Text
Max Length/Value	250 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	The standard checkout time for all rooms is 10am. To request a late check out, call the front desk at extension 0-1-2. Checkout time is 10am.

Return to Property Information.

contact_information

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	To make a reservation or order room service, call 5-6-7. To call the concierge, dial 0-1-2 or email them at front_desk@hotelcalifornia.example.com.

Return to Property Information.

description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	The front desk is available to assist you 24/7. If you have any questions or need assistance, dial 0-1-2. Room 30 offers numerous conveniences like refrigerators and microwaves, free WiFi, flat-screen TVs with cable channels, premium bedding, coffee/tea makers, and free newspapers.

Return to Property Information.

directions

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	To get to the front desk, take the elevator to the lobby and walk to the main entrance. Bathrooms can be found on every floor next to the elevator.

Return to Property Information.

email

Optional.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	front_desk@example.com workout_center@example.com

Return to Property Information.

phone_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123)555-1230 123-555-1232

Return to Property Information.

fax_number

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	Standard telephone number formats
Example Values	(123) 555-0199 (123) 555-0198

Return to Property Information.

address

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	123 7th Avenue 123 Operations Way

Return to Property Information.

floor

Optional.

Data Type	Text
Max Length/Value	50 characters
Accepts List Values	No
Formatting Notes	No unit is included, so use your preferred units in your data.
Example Values	the 2nd floor the roof

Return to Property Information.

location_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	The restaurant is located in the lobby, next to the bar. Ice machines can be found on every floor next to the elevator.

Return to Property Information.

wifi_instructions

Optional.

Data Type	Text
Max Length/Value	250 characters
Accepts List Values	No
Formatting Notes	This field supports custom, free-text input. Whatever you input in the cell is exactly how Alexa will respond when end-users query this field.
Example Values	To connect to the WiFi, use the network 'building-guest' and enter the password 'buildingguest,' with no spaces or capital letters. Use the network 'anycompany' and enter the password 'anycompanypw,' with no spaces or capital letters.

Return to Property Information.

wifi_network

Optional.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	building-guest anycompany

Return to Property Information.

wifi_password

Optional.

Data Type	Text
Max Length/Value	100 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	'buildingguest', with no spaces or capital letters anycompany, with no spaces or capital letters

Return to Property Information.

Products

You use the Products template to help users answer questions, such as locations and prices, about products.

The following table contains key information about the Products template.

Information	Value
Name field	`name`
Alternate name field	`alternate_names`
Example questions	"What product was released most recently?" "When did State Street Merlot 2013 come out?" "What is the price of Atlantic Salmon?" "What is the newest item?" "How new is Midnight Moon Vegan Cheese Alternative?"
Template ID	`8e2d16c5-ab91-42f7-9e99-27ed15479559`

Products template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Products template:

name (Required)
alternate_names
description
features
shelf
status
product_categories
location_description
release_date
rating
brand
price
floor
aisle

name

Required.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Midnight Moon Vegan Cheese Alternative Atlantic Salmon

Return to Products.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	Midnight Moon Vegan Cheese Atlantic Salmon^Farm-Raised Salmon^Farm Salmon

Return to Products.

description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Who needs cheese when you have Midnight Moon's vegan cheese alternative? It takes just like the real thing - but vegan! Our Atlantic Salmon has a mild flavor. It has a medium-to-firm texture with large flakes.

Return to Products.

features

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	organic^vegan farm raised^healthy

Return to Products.

shelf

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	top shelf middle shelf

Return to Products.

status

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	in-stock^discounted in-stock

Return to Products.

product_categories

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	dairy^cheese^snack fish^seafood^salmon

Return to Products.

location_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	The Midnight Moon Vegan Cheese Alternative is located in aisle twelve. You can find all seafood at the counter behind aisle one.

Return to Products.

release_date

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
Example Values	2015-09-15 2015-10-15 00:00:00

Return to Products.

rating

Optional.

Data Type	Number
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	3.7 4

Return to Products.

brand

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Midnight Moon Fresh Fish

Return to Products.

price

Optional.

Data Type	Number
Max Length/Value	9,999,999,999
Accepts List Values	No
Formatting Notes	U.S. dollars No currency symbol, such as "$." Can use decimals.
Example Values	20 4.50

Return to Products.

floor

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	first floor

Return to Products.

aisle

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	aisle 12 aisle 1

Return to Products.

Inventory

You use the Inventory template to provide information, such as the location and description, about items.

The following table contains key information about the Inventory template.

Information	Value
Name field	`name`
Alternate name field	`alternate_names`
Example questions	"How many items are in the cabinet?" "Tell me about power strips." "What are the instructions of power strips?"
Template ID	`dbdf3800-a805-4214-be1c-d98a966cd3f6`

Inventory template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Inventory template:

name (Required)
alternate_names
associated_task
item_categories
description
features
instructions
room
shelf
storage_area
location_description

name

Required.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	printer paper power strips

Return to Inventory.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	printing paper^white paper electrical socket^plugs

Return to Inventory.

associated_task

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	printing battery charging^re-charging

Return to Inventory.

item_categories

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	paper^copy paper outlet^wall charger

Return to Inventory.

description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	The office has printer paper that is 8.5'' by 11''. The office has power strips with 6-outlets and can be used when you need more power receptacles than are available. These power strips offer surge protection.

Return to Inventory.

features

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	print^printer electrical

Return to Inventory.

instructions

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	To re-stock the printer paper, open the paper tray door. Pull out the paper tray and load a stack of plain paper into the tray. The power strips can be plugged into any wall socket. Make sure that the cord is not in a position where people can easily trip over it.

Return to Inventory.

room

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	the supply room the storage room

Return to Inventory.

shelf

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	the green shelf the blue shelf

Return to Inventory.

storage_area

Optional.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	the cabinet the orange bin

Return to Inventory.

location_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	The printer paper is located on the green shelf in the cabinet in the supply room. Reach out to IT if the office is out of stock. The power strips are located in the orange bin on the blue shelf in the storage room. Reach out to IT if you have trouble finding it.

Return to Inventory.

Events

You use the Events template to provide the time, location, and other information about events.

The following table contains key information about the Events template.

Information	Value
Name field	`name`
Alternate name field	`alternate_names`
Example questions	"What is the earliest event?" "What is the venue for the Company All Hands?" "What are AnyCompany central conference room events?"
Template ID	`f9014c76-7cdc-4e6c-ab94-a7873127c25e`

Events template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Events template:

name (Required)
alternate_names
description
event_categories
event_type
start_date
end_date
location_description
venue

name

Required.

Data Type	Text
Max Length/Value	150 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	the Holiday Party the Team Offsite

Return to Events.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol. Trailing ^ values are removed on import.
Example Values	Christmas Party^Holiday Party^Office Holiday Party^Office Christmas Party Off site^Team Off-site^Off-site^Team Off Site^Q1 Team Offsite

Return to Events.

description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Join us for our upcoming Holiday Party on December 21st, 2020! There will be free fruit punch and pie. Our upcoming quarterly off-site is from January 8th to January 9th and will involve a review of team goals for the year 2021.

Return to Events.

event_categories

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	celebratory offsite^off-site^off site

Return to Events.

event_type

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	Office Party Offsite^Off site^Team Event

Return to Events.

start_date

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: MM-DD-YY H:MM, MM-DD-YYYY H:MM, MM-DD-YY, or MM-DD-YYYY. The default time zone is UTC.
Example Values	12/21/2020 19:00 1/8/2021 09:00

Return to Events.

end_date

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: MM-DD-YY H:MM, MM-DD-YYYY H:MM, MM-DD-YY, or MM-DD-YYYY. The default time zone is UTC.
Example Values	12/22/2020 1/9/2021 17:00

Return to Events.

location_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	The 2020 Holiday Party will take place at AnyCompany Headquarters. The next off-site will take place at AnyCompany's Expansion Office.

Return to Events.

venue

Optional.

Data Type	Text
Max Length/Value	500 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	AnyCompany Headquarters AnyCompany's Expansion Office

Return to Events.

Menus

You use the Menus template to provide information about menus, timing, and locations for meals.

The following table contains key information about the Menus template.

Information	Value
Name field	`menu_name`
Alternate name field	`alternate_names`
Example questions	"When is the brunch special?" "When will the brunch special menu end?" "What's for dinner?"
Template ID	`76b8edca-a1da-11ea-bb37-0242ac130002`

Menus template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Menus template:

menu_name (Required)
menu_type (Required)
alternate_names
location
menu_items (Required)
start_time
end_time

menu_name

Required.

Data Type	Text
Max Length/Value	150 characters.
Accepts List Values	No
Formatting Notes	N/A
Example Values	AnyCompany Cafeteria Lunch AnyFacility Eatery Dinner

Return to Menus.

menu_type

Required.

Data Type	Text
Max Length/Value	200 characters.
Accepts List Values	No
Formatting Notes	N/A
Example Values	lunch brunch special

Return to Menus.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	brunch^ supper^

Return to Menus.

location

Optional.

Data Type	Text
Max Length/Value	200 characters.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	AnyCompany Cafeteria^ AnyFacility Eatery^

Return to Menus.

menu_items

Required.

Data Type	Text
Max Length/Value	200 characters.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	triple chocolate brownie^cobb salad^coffee^ denver omelet^

Return to Menus.

start_time

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: MM-DD-YY H:MM, MM-DD-YYYY H:MM, MM-DD-YY, or MM-DD-YYYY. The default time zone is UTC.
Example Values	2020-09-23 23:00:00 2020-12-23 11:00:00

Return to Menus.

end_time

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: MM-DD-YY H:MM, MM-DD-YYYY H:MM, MM-DD-YY, or MM-DD-YYYY. The default time zone is UTC.
Example Values	2020-09-23 14:00:00 2020-12-23 14:00:00

Return to Menus.

You use the Menu Items template for facts such as ingredients, nutrition information, and pricing for food and drink items.

The following table contains key information about the Menu Items template.

Information	Value
Name field	`name`
Alternate name field	`alternate_names`
Example questions	"What are the ingredients for the Any Brewery brown ale?" "What is in triple chocolate brownie?" "How many calories are in Any Eatery penne carbonara?" "What are the allergens in triple chocolate brownie?"
Template ID	`cbfc7250-2981-11eb-adc1-0242ac120002`

The following list shows the requirements for the columns in your data spreadsheet file for the Menu Items template:

name (Required)
alternate_names
description
item_category
item_type
ingredients
allergens
dietary_characteristics
calories
alcohol_by_volume
price
price_description
location_description

Required.

Data Type	Text
Max Length/Value	200 characters.
Accepts List Values	No
Formatting Notes	N/A
Example Values	triple chocolate brownie Any Eatery penne carbonara

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	brownie^ carbonara^signature carbonara^

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	The Any Eatery triple chocolate brownie combines white, milk, and dark chocolate into a sweet, rich, and creamy delight. The Any Eatery carbonara is an American twist on the classic Italian carbonara.

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol. Trailing ^ values are removed on import.
Example Values	baked^warm^sweet^ italian^american^

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol. Trailing ^ values are removed on import.
Example Values	dessert^ pasta^

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol. Trailing ^ values are removed on import.
Example Values	white chocolate chips^dark chocolate chips^milk chocolate^butter^sugar^eggs^vanilla extract^cocoa^salt^ spaghetti^eggs^bacon^parmesean cheese^black pepper^salt^

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol. Trailing ^ values are removed on import.
Example Values	eggs^milk^ gluten^wheat^milk^eggs^

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list values with the ^ symbol. Trailing ^ values are removed on import.
Example Values	gluten free^nut free^ high sodium^

Return to Menu Items.

Optional.

Data Type	Number
Max Length/Value	9,999,999,999
Accepts List Values	No
Formatting Notes	Decimals are allowed but not required.
Example Values	600 850.5

Return to Menu Items.

Optional.

Data Type	Number
Max Length/Value	9,999,999,999
Accepts List Values	No
Formatting Notes	Decimals are allowed but not required.
Example Values	8.5 5

Return to Menu Items.

Optional.

Data Type	Number
Max Length/Value	9,999,999,999
Accepts List Values	No
Formatting Notes	U.S. dollars. No currency symbols, such as "$." Decimals are allowed but not required.
Example Values	7 10.50

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters.
Accepts List Values	No
Formatting Notes	N/A
Example Values	The small brownie is $2; the large brownie is $3.50.

Return to Menu Items.

Optional.

Data Type	Text
Max Length/Value	65,535 characters.
Accepts List Values	No
Formatting Notes	N/A
Example Values	You can find the carbonara in the first floor cafe, at the west end of the building.

Return to Menu Items.

Points of Interest

You use the Points of Interest template to provide the location, contact, and activity information about attractions such as museums, stadiums, and restaurants.

The following table contains key information about the Points of Interest template.

Information	Value
Name field	`name`
Alternate name field	`alternate_names`
Example questions	"What are some points of interests?" "What is the address of Any Museum?" "How much does Any Museum cost?" "Where is Any Team Stadium?"
Template ID	`cc8157c7-59b1-401b-bd68-08f8c2ba4ba8`

Points of Interest template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Points of Interest template:

name (Required)
activities
address
alternate_names
city
cost
features
location_description
location_type
locations
operating_hours_description
price_description
state
website
wifi_instructions
wifi_network
wifi_password

name

Required.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	AnyTeam Stadium AnyMuseum

Return to Points of Interest.

activities

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	tours^fireworks^anysport games^ guided tour^modern art gallery^

Return to Points of Interest.

address

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	1 East AnyStreet, AnyCity, AnyState, 12345 1 AnyRoad, AnyMunicipality, AnyState, 12345

Return to Points of Interest.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	AnyTeam Stadium^AnyTown Stadium AnyMuseum^AnyTown Museum

Return to Points of Interest.

city

Optional.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	AnyCity AnyMunicipality

Return to Points of Interest.

cost

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	At the box office, tours cost $10 for adults and $5 for children and seniors. Tours booked online are $5 for all guests. For tickets, please visit https://www.anyleague.com/anyteam/tickets or call the box office at 1 (800) 123-4567. AnyMuseum is free to all members of the public.

Return to Points of Interest.

features

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	group^outdoors^ free^wifi^

Return to Points of Interest.

location_description

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	AnyTeam Stadium is located on Any Street off the AnyState highway. Parking is limited. AnyMuseum is located at the corner of AnyCity Street and AnyStreet Avenue.

Return to Points of Interest.

location_type

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	stadium^ museum^indoors^

Return to Points of Interest.

locations

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	AnyLocation^AnyNeighborhood^AnyPrecint^AnyCongressionalDistrict^ AnyTown Arts District^

Return to Points of Interest.

operating_hours_description

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Any Stadium is temporarily closed to visitors. Any Museum is open 9AM-5PM Monday through Friday. It is not open on the weekends.

Return to Points of Interest.

price_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Tickets to Any Museum are $20 for adults and $10 for children and seniors.

Return to Points of Interest.

state

Optional.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	AnyState

Return to Points of Interest.

website

Optional.

Data Type	Text
Max Length/Value	2000 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	https://www.anyleague.com/anyteam/stadium www.anymuseum.com

Return to Points of Interest.

wifi_instructions

Optional.

Data Type	Text
Max Length/Value	250 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	To connect to the WiFi, use the network 'museum-public' and enter the password 'AnyMuseum'.

Return to Points of Interest.

wifi_network

Optional.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	museum-public

Return to Points of Interest.

wifi_password

Optional.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	AnyMuseum

Return to Points of Interest.

Projects

You use the Projects template to track the status, relevant dates, and key participants for a project. This template can also be used for goal tracking.

The following table contains key information about the Projects template.

Information	Value
Name field	`name`
Alternate name field	`alternate_names`
Example questions	"Who owns the Mobile Application Launch?" "Are any projects blocked?" "What's the latest with Any Company Financial Review?" "Who are the stakeholders of the Mobile Application Launch project?" "What's the Any Company Financial Review budget?"
Template ID	`fd716d02-3b80-11eb-adc1-0242ac120002`

Projects template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Projects template:

name (Required)
alternate_names
description
owner
assignee
stakeholder
project_type
start_date
due_date
budget
project_update
project_status
project_status_category
project_tags
priority
rank
location_description

name

Required.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Launch Mobile Application Complete Any Company Financial Review

Return to Projects.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	app launch^mobile app deployment Any Company diligence^due diligence for Any Company

Return to Projects.

description

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	This project tracks the end to end development for Any Company's Mobile Application launch, slated for 2022. The objective of this project is to complete a financial review for Any Company and provide a recommendation to the investment committee.

Return to Projects.

owner

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	Martha Rivera Diego Ramirez^Martha Rivera^

Return to Projects.

assignee

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	No
Formatting Notes	N/A
Example Values	Martha Rivera Diego Ramirez

Return to Projects.

stakeholder

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	John Doe^Richard Roe^John Stiles^ Mateo Jackson^

Return to Projects.

project_type

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	sprint^story^ task^

Return to Projects.

start_date

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
Example Values	9/23/2020 10/23/2020 12:00PM

Return to Projects.

due_date

Optional.

Data Type	Date
Max Length/Value	N/A
Accepts List Values	No
Formatting Notes	Accepted formats: YYYY-MM-DD or YYYY-MM-DD HH:MM:SS
Example Values	1/23/2022 2/23/2022 12:00PM

Return to Projects.

budget

Optional.

Data Type	Number
Max Length/Value	9,999,999,999
Accepts List Values	No
Formatting Notes	U.S. dollars No currency symbol, such as "$." Can use decimals.
Example Values	50.35 50045

Return to Projects.

project_update

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Scoping work on the sprint will begin in quarter four. The team divided responsibilities among the analysts and will begin investigating next week.

Return to Projects.

project_status

Optional.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	on track blocked

Return to Projects.

project_status_category

Optional.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	green red

Return to Projects.

project_tags

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	operational excellence^ backlog^

Return to Projects.

priority

Optional.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	high low

Return to Projects.

rank

Optional.

Data Type	Number
Max Length/Value	999,999,999
Accepts List Values	No
Formatting Notes	N/A
Example Values	1 176

Return to Projects.

location_description

Optional.

Data Type	Text
Max Length/Value	500 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Mobile app development is located in Twin Falls, Idaho. The diligence is taking place in the United States and United Kingdom.

Return to Projects.

Policies

You use the Policies template to denote the availability and rules governing an amenity for a user group at a location. For example, "Can guests use the wifi at the student union?", where guests are the user_group, wifi is the amenity_name, and the student union is the location.

Each combination of amenity_name, user_group, and location should be unique. The user_group and location accept multiple values, which you can use for cases where a policy applies to multiple user_groups and locations.

The following table contains key information about the Policies template.

Information	Value
Name field	`policy_name`
Alternate name field	`alternate_names`
Example questions	"Tell me about wifi for guests at the student union." "Can students use the wifi?" "How can guests request a study room?" "Can I use the study rooms at the student union building?"
Template ID	`1845aac8-5ed9-11eb-ae93-0242ac130002`

Policies template fields

The following list shows the requirements for the columns in your data spreadsheet file for the Policies template:

policy_name (Required)
alternate_names
amenity_name
user_group
location
policy_description (Required)

policy_name

Required.

Data Type	Text
Max Length/Value	200 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	wifi for guests at the student union study rooms for guests at the student union

Return to Policies.

alternate_names

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	guest wifi at the student union building^student union guest wifi^ student wifi at the student union

Return to Policies.

amenity_name

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	wifi^ study rooms^discussion rooms

Return to Policies.

user_group

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	guests^visitors^ student^undergrads^grad students^

Return to Policies.

location

Optional.

Data Type	Text
Max Length/Value	65,535 characters. Each individual list value must be 200 characters or less.
Accepts List Values	Yes
Formatting Notes	Separate list items with ^ symbol. Trailing ^ values are removed on import.
Example Values	student union^student union building

Return to Policies.

policy_description

Required.

Data Type	Text
Max Length/Value	65,535 characters
Accepts List Values	No
Formatting Notes	N/A
Example Values	Guests should use the network lib-guest. After connecting, you will be directed to www.anylibrary.edu to enter your name and email address. Once submitted, you will have 6 hours of wifi before you will have to reconnect. Students should log in to their AnyLibrary Account to see available rooms and time slots on the home page. Please reach out to the front desk or any staff member for assistance.

Return to Policies.