Overview
Weld's ready-to-use SQL core metrics create unified tables instantly in your Weld App when you set up your connectors. This helps you unlock valuable insights from your data, accelerating your journey to data-driven decision making. Simply choose your core metric use case, connect your data sources and Weld will auto create your SQL tables in your workspace.
Data Preparation and Aggregation Process:
Staging Models
The staging model serves as an intermediate step where data from raw tables is cleaned, transformed into a format that is ready for data modeling.. The staging models join in the necessary tables, to build daily aggreated tables based on metrics specfic to the connector.
Core Models
The core models are created by joining the data from the individual staging models per connector into one unified table. For example the ad_report staging models from google_ads, facebook_ads and tiktok_ads are all joined in one table called core.ad_report
Supported Use cases:
- Marketing Metrics Ecommerce Metrics Finance Metrics
Marketing Metrics
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.
- ad_group_report
- ad_report
- ad_account
- campagin_report