Using extracts/FormSubmission.aspx

TSL Ping Tree > Page Usage

Using extracts/FormSubmission.aspx

This article explains how to extract data for the Form Submission (a.k.a. Submit) event.  The extract file produced is in Comma Separated Value (CSV) format.  CSV is a popular text-based file format which can be imported by most spreadsheet and database software and can be opened in any editor that supports text based file formats.

TSL Ping Tree has an event driven architecture.  When a visit begins, for example, a Click event is raised and certain tracking information is captured.  When a lead is posted, a Form Submission (a.k.a. Submit) event is raised; this is where data items such as the name and email address of the lead are captured.

The Extracts menu lists all of the supported events.  Each option from that menu presents a web page for extracting data for the selected event.

Query Criteria

Select a time zone and enter a From and a To date.  The From date is inclusive while the To date is exclusive.  For example, to extract a single day's worth of data select that date for the From date and the following date for the To date.

Next select a Ping Tree.  Form submission extracts are limited to a single Ping Tree at a time.

Next enter the number of minutes that you wish to consider a redirect as valid.

As soon as you enter both a From and To date, and if you change a From or To date, the Filename field will automatically change to "FormSubmit_FromDate-ToDate.csv" e.g. "FormSubmit_20120101-20120201.csv".  You may change the Filename before clicking the Create Extract button.

Extract File Contents

Field Description
SubmitDateTime_Time_Zone The date and time that the event was raised down the the second.
Millseconds How many milliseconds the system took to process this event.
SubmitGuid A Globally Unique IDentifier (GUID) -based internal unique identifier for the event.
IpAddress The IP Address (v4) of the HTTP request that raised this event.
BrowserIpAddress The unverified value of the Visitor/Browser IP Address (ip) parameter.  Only IP v4 is supported.
Referrer The value of the HTTP "REFERER" (sic) header field for the HTTP request that raised this event.  Browsers and proxy servers control whether this URL is set and if so what URL is supplied.
GeneralErrors Any system errors encountered when this event was raised.  Each error message is separated by a pipe symbol, |.  If a pipe symbol is part of the message itself (unlikely but possible) then it will be escaped by using the doubling technique... so each | becomes ||.
FieldErrors Any Form Field specific errors encountered when this event was raised.  Each error message is separated by a pipe symbol, |.  If a pipe symbol is part of the message itself (unlikely but possible) then it will be escaped by using the doubling technique... so each | becomes ||.
InternalMessages Any system warnings produced when this event was raised.  Each warning message is separated by a pipe symbol, |.  If a pipe symbol is part of the message itself (unlikely but possible) then it will be escaped by using the doubling technique... so each | becomes ||.
PingTreeUid An integer-based globally unique identifier for the associated Ping Tree.
Disposition An integer value for the outcome of this event.
DispositionDescription A description of the Disposition integer value for the outcome of this event. DispositionDescription manifests as the XML tag value when using the XML response type where Accept and Decline manifest as values Accept and Decline, respectively, while Decline As Error manifests as Error, and on Error any FieldErrors and/or GeneralErrors will be returned to the caller in the XML response.
RedirectUrl The Redirect URL produced by this event, if any.
RedirectCounts TRUE/FALSE: Did the system track a redirect for the Redirect URL within the allowed timeframe? TRUE means that a redirect was tracked within the allowed time frame. When you requested the extract you were able to specify how many minutes you were willing to allow for a redirect to occur to count it as valid. FALSE wither means that no redirect attempt has been captured thus far or that it was captured but that it occured after the allowed number of minutes. To tell which it is if there is no RedirectDateTime_Time_Zone value then no redirect was ever tracked; if there is a date/time value then a redirect was tracked but it was too late.
RedirectDateTime_Time_Zone The date/time the system first tracked a redirect for the Redirect URL, if any.
RawHttpRequestGuid A Globally Unique IDentifier (GUID) -based internal unique identifier for the HTTP request that raised this event.
ClickId An integer-based unique identifier for the associated Click.
SiteId The value of the SiteId (s) visit tracking parameter when the associated Click event was raised.
AffiliateId The value of the AffiliateId (a) visit tracking parameter when the associated Click event was raised.
PromotionId The value of the PromotionId (p) visit tracking parameter when the associated Click event was raised.
SubId1 The value of the SubId1 (s1) visit tracking parameter when the associated Click event was raised.
SubId2 The value of the SubId2 (s2) visit tracking parameter when the associated Click event was raised.
SubId3 The value of the SubId3 (s3) visit tracking parameter when the associated Click event was raised.
one or more Form Fields The remaining fields for this extract match the Form Fields for the Form attached to the specified Ping Tree.  This is how lead data can be extracted.

keywords: list management, download, downloads, leads