CSV Files
At Grade.us you can leverage your data in multiple ways. You can add Data to your Grade.us account, or export data to your own devices through CSV files.
In this Article:
-
CSV Upload
-
CSV Formatting
- Multi-Location Business
- Review Requests
- Profiles
-
CSV Formatting
- CSV Export
- Common Questions
Definition:
CSV File: CSV stands for "comma-separated values." CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Files in the CSV format can be imported to and exported from programs that store data in tables.
CSV Upload
At different points throughout your Grade.us account set up, you will have the ability to add data through a CSV file. This step will allow you to add multiple pieces of data all at once without having to input information manually, saving you time in your account creation and/ or management.
1. Navigate to the tab or area where you would like to upload your information.
2. Select the "Upload CSV/XLSX" button.
3. Choose a file to upload.
- Select the "Upload Csv Xlsx" button.
- Navigate to where your file is saved on your computer.
- Select the file and select "Open."
3. Organize Columns.
- Move the options from the "Columns from file" column to the "Expected for upload" column.
Caution:
If your headers do not match our guidelines, you will be prompted to match them after uploading the file. Please see "CSV Formatting" to find out what the guidelines are for your CSV file.
4. Select "Continue to Upload."
CSV Formatting
Each area where you are able to upload a CSV file has different requirements for the name of the information that can be accepted. Each column in your file must have a specific name in order to be recognized by our file system. To better understand how to format your CSV file for optimal results, please see the requirements based on where you are trying to upload your information:
Funnel: Multi-Location Business
| shortname (for URL) | Profile Name | Internal ID |
|---|---|---|
| Required | Optional | Optional |
-
shortname: Your desired URL shortname for the business location (e.g. atlanta). Note that the shortname will be the displayed location name (i.e. it will appear on the location button or map bubble), and will follow a few rules:
- Dashes in the shortname will create a space in the final display.
- The first letter of each section of the shortname (separated by a dash) will be capitalized in the final display.
- For example, the shortname "atlanta" will become "Atlanta". "san-jose" will become San Jose.
- label: The main business name that will appear on the landing page (e.g. Pizza Hutch - San Diego)
- internal_id: If the business has a store code or other unique identifier, you can include it under this header. It will not be displayed publicly.
Auto-find major listings
Include all of the following optional headers to auto-run Connect a location for all uploaded locations. Make sure to check the appropriate box when uploading.
- name: The business location name. This should correspond to the name of the business as it is likely to appear in review site listings you would like to use (e.g. Peachtree Mortgage - Atlanta Office)
- postal_code: The postal code for the business location (e.g. 90210)
- phone_number: The phone number for the business location (e.g. 212-867-5309)
Auto-add other listings
If you have URLs for other review site listings that you'd like added when uploading, simply create an additional column with the name of the review site (e.g. facebook) and place the URLs in the corresponding rows below it. Here's an example of what a finished bulk location upload file might look like:
Remember: the only required column is shortname. When you've finished creating your file, the next step is to upload it.
Review Requests: Recipients, Email, Phone/ Text
| email_address | phone_number | first_name | Last_name | shortname | tags |
|---|---|---|---|---|---|
| at least one is required | at least one is required | Required | Optional | Optional | Optional |
- email_address: the email address of the customer you would like to receive campaign information.
- phone_number: the phone number of the customer you would like to receive campaign information.
- first_name: Customer's first name.
- Last_name: Customer's last name.
-
shortname: Your desired URL shortname for the business location (e.g. atlanta). Note that the shortname will be the displayed location name (i.e. it will appear on the location button or map bubble), and will follow a few rules:
- Dashes in the shortname will create a space in the final display.
- The first letter of each section of the shortname (separated by a dash) will be capitalized in the final display.
- For example, the shortname "atlanta" will become "Atlanta". "san-jose" will become San Jose.
- tags: keywords you would like associated with this data.
Manage: Profiles
| shortname (for URL) | Profile Name | Internal ID |
|---|---|---|
| Required | Optional | Optional |
-
shortname: Your desired URL shortname for the business location (e.g. atlanta). Note that the shortname will be the displayed location name (i.e. it will appear on the location button or map bubble), and will follow a few rules:
- Dashes in the shortname will create a space in the final display.
- The first letter of each section of the shortname (separated by a dash) will be capitalized in the final display.
- For example, the shortname "atlanta" will become "Atlanta". "san-jose" will become San Jose.
- label: The main business name that will appear on the landing page (e.g. Pizza Hutch - San Diego)
- internal_id: If the business has a store code or other unique identifier, you can include it under this header. It will not be displayed publicly.
CSV Export
All the data collected by Grade.us can also be exported to a CSV file for your own use. To export this data to a CSV file, perform the following:
1. Navigate to the tab or area where you would like to export your information.
2. Select the "Export to CSV" button.
3. Navigate to where you would like the data to be saved.
The following areas can have the data exported:
- Reviews: Customer Feedback
- Reviews: Survey Answers
- Reporting: Generated Reports
- Manage: Users
- Manage: Profiles
- Manage: Performance (beta) > Details
End of Article
Congratulations! You have now learned how to upload, format, and export CSV files.
Common Questions
Why would some recipients be dropped from a CSV upload?It's most likely that the dropped recipients have already been added to the campaign and are still on either the pending, active, or inactive list. As long as a recipient resides on one of these lists, they cannot be re-added.
Duplicate recipients can be re-added to a campaign after completely deleting them from your campaign. Click the 'X' in the recipient's entry or delete in bulk by clicking 'Delete all pending/active/inactive recipients