Snapchat Ads SQL templates

1 ready-to-run SQL model for Snapchat Ads data in your own warehouse. Each one runs as-is against your synced tables, in Weld SQL or dbt.

Ad Report
Generates an ad report by integrating with Snapchat Ads. It retrieves data from various tables such as ad_daily_report, campaign, ad_account, and ad. The report includes information such as date, account ID and name, campaign ID and name, ad ID and name, currency, spend, impressions, clicks, CPC, CTR, CPM, and conversions. The data is filtered based on the date and grouped by different columns.
Intermediate

Or browse templates for every connector.