campaign_spend contains daily spend and performance metrics for all paid marketing campaigns across connected advertising platforms (e.g., Google Ads, LinkedIn Ads). It provides campaign-level insights by date, including spend, impressions, and clicks, with all spend amounts standardized to the organization's reporting currency. The table enables analysis of campaign performance, budget utilization, and marketing ROI over time.
Table | campaign_spend |
Description | Contains the spend data for all paid campaigns broken down by date. |
Granularity
(Composite key that uniquely identifies a row) | source_system, source_campaign_id, date |
Column Details:
Column Name | Description | Data Type |
campaign_id | RevSure internal Id for the campaign | STRING |
source_system | Source system for the campaign. E.g: GOOGLEADS/LINKEDIN etc. | STRING |
source_campaign_id | Campaign Id as found in the source system | STRING |
campaign_name | Campaign Name as found in the source system | STRING |
campaign_objective | Campaign Objective as found in the source system | STRING |
date | Date for which the Spend data corresponds to | DATE |
spend | Amount spent on corresponding date and campaign. Standardized to the reporting currency in RevSure (USD) | NUMERIC |
impressions | Number of Campaign Impressions for the date | NUMERIC |
clicks | Number of Campaign Clicks for the date | NUMERIC |
created_at | Time at which the record was created in UTC | TIMESTAMP |
updated_at | Time at which the record was last updated UTC | TIMESTAMP |