KnowledgeBase - What is the Webtrends Enterprise Data Connector log file format?

What is the Webtrends Enterprise Data Connector log file format?

« Go Back
Webtrends On Demand

What is the Webtrends Enterprise Data Connector log file format?
The Webtrends Enterprise Data Connector (EDC) log file format, sometimes referred to as the Teradata log file format, is available as an alternative to the Webtrends W3C format used for Log File Delivery. A utility exists that can perform conversions on existing W3C format files, available via Professional Services.

The EDC format makes it is easier to import log file data into a data warehousing system using their loader function, and while the basic format is similar to Webtrends' log files, some differences exist:

    Some fields are not mapped from the W3C format.
    Field delimiter is a tab.
    By default there is no field header on the file.
    The File extension is .lta instead of .log

W3C format example:#
#Fields: date time c-ip cs-username cs-host cs-method cs-uri-stem cs-uri-query sc-status sc-bytes cs-version cs(User-Agent) cs(Cookie) cs(Referer) dcs-geo dcs-dns origin-id dcs-id
2013-06-24 16:00:00 - - GET /folder1/folder2/folder3/fileName.htm WT.vtid= 200 - - Mozilla/4.0+compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0;+.NET4.0C;+MALC) WEBTRENDS_ID=;+WT_ACCT= - cc=BR&ci=Porto+Alegre&cn=South+America&co=Comite+Gestor+Da+Internet+No+Brasil&cs=Brazil&nt=Broadband&rc=RS&rs=Rio+Grande+Do+Sul&tz=GMT%2D2 dcs-2013-06-24-16-00000-iaddcs02v dcsxxxxxxxxxxxxxxxxxxxxxx_xxxx

EDC format example:
2013-06-24 16:00:00 - - GET /folder1/folder2/folder3/fileName.htm WT.vtid= 200 - - Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0;+.NET4.0C;+MALC) WEBTRENDS_ID=;+WT_ACCT= - cc=BR&ci=Porto+Alegre&cn=South+America&co=Comite+Gestor+Da+Internet+No+Brasil&cs=Brazil&nt=Broadband&rc=RS&rs=Rio+Grande+Do+Sul&tz=GMT%2D2 dcsxxxxxxxxxxxxxxxxxxxxxx_xxxx        Yes                                       Hero Carousel Home                          1372089595     BR Porto+Alegre South+America Comite+Gestor+Da+Internet+No+Brasil Brazil        Broadband     RS Rio+Grande+Do+Sul  GMT%2D2   

The EDC log by default does not have a header. However, this can be set to contain a header by editing the wtlta.ini file and setting the following variable:


Note: The delimiter is tab by default however a space, or any other non-double-byte character, may be substituted in its place.
More Information
The following is a list of default parameters. Any Webtrends Parameter may be included however.
WT.acAd click
WT.adAd name
WT.bhBrowsing hour
WT.bsBrowser window size
WT.cdColor palette depth
WT.cg_nContent group name
WT.cg_sContent sub-group
WT.coWebtrends cookie
WT.co_aCustomer defineed cookie
WT.co_dWebtrends cookie (third party)
WT.co_fWebtrends cookie (first party)
WT.ctConnection type
WT.dcsvidWebtrends external visitor ID
WT.dlEvent type indicator (page view, downloads, etc)
WT.emEncoding method
WT.esClick based tracking
WT.fiFlash installed
WT.fvFlash version
WT.hdrHttp header
WT.hpHome page event
WT.joJava enabled
WT.jsJavascript enabled
WT.jvJava version
WT.leLanguage encoding
WT.mc_evMarketing campaign event type
WT.mc_idMarketing campaign ID
WT.mleMetalanguage encoding
WT.ossOnsite search terms
WT.oss_rOnsite search number of results
WT.piProduct attribute parameter
WT.pn_faProduct attribute parameter (family)
WT.pn_grProduct attribute parameter (group)
WT.pn_idProduct ID
WT.pn_maProduct attribute parameter (manufacturer)
WT.pn_scProduct attribute parameter (sub-catagory)
WT.pn_skuProduct sku
WT.pn_suProduct attribute parameter (supplier)
WT.rvRegistration event (registered visitor true)
WT.si_csConversion step event
WT.si_nScenario name
WT.si_pScenario step name
WT.si_xScenario step number
WT.slvSilverlight version
WT.spWT profile split parameter
WT.srScreen resolution
WT.srchPaid search indicator
WT.svlSmartView link
WT.tiPage title
WT.tspSmartView transition source
WT.ttpSmartView transition target page
WT.tuURL truncated
WT.tvWebtrends tag version
WT.tx_cartidTransaction cart ID
WT.tx_eTransaction event (purchase, add to cart, etc.)
WT.tx_iTransaction invoice
WT.tx_idTransaction invoice date
WT.tx_itTransaction invoice time
WT.tx_sTransaction subtotal
WT.tx_tTransaction total
WT.tx_uTransaction # of units
WT.tzBrowser time zone setting
WT.ulUser language
WT.vhseg_1Custom WT visitor history segment #1
WT.vhseg_2Custom WT visitor history segment #2
WT.vhseg_3Custom WT visitor history segment #3
WT.vhseg_4Custom WT visitor history segment #4
WT.vt_a_dVisitor history visit attributes
WT.vt_a_sVisitor history visit attributes
WT.vt_dVisitor history visit attributes
WT.vt_fVisitor history visit attributes
WT.vt_f_aVisitor history visit attributes
WT.vt_f_dVisitor history visit attributes
WT.vt_f_sVisitor history visit attributes
WT.vt_f_tlhWH 1st party cookie time last hit
WT.vt_f_tlvWH 1st party cookie time last visit
WT.vt_sWarehouse visit start time
WT.vt_sidWarehouse sessionID parameter
WT.vt_tlvWarehouse time of last visit


arArea code
ccCountry code
cnContinental region
csCountry string
dmDesignated marketing area
dmcDesignated marketing area city
dmsDesignated marketing area state
msMetropolitan statistical area
mcsMetropolitan statistical area city
mssMetropolitan statistical area state
ntNetwork type
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255