This cheat sheet explains how Fivetran’s Amazon Ads connector enables performance tracking for Sponsored Product Ads, Amazon’s most popular ad type. It supports features like priority first sync for faster data access, universal column masking to protect sensitive information, and multiple conversion windows from 1 to 30 days. Users can analyze data at the account, campaign, ad group, keyword, and product levels, with popular reports including KEYWORD_REPORT, PRODUCT_ADS_REPORT, and TARGET_REPORT. By combining metadata with reporting tables, teams can link configurations to campaign performance. Cross-platform models also roll up spend, clicks, and impressions across major ad networks.

Join for free to read