Кейс 1
{
  "name": "Пациенты у которых сегодня день рождения.",
  "database_id": 8308,
  "conditions": {
    "include": {
      "patients": {
        "birthday_days_from": 0,
        "birthday_days_to": 0
    }
    }
  }
}

Кейс 2
{
  "name": "Напоминания о плановой профилактике",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -3,
        "days_to": -1,
        "status": ["arrived"],
        "service_ids": [1000,2000,3000]
    }
  }
}
}

Кейс 3
{
  "name": "Отслеживание динамики лечения после 3-х процедур",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "status": ["arrived"],
        "service_ids": [1000],
        "quantity_from": 3,
        "quanityt_to": 3
    }
  }
}
}

Кейс 4
{
  "name": "Потратили более 8000 и не платили последние 3 месяца",
  "database_id": 1000,
  "conditions": {
    "include": {
      "statistics": {
      "purchase_amount_from":8000
    }
  },
    "exclude":{
     "appointments":{
       "days_from": -90,
       "days_to":0,
       "status": ["arrived"]
     } 
    }
}
}

Кейс 5
{
  "name": "Активные за 6 мес, но без чистки зубов за 6 мес",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from":-180,
        "days_to":0,
        "status":["arrived"]
    }
  },
    "exclude":{
     "appointments":{
     "days_from":-180,
       "days_to":0,
       "status":["arrived"],
       "service_ids": [1000]
     } 
    }
}
}

Кейс 6
{
  "name": "Отменившие за сутки — скидка 5%",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from":-1,
        "days_to":0,
        "status":["canceled"]
    }
    }
  }
}

Кейс 7
{
  "name": "Отменившие 5-7 дней назад без повторной записи — скидка 10%",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from":-7,
        "days_to":-5,
        "status":["canceled"]
    }
  },
    "exclude":{
     "appointments":{
       "days_from": -5,
       "days_to": 0,
       "status": ["confirmed", "arrived"]
     } 
    }
}
}

Кейс 8
{
  "name": "Напоминание о профилактике у стоматолога",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -365,
        "days_to": -180,
        "status": ["arrived"],
        "speciality_ids": ["23000"]
    }
  },
    "exclude":{
     "appointments":{
       "days_from": -180,
        "days_to": 0,
        "status": ["confirmed", "arrived"],
        "speciality_ids": ["23000"]
     } 
    }
}
}

Кейс 9
{
  "name": "Чекап для возрастной группы 36-45",
  "database_id": 1000,
  "conditions": {
    "include": {
      "patients":{
        "age_group":["H"]
      },
      "appointments": {
        "days_from": -365,
        "days_to": -180,
        "status": ["arrived"]
    }
  },
    "exclude":{
     "appointments":{
       "days_from": -365,
        "days_to": 0,
        "status": ["arrived"],
        "service_ids": ["1000","2000"]
     } 
    }
}
}

Кейс 10
{
  "name": "День рождения — подарок именинникам",
  "database_id": 1000,
  "conditions": {
    "include": {
      "patients":{
        "birthday_days_from": 0,
        "birthday_days_to": 7
      },
      "appointments": {
        "days_from": -365,
        "days_to": 0,
        "status": ["arrived"]
    }
    }
  }
}

Кейс 11
{
  "name": "Был у терапевта, рекомендуем ортодонта",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -180,
        "days_to": 0,
        "status": ["arrived"],
        "speciality_ids":["1000"]
    }
  },
    "exclude":{
     "appointments":{
       "days_from": -365,
        "days_to": 0,
        "status": ["arrived"],
        "speciality_ids": ["2000"]
     } 
    }
}
}

Кейс 12
{
  "name": "Годовщина первого визита",
  "database_id": 1000,
  "conditions": {
    "include": {
      "patients":{
        "days_in_database_from":-380,
        "days_in_database_to": -350
      },
      "appointments": {
        "days_from": -365,
        "days_to": 0,
        "status": ["arrived"]
    }
  }
  }
}

Кейс 13
{
  "name": "Завершил курс — предложить поддерживающие процедуры",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -90,
        "days_to": 0,
        "status": ["arrived"],
        "service_ids": ["1000","2000","3000"],
        "quntity_from": 5
    }
  }
  }
}

Кейс 14
{
  "name": "Бросил курс лечения",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -120,
        "days_to": -30,
        "status": ["arrived"],
        "service_ids": ["1000","2000","3000"],
        "quntity_from": 3
    }
    },
    "exclude":{
     "appointments":{
       "days_from": -30,
        "days_to": 0,
        "status": ["arrived","confirmed"],
        "service_ids": ["1000","2000","3000"]
     } 
    }
}
}

Кейс 15
{
  "name": "VIP-клиенты — спецпредложение",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -365,
        "days_to": 0,
        "status": ["arrived"]
    },
      "statistics":{
        "bill_avg_from":15000,
        "purchase_amount_from":100000
      }
    }
  }
}

Кейс 16
{
  "name": "Забота на следующий день после визита",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -1,
        "days_to": -1,
        "status": ["arrived"]
    }
    }
  }
}

Кейс 17
{
  "name": "После удаления зуба мудрости — рекомендации",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -1,
        "days_to": -1,
        "status": ["arrived"],
        "service_ids":["1000"]
    }
    }
  }
}

Кейс 18
{
  "name": "Повторные пациенты сбор отзывов",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -1,
        "days_to": -1,
        "status": ["arrived"],
        "quantity_from":2
    }
    }
  }
}

Кейс 19
{
  "name": "Первый визит к врачу — видео-визитка",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": 1,
        "days_to": 2,
        "status": ["confirmed"],
        "doctor_ids": ["1000"],
        "quantity_from":1
    }
    }
  }


Кейс 20
{
  "name": "3-я процедура — опрос о динамике",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": 1,
        "days_to": 2,
        "status": ["confirmed"],
        "doctor_ids": ["1000"],
        "quantity_from":2
    }
    }
  }
}

Кейс 21
{
  "name": "Семейная программа — лояльные пациенты",
  "database_id": 8308,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -180,
        "days_to": 0,
        "status": ["arrived"],
        "quantity_from":3
    },
      "statistics":{
        "purchase_amount_from": 30000
      }
    }
  }
}

Кейс 22
{
  "name": "Подготовка к приему за 2 дня",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": 1,
        "days_to": 2,
        "status": ["confirmed"],
        "service_ids": ["1000", "2000"]
    }
    }
  }
}

Кейс 23
{
  "name": "Новая услуга информирование активных пациентов",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -365,
        "days_to": 0,
        "status": ["confirmed"],
        "speciality_ids": ["1000"]
    }
    },
    "exclude":{
      "appointments":{
        "days_from":-365,
        "days_to":0,
        "service_ids": ["1000"]
      }
    }
  }
}

Кейс 24
{
  "name": "8 марта поздравление",
  "database_id": 1000,
  "conditions": {
    "include": {
      "patients": {
        "gender": "female"
      },
      "appointments": {
        "days_from": -365,
        "days_to": 0,
        "status": ["arrived"]
    }
    }
  }
}

Кейс 25
{
  "name": "23 февраля поздравление",
  "database_id": 1000,
  "conditions": {
    "include": {
      "patients": {
        "gender": "male"
      },
      "appointments": {
        "days_from": -365,
        "days_to": 0,
        "status": ["arrived"]
    }
    }
  }
}

Кейс 26
{
  "name": "Первичные — напоминание с инструкцией",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": 1,
        "days_to": 2,
        "status": ["confirmed"],
        "quantity_to": 1
    }
    }
  }
}

Кейс 27
{
  "name": "Вторичные — короткое напоминание",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": 1,
        "days_to": 2,
        "status": ["confirmed"],
        "quantity_to": 2
    }
    }
  }
}

Кейс 28
{
  "name": "Реанимация — высокий LTV, не был 1-2 года",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -730,
        "days_to": -365,
        "status": ["arrived"]
    },
      "statistics":{
        "bill_avg_from":8000
      }
    },
    "exclude":{
      "appointments":{
        "days_from":-365,
        "days_to":0,
        "status":["arrived","confirmed"]
      }
    }
  }
}

Кейс 29
{
  "name": "Реанимация не был 2-3 года, был у стоматолога",
  "database_id": 1000,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -1095,
        "days_to": -730,
        "speciality_ids":["1000"]
    }
    },
    "exclude":{
      "appointments":{
        "days_from":-730,
        "days_to":0
      }
    }
  }
}

Кейс 30
{
  "name": "Нет записи на будущее после визита",
  "database_id": 8308,
  "conditions": {
    "include": {
      "appointments": {
        "days_from": -7,
        "days_to": -1,
        "status":["arrived"]
    }
    },
    "exclude":{
      "appointments":{
        "days_from":0,
        "days_to":90,
        "status":["confirmed"]
      }
    }
  }
}