Amazon Ads - Historical Backfill Instructions

Section A: Pull the Amazon Ads Report

Step 1: Log Into Amazon Ads

1. Go to: https://advertising.amazon.com/
2. Confirm the correct account is selected in the top header
3. In the left sidebar:
   • Click “Measurement & reporting”
   • Click “Reporting”

Step 2: Create a New Report

1. On the Reporting page, locate the “Campaign” template
2. Click “Use template”

Step 3: Name the Report

Use a clear naming convention, for example:

• Amazon Ads - Daily - Last 24 Months (preferred)
• Amazon Ads - Daily - [Start Date] to [End Date]

Step 4: Add Your Account

1. Under Filters → Accounts, click “Add”
2. Select your advertiser account
3. Click “Save”

Leave all other filters as:

• Campaigns: All
• Country: All
• Ad product: All

Step 5: Configure Dimensions

In Customize columns → Dimensions, select:

• ❌ Uncheck: Date range
• ✅ Check:
  • Day / Month / Year
  • Ad product
  • Campaign ID
  • Campaign name

⚠️

Important: “Day” and “Date range” cannot both be selected.

Step 6: Configure Metrics

In the Metrics tab, select:

• Impressions
• Clicks
• Total cost
• Purchases
• Sales (under “Amazon retail conversions”)

Step 7: Set the Date Range

1. Scroll to Report period
   1. Preferred: Last 24 months of Historical Data
2. Select a custom date range:
   • To get a daily grain data there is 90 day window restriction
     • Example: April 1, 2024 → June 30, 2024
   • There will be a need to run the 90 day window request multiple times to account for 6 months or more of data

🗒️

Note: Amazon allows ~365 days per report pull.

Based on customer feedback, the furthest back data is typically available from January 2025.
For a full history pull, set your start date to January 1, 2025 and run multiple adjacent windows if needed.

3. Click Save

Step 8: Confirm Delivery Settings

• Send to: Leave blank
• Report frequency: Once
• File format: CSV

Step 9: Submit & Download

1. Click Submit
2. Wait for processing (typically 5–60 minutes)
3. Refresh the page until status = Completed
4. Download the CSV file

Section B: Convert to the Prescient Marketing Template

Step 10: Open the Prescient Template

1. Open the Prescient Marketing Template workbook
2. Navigate to the Digital Marketing Sources tab
3. This is where your Amazon data will go

Step 11: Map Data into the Template

Copy data from the Amazon CSV into the template using the following mapping:

• Paste values into the corresponding template columns
• Do not include extra columns

Step 12: Match Template Format Exactly

Ensure the file uses exactly these column names:

• DATE
• CAMPAIGN_NAME
• CAMPAIGN_ID
• TACTIC_TYPE (optional — can be left blank)
• SPEND
• CLICKS
• IMPRESSIONS
• CONVERSIONS
• REVENUE

Formatting requirements:

• Keep headers exactly as written (all caps)
• Dates must be formatted as YYYY-MM-DD or YYYY/MM/DD
• Ensure one row per day × campaign
• No blank rows
• No extra columns

Step 13: Quality Check Before Export

Before saving:

• Confirm DATE, CAMPAIGN_NAME, CAMPAIGN_ID, and SPEND are populated
• Confirm numeric fields contain only numbers (no symbols or text)
• Confirm daily granularity (one row per day per campaign)
• Confirm only template columns are present

ℹ️

TACTIC_TYPE is optional and can be left blank.
Prescient’s system will validate these requirements upon upload.

Step 14: Export the Final File

Save or export the completed template as a CSV file.

This is your Prescient-ready file that can be uploaded to the platform through Prescient’s Data Patch.