Snapchat Ads
Snapchat Ads is the advertising platform offered by Snapchat, a popular multimedia messaging app known for its disappearing photo and video messages. It allows businesses and advertisers to create and manage ad campaigns to reach Snapchat's extensive user base, which primarily consists of a younger demographic.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Column level |
| Blocking | True | Column level |
| Incremental | True | Only on reports. |
| Custom data | False | |
| History | False | |
| ReSync | True | Table level |
| Templates | True |
Data Schema
Setup Guide
Step 1 - Create the connection
- In Weld, click Data Sources in the sidebar, then Add Data Source, and choose Snapchat Ads. If the account is already connected, choose Use existing connection and go to Step 2.
- Check the connection Name (1). It's filled in for you, and you can change it.
- Click Authorize (3) and sign in to Snapchat. Approve Weld's access, and you're taken back to the setup.
If someone else owns the Snapchat account, for example a client, click Share Authorization Link (2) instead and send them the link. They sign in and grant access without a Weld login. See Authorization links.
Step 2 - Connection Settings
On Connection Settings, choose:
- Organizations: the Snapchat organizations to sync.
Click Next.
Step 3 - Data to sync
Tick the tables you want. Each table shows whether it syncs in full or incrementally, and you can expand it to remove or hash columns. See Tables below for what each kind holds.
Step 4 - Configure sync
Choose how often to sync, check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.
Query your data
When the first sync finishes, the tables are in your warehouse under the destination schema. In Transform, find them under Data Sources in the sidebar, then write a model on top of them or ask Ed to write one. See Data models.
Tables
Account and billing:
organization,ad_account,memberbilling_center,funding_source,invoice
Ads. How your campaigns are set up. Ad squads are Snapchat's ad sets:
campaign,ad_squad,adcreative,media,pixel,segment
Reports. Daily performance metrics at three levels, each with breakdowns by demographic, device and location:
campaign_daily_report,ad_squad_daily_report,ad_daily_reportcampaign_demographic_daily_report,campaign_device_daily_report,campaign_geo_daily_report, and the same forad_squad_*andad_*- By hour:
campaign_hourly_report