Home > Destinations > Data Studio (ex Looker Studio) > Amazon DSP

Connect Amazon DSP to Data Studio (ex Looker Studio)

Connect Amazon DSP to Data Studio (ex Looker Studio) and and build automated dashboards without CSV exports, spreadsheets, or manual API setup.

Looker Studio
Power BI
Google Sheets
BigQuery
Snowflake

Used by the world's leading companies

Why do agencies use Catchr for Amazon DSP reporting in Data Studio (Looker Studio)?

Catchr lets media buyers and agencies stop rebuilding Amazon DSP reports by hand: the data lands in Data Studio ready to chart, for every ad account you manage.

No manual csv export
‍

Stop downloading files from Amazon DSP every time a client report, spreadsheet, or dashboard needs fresh numbers.

Connected in minutes

Your first Amazon DSP report can be live in a few minutes. Authorize your Amazon DSP account, pick your ad accounts, and your data source is ready.

Built for agencies with many Advertising accounts

Pull several Advertising accounts into one data source, then filter by account to build a report per client or brand in the same Data Studio file.

Amazon DSP to Looker Studio pricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

How to connect Amazon DSP to Data Studio with Catchr?

To connect Amazon DSP to Looker Studio (Data Studio), open the Catchr connector, authorize your Amazon DSP account, select the ad accounts you want to report on, then create your report.

1. Open the Catchr Amazon DSP connector in Looker Studio

Click the connector link to open it inside Looker Studio. You will be asked to authorize the connector before creating your data source.

2. Authorize Looker Studio (Data Studio) and Catchr

Choose the Google account you use for Looker Studio and authorize Catchr to create a secure Amazon DSP data source.

3. Connect your Amazon DSP account

Sign in with your Amazon DSP account that has access to the accounts you want to report on. Make sure your user has the right Amazon DSP permissions.

4. Select your Amazon DSP accounts

Choose one or several Advertising accounts, depending on the report you want to build.

5. Create your Data Studio report

Click Create report, then add charts, scorecards, tables, filters, and date controls using your Amazon DSP metrics and dimensions.

6. Customize your dashboard

Use Total ROAS, Combined Product Sales, Purchases, New To Brand Purchases, E CPC, Amazon Date Source, Advertiser Name, Brand Name, Line Item Name, Creative Name, Placement, Supply Source, Targeting Method and many more.

Amazon DSP metrics and dimensions available in Data Studio

Access 448 metrics and 94 dimensions from Amazon DSP connectors including Total ROAS, Combined Product Sales, Purchases, New To Brand Purchases, E CPC, Amazon Date Source, Advertiser Name, Brand Name, Line Item Name, Creative Name, Placement, Supply Source, Targeting Method and more.

448

Available metrics

94

Available dimensions

Build better Amazon DSP dashboards in Data Studio (ex Looker Studio)

Use Catchr to create dashboards that show what is working, what is wasting budget, and where performance is changing.

Client reporting for agencies

Create clean Looker Studio dashboards for each client with with Total ROAS, Combined Product Sales, Purchases, New To Brand Purchases, E CPC always up to date.

Budget pacing

Compare daily spend with the monthly budget of each campaign, so overspend shows up mid-month instead of on the invoice.

Review what drives results across

Compare to see where budget, traffic, or revenue is improving and where performance is dropping.

Compare with your other channels

Combine with your others marketing to understand performance across your full acquisition journey.

Keep an eye on Amazon DSP performance

Track Amazon DSP Total ROAS, Combined Product Sales, Purchases, New To Brand Purchases, E CPC in refreshable Data Studio dashboards so you can spot changes before they become reporting problems.

Customer testimonials

What our customers say about us.

85 %
Faster
Reporting time

After three years of use, Catchr has become essential for both our teams and our clients. So far, it has been our best solution for compiling and analyzing data from different advertising platforms. It’s easy to set up, and the customer service is responsive and excellent.

Valentin Keravel
CEO, Laio – Agency

With Catchr’s automated API, we can finally collect and centralize all advertising data, connect it with booking information, and calculate the real ROAS for our restaurant clients. It gives them full visibility, more autonomy, and the ability to optimize campaigns to maximize ROI.

Corentin Largeron
Freelance
30
hours saved

The solution is a real game changer, providing optimal time savings for our data reporting. The major strength of the solution is their highly responsive and professional support.

Corentin Largeron
CEO at The Browz – Agency

Amazon DSP to Data Studio (ex Looker Studio): FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How do I connect Amazon DSP to Looker Studio?

Open the Catchr Amazon DSP connector in Looker Studio, authorize your Google account, and connect the Amazon account with access to your DSP advertiser. Select the advertiser and report type, then choose compatible metrics and dimensions. Start with a campaign report for a completed period and compare it with the same advertiser's DSP export before sharing the dashboard.

Is Amazon DSP reporting the same as Amazon Sponsored Ads reporting?

They are separate sources in Catchr. Amazon DSP covers demand-side platform campaigns, while the Amazon Ads connector handles its supported sponsored advertising reports. You can show both in Looker Studio, but keep report types and attribution definitions visible. This DSP source concerns advertising, not Amazon's Delivery Service Partner business.

Which Amazon DSP reports and metrics can I use?

Catchr offers campaign, inventory, product, geographic, technology, audience, reach and frequency, audio and video, and bid adjustment report types. Depending on the report, available fields include impressions, clicks, cost, purchases, sales, ROAS, reach and creative details. Select a report first: a field supported by the campaign report is not automatically supported by every other report.

Why do Supply Cost and Total Cost show different amounts?

Supply Cost measures media supply, while Total Cost has a broader campaign cost scope. Neither should be silently substituted for the other in a cost-per-result or return calculation. Check the metric definition and which fees your DSP export includes, then use the same denominator throughout the dashboard. Keep agency charges or other separately paid fees explicit if you add them to a business-level cost measure.

Can I add daily Amazon DSP reach to get monthly reach?

No. The same person can be reached on several days, so adding daily unique reach overcounts a period's audience. Use a summary reach report for the period and scope you want to assess. Frequency is also a ratio, not an additive total; do not sum daily frequency values. Keep campaign, advertiser and household audience measures distinct when comparing charts.

Why is my Amazon DSP date range or field combination rejected?

DSP reports have different restrictions. Catchr limits most report requests to a 31-day range, while some report types support longer requests. That request limit is separate from how much history Amazon retains. Reduce the date range and select fields from one compatible report level. Audio and video and bid adjustment reports are requested as summaries, so adding a date field does not turn them into daily time series.

Why don't DSP sales match Amazon retail sales or update immediately?

DSP sales are advertising-attributed results; Seller Central and Vendor Central describe retail activity with different scopes. Match the sales field, advertiser, dates and currency before comparing. DSP reports are generated asynchronously, so a dashboard query must wait for Amazon's report. Recent results can evolve as attribution is processed; a completed-period comparison is more useful than expecting a live sales counter.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.