There are two ways to integrate with Amazon: Manual Upload or via an S3 Data Feed.
The S3 Data Feed is an automated way to continuously import your Amazon activity reports, but is only available to qualifying affiliates.
The Upload method entails manually uploading your Amazon Earnings reports on a regular basis, but is available to all affiliates.
In this article:
In both cases, start by opening the Performance tab in Affilimate, clicking Import, and choosing Amazon from the list of data sources:
Method 1: Upload Amazon Reports
- Open the Amazon affiliate portal in a new tab
- Under Summary for This Month click View Full Report
- Change the timeframe to This Year
- Click Download Reports
- Choose only Earnings as report type, and CSV as format
- Download the your zip file report, and upload it to Affilimate with the Import button
Start by opening two tabs in your web browser:
Step 1. Under "Summary for This Month" click on "View full report"
Step 2. Adjust the dates and choose a timeframe to import
For example, choose "Last 30 days" or "This Quarter".
For your first import, you can also bring in a full year of sales data for more context.
Step 3. Click Download Reports
This will open a popup where you can choose the kind of report you want to download.
Step 4. Uncheck ALL boxes except "Earnings" and under "Format:" choose "CSV"
While those other reports might be worth checking out, Affilimate is only interested in your earnings reports, because those provide product or SKU-level data.
Step 5. Click the "Generate Reports" button
It can take a few seconds, depending on how many sales you need to export.
Step 6. Once it's finished, click "Download" in the row named "Fee-Earnings"
This will download a ZIP file containing your CSV report to your computer.
You'll see the file appear at the bottom of your browser window in a "Downloads" section.
Leave it there.
Step 7. Without closing the "Downloads" section of your browser, change tabs to Affilimate
Make sure you're on the "Performance" page, and have clicked the blue Import button.
Then drag the ZIP file you just downloaded onto the blue, outlined "dropzone" in Affilimate.
Step 8. Review your sales and import
We'll do a little data crunching, and then your Amazon sales will appear in the Performance section of the Affilimate app.
Your sales are now imported and ready for analysis!
Method 2: Connect the Amazon S3 Data Feed
Step 1. Request your s3 Data Feed credentials
Contact the Amazon Associates Support, or your account manager, to request access to your Amazon Associates S3 Data Feed.
If you qualify for access, you'll then be given a set of credentials (username and password) which Affilimate will use to pull your Amazon conversions automatically.
Please note: The S3 Data Feed is not the same as the Product Feed, and your username and password for the feed are not the same as your Amazon account.
Step 2. Provide these credentials in Affilimate
Go to Affilimate's Performance overview and click the blue Import button.
Then select Amazon from the list of integrations, and then under "How do you want to integrate?" choose API.
You'll be asked to provide:
- Username and Password: These are provided to you by Amazon
- Data Feed URL: Select from North America, Europe, or Japan
- Report Currency: Choose your report's currency (e.g. USD for United States, CAD for Canada, etc.)
- Store ID: Find this in the top right corner of your Amazon Associates account, as shown below:
Provide these details, then click Test Connection and import your sales.