Calculating Week on Week customer retention using beast mode

Opeyemi
Opeyemi Member
in Magic ETL

Hi, i need assistance calculating week on week customer retention using a domo beastmode on a transaction dataset. Dataset appends new transaction based on the transaction date so a single customer has multiple rows of transaction distinguished by transaction data

Best Answer

  • trafalger
    trafalger Coach
    Answer ✓

    What fields do you have? Do you have customer start date and customer end date? You might have to do it in a dataflow, join it to a data dimension and you could calculate for each month whether a customer was active or not.

Answers

  • trafalger
    trafalger Coach
    Answer ✓

    What fields do you have? Do you have customer start date and customer end date? You might have to do it in a dataflow, join it to a data dimension and you could calculate for each month whether a customer was active or not.

Categories