Example event reporting
In the following example, suppose you have a Purchase Event that records the total value of the products that were purchased. In this case, price is the event value.
You could then specify a report group to record the following dimensions:
- Membership Type
- Credit Card
- Product
- Price (event value)
Suppose the recorded purchases for a day look like the following:
Membership Type | Credit Card | Product | Price |
---|---|---|---|
Bronze | Amex | Plane | 72 |
Bronze | Disc | Plane | 72 |
Gold | Amex | Car | 24 |
Gold | Visa | Boat | 45 |
Gold | Visa | Car | 32 |
Silver | Amex | Boat | 43 |
Depending on how you configured your report group, you may be able
to perform additional segment analysis by examining the purchases
by Gold members who used Visa cards. Since you specified that the
dimensions Membership Type, Credit Card, and Product are to be recorded
in the same report group with the value price, you can segment the
data for further analysis. For example, you can examine just the purchases
where Membership Type = Gold
.
Membership Type | Price | Credit Card | Price | Product | Price |
---|---|---|---|---|---|
Bronze | 72 | Amex | 72 | Plane | 72 |
Bronze | 72 | Disc | 72 | Plane | 72 |
Gold | 24 | Amex | 24 | car | 24 |
Gold | 45 | Visa | 45 | boat | 45 |
Gold | 32 | Visa | 32 | car | 32 |
Silver | 43 | Amex | 43 | boat | 43 |
However, if you choose to record those dimensions but did not include them in the same report group, you could not see the purchases of Gold members who used Visa cards.
- You could see the purchases of Gold members, or the purchases by Visa cards, but not both together.
- Data for each report group is stored in individual tables. Since the data for two unconnected report groups is stored in different tables, there is no common key to specify how the data in one table is associated with data in the other table.