Asosuy kontentga o’tish

Qidirish

Telegram Dashboard KPI Hisoblash Mantiqi

telegramkpi.jpg

Telegram dashboard Telegram aloqa samaradorligi uchun KPI kartalarini, grafiklarni va batafsil jadval metrikalarini ko‘rsatadi.

Rejalashtirilgan

Tanlangan hisobot davrida yuborish uchun rejalashtirilgan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Planned =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    'Distribution'[Communication_channel] = "telegram"
)

Hisoblash mantiqi

Ushbu o‘lchov aloqa kanali telegram bo‘lgan barcha tarqatish yozuvlarini hisoblaydi. Bu tanlangan davr va filtrlarga mos keladigan rejalashtirilgan Telegram xabarlari umumiy sonini ifodalaydi.

Yuborilgan

Yuborish jarayoniga kirgan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Sent =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DELIVERED", "BOUNCED", "DECLINED", "DEFERRED", "EXPIRED",
            "FAILED", "OLD", "REJECTED", "UNDELIVERABLE", "UNDELIVERED",
            "UNKNOWN", "ENQUEUED", "QUEUED", "SENT", "VISITED", "READ", "SEEN"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Hisoblash mantiqi

Ushbu o‘lchov yuborish jarayoniga kirganligini ko‘rsatadigan holatlarga ega bo‘lgan Telegram xabarlarini hisoblaydi. Bu muvaffaqiyatli ishlov berilgan va yetkazib berilmagan holatdagi xabarlarni o‘z ichiga oladi.

Yuborilgan %

Rejalashtirilgan Telegram xabarlarining yuborilgan foizini ko‘rsatadi.

DAX formulasi

Telegram Sent % =
[Telegram Sent] / [Telegram Planned]

Hisoblash mantiqi

Ushbu o‘lchov yuborilgan Telegram xabarlari sonini rejalashtirilgan xabarlar soniga bo‘ladi.

Yetkazilgan

Qabul qiluvchilarga muvaffaqiyatli yetkazilgan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Delivered =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DELIVERED", "READ", "VISITED", "SEEN"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Hisoblash mantiqi

Ushbu o‘lchov yetkazilganlik bilan bog‘liq holatlarga ega bo‘lgan Telegram xabarlarini hisoblaydi. READ, VISITED va SEEN holatlari muvaffaqiyatli yetkazilganidan keyin yuzaga keladigan harakatlar bo‘lgani uchun kiritilgan.

Yetkazilgan %

Yuborilgan Telegram xabarlarining muvaffaqiyatli yetkazilgan foizini ko‘rsatadi.

DAX formulasi

Telegram Delivered % =
[Telegram Delivered] / [Telegram Sent]

Hisoblash mantiqi

Ushbu o‘lchov yetkazilgan Telegram xabarlari sonini yuborilgan xabarlar soniga bo‘ladi.

O‘qilgan

Qabul qiluvchilar tomonidan o‘qilgan yoki ko‘rilgan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Read =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "READ", "VISITED", "SEEN"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Hisoblash mantiqi

Ushbu o‘lchov qabul qiluvchining o‘qishi yoki ko‘rish faoliyatini ko‘rsatadigan holatlarga ega bo‘lgan Telegram xabarlarini hisoblaydi. VISITED holati ham kiritilgan, chunki havolaga tashrif qabul qiluvchining jalb qilinishidan keyin yuz beradi.

O‘qilgan %

Yetkazilgan Telegram xabarlarining qabul qiluvchilar tomonidan o‘qilgan foizini ko‘rsatadi.

DAX formulasi

Telegram Read % =
[Telegram Read] / [Telegram Delivered]

Hisoblash mantiqi

Ushbu o‘lchov o‘qilgan Telegram xabarlari sonini yetkazilgan xabarlar soniga bo‘ladi.

Tashrif buyurilgan

Qabul qiluvchilar havolaga tashrif buyurgan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Visited =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "VISITED"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Hisoblash mantiqi

Ushbu o‘lchov VISITED holatiga ega bo‘lgan Telegram xabarlarini hisoblaydi. Bu Telegram aloqalarining havola bilan o‘zaro ta’sirini ko‘rsatadi.

Tashrif buyurilgan %

O‘qilgan Telegram xabarlarining havolaga tashrif bilan yakunlangan foizini ko‘rsatadi.

DAX formulasi

Telegram Visited % =
[Telegram Visited] / [Telegram Read]

Hisoblash mantiqi

Ushbu o‘lchov havolaga tashrif buyurilgan Telegram xabarlari sonini o‘qilgan xabarlar soniga bo‘ladi.

Obunani bekor qilganlar

Telegram aloqalaridan obunani bekor qilgan qabul qiluvchilar sonini ko‘rsatadi.

DAX formulasi

Telegram Unsubscribed =
CALCULATE(
    COUNT('Unsubscribed'[ID_Unsubscribed]), 
    'Distribution'[Communication_channel] = "telegram"
)

Hisoblash mantiqi

Ushbu o‘lchov telegram aloqa kanali uchun obunani bekor qilish yozuvlarini hisoblaydi.

Obunani bekor qilganlar %

Yetkazilgan Telegram xabarlarining obunani bekor qilish harakatiga olib kelgan foizini ko‘rsatadi.

DAX formulasi

Telegram Unsubscribed % =
[Telegram Unsubscribed] / [Telegram Delivered]

Hisoblash mantiqi

Ushbu o‘lchov Telegram obunani bekor qilish yozuvlari sonini yetkazilgan xabarlar soniga bo‘ladi.

Yetkazilmagan

Yuborilgan Telegram xabarlaridan yetkazilmaganlari sonini ko‘rsatadi.

DAX formulasi

Telegram Undelivered =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "UNDELIVERED", "UNDELIVERABLE",
            "RESENDING_SMS_UNDELIVERED",
            "RESENDING_SMS_UNDELIVERABLE",
            "EXPIRED", "OLD", "BOUNCED",
            "DEFERRED", "UNKNOWN"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Hisoblash mantiqi

Ushbu o‘lchov yetkazib berish muvaffaqiyatsizligini ko‘rsatadigan holatlarga ega Telegram xabarlarini hisoblaydi.

Yetkazilmagan %

Yuborilgan Telegram xabarlarining yetkazilmagan foizini ko‘rsatadi.

DAX formulasi

Telegram Undelivered % =
[Telegram Undelivered] / [Telegram Sent]

Hisoblash mantiqi

Ushbu o‘lchov yetkazilmagan Telegram xabarlari sonini yuborilgan xabarlar soniga bo‘ladi.

Yuborilmagan

Rejalashtirilgan Telegram xabarlaridan yuborilmaganlari sonini ko‘rsatadi.

DAX formulasi

Telegram Unsent =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DUPLICATE", "INVALID_EMAIL", "EMPTY_RECIPIENT",
            "EMPTY_CONTENT", "MESSAGE_LIMIT", "EXCLUDED",
            "UNSUBSCRIBED", "FAILED", "DECLINED", "UNVERIFIED"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Hisoblash mantiqi

Ushbu o‘lchov cheklovlar, nusxa yozuvlar, qabul qiluvchi ma’lumotlarining yetishmasligi, ishlov berishdagi muammolar, obunani bekor qilish holati yoki boshqa yuborish muammolari sababli yuborilmagan rejalashtirilgan Telegram xabarlarini hisoblaydi.

Yuborilmagan %

Rejalashtirilgan Telegram xabarlarining yuborilmagan foizini ko‘rsatadi.

DAX formulasi

Telegram Unsent % =
[Telegram Unsent] / [Telegram Planned]

Hisoblash mantiqi

Ushbu o‘lchov yuborilmagan Telegram xabarlari sonini rejalashtirilgan xabarlar soniga bo‘ladi.

Telegram Yetkazilgan Dinamikasi

Tanlangan dinamik davrda yetkazilgan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Delivered Dynamic =
VAR N = [DaysToShow Telegram]
VAR MaxDate =
    CALCULATE (
        MAX ( 'Distribution Status'[Send_DateOnly] ),
        ALL ( 'Distribution Status' )
    )
VAR Mode = SELECTEDVALUE(PeriodMode[Mode], "Day")
VAR StartDate_Day = MaxDate - (N - 1)
VAR StartDate_Month =
    DATE(
        YEAR ( EOMONTH ( MaxDate, -N + 1 ) ),
        MONTH( EOMONTH ( MaxDate, -N + 1 ) ),
        1
    )
VAR StartDate = IF(Mode = "Month", StartDate_Month, StartDate_Day)
RETURN
CALCULATE (
    COUNT ( 'Distribution Status'[ID_Distribution] ),
    FILTER (
        ALL ( 'Distribution Status'[Send_DateOnly] ),
        'Distribution Status'[Send_DateOnly] >= StartDate
            && 'Distribution Status'[Send_DateOnly] <= MaxDate
    ),
    KEEPFILTERS (
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DELIVERED", "READ", "VISITED", "SEEN"
        }
    ),
    KEEPFILTERS ( 'Distribution'[Communication_channel] = "telegram" ),
    REMOVEFILTERS ( 'Calendar' ),
    REMOVEFILTERS ( 'PeriodsFilter' )
)

Hisoblash mantiqi

Ushbu o‘lchov tanlangan dinamik davr uchun yetkazilgan Telegram xabarlari sonini hisoblaydi. U ko‘rsatiladigan sana oralig‘ini aniqlash uchun DaysToShow Telegram va tanlangan davr rejimini, masalan Kun yoki Oy ni ishlatadi.

Telegram O‘qilgan Dinamikasi

Tanlangan dinamik davrda o‘qilgan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Read Dynamic =
VAR N = [DaysToShow Telegram]
VAR MaxDate =
    CALCULATE (
        MAX ( 'Distribution Status'[Send_DateOnly] ),
        ALL ( 'Distribution Status' )
    )
VAR Mode = SELECTEDVALUE(PeriodMode[Mode], "Day")
VAR StartDate_Day = MaxDate - (N - 1)
VAR StartDate_Month =
    DATE(
        YEAR ( EOMONTH ( MaxDate, -N + 1 ) ),
        MONTH( EOMONTH ( MaxDate, -N + 1 ) ),
        1
    )
VAR StartDate = IF(Mode = "Month", StartDate_Month, StartDate_Day)
RETURN
CALCULATE (
    COUNT ( 'Distribution Status'[ID_Distribution] ),
    FILTER (
        ALL ( 'Distribution Status'[Send_DateOnly] ),
        'Distribution Status'[Send_DateOnly] >= StartDate
            && 'Distribution Status'[Send_DateOnly] <= MaxDate
    ),
    KEEPFILTERS (
        'Distribution Status'[Distribution_Sending_Status] IN {
            "READ", "VISITED", "SEEN"
        }
    ),
    KEEPFILTERS ( 'Distribution'[Communication_channel] = "telegram" ),
    REMOVEFILTERS ( 'Calendar' ),
    REMOVEFILTERS ( 'PeriodsFilter' )
)

Hisoblash mantiqi

Ushbu o‘lchov tanlangan dinamik davrda qabul qiluvchilar tomonidan o‘qilgan Telegram xabarlari sonini hisoblaydi. U Xabar Yetkazilishi va Jalb Qilish Tendentsiyalari grafikida ishlatiladi.

Telegram Yetkazilmagan Dinamikasi

Tanlangan dinamik davrda yetkazilmagan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Undelivred Dynamic =
VAR N = [DaysToShow Telegram]
VAR MaxDate =
    CALCULATE (
        MAX ( 'Distribution Status'[Send_DateOnly] ),
        ALL ( 'Distribution Status' )
    )
VAR Mode = SELECTEDVALUE(PeriodMode[Mode], "Day")
VAR StartDate =
    SWITCH (
        TRUE(),
        Mode = "Day", MaxDate - (N - 1),
        Mode = "Month", EOMONTH(MaxDate, -N + 1) + 1,
        MaxDate - N
    )
RETURN
CALCULATE (
    COUNT ( 'Distribution Status'[ID_Distribution] ),
    FILTER (
        ALL ( 'Distribution Status'[Send_DateOnly] ),
        'Distribution Status'[Send_DateOnly] >= StartDate
            && 'Distribution Status'[Send_DateOnly] <= MaxDate
    ),
    KEEPFILTERS (
        'Distribution Status'[Distribution_Sending_Status] IN {
            "UNDELIVERED", "UNDELIVERABLE",
            "RESENDING_SMS_UNDELIVERED",
            "RESENDING_SMS_UNDELIVERABLE",
            "EXPIRED", "OLD", "BOUNCED",
            "DEFERRED", "UNKNOWN"
        }
    ),
    KEEPFILTERS ( 'Distribution'[Communication_channel] = "telegram" ),
    REMOVEFILTERS ( 'Calendar' ),
    REMOVEFILTERS ( 'PeriodsFilter' )
)

Hisoblash mantiqi

Ushbu o‘lchov tanlangan dinamik davr ichida yetkazilmagan Telegram xabarlari sonini hisoblaydi. Bu yetkazib berish muvaffaqiyatsizligi dinamikasini vaqt bo‘yicha ko‘rsatishda ishlatiladi.

Telegram Tashrif Buyurilgan Dinamikasi

Tanlangan dinamik davrda havolaga tashrif buyurilgan Telegram xabarlari sonini ko‘rsatadi.

DAX formulasi

Telegram Visited Dynamic =
VAR N = [DaysToShow Telegram]
VAR MaxDate =
    CALCULATE (
        MAX ( 'Distribution Status'[Send_DateOnly] ),
        ALL ( 'Distribution Status' )
    )
VAR Mode = SELECTEDVALUE(PeriodMode[Mode], "Day")
VAR StartDate =
    SWITCH (
        TRUE(),
        Mode = "Day", MaxDate - (N - 1),
        Mode = "Month", EOMONTH(MaxDate, -N + 1) + 1,
        MaxDate - N
    )
RETURN
CALCULATE (
    COUNT ( 'Distribution Status'[ID_Distribution] ),
    FILTER (
        ALL ( 'Distribution Status'[Send_DateOnly] ),
        'Distribution Status'[Send_DateOnly] >= StartDate
            && 'Distribution Status'[Send_DateOnly] <= MaxDate
    ),
    KEEPFILTERS (
        'Distribution Status'[Distribution_Sending_Status] IN {
            "VISITED"
        }
    ),
    KEEPFILTERS ( 'Distribution'[Communication_channel] = "telegram" ),
    REMOVEFILTERS ( 'Calendar' ),
    REMOVEFILTERS ( 'PeriodsFilter' )
)

Hisoblash mantiqi

Ushbu o‘lchov tanlangan dinamik davrda qabul qiluvchilar havolaga tashrif buyurgan Telegram xabarlari sonini hisoblaydi. Bu Telegram havola tashrif faoliyatini vaqt bo‘yicha ko‘rsatish uchun tendensiya grafikida ishlatiladi.