Custom data

• Introduction
• An example of operations
• Data schema
• Configuration
  • Start module creation
  • Initial settings
• Setting module in schedule

Introduction

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

1. You have budget and cost data in your spreadsheet file.
2. 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

Field name	Type	Mode
end_date	DATE	NULLABLE
source	STRING	NULLABLE
medium	STRING	NULLABLE
campaign	STRING	NULLABLE
content	STRING	NULLABLE
keyword	STRING	NULLABLE
channel_group	STRING	NULLABLE
currency	STRING	NULLABLE
cost	FLOAT	NULLABLE
clicks	INTEGER	NULLABLE
impressions	INTEGER	NULLABLE

Configuration

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.