Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Two different eVars with different values report the same value?

Avatar

Level 1

The query string for these evars (v1 & v2) have different values - but when a report is created they are equal?

Query Params

AQB: 1

ndh: 1

pf: 1

t: 6/8/2018 14:7:27 4 300

ts: 1536260847

fid: 1647C7AE5DBE668C-39546B5D40575ED0

ce: UTF-8

ns: MY-COMPANY

pageName: /pin

g: http://localhost:53183/#/login

cc: CAD

v1: 1

v2: 3

v8: 989

pe: lnk_o

pev2: ENVIRONMENT: BEGIN EVENT

s: 473x940

c: 24

j: 1.6

v: N

k: Y

bw: 473

bh: 940

AQE: 1

Here's what a report looks like when we try to Breakdown by evar8, with metrics from evar1 and evar2

(evar8)(Instance of evar1)(Instance of evar2)
1212
10099
16500
2101212
35500
44300
49600
67411
96200
96433
98711
9891111
99100

I dont expect evar1 and evar2 to have the same values for evar 8

Hope this makes sense.

1 Accepted Solution

Avatar

Correct answer by
Level 5

So each eVar is its own dimension. You're looking for a report with three dimensions, so a simple table wouldn't do. In this example I've used three different dimensions: Hit Depth, Day and Hour of Day. So you'd have to break down evar8 by evar1, and break down those evar1's by evar 2.

As far as the metric goes you could use Instance of evar1 and Instance of evar 2, which would show you how many times those evars were set to those values.

1566433_pastedImage_0.png

View solution in original post

3 Replies

Avatar

Level 5

It looks like that report is giving you the instances for evars 1 and 2, not their values. This table is telling you that when evar8 was set to 989, evars 1 and 2 were set 11 times, but it doesn't tell you what they were set to. Instances measures the number of times that a value was set for a variable. Documentation: Instances

To see the values of evars 1 and 2 when evar8 was 989, you would break down the evar8 dimension by the evar1 and evar2 dimensions.

Avatar

Level 1

To see the values of evars 1 and 2 when evar8 was 989, you would break down the evar8 dimension by the evar1 and evar2 dimensions.

So maybe my reporting is wrong? When you say dimension - do you mean participation?

In Data Warehouse I can Breakdown by evar 8, then have Metrics set by Instances or Participation

I can also have multiple Breakdowns..

How would i report on the values of evar1 and evar2 by evar 8?

Avatar

Correct answer by
Level 5

So each eVar is its own dimension. You're looking for a report with three dimensions, so a simple table wouldn't do. In this example I've used three different dimensions: Hit Depth, Day and Hour of Day. So you'd have to break down evar8 by evar1, and break down those evar1's by evar 2.

As far as the metric goes you could use Instance of evar1 and Instance of evar 2, which would show you how many times those evars were set to those values.

1566433_pastedImage_0.png