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.  


Download CSV example file (v 1.4)

Download XLS exmpale file (v 1.4)


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.)

 

XLS / CSV file structure 


Column  (no. | letter) 

Description
1 | AOrder Title
2 | BKeywords (optional field, separate with "|" when necessary )
3 | CYour Reference-ID (optional, leave balnk if you have none)
4 | DMinimum word count (Minimum 30)
5 | EMaximum word count
6 | FMinimum keyword density
7 | GMaximum keyword density (Maximum 40)
8 | HQuality level (see table below)
9 | ITime frame in days (1-10 days)
10 | JText type ID (see table below)
11 | KText topic ID (see table below)
12 | LWriter 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 | MURL. 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


IDs

Text type ID: (CSV column 10 / J)

  • 1493 : Anderer Texttyp 
  • 1484 : Angebote & Promotionen 
  • 1701 : B2B Text 
  • 1702 : Blogbeitrag 
  • 1543 : E-books, Konzepte, Studien 
  • 1486 : Kategoriebeschreibung 
  • 1380 : Lexikon & Glossar 
  • 1488 : Markenbeschreibung
  • 1492 : Neu formulieren 
  • 1483 : Portraits & Profile 
  • 1480 : Pressemitteilung 
  • 1487 : Produktbeschreibung 
  • 1381 : Ratgeber 
  • 1491 : Transcreation/freie Übersetzung 
  • 1503 : Werbetext 
  • 1562 : Zielgebietsbeschreibung  

Text topic ID: (CSV column 11 / K)

  • 1700 : Andere Kategorie 
  • 1463 : Autos & LKWs 
  • 1526 : Bekleidung & Accessoires 
  • 1420 : Bildung, Ausbildung & Kultur 
  • 1546 : Elektronik & Software 
  • 1600 : Energiegewinnung 
  • 1580 : Erotische Inhalte 
  • 1322 : Essen, Trinken & Kochen 
  • 1402 : Finanzthemen 
  • 1301 : Fitness & Sport 
  • 1524 : Garten & Heimwerken 
  • 1528 : Gesundheit & Wellness
  • 1563 : Hotels & Ferienwohnungen 
  • 1541 : Internet & Programmierung 
  • 1522 : Kosmetik & Schönheit 
  • 1323 : Luxusprodukte 
  • 1523 : Möbel & Dekoration 
  • 1527 : Musik, TV, Serien, Filme 
  • 1485 : Online & Mobile Marketing 
  • 1441 : Rechtsthemen 
  • 1560 : Reisen 
  • 1561 : Sehenswürdigkeiten 
  • 1481 : Spiele & Glückspiel 
  • 1461 : Tiere & Haustiere  

Quality Level IDs (CSV column 8 / H)

  • 10 = 4 simple
  • 15 = 4+ budget
  • 17 = 5 good
  • 20 = 5+ professional
  • 25 = 6 premium
  • 30 = 6+ excellent