Export Amazon DSP to BigQuery

Setup guide

How to Connect Amazon DSP to BigQuery

Connect your Amazon DSP account, set up BigQuery, and run your first report.

Connect Amazon DSP to Adzviser

Authorize your Amazon account in Adzviser and select the DSP advertiser you want to report on.

Set up BigQuery

Create a BigQuery pipeline in Adzviser. Connect your Google Cloud project with a service account and select a dataset prefix. BigQuery setup guide →

Run your first report

Select Total cost, Impressions, Clicks and a date range. Export the data to BigQuery for your reporting workflow.

Why this connection

Why Export Amazon DSP to BigQuery?

Keep Amazon DSP reporting data in your own BigQuery project for custom analysis and downstream reporting.

What you can do

Choose which data to export

Export line-item spend, impressions, and video performance, with the account and reporting detail your downstream tools need.

Query data in your own project

Use SQL to analyze the exported tables alongside the data already in your Google Cloud project.

Build cross-channel reports

Combine Amazon DSP exports with your other advertising or sales data in your reporting system.

AUTOMATED EXPORTS

Export Amazon DSP data to BigQuery tables

Export reporting data into BigQuery tables for SQL analysis and dashboards. Join it with your sales or CRM data in your own Google Cloud project.

Choose the columns to export

Export Total cost, Impressions, Clicks, eCPM by Advertiser ID, Line item ID, Line item name. Use daily granularity for time-series analysis.

Query data from multiple sources

Join reporting tables to your product or campaign lookups using stable IDs, then query the combined data in SQL.

Keep the table current

Run a backfill and set a schedule. Matching reporting dates are replaced on subsequent exports, so use separate dataset prefixes for independent reports.

Use the Amazon DSP connection for advertiser, order, and line-item reporting. Sponsored-ad reports use the separate Amazon Ads connection.

Reporting coverage

Amazon DSP reporting coverage for BigQuery

574supported metrics

87supported breakdowns

Complete field catalogBrowse all metrics & breakdowns for Amazon DSP

Trusted by Agencies, Freelancers, and Founders

See how data teams are using Adzviser to analyze their Amazon DSP data in BigQuery.

Ryan Whiteside

Adzviser is the Supermetrics replacement we've been looking for. Adzviser delivers the same essential functionality at a much better price point, with far superior customer support. The added bonus of a ChatGPT connector allows for seamless data analysis in a way that enhances workflow efficiency.

Digital Marketing DirectorTwo Wheels Marketing

Jared Laidlaw

I appreciate Adzviser's per-client workspace setup, which simplifies organizing data sources compared to setting them up via channels. The customer support is excellent and responsive, addressing my issues swiftly. The pricing is competitive and scales nicely with business growth, which is crucial for me.

Managing DirectorOrchard Financial Marketing

Adam Orris

It is so simple to create your integration with all the supplied connectors. I also love the ability to send data to Gsheets and Looker for automation. The best part is being able to chat with your data inside of ChatGPT's. Adzviser really helps you along the way as well. The customer support is superb.

Director of Data and AnalyticsDisruptive Advertising

Saar Bell

Adzviser completely transformed the way I handle marketing data! Connecting all my sources to Google Sheets, Looker, and ChatGPT was unbelievably simple — no endless setup or technical headaches. Everything runs fast, accurate, and at a fraction of the cost compared to other tools I’ve tried. The customer support is extremely personal and responsive.

Company OwnerBellaPOINT

Powering data-driven decisions for 15K+ companies across 100 countries

Amazon DSP to BigQuery Integration FAQs

Total cost, impressions, clicks, eCPM, video starts, and video completions, with advertiser, order, line-item, or creative detail. Supported inventory reports also show where your ads appeared. View supported Amazon DSP fields →

Authorize your Amazon account in Adzviser and select the DSP advertiser you want to report on. Create a BigQuery pipeline in Adzviser. Connect your Google Cloud project with a service account and select a dataset prefix. BigQuery setup guide →

Yes. Choose Schedule in your Adzviser pipeline, set the frequency and date range for each run, and save the schedule. Adzviser then delivers the selected data to your BigQuery tables automatically.

Yes. Choose Run Once and select the date range you need. You can export data from before you connected Adzviser, as far back as your source account makes it available.

Yes. Export your other connected sources through separate Adzviser pipelines, then use SQL to combine the tables with sales, CRM, or other data in your project. Use the results in your BI dashboards.

Amazon Ads is the broader advertising platform. Adzviser’s Amazon Ads connector covers sponsored-ad reports; its Amazon DSP connector covers DSP advertisers, orders, line items, and supported inventory and audience reports. View the Amazon Ads integration →

Supercharge your data-driven decisions
with Adzviser

Start 14-day trial

Have a question?

Talk to us