Marketing Core Metrics
Have a single view of across all your ad platforms, providing a broader and more detailed perspective on your marketing performance
Weld marketing core metrics 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 consolidated view of your ad campaign, account, ad_group and ad performance, you can easily see which of your ads are doing well on different platforms and optimize where to spend your ad budget.
Supported connectors
IMPORTANT: To maximize the effectiveness of the marketing core metrics, we suggest connecting at least two connectors from any of the supported connectors listed below
The marketing core metrics supports the following connectors:
LinkedIn Ads
Google Ads
Facebook Ads
Microsoft Ads
Pinterest Ads
Tiktok Ads
Snapchat Ads
π§ Setup Guide
Step 1 - Set Up Connectors
- Choose the connector you would like to set up
- Click Authorize to allow Weld to access your Ads account using OAuth
- Weld will pre-select the required tables for the core metrics. You can add in additional tables if needed.
- Click how often you would like the data to sync.
Step 2 (Optional) - Choose Metrics and Dimensions
- You have the option to create additional models based on specific dimension and metrics from the pre-made core models
Step 3 - View and interact with your core models
- When the initial sync has completed the core metrics will be available in your workspace for you to view and explore.
Staging Models
The staging model serves as an intermediate step where data from raw tables is cleaned, transformed, and prepared for analytical queries or for loading into a more structured data warehouse schema. The marketing staging models join in the necessary tables, to build daily aggreated tables based on metrics specfic to the connector.
Core Models
Core model in Weld are designed to integrate and standardize data from multiple advertising platforms into a unified format. The core models are essential for creating a consistent and consolidated view of advertising data, making it easier to perform cross-platform analysis and reporting. It represents a key component in transforming diverse raw data into a structured, analysis-ready format in a data warehouse.
π account_report
This SQL model creates a unified table that consolidates advertising data from your social media platforms. It compiles daily metrics for each platform on an account level. You can identify the account by ID or name. This table is instrumental for marketers and analysts in comparing and analyzing advertising performance metrics across diverse social media channels, enabling informed decisions on advertising strategies and budget allocation.
𧱠Depends On
linkedin_ads_account_report
facebook_ads_account_report
google_ads_account_report
tiktok_ads_account_report
microsoft_ads_account_report
snapchat_ads_account_report
pinterest_ads_account_report
π core.account_report Schema
| # | Column | Type | Description |
|---|---|---|---|
| 1 | account_name | Dimension | The name of the account. |
| 2 | date_day | Dimension | The day of the ad performance, aggregated daily. |
| 3 | platform | Dimension | The ad platform source of the data. |
| 4 | spend | Metric (Sum) | The total amount spent on the ad. |
| 5 | impressions | Metric (Sum) | The number of times the ad was displayed. |
| 6 | clicks | Metric (Sum) | The number of times the ad was clicked. |
| 7 | cpc | Metric (Average) | The average cost per click. |
| 8 | ctr | Metric (Average) | The average click-through rate. |
| 9 | cpm | Metric (Average) | The cost for every thousand impressions. |
π ad_group_report
This SQL model creates a unified table that consolidates advertising data from your social media platforms. It compiles daily metrics for each platform on an account level. You can identify the ad_group by ID or name. This table is instrumental for marketers and analysts in comparing and analyzing advertising performance metrics across diverse social media channels, enabling informed decisions on advertising strategies and budget allocation.
𧱠Depends On
linkedin_ads_ad_group_report
facebook_ads_ad_group_report
google_ads_ad_group_report
tiktok_ads_ad_group_report
microsoft_ads_ad_group_report
snapchat_ads_ad_group_report
pinterest_ads_ad_group_report
π core.ad_group_report Schema
| # | Column | Type | Description |
|---|---|---|---|
| 1 | ad_group_name | Dimension | The name of the group. |
| 2 | account_name | Dimension | The name of the account. |
| 3 | campaign_name | Dimension | The name of the campaign. |
| 4 | date_day | Dimension | The day of the ad performance, aggregated daily. |
| 5 | platform | Dimension | The ad platform source of the data. |
| 6 | spend | Metric (Sum) | The total amount spent on the ad. |
| 7 | impressions | Metric (Sum) | The number of times the ad was displayed. |
| 8 | clicks | Metric (Sum) | The number of times the ad was clicked. |
| 9 | cpc | Metric (Average) | The average cost per click. |
| 10 | ctr | Metric (Average) | The average click-through rate. |
| 11 | cpm | Metric (Average) | The cost for every thousand impressions. |
π ad_report
This SQL model creates a unified table that consolidates advertising data from your social media platforms. It compiles daily metrics for each platform on an account level. You can identify the ad by ID or name. This table is instrumental for marketers and analysts in comparing and analyzing advertising performance metrics across diverse social media channels, enabling informed decisions on advertising strategies and budget allocation.
𧱠Depends On
linkedin_ads_ad_report
facebook_ads_ad_report
google_ads_ad_report
tiktok_ads_ad_report
microsoft_ads_ad_report
snapchat_ads_ad_report
pinterest_ads_ad_report
π core.ad_report Schema
| # | Column | Type | Description |
|---|---|---|---|
| 1 | ad_name | Dimension | The name of the advertisement. |
| 2 | account_name | Dimension | The name of the account. |
| 3 | campaign_name | Dimension | The name of the campaign. |
| 4 | date_day | Dimension | The day of the ad performance, aggregated daily. |
| 5 | platform | Dimension | The ad platform source of the data. |
| 6 | spend | Metric (Sum) | The total amount spent on the ad. |
| 7 | impressions | Metric (Sum) | The number of times the ad was displayed. |
| 8 | clicks | Metric (Sum) | The number of times the ad was clicked. |
| 9 | cpc | Metric (Average) | The average cost per click. |
| 10 | ctr | Metric (Average) | The average click-through rate. |
| 11 | cpm | Metric (Average) | The cost for every thousand impressions. |
π campaign_report
This SQL model creates a unified table that consolidates advertising data from your social media platforms. It compiles daily metrics for each platform on an account level. You can identify the campaign by ID or name. This table is instrumental for marketers and analysts in comparing and analyzing advertising performance metrics across diverse social media channels, enabling informed decisions on advertising strategies and budget allocation.
𧱠Depends On
linkedin_ads_campaign_report
facebook_ads_campaign_report
google_ads_campaign_report
tiktok_ads_campaign_report
microsoft_ads_campaign_report
snapchat_ads_campaign_report
pinterest_ads_campaign_report
π core.campaign_report Schema
| # | Column | Type | Description |
|---|---|---|---|
| 1 | account_name | Dimension | The name of the account. |
| 2 | campaign_name | Dimension | The name of the campaign. |
| 3 | date_day | Dimension | The day of the ad performance, aggregated daily. |
| 4 | platform | Dimension | The ad platform source of the data. |
| 5 | spend | Metric (Sum) | The total amount spent on the ad. |
| 6 | impressions | Metric (Sum) | The number of times the ad was displayed. |
| 7 | clicks | Metric (Sum) | The number of times the ad was clicked. |
| 8 | cpc | Metric (Average) | The average cost per click. |
| 9 | ctr | Metric (Average) | The average click-through rate. |
| 10 | cpm | Metric (Average) | The cost for every thousand impressions. |