GroupStatisticData / GroupStatisticDataAggregate
These objects make it possible to obtain pre-calculated statistics on the histories of groups. These statistics are based on event histories AdEvent
- GroupStatisticData: gives statistics on a daily basis
- GroupStatisticDataAggregate: gives the cumulative statistics on a daily basis (since the creation of the account)
general fields
general data
id
Adelya Internal object ID
dateCreate
Creation date of this object
datetime
dateUpdate
When was the last update of this object
datetime
idExternal
The external reference
group
On which group thoses datas were created ?
see Group
globalGroup
See Group
date
date of this object
group activity
group statistics
nbgroup
Number of sub-group
nblogin
Number of login
addCA
addCA statistics
nbaddca
Number of addCA
nbPositiveAddCA
Number of positive addCA values
nbNegativeAddCA
Number of negative addCA values
sumaddca
Sum of addCA values
sumPositiveAddCA
Sum of positive addCA values
sumNegativeAddCA
Sum of negative addCA values
addCredit
addCredit statistics
nbaddcredit
Number of addCredit
nbPositiveAddCredit
Number of positive addCredit values
nbNegativeAddCredit
Number of negative addCredit values
sumaddcredit
Sum of addCredit values
sumPositiveAddCredit
Sum of positive addCredit values
sumNegativeAddCredit
Sum of negative addCredit values
addPoint
addPoint statistics
nbaddpoint
Number of addPoint
nbPositiveAddPoint
Number of negative addPoint values
nbNegativeAddPoint
Number of negative addPoint values
sumaddpoint
Sum of addPoint values
sumPositiveAddPoint
Sum of positive addPoint values
sumNegativeAddPoint
Sum of negative addPoint values
others events
others events statistics
nborder
Number of Order
sumorder
Sum of order values
resa
Number of reservation
usedcoupon
Number of coupon usage
renew
Number of Renew
coupon
Number of generated coupons
badge
Number of badgeage event
message
Number of message
nbquizzsession
Number of QuizzSession
nbunsubscribe
Number of unsubscribe events
members
members statistics
nbclient
Number of customers evolution
nbprospect
Number of prospects evolution
nbother
Number of others clients evolution
nbcardholder
Number of card holders
nbemail
Number of email holders
nbmobile
Number of mobile holders
nboptinemail
Number of e-mail opt-in holders
nboptinaddress
Number of postal address opt-in holders
nboptinmobile
Number of mobile opt-in holders
nbaddress
Number of postal address holders
Example
Get total statistics on a date period
{
"GroupStatisticDataAggregate": {
"date_gt": "2021-01-01",
"date_lt": "2021-02-01"
}
}
Example
Get statistics data for a given group having at least 10 coupons used (forget others dates with less than 10)
{
"GroupStatisticData": {
"usedcoupon_ge": "10",
{
"group":{
"idExternal":"MY_FOCUS_GROUP"
}
}
}
}