Home
Kits marketplace
Marketing Analytics B2C – BigQuery

Marketing Analytics B2C – BigQuery

Last published

2021-04-16

By Rivery

This kit includes

Data ingestion from the following Facebook Ads entities:

– Data ingestion rivers for ad statistics and entities for Facebook Ads, Twitter Ads, and Snapchat Ads

– Logic that creates a Marketing data model across the three platforms

– Master orchestration river

Minimum RPU Consumption: 17

For more information on the schema, data model, and output fields in this kit, see here.

Configuring this kit for use

Variables

In this kit, there are two variables that are used to make for dynamic use of target configuration. {dataset_b2c_bq} is used in all Target configurations and queries as the target dataset name.Go to the Variables menu on the left side navigation bar and create variables for db_marketing_b2c and schema_marketing_b2c. Then fill in the values as the Google Big Query database and schema where you would like the data to land.

Connections

Kits are imported with ‘blank’ source and target connections. In order to use the kit, you have two options:Swap out blank connections with existing connectionsAdd credentials to the blank connections that come with the imported template

Have questions about this kit?

Set up a meeting with a Rivery solutions engineer.

Use Kit

Discover more kits

Marketing Analytics B2C – Snowflake

The Marketing Analytics B2C kit combines Ad Performance data from Facebook Ads, Twitter Ads, and Snapchat…