Connect Amazon DSP to Excel

Setup guide

How to Connect Amazon DSP to Excel

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

Install the Adzviser Excel add-in, sign in, and select your workspace, account, report fields, and date range. Excel setup guide →

Run your first report

Select Total cost, Video start, Video complete and a date range. Use the data in Excel to analyze trends and build reports.

Why this connection

Why Connect Amazon DSP to Excel?

Use Excel 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 Excel

Bring reporting data into Excel for pivot tables, charts, and planning workbooks. Refresh saved queries from the Adzviser task pane.

Import the report you need

Retrieve Total cost, Video start, Video complete by Advertiser ID, Line item ID, Creative ID into an Excel worksheet.

Create an Excel report

Use the imported table in pivots and charts, or compare results with your team’s targets and forecasts.

Refresh before sharing

Use Refresh all queries in the task pane. Keep the hidden adzviserQuery worksheet so your saved queries remain available.

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 Excel

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 export their Amazon DSP data to Excel.

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 Excel 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 Excel add-in, sign in, and select your workspace, account, report fields, and date range. Excel setup guide →

Open the Adzviser task pane and select Refresh all queries to retrieve data using your saved report settings. The Excel add-in currently supports manual refresh; scheduled refresh is available in the Google Sheets add-on. Excel refresh guide →

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