NewPath-Consulting/warm

Add several metrics to the contacts endpoint

Opened this issue · 1 comments

As it currently stands the contacts endpoint doesn't return any metrics. It would be really useful to have some default metrics start to trickle into the contacts endpoint. That way the default usage of this endpoint in the data source will not require the creation of custom metrics and they can be used out of the box.

In particular these 5 metrics:

Active Member?
Calculated as follows:

CASE 
WHEN IsActiveMember = TRUE THEN 1
ELSE 0
END

Lapsed Member?

CASE 
WHEN IsLapsedMember = TRUE THEN 1
ELSE 0
END

Pending New Member?

CASE 
WHEN IsPendingNewMember = TRUE THEN 1
ELSE 0
END

Pending Renewal?

CASE 
WHEN IsPendingRenewalMember = TRUE THEN 1
ELSE 0
END

Pending Level Change?

CASE 
WHEN Status = "PendingUpgrade" THEN 1
ELSE 0
END

This will make reports like this easier to make out of the box:

membership summary report