Circle Separator4 mins read

How Do You Connect AdsWizz to Looker Studio?

The fastest AdsWizz to Looker Studio connection is a third-party community connector, such as Catchr, which pulls AdsWizz reporting data into a Looker Studio data source. Google's native connector catalogue includes Google Ads, Google Ad Manager, BigQuery, Google Sheets and CSV uploads, but it does not list AdsWizz as a built-in connector.

For full technical control, use the AdsWizz Domain API, load the results into BigQuery or Google Sheets, and connect that destination to Looker Studio.

You have 4 practical connection routes:

AdsWizz to Looker Studio Connection Options

MethodBest forRefreshMain limitation
Third-party AdsWizz connectorFast, no-code dashboardsAutomatic, depending on providerProvider fees and field availability
AdsWizz API to BigQueryScalable reporting and multiple clientsAutomated with your own workflowRequires development and data modelling
AdsWizz API to Google SheetsSmall reporting workflowsAutomated with scripting or an integration toolSheets has performance and row-size limitations
CSV uploadOne-off reportsManualNo automatic updates

Option 1: Use a Third-Party AdsWizz Connector

A community connector is the simplest choice when you want an AdsWizz dashboard without building an API pipeline. Catchr's AdsWizz connector supports exporting campaign data to Looker Studio and lets you select AdsWizz accounts, dimensions and metrics before sending the data to a reporting destination.

Step-by-Step Setup

  1. Create an account with the connector provider.
  2. Connect your AdsWizz account.
  3. Select the AdsWizz account or accounts you want to report on.
  4. Choose the required dimensions and metrics.
  5. Send the data to Looker Studio through the provider's destination or connector workflow.
  6. Create or select a Looker Studio report.
  7. Check field types and aggregations before building charts.

AdsWizz reporting can include several environments, including AudioServe, AudioMax and AudioMatic. Confirm that the connector is using the correct AdsWizz environment before comparing metrics across reports.

A basic AdsWizz performance dashboard usually needs the following fields.

Dimensions

  • Campaign name
  • Advertiser name
  • Ad name
  • Reporting date
  • Country
  • Device type
  • Publisher
  • Ad format

Metrics

  • Impressions
  • Audio impressions
  • Clicks
  • CTR
  • Conversions
  • Conversion rate
  • Revenue
  • Cost
  • Reach

Start with one reporting grain, such as Campaign plus Date. Add geographic or device dimensions only when the report needs them. More dimensions create more rows and can change how totals are calculated.

Option 2: Connect AdsWizz Through the API

The API route is the better choice when you need custom authentication, central data storage, historical reporting or dashboards across several AdsWizz accounts.

The AdsWizz Domain API uses an API key and supports custom reports built from selected dimensions, metrics, filters and reporting intervals. AdsWizz requires an API key for access, and API requests use an agency identifier and environment where applicable.

AdsWizz
   ↓
AdsWizz Domain API
   ↓
BigQuery or Google Sheets
   ↓
Looker Studio

API Setup Process

  1. Request an AdsWizz API key from AdsWizz support or your AdsWizz administrator.
  2. Confirm the agency identifier and AdsWizz environment you need to query.
  3. Choose the reporting dimensions and metrics.
  4. Create a scheduled extraction script that requests the required reporting interval.
  5. Store the response in BigQuery or Google Sheets.
  6. Connect BigQuery or Google Sheets to Looker Studio.
  7. Set data freshness, credentials and access controls in the Looker Studio data source.

Google provides native connectors for both BigQuery and Google Sheets. Looker Studio also supports reusable data sources, calculated fields, data credentials and data freshness settings.

When BigQuery Is the Better Destination

Use BigQuery instead of Google Sheets when you need:

  • Multiple AdsWizz accounts
  • Large historical datasets
  • Scheduled transformations
  • Cross-channel reporting
  • Joins with CRM, ecommerce or analytics data
  • More control over user access
  • Better dashboard performance at scale

Google Sheets is suitable for a smaller workflow where the extracted AdsWizz dataset is compact and the reporting logic is simple.

Option 3: Upload AdsWizz CSV Files Manually

For a one-off report, export a CSV from AdsWizz and use the Upload CSV files connector in Looker Studio.

This approach is simple but does not suit recurring client reporting. Google states that uploaded CSV data sources cannot update automatically, so you must import a new file whenever the underlying AdsWizz data changes.

Use manual CSV uploads when:

  • You need a single historical analysis
  • The report will not be refreshed regularly
  • You are testing the required fields
  • You do not yet have API or connector access

Which Connection Method Should You Choose?

The right method depends on whether you value setup speed or control over the reporting pipeline.

Choose a third-party connector when you need a working dashboard quickly and its available fields meet your reporting requirements.

Choose AdsWizz API to BigQuery when the report is business-critical, needs historical storage, combines multiple platforms or will be used by several clients.

Choose AdsWizz API to Google Sheets when the workflow is small and your team already manages reporting in spreadsheets.

Choose CSV upload for temporary or one-time reporting.

Important Data Modelling Checks

Keep One Consistent Reporting Grain

A report grouped by Campaign plus Date produces different totals from a report grouped by Campaign, Date, Country and Device Type. The extra dimensions split campaign performance into smaller rows.

Define the grain before creating calculated fields. For example:

One row = one campaign, one reporting date, one country

This reduces the risk of double counting when you blend the data with another source.

Check Metric Aggregation

Use:

  • SUM for impressions, clicks, conversions and revenue
  • AVERAGE or calculated ratios for some rate-based metrics
  • A calculated CTR rather than summing row-level CTR values

A common CTR calculation is:

SUM(Clicks) / SUM(Impressions)

Format the result as a percentage in Looker Studio.

Separate Delivery and Metadata Tables

AdsWizz campaign metadata and delivery performance are different types of data. Campaign names, advertiser names and campaign statuses describe entities. Impressions, clicks and conversions describe performance.

Keep these relationships clear when joining or blending data:

Advertiser -> Campaign -> Ad -> Performance

Joining two performance tables at different grains can multiply rows and inflate totals.

Troubleshooting AdsWizz Connections

AdsWizz Does Not Appear in the Connector List

AdsWizz is not listed among Google's built-in connectors. Search the Looker Studio Connector Gallery for a third-party AdsWizz connector, or use the API route through BigQuery or Google Sheets.

The Connector Asks for an API Key

This is expected for an API-based AdsWizz connection. AdsWizz requires an authentication key, and the key must have access to the relevant agency or reporting environment.

The Report Shows No Data

Check the following:

  • The AdsWizz account is connected
  • The agency identifier is correct
  • The reporting interval contains data
  • The correct environment is selected
  • The API key has reporting permissions
  • The selected dimensions and metrics are compatible
  • The Looker Studio data source fields have been refreshed

Community Connectors Are Blocked

A Google Workspace administrator can restrict third-party connectors. Apps Script must also be enabled for community connectors to fetch data in Looker Studio. If a connector is unavailable or charts return an Apps Script error, contact the Google Workspace administrator.

Final Recommendation

For most teams, start with a third-party AdsWizz connector if its fields and refresh options cover the dashboard requirements.

Use AdsWizz API to BigQuery to Looker Studio when you need long-term historical reporting, multiple accounts, cross-channel joins or tighter access controls. Keep the Google Sheets route for smaller workflows, and use CSV uploads for one-time analysis.

Next Read