Explanation

You can place orders via an XLS- or CSV-file. Each column in the data file represents an attribute of a single order. Each line represents a single order. All uploaded orders are placed in the system. Publishing of the orders needs to be confirmed in the system.



Upload templates

Important notes

  • The first line of the XLS / CSV must contain the version number in the first column (no order!. Last version of the XLS / CSV file  is"v 1.4". Older versions are compatible but with a limited feature set

  • CSV file must be formatted in UTF-8 format and stored with column separator ";" 
  • Briefing text in HTML format in column 12 | L must be included (Failure to upload the briefing in HTML will result in your briefing being cut short, and writers will have problems meeting your requirements.)

 

File structure

Column  (no. | letter) - Description

  • 1 | A         Order Title
  • 2 | B         Keywords (optional field, separate with "|" when necessary )
  • 3 | C         Your Reference-ID (optional, leave balnk if you have none)
  • 4 | D         Minimum word count (Minimum 30)
  • 5 | E         Maximum word count
  • 6 | F         Minimum keyword density
  • 7 | G         Maximum keyword density (Maximum 40)
  • 8 | H         Quality level (see table below)
  • 9 | I          Time frame in days (1-10 days)
  • 10 | J       Text type ID (see table below)
  • 11 | K       Text topic ID (see table below)
  • 12 | L       Writer Briefing (HTML for formatting must be used; tags are allowed: br, p, span, address, pre, h1,                  h2, h3, h4, h5, h6, strong, em, ul, ol, li)
  • 13 | M       URL. Give an URL to the webpage or to the product so writers can see what they are writing about
  • 14 | N       Keyword counting: 0 = relative (in % of total words), 1 = absolute number

Text type ID: (CSV column 10 / J)

  • 1503 : Advertising text
  • 1701 : B2B text
  • 1702 : Blog
  • 1488 : Brand description
  • 1486 : Category description
  • 1562: Destination description
  • 1543 : E-books & whitepaper 
  • 1381 : Guidebooks & how-to texts
  • 1380 : Lexicon & glossary
  • 1493 : Other
  • 1484 : Promotions & offers
  • 1483 : Portraits & profiles
  • 1480 : Press release
  • 1487 : Product descriptions
  • 1492 : Rewriting
  • 1491 : Transcreation 

Text topic ID: (CSV column 11 / K)

  • 1563 : Accomodations
  • 1580 : Adult content
  • 1526 : Apparel & accessoires
  • 1463 : Cars & trucks
  • 1522 : Cosmetics & Beauty
  • 1420 : Education & culture 
  • 1546 : Electronics & software 
  • 1600 : Energy production 
  • 1402 : Finance & insurance
  • 1301 : Fitness & sports 
  • 1322 : Food, drinks & cooking
  • 1523 : Furniture & decoration
  • 1481 : Gaming & gambling
  • 1524 : Gardening & FYI 
  • 1528 : Health & wellness
  • 1541 : Internet & programming 
  • 1441 : Law
  • 1323 : Luxury goods 
  • 1527 : Music, TV series, movies 
  • 1485 : Online & mobile marketing 
  • 1700 : Other
  • 1561 : Places of interest
  • 1461 : Pets & animals 
  • 1560 : Travelling

Quality Level IDs (CSV column 8 / H)

  • 110 = Junior Linguist  
  • 120 = Linguist    
  • 130 = Senior Linguist
  • 140 = Expert Linguist
  • 150 = Technical expert Linguist