The OLX Ad Copy Import allows for loading the connected projected revenue and call statistics for a given group of media buys into the OrderLogix application for reporting purposes. File Format: ASCII text. The file must contain one line per addition, with each field enclosed in double quotes and comma separated, ending with a Carriage Return (↵) <CR>. All unused fields will be left blank and remain separated by a single comma. File Naming: <Organization Identifier><YYYYMMDD>.csv Import Definitions: #
| Field Name | Req. | Type | Max | Field Description | 1 | NAME | YES | Alpha | 255 | Ad copy name (provided or generated) | 2 | CAMPAIGN | YES | Alpha | 255 | Valid campaign name in OLX | 3 | MEDIA TYPE | YES | Alpha | 255 | Valid media type in OLX (ex. TV, RADIO) | 4 | AD TYPE | YES | Alpha | 255 | Valid ad type in OLX (ex. Infomercial) | 5 | DURATION | NO | Numeric | 6 | Ad copy duration (Decimal, ex. 0000.00) | 6 | CALLS PER K | NO | Numeric | 6 | Calls per $1,000 (Decimal, ex. 0000.00) | 7 | TRICKLE % | NO | Numeric | 6 | Trickle percent (Decimal, ex. 0000.00) | 8 | TRICKLE HRS | NO | Numeric | 6 | Trickle hours (Decimal, ex. 0000.00) | 9 | ORD CLOSE | NO | Numeric | 6 | Order close rate (Decimal, ex. 0000.00) | 10 | AVG TICKET | NO | Numeric | 6 | Average ticket (Decimal, ex. 0000.00) | 11 | AVG TALK TIME | NO | Numeric | 8 | Average talk time (Decimal, ex. 0000.0000) | 12 | RESERVED | | | 0 | Reserved, leave blank, separated by comma | 13 | RESERVED | | | 0 | Reserved, leave blank, separated by comma | 14 | MAX STATION DISTANCE | NO | Numeric | 6 | Maximum distance allowed between stations |
The attached documentation includes the OLX Ad Import Spec, Template, and Example. |