In this guide, we will guide you through the steps to connect your TV / Radio data to Billy Grace. See the results of your TV and Radio campaigns in Billy Grace.
The import will grant you:
Insight into metrics such as (Blended) ROAS;
Model the effect of impressions / GRP's on other channels in the Unified Marketing Measurement attribution model;
An example of media data can be TV advertising, radio advertising or Digital Out of Home (DOOH). Learn more about the modeling of TV / Radio results here.
Importing media data is not available in all pricing plans. Please contact your Customer Success Manager for more information.
Import Method
There are two main ways of sending us custom media data:
SFTP: you can share a daily .csv or parquet file with the orders.
BigQuery: you can share access to a BigQuery table, from which we will import the data.
It is essential that the data you share has the correct schema, so that we will be able to import it correctly. If you share data with an incorrect schema with us, we will not be able to ingest it into your dashboard.
Schema
The schema of the data we expect is listed below:
Field Name | Data Type | Description | Required |
source | String | Name of the channel you are connecting | Yes |
date | String | Date in format YYYY-MM-DD. | Yes |
impressions | bigint | Impressions or GRP's | Yes |
spend* | float | Spend | Yes |
campaign_name | String | String containing the campaign name | Yes |
adset_name | string | String containing the adset name | No |
ad_name | string | String containing the ad name | No |
campaign_id | string/int | The ID of the campaign (add random if no ID is available) | Yes |
adset_id | string/int | The ID of the adset | No |
ad_id | string/int | The ID of the ad | No |
*Should be separated by a point and not contain a currency symbol
Schedule the import
It is important that the media data is available for ingestion at the correct time. Data should reach us before 02:00 AM CET (containing the statistics of the day before).
For example: a file containing media data for the 29th of July needs to reach us before 02:00 AM on the 30th of July. If the data is not available at that time, there might be up to a week lag before you see correct attribution for this channel.
Furthermore, the CSV file must contain all the data you want to have in Billy Grace. If any data is no longer included in the CSV, it will not be part of the sync and will no longer be visible in Billy Grace.
Example of Radio CSV import:
The CSV template is attached to this knowledge article. You can find it at the end of the article.
Considerations
Example of table results when sharing radio data with Billy Grace.
The fields campaign, adset_id and ad_id are used as subsections in data tables in Billy Grace. They can also be used for other items. I.e. if you are sharing radio data, you fill them with other data that indicates the hierarchy in your advertising. (see example below)
source = radio
campaign_name = 538
This will show in Billy Grace like this:
Each channel should have only one import setup. It is not possible to create a new import for the same channel every month. If multiple imports are created for the same channel, we cannot identify that they belong to the same source. However, this is unnecessary because:
SFTP: You can simply place multiple files in the designated folder.
BigQuery: New data can be appended as new rows in the existing table.
It is not possible to include multiple channels within a single import (see the explanation above).
Campaign_id and campaign_name need to be filled. If you leave adset_id and ad_id fields empty, we will assign them with the values of the higher hierarchy.
If you are sharing TV or radio data, please input GRPs (Rough impressions for TV) or similar into the impressions' column.
We need at least 20 days of data (since pixel installation) before we can add it to the UMM model.
Unified Marketing Measurement trains its models once a week on Thursday night. After uploading TV or Radio data, UMM results will only be available after the training moment on Thursday night.
We expect ad_id to be unique and not shared among campaigns.
UTM For your import
As you can't click on TV / Radio or DOOH, no UTMs are needed.
Import in Billy Grace
If you are finished with setting up the import, the data will be available in reports after 24 hours. Please take into consideration that the models behind UMM train once a week on Thursday, so when you add radio / tv data on Tuesday, UMM results will be available on Friday.
Unified Marketing measurement requires at least 20 days of data. Any upload with less than 20 days of data will not have significant UMM effects.
You can see the newly imported Channels and its results in the Paid Performance report.
How to connect via SFTP?
Navigate to Settings -> Import Custom Data
. Here, you'll find personalized credentials, including a host, username, and password.
You're required to establish a daily file dump on your own, ensuring that a CSV or Parquet file, following the previously mentioned schema, is sent to us daily at the designated time.
Once set up, please create an export on the same page where you obtained your credentials by completing the form that appears when you click on 'Add Custom Import'.
How to connect via BigQuery?
First, upload the schema with the correct information into a BigQuery table.
Follow these steps to share the specific table with schema from earlier in this article.
Granting Permissions via IAM:
Go to the IAM & Admin section in their Google Cloud Console.
Click "Add" at the top of the IAM page.
Enter service account email (data-retriever@billy-grace.iam.gserviceaccount.com)
Assign appropriate roles that your service account needs to access the required resources (e.g., Viewer, Storage Object Viewer, etc.).
Click "Save".
Granting Permissions on Specific Resources:
If the service account needs access to specific resources, please grant permissions at the resource level (e.g., on a particular Cloud Storage bucket or BigQuery dataset).
For example, to grant access to a Cloud Storage bucket:
Go to the Cloud Storage section in the Google Cloud Console.
Select the bucket.
Click on "Permissions".
Click "Add" and enter your service account email (data-retriever@billy-grace.iam.gserviceaccount.com).
Assign the necessary roles (e.g., Storage Object Viewer).
Click "Save".
After completing this step, please navigate to Settings -> Import Custom Data and complete the form to activate your export.