Derive data impacted by events
If you have data impacted by an event , you can use calculated metrics to derive trended values for the duration of the event. For example, if you had an event that caused a 25% drop in data, you can use that as a multiplier in a calculated metric.
These steps work best when you understand the impact of an event, both from a segmentation and date comparison perspective. Make sure to follow Compare dates impacted by an event to previous ranges and Exclude specific dates in analysis before following this page.
- Create two segments for 'Affected days' and 'Exclude affected days', as outlined under Exclude specific dates in analysis .
- Navigate to Components > Calculated metrics .
- Click Add .
- Drag both of the above segments to the definition canvas. Change the operator between them to a + to sum them.
- Add the desired metric inside both segments. For example, you could use the 'Visits' metric.
- Click Add in the upper right of the 'Affected days' container, then click Static number . Set the static number to the percent that you want to offset your data, as outlined under Compare dates impacted by an event to previous ranges . In this example, the offset is 25%, or 1.25.
- Apply the "corrected" metric side-by-side in a trended freeform table. All days outside the event reflect their normal metric count, while all affected days use the multiplier offset.
- View the data in a line visualization to see the effect of your corrected metric.