# Amazon Music

## Locations

| licensor   | report_name | Drop location                                       |
|------------|-------------|-----------------------------------------------------|
| theorchard | adsupported | s3://prod-orcdbucket/feed-drop/AmazonAdSupported/   |
| theorchard | prime       | s3://prod-orcdbucket/feed-drop/AmazonPrime/         |
| theorchard | unlimited   | s3://prod-orcdbucket/feed-drop/AmazonUnlimited/     |
| sme        | adsupported | s3://sme-ca-prod-partners/amazon/in/adsupported/    |
| sme        | prime       | s3://sme-ca-prod-partners/amazon/in/prime/          |
| sme        | unlimited   | s3://sme-ca-prod-partners/amazon/in/musicunlimited/ |

## SME Product remapping

### Description
When an Album has a future release date, Amazon may have a “lead single” that is released before the full Album. 
Amazon will often report streams against the unreleased Album instead of the released Single.

### Solution
When Amazon reports streams for an ISRC against a UPC that we do not have in dim_release, then use the another available UPC. 
It was done in **load_staging_fact_sme.sql file.**

The problem is described in the following Notion document:
https://www.notion.so/SME-Streams-Matching-Improvement-20197177520f8085bf8ee0bb7d913a66?pvs=4