Article date

Snapchat template

In this guide, you'll find the JSON file for the Snapchat modeling templates and a step-by-step guide on how to implement it. Please check out the template 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 Snapchat integration:

Table name
Column name
 snap_ads
  •  id
  • name
  • ad_squad_id
ads_squads
  • id
  • name
  • campaign_id
campaigns
  • id
  • name
ads_stats_daily
  • id
  • start_time
  • conversion_purchases_value
  • conversion_purchases
  • impressions
  • spend
  • swipes
ad_accounts
  • id
  • name
  • currency

 

Data lineage

mceclip0.png

Step-by-step guide

  1. Create a new model.
  2. Name it stg_snapchat_ads.
  3. Import the JSON file stg_snapchat_ads.
  4. Replace the INPUT nodes with tables from your actual Snapchat integration.
  5. Commit the model.

Please find the template JSON file down below ⬇️

 

 

Articles in this section

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