Adspert needs to receive a feed with details to calculate and the profit per product to start profit optimisation.
In this article, we describe what type of feed format and parameters we need to start profit optimisation.
Feed Format
You can either send us a CSV or XML or GSheet with that data or give us an URL where we can download the data automatically every day (preferred!).
Feed Parameter
Name | Description |
URL | Where to get the feed from. Supported file formats:
|
vat_price | The default VAT rate for product prices. This refers to the prices from the feed. |
To fetch product values from a GSheet, it must be publicly accessible or access granted to the userinspector@adspert-inspector.iam.gserviceaccount.com.
The URL in table product_value_feed must follow the pattern gsheet:<DOC-ID>[/<SPREADSHEET-ID>].
Feed Columns
Column | Description | Required |
adw_id | Product ID used in GMC and Google Ads. | Yes. |
cost_of_goods_sold | Seller’s buying and handling cost for a product, excluding VAT. | Yes |
price | The advertised price of the product including VAT. | Yes |
vat_price | Rate of VAT included in price (e.g 0.19 for 19%) | No (feed parameter vat_price is the default). |
Example of how it should look like
adw_id | cost_of_goods_sold | vat_price |
AB1233r | 10 | 0.19 |
Please make sure to provide information to your client success manager, about the number format for monetary values and rates:
Is comma or point used as decimal separator?
Is VAT provided as a rate (e.g. 0.19) or as a factor (e.g. 1.19)