Using the Reports endpoint, you can replicate the custom metric feature in the Affluent UI by passing an object as a metric as oppose to a metric name.

You will need the following fields:

  • alias: Specify the name you want to give the custom metric (this is how it will be labelled in the response). Note, it must start with the prefix custom_.
  • aggregation: Specify how you want to aggregate your metric(s). All the possible values are
    [ SUM, MAX, AVG, MIN ]
  • calculation: An object containing your operator and your operands.

Note, the possible operator values are +, -, *, and /.

Here's an example of how you could request a custom metric that represents the Net number of Actions driven by New Customers:

"metrics": [
    {
      "alias": "custom_new_actions", // prefix `custom_` is required!
      "aggregation": "SUM",
      "calculation": {
        "operator": "+",
        "operands": [
          {
            "metric": "actionCountNet",
            "filters": {
              "operator": "AND",
              "statements": [
                {
                  "category": "repeatCustomer",
                  "match": "equals",
                  "values": [
                    "FALSE"
                  ]
                }
              ]
            }
          }
        ]
      }
    }
  ]