Learn how to blend data from Google Ads, Meta Ads, LinkedIn Ads, and other platforms into unified tables and insights for your slide presentations.
Campaign Name
, Clicks
, Impressions
, Cost
Workflow Structure:
cross_platform_table
cross_platform_table
Data Source
, Campaign Name
, Clicks
, Conversions
, Cost
cost
(text) - “the sum of spend/costs fields”clicks
(text) - “the sum of clicks fields”impressions
(text) - “the sum of impressions fields”conversions
(text) - “the sum of conversions fields”ctr
(text) - “(the sum of clicks fields) divided by (the sum of impressions fields). Add % sign to the number”platform_summary_table
Cost | Clicks | Impressions | Conversions | CTR |
---|---|---|---|---|
$4.3K | 2.15K | 83K | 77 | 2.6% |
Method | Best For | Result |
---|---|---|
Method 1: Simple Merge | Campaign-level analysis | One table with all campaigns from both platforms |
Method 2: Rename + Merge | When platforms use different field names | Standardized table with consistent column names |
Method 3: AI Aggregation | Executive summaries and totals | Single row with combined performance across all platforms |
Merge not working - getting inconsistent columns
AI aggregation returning wrong calculations
Slides not updating with merged data
Different platforms have different metrics