gistfile1.py

def get_alert_info():
    metrics_list = {
        'users_feed': {
            'alias': 'users_feed',
            'formula': 'uniqExact(user_id)',
            'metric_name': 'Users Feed',
            'table_name': 'simulator.feed_actions'
        },
        'likes': {
            'alias': 'likes',
            'formula': "countIf(user_id, action='like')",
            'metric_name': 'Likes',
            'table_name': 'simulator.feed_actions'
        },
        'views': {
            'alias': 'views',
            'formula': "countIf(user_id, action='view')",
            'metric_name': 'Views',
            'table_name': 'simulator.feed_actions'
        },
        'ctr': {
            'alias': 'ctr',
            'formula': "countIf(user_id, action='like') / countIf(user_id, action='view')",
            'metric_name': 'CTR',
            'table_name': 'simulator.feed_actions'
        },
        'lpu': {
            'alias': 'lpu',
            'formula': "countIf(user_id, action='like') / uniqExact(user_id)",
            'metric_name': 'Likes per user',
            'table_name': 'simulator.feed_actions'
        },
        'vpu': {
            'alias': 'vpu',
            'formula': "countIf(user_id, action='view') / uniqExact(user_id)",
            'metric_name': 'Views per user',
            'table_name': 'simulator.feed_actions'
        },
        'users_msg': {
            'alias': 'users_msg',
            'formula': 'uniqExact(user_id)',
            'metric_name': 'Users Messenger',
            'table_name': 'simulator.message_actions'
        },
        'messages': {
            'alias': 'messages',
            'formula': 'count(user_id)',
            'metric_name': 'Messages',
            'table_name': 'simulator.message_actions'
        },
        'mpu': {
            'alias': 'mpu',
            'formula': 'count(user_id) / uniqExact(user_id)',
            'metric_name': 'Messages per user',
            'table_name': 'simulator.message_actions'
        },
    }
    group_by_slices_list = {
        'os': {
            'alias': 'os',
            'group_levels': ['iOS', 'Android'],
            'formula': 'os',
        }
    }
    where_expression_template = ''' 
         toDate(time) in (today(), today() - 1, today() - 7) and formatDateTime(time, '%R') >= '01:00' '''

    responsible_users = {
        "metrics" : {"users_msg": "@zmey5656"},
        "groups" : {"os": "@zmey5656"}
    }
    alert_plots = {
        'total': {
            'users_feed': 'http://superset.lab.karpov.courses/r/27',
            'likes': 'http://superset.lab.karpov.courses/r/30',
            'views': 'http://superset.lab.karpov.courses/r/33',
            'ctr': 'http://superset.lab.karpov.courses/r/36',
            'vpu': 'http://superset.lab.karpov.courses/r/39',
            'lpu': 'http://superset.lab.karpov.courses/r/42',
            'users_msg': 'http://superset.lab.karpov.courses/r/45',
            'messages': 'http://superset.lab.karpov.courses/r/50',
            'mpu': 'http://superset.lab.karpov.courses/r/55'
        },
        'os': {
            'users_feed': 'http://superset.lab.karpov.courses/r/28',
            'likes': 'http://superset.lab.karpov.courses/r/32',
            'views': 'http://superset.lab.karpov.courses/r/35',
            'ctr': 'http://superset.lab.karpov.courses/r/38',
            'vpu': 'http://superset.lab.karpov.courses/r/41',
            'lpu': 'http://superset.lab.karpov.courses/r/44',
            'users_msg': 'http://superset.lab.karpov.courses/r/46',
            'messages': 'http://superset.lab.karpov.courses/r/52',
            'mpu': 'http://superset.lab.karpov.courses/r/54'
        }
    }
    return metrics_list, group_by_slices_list, where_expression_template, alert_plots, responsible_users