In this guide, you'll find the JSON file for the Bing Ads modeling template and a step-by-step guide on how to implement it. Please check out the templates introduction guide to learn how to add a data modeling template in Y42.

Prerequisites

In order to use this template, please make sure that you have selected these tables and columns inside your Bing Ads integration:

 Table name  Column name
ad_performance_report
  • AccountId
  • AccountName
  • AdGroupName
  • AdGroupId
  • AdId
  • AdTitle
  • AdType
  • CampaignId
  • CampaignName
  • Clicks
  • CurrencyCode
  • Impressions
  • Revenue
  • Spend
  • TimePeriod

 

Data lineage

Bildschirmfoto_2022-04-22_um_10.57.33.png

 

Step-by-step guide

  1. Create a new model.
  2. Name it stg_bing_ads.
  3. Import the JSON file stg_bing_ads.
  4. Replace the INPUT node with your actual Bing Ads ad_performance_report table
  5. Commit the model.

Please find the template JSON file down below ⬇️

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.