Creating Visit Segment in SQL

Hi @dineshrkumar,

So you want the visit to include event3 and event35 and eVar13 to exist? Do all of these need to be on the same hit? Or any time in the Visit?

Examples:

Scenario 1:

• Page A
  • eVar13 set to "something"
  • eVar13 instance counted
• Page B
  • eVar13 retains value "something"
  • eVar13 instance is not counted
• Page C
  • eVar13 retains value "something"
  • eVar13 instance is not counted
  • event3 counted
• Page D
  • eVar13 retains value "something"
  • eVar13 instance is not counted
  • event35 counted

Scenario 2:

• Page A
• Page B
• Page C
  • eVar13 = "something"
  • eVar13 instance counted
  • event3 counted
  • event35 counted
• Page D
  • eVar13 retains value "something"
  • eVar13 instance is not counted

Scenario 3:

• Page A
• Page B
  • eVar13 = "something"
  • eVar13 instance counted
• Page C
  • eVar13 retains value "something"
  • eVar13 instance is not counted
  • event3 counted
  • event35 counted
• Page D
  • eVar13 retains value "something"
  • eVar13 instance is not counted

Also, depending on the attribution settings of eVar13 (if it's set to something greater than Visit, maybe it's set to Week or Month, etc), you might have:

Scenario 4:

Visit 1

• Page A
• Page B
  • eVar13 set to "something"
  • eVar13 instance counted
• Page C
  • eVar13 retains value "something"
  • eVar13 instance is not counted

Visit 2

• Page D
  • eVar13 retains value "something"
  • eVar13 instance is not counted
• Page E
  • eVar13 retains value "something"
  • eVar13 instance is not counted
  • event3 counted
• Page F
  • eVar13 retains value "something"
  • eVar13 instance is not counted
  • event35 counted

So in all the scenarios the visit contains all three, but only scenario 2 has them on the same hit.... scenario 3 has a value and the events on the same hit (but not the instance), and scenario 4, has the value of eVar13 included, but not the instance (the actual setting of the value) and the two events on different hits within the visit.

Your sample segment would return scenarios 1 and 2 and 3, but would not return Visit 2 in Scenario 3, since there is no "instance" being counted in the visit.

If the same hit matters, and it needs to be the instance of the eVar, as in you only want scenario 2 to be returned, you can use:

VISIT [

    HIT Container [

        event3 exists

        AND

        event35 exists

        AND

        eVar13 Instance exists

    ]

]

If you need to return visits where your eVar has a value (but not necessarily the instance), and the events are on the same hit, so scenarios 2 and 3, you can use:

VISIT [

    HIT Container [

        event3 exists

        AND

        event35 exists

        AND

        eVar13 exists

    ]

]

(note this is very similar to above, but I am not looking at the instance, only at if eVar13 has a value.)

If you are looking for Visits that have a value in eVar13 (but not necessarily the instance during the visit), but the three don't have to be on the same hit... so returning Scenarios 1, 2, 3 and 4 (visit 2), then the segment will be similar to yours, but looking at the value of eVar13 instead of the instance:

VISIT [

    event3 exists

    AND

    event35 exists

    AND

    eVar13 exists

]

I hope this helps.