# Custom data
External data may include product or transaction information such as budget, cost, and other data. This module allows you to include this information in your reports.
# An example of operations
- You have budget and cost data in your spreadsheet file.
- You can combine this data with our ready-made reports.
# Data schema
After starting the module, a table is displayed in the record:
Rozwiń aby zapoznać się ze schematem danych
To create collect, you need to import the data in a spreadsheet or BigQuery table.
# Start module creation
Select the “Collect” tab in the left menu and then click the Add new data collect button.
From the list of available modules we select Custom Data
# Initial settings
In the first step, you have to fill in the following fields:
Collect Name – the name of our module. It will be visible under that name elsewhere on the platform.
Data type – we choose the data type: cost, budget or individual data.
Data source – we select the data source.
Depending on whether our data source is Spreadsheet or BigQuery, the following fields appear:
# Spreadsheet option
Spreadsheet ID – Address of Spreadsheet
Sheet name – The name of our Spreadsheet.
Select Google Token – we select an email address that is associated with our data.
# BigQuery option
Google Cloud Project – We select the project from which we obtain the data.
BigQuery Dataset - We select the dataset from which we obtain the data.
BigQuery Table - We select the table from which we obtain the data.
By pressing the Finish button, the module configuration is created.
# Setting module in schedule
Your module is now created in WitCloud 📊. The final step is to determine the time range for which you need to retrieve historical data. The schedule for retrieving current data will be created automatically.
Enter the appropriate range and click the Finish button.