The GSC Warehouse allows you to blend data from multiple data sources into a single database for consolidated reporting. This would typically be for a single client or website domain.
Create a New Client Database
Client Name: Databases are referenced by their name, so make it short and meaningful. Do not use special characters.
Database Folder: You can store client databases in the default folder you specified during setup, of you can use a different location if you want to keep client files separated. This location should NOT be on a shared of synchronized drive or you risk database corruption.
Database File: By default, this will be derived from the client name, but you can change it if you want. It must be a valid file name. A ‘.db’ file extension will be appended automatically. Backup files will use the same name with a date stamp (clientname-20260601.db).
Backup Folder: This can be the backup folder you specified during setup or a different location.
Load an Existing Client Database
This allows you to load an existing client database, maybe from a backup or one shared by a co-worker.
Database File: identify the file to be loaded.
Client Name: Assign a short, meaningful name for this database.
This is a SHARED/BACKUP file — if you are loading a date-stamped backup file maintained by someone else, use this option. The checkbox makes sure you always load the most recent date-stamped version of that file. Uncheck it if you want a specific dated version.
This is MY database file — If you want to use it as your own file, refreshing the data in it, then it should be on a local, non-synchronized drive to prevent corruption. You will also need to specify the backup folder for it.
If you are restoring your system from date-stamp backup files, copy them to a local drive (out of your backup folder) and remove the date-stamps from the file names.