Supermetrics for Power BI
Connect Google Campaign Manager 360 to Power BI — Ad Serving Intelligence Dashboards
Analyze CM360 campaign tracking data in Power BI with cross-channel delivery reconciliation, Floodlight conversion attribution, and reach/frequency analysis. DAX measures calculate deduplicated reach, placement-level efficiency, and creative rotation performance.
Why Connect Google Campaign Manager 360 to Power BI?
Build live CM360 dashboards in Power BI that update automatically and share with your team.
Cross-channel delivery reconciliation
Use CM360 as the source of truth for cross-channel impression delivery. Compare ad server counts against DSP-reported impressions to reconcile discrepancies and ensure accurate billing.
Floodlight conversion path analysis
Track Floodlight conversion activities with click-through and view-through attribution. DAX measures calculate conversion paths across multiple placements and sites.
Reach and frequency management
Analyze deduplicated reach and average frequency across campaigns. DAX measures identify when campaigns exceed optimal frequency thresholds, preventing audience fatigue and wasted spend.
How to Connect Google Campaign Manager 360 to Power BI
Three steps. Under two minutes. Zero code.
- 1
Open Power BI Desktop and Get Data
Launch Power BI Desktop, click "Get Data," and search for the Supermetrics connector to install it.
- 2
Authorize your data source
Sign in with your Supermetrics account and authorize your data source. Your credentials are encrypted and securely stored.
- 3
Build Your Dashboard
Select your metrics and dimensions, load the data into your model, and start building visuals, DAX measures, and interactive reports.
Dashboard Templates for Google Campaign Manager 360 in Power BI
Pre-built dashboards to get you started. Customize layouts, filters, and visualizations to match your reporting needs.
CM360 Delivery & Attribution Report
Campaign delivery summary with Floodlight conversion attribution by placement and site. Reach and frequency analysis with cross-channel delivery reconciliation.
Reach & Frequency Management
Deduplicated reach trending with frequency distribution. Campaign-level frequency caps monitoring with conditional formatting for threshold alerts.
Reporting Scenarios for Google Campaign Manager 360 in Power BI
Common reporting use cases that teams build with CM360 data in Power BI.
Placement Conversion Attribution Matrix
Matrix table showing Floodlight conversion counts per placement and site with conditional formatting highlighting top converters across the media plan.
Frequency Distribution by Campaign
Bar chart showing the distribution of impression frequency across the audience for each campaign, identifying over-exposed segments.
What Google Campaign Manager 360 Data Can You Pull into Power BI?
Supermetrics gives Power BI access to your full CM360 reporting data — metrics and dimensions you already know from the CM360 interface.
Key Metrics
- Impressions
- Clicks
- CTR
- Rich media video completions
- Rich media video views
- Total conversions
- Click-through conversions
- View-through conversions
- Reach
- Average frequency
- Active View viewable impressions
- Media cost
Key Dimensions
- Campaign
- Placement
- Site
- Ad
- Creative
- Creative type
- Advertiser
- Activity
- Floodlight configuration ID
- Placement size
View all Google Campaign Manager 360 fields, metrics, and dimensions →
Resources & Guides
Why Supermetrics for Power BI?
The trusted marketing data platform since 2009. 200,000+ companies use Supermetrics — 15% of global ad spend flows through our connectors.
Built for Power BI
Purpose-built Power BI connector with setup in minutes. Your marketing team can build dashboards independently — no data engineering resources required.
170+ Data Sources
Connect Google Campaign Manager 360 alongside 170+ other platforms through a single integration. All your marketing data in one place.
Template Gallery
Start with pre-built Power BI dashboard templates for Google Campaign Manager 360. Connect your account and have a polished, interactive report in minutes.
Enterprise Security
SOC 2 Type II certified. GDPR compliant. OAuth authentication. Your data is encrypted at rest and in transit.
Always Current
Your Google Campaign Manager 360 data refreshes automatically in Power BI. No manual exports, no stale numbers — open your report and the data is current.
No Data Limits
Query any date range, any number of campaigns, any level of granularity. No row limits, no sampling, no restrictions on the data you can pull.
Frequently Asked Questions
How do I connect Google Campaign Manager 360 to Power BI with Supermetrics?
Install the Supermetrics connector from the Power BI Desktop "Get Data" menu, sign in with your Supermetrics account, and authorize Google Campaign Manager 360. Your data appears as a Power Query table — from there you load it into your model, build relationships, and start creating visuals. No custom connector development needed.
Can I schedule automatic data refreshes for Google Campaign Manager 360 in Power BI?
Yes. Publish your report to the Power BI Service and configure a scheduled refresh through your dataset settings. Supermetrics refreshes your Google Campaign Manager 360 data on the schedule you set — hourly, daily, or whatever cadence fits your reporting rhythm. Your dashboards stay current without manual intervention.
Can I combine Google Campaign Manager 360 data with other sources inside Power BI?
Absolutely. Power BI's data model is built for blending. Use Supermetrics to pull Google Campaign Manager 360 alongside data from 170+ other marketing platforms — Google Ads, LinkedIn Ads, GA4, and more — then join them through shared dimensions like date, campaign name, or UTM parameters in Power Query or the data model.
What Google Campaign Manager 360 metrics and dimensions can I access in Power BI?
All standard Google Campaign Manager 360 reporting fields are available, including Impressions, Clicks, CTR, Rich media video completions, Rich media video views, and more. You get the same data as the Google Campaign Manager 360 native reporting UI, loaded into Power BI where you can create DAX measures, build relationships, and apply row-level security.
Do I need technical skills to use Google Campaign Manager 360 data in Power BI?
Basic Power BI Desktop knowledge is enough. Supermetrics handles the API connection, authentication, and data formatting. You pick your metrics, choose a date range, and load — the data arrives as clean tables ready for modeling. No API code, no ETL scripting.
How do I reconcile CM360 delivery with DSP data in Power BI?
Pull CM360 impression data alongside DV360 or TTD data. Join in Power Query on campaign and date. Build discrepancy reports comparing served impressions between ad server and DSP for billing accuracy.
Can I track Floodlight conversions across placements in Power BI?
Yes. Pull Floodlight activity data with placement and site dimensions. Build attribution matrices showing which placements contribute most to each conversion activity type.
Also Connect to Power BI
Ready to Connect Google Campaign Manager 360 to Power BI?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.