Amazon Advertising FAQs
Amazon advertising FAQs
- 1.Amazon Sponsored Products
- 2.Amazon Sponsored Brands
- 3.Amazon Sponsored Display
- 1.Are click attribution metrics updated by Amazon replicated by Daton?
Yes. You can configure the look back window (Attribution Offset) from the UI and Daton will repeat the data after the selected number of days.
- 2.What attribution options are available?
Look back Until: Repeat data until selected number of days. You can select up to 31 days to replicate changes up to 30 days. Look back After: Repeat data after selected number of days. Multiple days can be selected up to 31 days.
- 3.Which attribution offset is better for me?
Look back Until: When you consume Amazon reports every day for your business insights. Look back After: When you consume your reports on a weekly or monthly basis. Note that the metrics may not be accurate for previous 7 days as the minimum look back date is 8 days in Daton.
- 4.Which days are preferred attribution offset?
It depends on your use case. If you use 30day attribution for your reporting, then you must choose 31day offset on Daton. Amazon Ad console will use 14day attribution for most of their reports. If you want to match with Amazon reports, then you must use 15day offset on Daton.
- 5.Why do I see duplicates in my tables?
Since we replicate the data after a few days (based on selection from UI), we append the new data to the tables by default. You can also configure the tables or integrations to ‘upsert’ instead of ‘append’ to handle the duplicates.
- 6.How do I eliminate duplicates from these tables?
You can use _daton_batch_runtime to identify most recent record for a primary key of the table. Use the deduplication guide at the bottom of this page.
- 7.How much historical data can be replicated through Daton?
Amazon Ads APIs share previous 60 days of reports. Daton can lookback and replicate previous 60 days of data from the date of integration.
- 8.Will reloading a table affect my historical data?
Yes. Daton will drop and create the table again for reloads. Historical data replicated so far would be lost and previous 60 days data would be replicated again.
- 9.Is present days data replicated through Daton?
No. Amazon will not share present day’s reports through APIs, until the day ends. Daton can replicate only previous days data after 2 AM of seller time.
- 10.Why are most of my jobs showing zero records processed?
Daton replicates previous day’s data in the first job after 2 AM of seller time. All jobs after that will be skipped and marked success with zero records processed. This is to reduce the volume of data and duplicates on destinations. If the first job fails, then Daton will repeat the job based on frequency selected.
- 11.What is reportDate column?
ReportDate is the date for which the data belongs to. For example, reportDate=’2021-04-01’ will have all metrics such as clicks, spend, attributedSales14d generated for 1st April.