Amazon DSP

Data Availability & Refresh Schedule

Historical Availability

Historical availability of data refers to the pulling in of past data from Amazon in Intentwise Analytics. This refers to your data for the time period before you added a particular account as a data source under My Connections.

For historical data going further back, please write to us at [email protected]

Data Refresh Schedule

Data for all Amazon DSP tables is updated daily between 7:30 AM PST to 10:30 AM PST daily.

Intentwise Analytics pulls in multiple days of data daily to account for variations in past data due to various factors like Amazon’s click attribution logic, cancellations/returns, adjustments by Amazon, etc.

The following table highlights the refresh window for each data source—the number of days for which we pull in data from Amazon in every data load cycle.

Order

Table name: dsp_order

For details on data availability and refresh schedule, please click here.

Order Budget Cap

Table name: dsp_order_budgetcap

Order Budget Flight

Table name: dsp_order_budgetflight

For details on data availability and refresh schedule, please click here.

Order Report

Table name: dsp_order_report

For details on data availability and refresh schedule, please click here.

Line Item

Table name: dsp_lineitem

<!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}-->

For details on data availability and refresh schedule, please click here.

Line Item Report

For details on data availability and refresh schedule, please click here.

Creative

For details on data availability and refresh schedule, please click here.

Creative Report

Product Report

Table name: dsp_product_report

For details on the description, please click here.

Inventory Report

Table name: amazon_source_data.dsp_inventory_report

For details on the description, please click here.

Audience Report

Table name: amazon_source_data.dsp_audience_report

For details on the description, please click here.