How Can I Map Fivetran Amazon Ads Tables to Sponsored Products, Sponsored Brands, and Sponsored Display?
Question
How do I map Fivetran Amazon Ads tables to Sponsored Products, Sponsored Brands, and Sponsored Display?
Environment
Connector: Amazon Ads
Answer
In the Amazon Ads schema, you can identify the ad service by the table name:
- Sponsored Products: These tables don't have a service prefix. Examples include
ADVERTISED_PRODUCT_REPORTandCAMPAIGN_LEVEL_REPORT. - Sponsored Brands: These tables use the
SB_prefix, such asSB_CAMPAIGN_REPORT. - Sponsored Display: These tables use the
SD_prefix, such asSD_TARGET_REPORT.