Attention! The Google BigQuery integration has to be enabled to use this feature.

Importing data from Recreativ

After enabling this data source, Recreativ advertising costs information for the previous day will be uploaded to Google BigQuery once every 24 hours.

Connecting and configuring

In order to connect a new data source, go to “DATA IMPORT → Automatic” (1), select the type of data source from menu (2) and enter the API token from the Recreativ personal account https://recreativ.com/advertiser/site/profile (3)

Configuring data source

This data source has only one setting - Title (1). Enter it to distinguish data sources of the same type in the list.

To save and enable the data source, click “Save” (2).

The “Disconnect” button (4) is used to revoke the authorization data. The settings are saved.

You can enable or disable the data source at any time (3).

Where to get data on advertising costs

The data for this data source will be written to a table named recreativCampaignStatistics_{ADVERTISER_ID}_{YYYYMMDD}

Table structure

Field name Type Mode
views INTEGER REQUIRED
clicks INTEGER REQUIRED
money FLOAT REQUIRED
is_retarget BOOLEAN REQUIRED