DATA FEED REQUIREMENTS

DATA FEED REQUIREMENTS

Data-feeds are the fastest, easiest way to upload product information to your advertisers and campaigns. Sticking to the following guidelines and specifications will ensure your products and ads are displayed correctly.

CSV file format

Adacado data feeds access formatted CSV files via HTTP/HTTPS or FTP. To download a sample CSV file, click here. See below for a description of each field in the upload file.

Note:
Informative ads always perform the best, and can only display the information made available in your CSV. So take the time now to fill out your CSV – you’ll be glad you did!

Click here to download a Sample CSV File

  • Product Link – *Mandatory Field* –  The URL of the specified product page. For example, “www.examplebrand.com/products/shoes/ayr_max”.
  • Product Title – The listed name of the product. For example, “Ayr Max“.
  • Product Image A link to a publicly-accessible image of the product – preferably the same as the main product image on the product page. For example, “www.examplebrand.com/products/shoes/ayr-max/featured-image-ayr-max.jpg”.
  • Price – The listed price of the product. For example, “$242.99“(must include currency symbol and necessary decimal places for it to show).
  • Sale Price – The product price, discounted from the listed Price. For example, “$219.49” (must include currency symbol and necessary decimal places for it to show).
  • Currency Symbol – 3-digit country code of the currency. For example, “USD“.
  • Description – A description of the product, its features, benefits, etc. For example, “Defy the laws of gravity with Ayr Max“.
  • Product ID – The code used to identify the product. For effective tracking and reporting, each ID must be unique. For example, “SHOE3374“.
  • Category – The broad product category (ie. Furniture, Toys, Wellness, etc.). For example, “Shoes“.
  • Brand – The name brand of the listed product. For example, “Example Brand“.
  • Manufacturer Part Number – Unique manufacturer ID for the product. For example, “HSC0424PP” (string – any alphanumeric).
  • Mobile Link – The product’s mobile-optimized landing page when you have a different URL for mobile/desktop traffic. For example, “examplebrand.com/mobile/products/shoes/kix”.
  • Stock Availability – The product’s availability. For example, “In Stock”, “Out of Stock”, “Preorder”.
  • Availability Date – The availability date of a pre-ordered product when it becomes available for delivery. For example, “2019-10-04” (should be in YYYY-MM-DD format).
  • Color – Main color as listed by the manufacturer. For example, “Cajun Red”.
  • Age Group – The demographic for which the product is intended. For example, “Adult”, “Kids”, “Infant”, “Newborn” etc.
  • Material – The composition of the product. For example, “100% Cotton”.
  • Condition – The state of the listed product at the time of sale.  For example, “New”.
  • Pattern – A repeated decorative design of the product. For example, “Plaid”.
  • Size – A measure of a manufactured product. For example, “Small”, “Medium”, “Large” etc.
  • Size Type – The apparel product cut. For example, “Regular”, “Petite”, “Plus”, “Maternity” etc.
  • Size System – The country of the size system that is used by the product. For example, “US”.
  • Inventory Count – The number of the specified products held in an inventory or warehouse. For example, “20”.
  • Global Trade Item Number – The product’s Global Trade Item Number (GTINs). For example, (North America – 12 digit number).
  • Custom Label – Label that is assigned to organize bidding and reporting in retail campaigns. For example, “Seasonal”.
  • Video Link – The video URL of the specified product page. For example, “www.examplebrand.com/video/products/shoes/kix”.
  • Weather Condition – The atmospheric condition that is specific to the product location. For example, “Partly Cloudy”.
  • Weather Temperature Min  For product targeting purposes – the minimum temperature acceptable for a location. For example, “20°C” (for bathing suits).
  • Weather Temperature Max – For product targeting purposes – the maximum temperature acceptable for a location. For example, “12°C” (for snow boots). 
  • Weather Temperature Unit – Measurement used for weather temperature, specific to the product location. For example, “Celsius (°C)”.
  • Additional Image Link – An additional link to a publicly accessible image of the product. For example, “https://inventory-cf.assets-cdk.com/RTT/Chevrolet/2019/3947163/default.jpg”.
  • Latitude – The latitude of the products’ physical location. For example, “50.481018”.
  • Longitude – The longitude of the products’ physical location. For example, “20.290493”.

Click here to download a Sample CSV File

  • Product Link – *Mandatory Field* – The URL of the specified product page. For example, “https://www.pschevy.com/VehicleDetails/new-2019-Chevrolet-Equinox-FWD_Premier-Fayetteville-NC/3373457313“.
  • Manufacturer VIN – *Mandatory Field* – The unique vehicle identification number (17 characters in length). For example, “3GNAXPEX1KS598407“.
  • Make – *Mandatory Field* – Manufacturer of the specified vehicle. For example, “Chevrolet“.
  • Model – *Mandatory Field* – Model name of the specified vehicle. For example, “Equinox“.
  • Year – *Mandatory Field* – Year of production. For example, “2019“.
  • Product Title – The listed name of the product. For example, “New 2019 Chevrolet Equinox FWD Premier“.
  • Product Image – A link to a publicly-accessible image of the product – preferably the same as the main product image on the product page. For example, “https://inventory-cf.assets-cdk.com/RTT/Chevrolet/2019/3947163/default.jpg“.
  • Price – The listed price of the product. For example, “$32,080.00” (must include currency symbol and necessary decimal places for it to show).
  • Sale Price – The product price, discounted from the listed Price. For example, “$190.49” (must include currency symbol and necessary decimal places for it to show).
  • Currency Symbol – 3-digit country code of the currency. For example, “USD.”
  • Description – A description of the product, its features, benefits, etc. For example, “New 2019 Chevrolet Equinox Premier 2.0“.
  • Product ID – The code used to identify the product. For effective tracking and reporting, each ID must be unique. For example, “3GNAXPEX1KS598407“.
  • Brand – The name brand of the listed product. For example, “Chevrolet“.
  • Trim – Trim grade of the specified model. For example, “Premier 2.0“.
  • Condition – Current (accurate) description of the vehicle’s condition. For example, “New.”
  • Mileage – Total lifetime miles traveled by the vehicle. For example, “24000“.
  • Color – Main color as listed by manufacturer. For example, “Cajun Red“.
  • Dealer ID The dealership ID based on the specific location of dealership. For example, “DEALER123”.
Note:
Maybe you went a little trigger happy on the info fields and your CSV has extra fields. No worries! Our bot is pretty clever, and will ignore what can’t be used!

File upload

Accessing your csv file via HTTP/HTTPS/FTP allows for regular updates of information – no version-tracking or re-uploads required.

  • Datafeed URL – The public URL (no password protection) where the csv file is hosted. For example, “https://docs.google.com/document/d/1WlHQ4eXXXXXXXDdYx47V1b2b2bWC4sh7w-JKZJKLLM
  • FTP Host Address – The URL of the host server.  For example, “ftp.examplesite.com”
  • Port – Data transfer port of the host server. For example, “21“.
  • Username – Login username of the account used. For example, “Radacado“.
  • Access Password – Login password of the account used. For example, “Pass1234″ (But please don’t make that your password…).
  • File Path” – The specific file path to the csv file. For example, “/files/products/exports/prod-04-08-2019.csv

File upload FAQs

  • “I don’t have a URL for my CSV file” – No problem. You can use a free service like Google Sheets to host the document. Just make sure it is a shareable link – like below.
data feed requirements on-anyone with the link
  • Multi-tabs – If you use Google Docs/Excel/Numbers to format your CSV document, keep it to 1 page (tab). Anything beyond the first tab will be ignored. 
  • “Do I enter all this information manually?” – Let’s hope not. If you don’t have an IT wizard to help you out, here are a few links to CSV file-export tutorials that might be useful.
  • My columns are in a different order – do I need to change them?” – As long as the document has the mandatory fields, the order isn’t important. When you upload your feed, the system will map it automatically, and if anything doesn’t map/maps incorrectly, you can (and should!) fix it manually.
  • My CSV isn’t separated with commas!” – A-ok. When you upload the file, specify “Manual Input” in the “How is your data delimited” dropdown, and enter whatever character is used to delimit.
  • What if the file maps incorrectly?” – These things happen. If something is off, you can always go back and change it.
A Note on Images…
Make sure the link to your product images is available to the public (ie. not protected by firewall, password, etc.). Our bot is clever, but password-hacking is definitely a no-go!