Instances Downstream DataFeed

In the data feeds every line is equal to one server call. So one row would equal one instance of an evar.

The "evar" column is populated when an evar fires, the "post_evar" column is populated when an evar fires or has a persisted value.

So if you want to count the number of times for it firing, look at the number of rows with the "evar" value, if you want to count all occurrences, count the "post_evar". I would do something like this

For evar instances (when it actually fires)

Select 

evar,

count(distinct concat(post_visid_high,post_visid_low,visit_num,first_hit_time_gmt,visit_page_num) as evar_instances

from

data_feed_table

For evar occurrences (every time the value fires and/or persists)

Select 

post_evar,

count(distinct concat(post_visid_high,post_visid_low,visit_num,first_hit_time_gmt,visit_page_num) as evar_occurrances

from

data_feed_table

These will show you all the instances/occurrences for each value in the evar or post_evar. The count and concatenation is what identifies a unique row/hit.

The Instances of an eVar are also passed in the event_list / post_event_list...

Instance of eVar1 is "100" in the event list.

100 Instance of eVar1
101 Instance of eVar2
102 Instance of eVar3
103 Instance of eVar4
104 Instance of eVar5
105 Instance of eVar6
106 Instance of eVar7
...
199 Instance of eVar100
10000 Instance of eVar101
10001 Instance of eVar102
10002 Instance of eVar103

---

This would probably be a lot easier than trying to replicate the logic with a count distinct....