To start product profit optimization in Amazon, Adspert needs to receive a product feed with specific details to calculate profit per product.
We provide a Google Sheet template for the profit maximization feature, making it easier and faster for you to provide the required data. Please request the template from your Customer Success Manager.
How It Works with the Google Sheet Template
You make a copy of the template.
Complete it with your data (ideally, you can set up an automation on your side so the data is always up-to-date).
Share the sheet with your Customer Success Manager (CSM) or
Template Instructions
Inside the template, you’ll find an Instructions tab. The key steps are:
Make a copy of the template.
Grant access to this sheet to:
userinspector@adspert-inspector.iam.gserviceaccount.comPopulate the “Product Feed” tab – fill in all columns without changing the formatting.
The product feed should be per account.
Reflect the name of the account in the file name.
If you have multiple accounts, create a separate copy for each one.
Add COGS (Cost of Goods Sold) in the same currency as the account.
Example: EUR for DE, ES, IT, FR accounts; USD for US accounts, etc.
Delete the “Instructions” tab after completing your file.
Send the sheet URL to your CSM.
Example:
SKU |
| COGS | VAT | return_rate | cost_per_return |
ABC1234XYZ |
| 10.5 | 0.10 |
|
|
Required Fields
SKU – The unique product identifier used in Amazon.
COGS – Seller’s buying and handling cost for a product, excluding Amazon fees and advertising cost.
If you set the shipping cost to zero in Amazon for FBM (Fulfilled by Merchant) products, please include the shipping cost in this value.
VAT – VAT rate formatted as a decimal (e.g., 0.19 for 19%).
Optional Fields
Return Rate – The percentage of sold units that are returned.
Cost per Return – The average cost incurred for each returned unit.
Data Format Notes
When sending the product feed, please inform your CSM about:
Decimal separator used in your file (comma or point).
Whether VAT is provided as a rate (e.g., 0.19) or as a factor (e.g., 1.19).
Tip: Keeping your Google Sheet automated and updated will ensure Adspert always has the latest data to optimize your profits effectively.