Bring data from two or more sources together (different accounts, different businesses, or different platforms entirely) into a single report. Power My Analytics gives you two ways to do it: a reusable blended dataset built in Data Builder, or Looker Studio's native Blend Data feature. This article walks through both and helps you pick the one that fits your reporting workflow.

When you might want to blend data

A few common scenarios where blending is the right move:

• Multiple businesses or clients in one report: showing combined performance for two or more brands (for example, a parent company and a sister company) in a single dashboard.
• Multiple accounts on the same platform: rolling up several Google Ads accounts, several Facebook Pages, or several Shopify stores into one view.
• Cross-platform reporting: comparing Google Ads, Microsoft Ads, and Facebook Ads side-by-side; or pairing ad spend with e-commerce sales for true ROAS.

Prerequisites

Before you blend, make sure you have the following in place:

• A Power My Analytics account on the Business, Pro, or Custom plan. Data Builder is available on all paid plans; blending in Looker Studio works with any plan that allows Looker Studio reports.
• Each platform you want to include is already connected as a data source in your hub (Sources > + Add new source). If you're adding a new business or platform, connect it first the same way you connected your original source.
• All relevant accounts are enabled for sync inside each data source (Action > Manage accounts).
• A destination in mind. This article assumes Looker Studio, but the Data Builder method also works for Google Sheets, Microsoft Excel, BigQuery, or any other supported destination.

Choose your blending method

You have two solid options. Here's how to decide:

Most customers are better served by a Data Builder blend: it keeps the prep work in one place, makes the blended dataset reusable across reports, and works with destinations beyond Looker Studio. If you're unsure, start there.

Method 1: Blend with Data Builder (recommended)

Data Builder lets you create a single blended data table that combines accounts from one or more sources. Once it's built, you can drop it into any report that uses the Power My Analytics connector.

1. Open Data Builder. In your hub, click Data Builder in the main navigation (just below Sources).
2. Create a dataset. Click + Create Dataset, give it a clear name (for example, "Brand A + Brand B Combined" or "All Paid Channels"), and choose an available data range. The range you pick here sets the maximum window for tables inside the dataset; you can override it per table later.
3. Add a blended data table. Inside your new dataset, click Create Data Table, then choose Blended as the table type.
4. Select the accounts you want to combine. You can pick accounts from the same connector (for example, two Google Ads accounts) or from different connectors (for example, one Google Ads account, one Microsoft Ads account, and one Facebook Ads account). Each account stays separately identified inside the blend so you can break out performance later.
5. Choose your fields. Pick the metrics and dimensions you want in the table. Use the search bar to find specific fields, toggle between Dimensions and Metrics, and drag fields to set the column order. Common dimensions for cross-account blends include date, account name, campaign, and platform.
6. Configure options. Name the data table, set sorting, apply any filters (for example, to exclude paused campaigns or limit to a specific country), and adjust the row limit if needed (the default is 1,000,000 rows).
7. Send it to your destination. Open your Looker Studio report (or create a new one), add a new data source, choose the Power My Analytics connector, and select the blended data table you just built. The combined data will appear as a single source with all the fields you picked.

Tip: If you plan to filter by business or platform in your report, include the account name (or a custom label dimension) as a field in the blend. That makes it easy to slice the combined view back into individual brands or platforms when you need to.

Method 2: Blend inside Looker Studio

If your blend is specific to one report and you don't need the combined dataset anywhere else, you can use Looker Studio's built-in Blend Data feature with each Power My Analytics source connected separately.

1. Add each source to your report. In Looker Studio, click Add data and use the Power My Analytics connector to add each platform or account as its own data source.
2. Open the chart you want to blend. Insert or select the chart that will display the combined data.
3. Blend the data. In the chart's Data panel, click Blend data (or right-click the chart and choose Blend data).
4. Configure your join. Pick the join key that ties the sources together (most often Date, sometimes Date + Campaign or Date + Country), choose the join type (Looker Studio supports left outer, inner, full outer, and others), and add the metrics and dimensions you want from each source.
5. Save and reuse. The blended source becomes available for other charts in the same report.

Looker Studio blends are powerful for ad-hoc work, but they live inside a single report and can be harder to maintain across many dashboards. If you find yourself rebuilding the same blend in multiple reports, that's a sign to move it into Data Builder.

Verify your blend

To confirm the blend is working as expected:

• Spot-check totals against each individual source. For example, sum total spend in the blended table for a given week and compare it to the spend you see for that week inside each contributing data source's account.
• Make sure every account you expected is represented. If you filter the blend by account name (or platform), every contributing account should show data for the period.
• Check date coverage. New connections may still be backfilling; if a brand-new source is included, allow time for the initial backfill to complete before drawing conclusions from the blend.

Related articles

• Data Builder Guide
• Sources Guide
• Manage and Configure Data Sources
  
• Power My Analytics Data Connector User Guide

Still have questions about blending data? Submit a ticket and our support team will help you map out the best approach for your reports.