Glossary

• wow → week over week
• mom → month over month
• qoq → quarter over quarter
• wtd → week to date
• mtd → month to date
• qtd → quarter to date

Business Requirement

Watching video Tutorial : https://www.youtube.com/watch?v=H5Um8-lFZzg

1. Dashboard period specifications (excluding years):

   a. This week (compared to last week) → /wow/wtd

   1. WTD (Week to Date)

   b. Last week (compared to the week before last) → /wow/last-week

   c. The week before last (compared to two weeks ago) → /wow/two-weeks-ago

   d. This month (compared to last month) → /mom/mtd

   1. MTD (Month to Date)

   e. Last month (compared to the month before last) → /mom/last-months

   f. The month before last (compared to two months ago) → /mom/two-months-ago

   g. Last quarter (compared to the previous quarter) → /qoq/last-quarter

2. The data granularity of the dashboard is based on Ad Type and Creative Type as the highest hierarchy.

   a. Sponsored Products - Creative Type: None

   b. Sponsored Brands - Creative Type: IMAGE

   c. Sponsored Brands Video - Creative Type: VIDEO

   d. Sponsored Display - Creative Type: IMAGE

   e. Sponsored Display Video - Creative Type: VIDEO

   Dashboard display metrics <Only data that can be retrieved or calculated with the Ads API can be used>

   1. Advertising revenue (integer) AD_ORDER
      • SP (v3) → sales7d
      • SB, SBV, SD, SDV (v2) → attributedsales14d
   2. Advertising cost (integer) AD_COST
      • SP (v3) → cost
      • SB, SBV, SD, SDV (v2) → cost
   3. ACoS (%) ACOS → *AD_COST*/*AD_ORDER*
   4. ROAS (%) ROAS
      • SP (v3) → roasclicks7d
      • SB, SBV, SD, SDV (v2) → *AD_ORDER*/*AD_COST*
   5. Impressions (integer) AD_IMPRESSION
      • SP (v3) → impressions
      • SB, SBV, SD, SDV (v2) → impressions
   6. CPC (cost per click) (integer) AD_CPC
      • SP (v3) → costPerClick
      • SB, SBV, SD, SDV (v2) → *AD_COST*/*AD_CLICKS*
   7. Clicks (integer) AD_CLICKS
      • SP (v3) → clicks
      • SB, SBV, SD, SDV (v2) → clicks
   8. Click-through rate (CTR) AD_CTR
      • SP (v3) → clickThroughRate
      • SB, SBV, SD, SDV (v2) → *AD_CLICKS/AD_IMPRESSION*
   9. Number of orders (integer) AD_ORDERED_UNIT
      • SP (v3) → purchases7d
      • SB, SBV, SD, SDV (v2) → attributedconversions14d
   10. Conversion rate (CVR) (%) AD_CVR → *AD_ORDERED_UNIT/AD_CLICKS*

Technical Requirement

Ads API uses the following version

1. Sponsored Products → V3

   https://advertising.amazon.com/API/docs/en-us/guides/reporting/v3/overview

2. Sponsored Brands, Sponsored Brands Video, Sponsored Display, Sponsored Display Video → V2

   https://advertising.amazon.com/API/docs/en-us/guides/reporting/v2/overview

Detail

API

Sumarry