Connect Amazon DSP to Google Sheets

Setup guide

How to Connect Amazon DSP to Google Sheets

Connect your Amazon DSP account, set up Google Sheets, 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 Google Sheets

Install the Adzviser Google Sheets add-on and sign in. Choose your workspace, source account, fields, and dates. Google Sheets setup guide →

Run your first report

Select Total cost, Impressions, Clicks and a date range. Use the data in Google Sheets to analyze trends and build reports.

Why this connection

Why Connect Amazon DSP to Google Sheets?

Use Google Sheets to report on line-item spend, impressions, and video performance from your connected Amazon DSP account.

What you can do

Find the line items driving spend

Compare cost and impressions by line item to see where delivery increased or slowed.

Compare video creatives

Review video starts and completions by creative to identify ads worth a closer look.

See which sites show your ads

Break down delivery by site in a separate inventory report to see where your ads appeared.

YOUR REPORTING WORKFLOW

Build your Amazon DSP report in Google Sheets

Build a spreadsheet report with formulas, pivot tables, and charts, then refresh the imported data on a schedule.

Choose your report columns

Select Total cost, Impressions, Clicks, eCPM. Add Advertiser ID, Line item ID, Line item name to keep the detail you need in your worksheet.

Create charts and pivot tables

Keep imported rows on a data tab and put formulas, pivots, or client-facing charts on a separate tab.

Schedule refreshes

Use Schedule → Add trigger to update the sheet automatically for your regular reporting cadence.

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 Google Sheets

574supported metrics

87supported breakdowns

Complete field catalogBrowse all metrics & breakdowns for Amazon DSP

Trusted by Agencies, Freelancers, and Founders

See how marketers are using Adzviser to automate their Amazon DSP reporting in Google Sheets.

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 Google Sheets 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. Install the Adzviser Google Sheets add-on and sign in. Choose your workspace, source account, fields, and dates. Google Sheets setup guide →

Yes. In the Adzviser add-on, choose Schedule → Add trigger and set the refresh schedule for your report. Your sheet can then retrieve updated data without manually exporting it from the source platform. Set up scheduled refresh →

Yes. Import each connected source into its own data tab, then use formulas, pivot tables, and charts to build a shared report. You can also compare the imported results with budgets or targets already in your workbook.

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