Advertising
Amazon Advertising schema
SightShark syncs Amazon Advertising into a data warehouse you own. It creates 1 table holding 8 fields, refreshed daily. Sponsored Products, Brands and Display campaign performance. Separate from Amazon DSP, which has its own connector and its own schema.
1 table / 8 fields / Provisional
Provisional
The table names below follow this site’s naming convention rather than a production sync, and the field names follow the documented Amazon Advertising schema. Confirm both against your own dataset before you rely on them.
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
amazon_ads_campaign_performance
8 fields
- campaign_id
- campaign_name
- date
- spend
- impressions
- clicks
- conversions
- conversion_value
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Every ad platform names the same number differently and reports it in its own currency and its own time zone. Put two of them in one report without reconciling that and the totals disagree.
Questions people ask
What tables does SightShark create from Amazon Advertising?
1 table, including amazon_ads_campaign_performance. amazon_ads_campaign_performance is one row per campaign, per day. Every one is listed on this page, with its fields.
Which Amazon Advertising fields can I get?
The columns on this page are the ones most reports use. Amazon Advertising exposes more, and a sync can be extended to any of it.
How often does Amazon Advertising data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Amazon Advertising data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Amazon Advertising and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 6 min read
Budget pacing: the formula, and the report.
Spend against plan, while there is still time to do something about it.
Read it - 5 min read
How often marketing data should refresh.
Almost always daily. Here is why more often is usually worse, not better.
Read it - 7 min read
Reporting across currencies and time zones.
Both are the same failure. A number that means something different depending on where it was read, and no error either way.
Read it
Get started
Want Amazon Advertising in your own warehouse?
A call with someone who can answer the schema questions.