Scope:
Delivery Time Insights enables to easily track changes in the delivery time of Amazon.
This supports Vendors in pausing / re-starting campaigns based on Amazon Delivery Time
during COVID-19.
Frequency of data collection and data updates:
Based on a daily data collection and update process, Delivery Time Insights Report provides data for current date (today) and the date before (yesterday).
Data Collection: Daily
Data update in reporting tool: Daily
Use cases:
Identify advertised ASINs, where Amazon holds the Buybox (BB) and has long delivery times
Aim: Pause campaigns to save budget and avoid bad conversion rates due to long delivery times
Use the following filter settings:
Target State = enabled
Today Buybox Owner = Amazon
Today Amazon Delivery Time = 8+ days (set filter to 8 - …)
The report will show you all ASINs that fit these criterias.
You can identify in the column “Campaign Type” in which type of campaign this ASIN is advertised.
For ASINs in SPA -> Pause the campaign
For ASINs in SBA -> Check the status of the other ASINs contained in the SBA, i.e. if Amazon holds the BB and has long delivery times, too. If yes, you should consider to pause the SBA and setup new ones with shorter delivery times.
Identify advertised ASINs, where Amazon holds the BB and delivery times shortened
Aim: Restart campaigns that were paused due to long delivery times
Use the following filter settings:
Target State = disabled
Today Buybox Owner = Amazon
Today Amazon Delivery Time <=7 days (set filter to 0 - 7)
The report will show you all ASINs that fit these criterias.
You can identify in the column “Campaign Type” in which type of campaign this ASIN is advertised.
For ASINs in SPA -> Restart the campaign
For ASINs in SBA -> Check the status of the other ASINs contained in the SBA.
If a reasonable amount of ASINs show short lead times and SBA was paused, restart it again.
Tipps & Tricks
By clicking on the column header, you can sort the ASINs accordingly and thus easily detect ASINs with issues.
Filters
Value | Description |
Entity | Entity name as defined in the metoda Campaign Manager |
Product Name (ASIN) | Amazon Product title and ASIN of product |
Target State | SPA & SBA: Campaign state based on metoda Ad Optimiser settings [enabled / disabled] DSP: no status available |
Campaign Type | The report includes ASINs advertised via metoda Ad Optimiser of the campaign types SPA and SBA and ASINs advertised via Managed Service of the campaign type DSP |
Change in Amazon Delivery Time | Selection: Delivery Time decreased Delivery Time increased No change
ASINs where we could not calculate the delivery time for yesterday or today, because of missing data, show the status “No information available” |
Today Amazon Delivery Time | Calculated Delivery Time based on today's Amazon delivery date; Between 0 and x days |
Today FBA | Is Today’s Buybox offer FBA (yes) or FBM (no) |
Today Buybox Owner | List of shops with Buybox Ownership today. |
Table: Description of column names/values and colour codes
Value (column name) | Type | Description | Colour Code |
ASIN | Alphanumeric character | Amazon product ID of promoted product | |
SKU | Alphanumeric character | Stock keeping unit Vendor: Same as ASIN Seller: Seller specific SKU | |
Product Name | Text | Today’s last observed product name | |
Brand | Text | Today’s last observed brand name | |
Product URL | Image (text in mouseover) | URL to amazon product page | |
Country | Text | 2 character country code of sourced data point | |
Campaign Type | Text | Shows campaign type of related ASIN [SPA / SBA / DSP] | |
Target State | Text
| The state a campaign should have today [enabled / disabled] | green: enabled red: disabled |
Change in Amazon Delivery Time | Text | Indicates a change of today’s Amazon Delivery Time compared to yesterday’s Amazon Delivery Time [decreased / increased / no information / no change]
Note: Only in case the delivery time change is larger than +/- 1 day, this is interpreted as change, otherwise it is marked as “no change”. | green: decreased red: increased orange: no information grey: no change |
Today Buybox Availability | Text | Today’s availability status [available / not available / no information] | |
Today Buybox Owner | Text | Name of today’s buybox owner | |
Today Buybox FBA | Text | FBA = Fulfilled by Amazon Today’s status as displayed on Amazon product detail page [yes / no] | |
Today Amazon Delivery Time | Number | Today’s Amazon Delivery Time in days calculated from Today’s Amazon Delivery Date | |
Today Amazon Delivery Date | Date dd.mm.yyyy | Today’s Delivery Date for Amazon Offer
Note: The Delivery Date is only available for Amazon offers and reflects the Delivery Date with Prime delivery. Please notice, that the Delivery Date shown on the Amazon website varies depending on the location. | |
Today Amazon Delivery Option | Text | Today’s Amazon Delivery Type, which is the base for the Delivery Date [prime, non-prime, scheduled delivery, no information] | |
Yesterday Buybox Availability | Text | Yesterday’s availability status [available / not available / no information available] | |
Yesterday Buybox Owner | Text | Name of yesterday’s buybox owner | |
Yesterday Buybox FBA | Text | FBA = Fulfilled by Amazon Yesterday’s status as displayed on Amazon product detail page [yes / no] | |
Yesterday Amazon Delivery Time | Number | Yesterday’s Amazon Delivery Time in days calculated from yesterday’s Amazon Delivery Date | |
Yesterday Amazon Delivery Date | dd.mm.yyyy | Yesterday’s Delivery Date for Amazon Offer
Note: The Delivery Date is only available for Amazon offers and reflects the Delivery Date with Prime delivery. Please notice, that the Delivery Date shown on the Amazon website varies depending on the location. | |
Yesterday Amazon Delivery Option | Text | Yesterday’s Amazon Delivery Type, which is the base for the Delivery Date [prime, non-prime, scheduled delivery, no information] |
General Functions of the Report
Clicking on headlines of columns activates sorting (A-Z), clicking again sorts Z-A.
Clicking on a certain table field, you can highlight the selected element. Click again to remove the highlighting.
Filtering: by clicking the desired value; click again or use the rubber symbol in order to clear filters.
Multiple selection in filters: you can select multiple items by pressing "ctrl" on your keyboard and clicking on the items.
Above the table, several buttons allow you to further analyze data. Hover above the table to see them.
1. 2. 3.
1. Shows filters and slicers affecting this visual.
2. Focus mode: can be used in order to zoom into a specific table or graph.
3. More Options:
Export data: you can download data into an Excel- or CSV-file (export can take several seconds). You have two options:
Summarized data: data as shown in the table
Underlying data: all data from the whole report