Ad Reporting SQL Model
Have a single view of across all your ad platforms, providing a broader and more detailed perspective on your marketing performance
Overview
Weld ad reporting data model aggregates data from our most popular advertising connectors. The model creates a unified table in your destination that shows your ad spend, clicks, impressions, conversions for each advertising platform. With this unified view of your ad campaign performance, you can compare how well your campaigns perform on each platform and optimize your ad spend.
Supported connectors
IMPORTANT: For the best performance when using the ad reporting data model, we recommend that you have at least two connectors of any of the supported types in the following list.
The ad reporting data model supports the following connectors:
Facebook Ads Google Ads LinkedIn Ads Microsoft Ads Pinterest Ads Snapchat Ads TikTok Ads
🔧 Schema
| # | Column | Type | Description |
|---|---|---|---|
| 1 | Day | Dimension | The day of the ad performance, aggregated daily. |
| 2 | Platform | Dimension | The ad platform source of the data |
| 3 | Ad Name | Dimension | The name of the advertisement. |
| 4 | Spend | Metric | The total amount of money spent on the ads. |
| 5 | Impressions | Metric | The total number of times the ads were displayed. |
| 6 | Clicks | Metric | The total number of times the ads were clicked. |
| 7 | Cost-Per-Click (CPC) | Metric | The average cost for each click. |
| 8 | Click-Through Rate (CTR) | Metric | The percentage of impressions that led to a click. |
| 9 | Cost-Per-Thousand Impressions (CPM) | Metric | The cost for every thousand impressions. |
| 10 | Conversions | Metric | The total number of conversions generated by the ads. |