Extract data from Amazon Advertising

Start moving your Amazon Advertising data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Amazon Advertising connector in the Weld documentation

sponsored_product_keyword

sponsored_product_negative_targeting

65 more amazon-ads tables

Explore available Amazon Advertising data

Browse all the data tables available for the Amazon Advertising connector, in our interactive ERD data viewer.

View the Amazon Advertising Data Schema

Transform and model Amazon Advertising data

Get clean data models from your Amazon Advertising data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Amazon Advertising

raw.amazon_advertising.table1

raw.amazon_advertising.table2

Get started with Amazon Advertising SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Amazon Advertising.

Campaign Report

Extracts a comprehensive report of advertising performance for Amazon's Sponsored Products, grouped by campaigns and accounts. This report integrates data from the campaign report with the account and campaign tables to provide metrics such as cost, clicks, and impressions for each campaign.

Ad Group Report

This template extracts a comprehensive breakdown of advertising performance on Amazon, grouped by ad groups for sponsored products. It integrates data from the sponsored product ad group report with the profile and ad group tables to deliver metrics like cost, clicks, and impressions for each ad group.

Keyword Report

This template extracts a comprehensive breakdown of advertising performance on Amazon, grouped by keywords for sponsored products. It integrates data from the sponsored product keyword report with the profile and keyword tables to deliver metrics like cost, clicks, and impressions for each keyword.

Ad Report

This template extracts a comprehensive breakdown of advertising performance on Amazon, grouped by product ads for sponsored products. It integrates data from the sponsored product product ad report with the profile and ad tables to deliver metrics like cost, clicks, and impressions for each product ad.

View all Amazon Advertising templates