Recent pages

Edit
page

New
page

Print
page
Page last modified 09:14, 19 May 2011 by Admin
2
Redirect
Page Notifications Off
Documentation Wiki > ExactTarget > Interactions > Activities > Data Extract Activity > Extract Types > Tracking Extract > Tracking Extract Output > ClickImpression

ClickImpression

From $1

    Table of contents
    1. 1. Description
    2. 2. Output Types
    3. 3. Columns
      1. 3.1. ClientID
        1. 3.1.1. Possible Values
        2. 3.1.2.
        3. 3.1.3. Data Type
        4. 3.1.4.
        5. 3.1.5. Length
        6. 3.1.6.
      2. 3.2. SendID
        1. 3.2.1. Data Type
        2. 3.2.2.
        3. 3.2.3. Length
        4. 3.2.4.
      3. 3.3. SubscriberKey
        1. 3.3.1. Data Type
        2. 3.3.2.
        3. 3.3.3. Length
        4. 3.3.4.
      4. 3.4. EmailAddress
        1. 3.4.1. Data Type
        2. 3.4.2.
        3. 3.4.3. Length
        4. 3.4.4.
      5. 3.5. SubscriberID
        1. 3.5.1. Data Type
        2. 3.5.2.
        3. 3.5.3. Length
        4. 3.5.4.
      6. 3.6. ListID
        1. 3.6.1. Data Type
        2. 3.6.2.
        3. 3.6.3. Length
        4. 3.6.4.
      7. 3.7. EventDate
        1. 3.7.1. Data Type
        2. 3.7.2.
        3. 3.7.3. Length
      8. 3.8. EventType
        1. 3.8.1. Data Type
        2. 3.8.2.
        3. 3.8.3. Length
        4. 3.8.4.
      9. 3.9. SendURLID
        1. 3.9.1. Data Type
        2. 3.9.2.
        3. 3.9.3. Length
        4. 3.9.4.
      10. 3.10. URLID
        1. 3.10.1. Data Type
        2. 3.10.2.
        3. 3.10.3. Length
        4. 3.10.4.
      11. 3.11. URL
        1. 3.11.1. Data Type
        2. 3.11.2.
        3. 3.11.3. Length
        4. 3.11.4.
      12. 3.12. Alias
        1. 3.12.1. Data Type
        2. 3.12.2.
        3. 3.12.3. Length
        4. 3.12.4.
      13. 3.13. BatchID
        1. 3.13.1. Sample Data
        2. 3.13.2.
        3. 3.13.3. Data Type
        4. 3.13.4.
        5. 3.13.5. Length
        6. 3.13.6.
      14. 3.14. TriggeredSendExternalKey
        1. 3.14.1. Data Type
        2. 3.14.2.
        3. 3.14.3. Length
        4. 3.14.4.
      15. 3.15. ImpressionRegionName
        1. 3.15.1. Data Type
        2. 3.15.2. Length
    4. 4. Schema Relationship

    Description

    The click event extract file shows all of the instances of a link in an email being clicked occuring within the specified date range. The file also includes the impression region name associated with the click event. The events in this report can be related to all sends for subscribers on a list or related to a particular send.

    Output Types

    • CSV
    • TAB
    • XML

    Columns

    ClientID

    The ExactTarget account identifier associated with attribute set.

    Possible Values

    -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    SendID

    The ExactTarget identifier associated to an email send.

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    SubscriberKey

    The customer-specified subscriber unique identifier associated with attribute set. By default, the value is the same as EmailAddress.

    Data Type

    String

    Length

    100

    EmailAddress

    The subscriber email address identifier associated with attribute set.

    Data Type

    String

    Length

    100

    SubscriberID

    The ExactTarget-generated subscriber unique identifier associated with attribute set.

    SubscriberID relates to the Subscriber's SubscriberID column.

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    ListID

    The ExactTarget identifier for the list that the job was sent to.

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    EventDate

    The date the click event occurred.

    Data Type

    datetime

    Length

    EventType

    Identifies the event type.  For this extract, this field contains Click.

    Data Type

    String

    Length

    6

    SendURLID

    A unique identifier for the individual URL in a send.

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    URLID

    Contains a value used by the application database to identify the target URL of the link.

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    URL

    Contains the target URL of the link.

    Data Type

    String

    Length

    4000

    Alias

    Contains the value in the Alias attribute of the link.

    Data Type

    String

    Length

    500

    BatchID

    Identifies the batch associated with a triggered email send event. This value defaults to 0 for a marketing list send.

    Sample Data

    SendID,EventDate,SubscriberKey,EmailAddress,TriggeredSendExternalKey,BatchId
    1234,1/2/2009,"dmccrory@example.com","dmccrory@example.com","Coupon",1
    1234,1/2/2009,"dmccrory@example.com","dmccrory@example.com","Coupon",2
    1238,1/10/2009,"dmccrory@example.com","dmccrory@example.com","Coupon",1

    Data Type

    Number

    Length

    Maximum Length (Big Integer)

    TriggeredSendExternalKey

    The external key associated to a triggered send definition if the bounce resulted from a triggered send request.

    Data Type

    String

    Length

    100

    ImpressionRegionName

    The name of the impression region associated with the click impression event.

    Data Type

    String

    Length

    60

    Schema Relationship

    sr.png

    This page was last updated by Josh Cloud on Thu, 19 May 2011 13:14:59 GMT.

    If you're having an application issue, please contact Global Support. To send Josh direct feedback, fill out the form below:

    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 7520 backwards:
       
    Tags: (Edit tags)
    • No tags
    Attach file or image
    Files (2)
    FileSizeDateAttached by 
     ClickImpressionSchema.png
    No description
    		27.62 kB08:45, 27 Aug 2009AdminActions
     sr.png
    No description
    		132.98 kB09:14, 19 May 2011AdminActions
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin