Extract Bing Ads data to Snowflake

ahoy

NOV 29, 2021

Content

The Bing Ads Kit retrieves different levels of data from multiple reports within the source API to provide a full data model for tracking paid Bing ad and campaign performances and insight analyses.

This Kit can be used in combination with the Modular Marketing Logic Kit to create a full spectrum marketing analysis table. Find out how to do this using the directions in the Modular Marketing Logic Kit preview.

This Kit includes…

Data ingestion from the following LinkedIn entities:
- Campaign Performance
- User Location Performance
- Ad Performance
- Keyword Performance
- Budget Summary
  - In order for this report to successfully run, you need to select at least one Account in the Account source-level filter within the “Bing Ads – Predefined Reports” river.
Logic that orchestrates and transforms raw Bing Ads data to create a data model with related paid entities

Configuring this Kit for use

Variables

In this Kit, there are three variables that are used to make for dynamic use of target configuration.

{Database_Bing} is used in all Target configurations and queries as the target database name.
{Schema_Bing} is used in all Target configurations and queries as the target schema name.
{Bing_Alert_Group} is used as the alert email address(es) for when a river fails (optional).

Go to the Variables menu on the left side navigation bar and create variables for Database_Bing, Schema_Bing, and Bing_Alert_Group. Then fill in the values as the Snowflake database and schema where you would like the data to land and the email address(es) to which you would like the failure emails sent.