WhatsApp dashboardi WhatsApp kommunikatsiya samaradorligi uchun KPI kartalari, diagrammalar va batafsil jadval metrikalarini ko‘rsatadi.

• Planned
• Sent
• Sent, %
• Delivered
• Delivered, %
• Read
• Read, %
• Visited
• Visited, %
• Unsubscribed
• Unsubscribed, %
• Undelivered
• Undelivered, %
• Unsent
• Unsent, %
• Reason Undelivered
• WhatsApp Devices
• WhatsApp Delivered to Read
• WhatsApp AVG Delivered to Read
• WhatsApp Delivered to Visited
• WhatsApp AVG Delivered to Visited
• WhatsApp Delivered Dynamic
• WhatsApp Read Dynamic
• WhatsApp Visited Dynamic
• WhatsApp Undelivered Dynamic

Planned

KPI tavsifi

Tanlangan hisobot davri uchun rejalashtirilgan WhatsApp kommunikatsiyalarining umumiy sonini ko‘rsatadi.

DAX formulasi

CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]),
    'Distribution'[Communication_channel] = "whatsapp"
)

Hisoblash logikasi

Kommunikatsiya kanali whatsapp bo‘lgan barcha distribyutsiya yozuvlarini sanaydi.

Sent

KPI tavsifi

Yuborilgan yoki yuborish bilan bog‘liq istalgan statusga yetgan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

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]) = "whatsapp"
    )
)

Hisoblash logikasi

SENT, DELIVERED, READ, VISITED, BOUNCED, FAILED, REJECTED, UNDELIVERED, UNKNOWN va boshqa texnik yuborish statuslariga ega WhatsApp yozuvlarini sanaydi.

Sent, %

KPI tavsifi

Rejalashtirilgan WhatsApp xabarlarining necha foizi yuborilganini ko‘rsatadi.

DAX formulasi

Whatsapp Sent % =
[Whatsapp Sent] / [Whatsapp Planned]

Hisoblash logikasi

Yuborilgan WhatsApp xabarlari sonini rejalashtirilgan WhatsApp xabarlari soniga bo‘ladi.

Delivered

KPI tavsifi

Qabul qiluvchilarga yetkazilgan yuborilgan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

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

Hisoblash logikasi

Yetkazish bosqichiga yetgan WhatsApp xabarlarini sanaydi. READ, VISITED yoki SEEN kabi keyingi engagement statuslariga ega xabarlar ham yetkazilgan deb hisoblanadi.

Delivered, %

KPI tavsifi

Yuborilgan WhatsApp xabarlarining necha foizi qabul qiluvchilarga yetkazilganini ko‘rsatadi.

DAX formulasi

Whatsapp Delivered % =
[Whatsapp Delivered] / [Whatsapp Sent]

Hisoblash logikasi

Yetkazilgan WhatsApp xabarlari sonini yuborilgan WhatsApp xabarlari soniga bo‘ladi.

Read

KPI tavsifi

Qabul qiluvchilar tomonidan o‘qilgan yetkazilgan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

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

Hisoblash logikasi

Yetkazilgandan keyin o‘qilgan yoki qo‘shimcha engagement olgan WhatsApp xabarlarini sanaydi.

Read, %

KPI tavsifi

Yetkazilgan WhatsApp xabarlarining necha foizi qabul qiluvchilar tomonidan o‘qilganini ko‘rsatadi.

DAX formulasi

[Whatsapp Read] / [Whatsapp Delivered]

Hisoblash logikasi

O‘qilgan WhatsApp xabarlari sonini yetkazilgan WhatsApp xabarlari soniga bo‘ladi.

Visited

KPI tavsifi

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

DAX formulasi

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

Hisoblash logikasi

VISITED statusiga ega WhatsApp yozuvlarini sanaydi. Bu qabul qiluvchi WhatsApp xabaridagi havolaga tashrif buyurganini anglatadi.

Visited, %

KPI tavsifi

O‘qilgan WhatsApp xabarlarining necha foizi havolaga tashrif bilan yakunlanganini ko‘rsatadi.

DAX formulasi

[Whatsapp Visited] / [Whatsapp Read]

Hisoblash logikasi

Havolaga tashrif bo‘lgan WhatsApp xabarlari sonini o‘qilgan WhatsApp xabarlari soniga bo‘ladi.

Unsubscribed

KPI tavsifi

WhatsApp kommunikatsiyalaridan obunani bekor qilgan qabul qiluvchilar sonini ko‘rsatadi.

DAX formulasi

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

Hisoblash logikasi

Kommunikatsiya kanali whatsapp bo‘lgan obunani bekor qilish yozuvlarini sanaydi.

Unsubscribed, %

KPI tavsifi

Yetkazilgan WhatsApp xabarlarining necha foizi obunani bekor qilish harakati bilan yakunlanganini ko‘rsatadi.

DAX formulasi

[Whatsapp Unsubscribed] / [Whatsapp Delivered]

Hisoblash logikasi

Obunani bekor qilgan qabul qiluvchilar sonini yetkazilgan WhatsApp xabarlari soniga bo‘ladi.

Undelivered

KPI tavsifi

Qabul qiluvchilarga yetkazilmagan va yetkazilmaslik sababi ko‘rsatilgan yuborilgan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

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]) = "whatsapp"
        && TRIM('Distribution Status'[Reason_Undelivered_Whatsapp]) <> ""
        && 'Distribution Status'[Reason_Undelivered_Whatsapp] <> "Пусто"
        && NOT ISBLANK('Distribution Status'[Reason_Undelivered_Whatsapp])
    )
)

Hisoblash logikasi

Yetkazilmagan delivery statuslari va bo‘sh bo‘lmagan yetkazilmaslik sababi mavjud WhatsApp yozuvlarini sanaydi. Bu KPI yuborilgan, ammo qabul qiluvchilarga yetib bormagan xabarlarni aniqlashga yordam beradi.

Undelivered, %

KPI tavsifi

Yuborilgan WhatsApp xabarlarining necha foizi yetkazilmaganini ko‘rsatadi.

DAX formulasi

[Whatsapp Undelivered] / [Whatsapp Sent]

Hisoblash logikasi

Yetkazilmagan WhatsApp xabarlari sonini yuborilgan WhatsApp xabarlari soniga bo‘ladi.

Unsent

KPI tavsifi

Yuborilmagan rejalashtirilgan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

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]) = "whatsapp"
    )
)

Hisoblash logikasi

Ma’lumot, konfiguratsiya, qabul qiluvchi, kontent, limit yoki validatsiya muammolari sababli yuborilmagan rejalashtirilgan WhatsApp yozuvlarini sanaydi.

Unsent, %

KPI tavsifi

Rejalashtirilgan WhatsApp xabarlarining necha foizi yuborilmaganini ko‘rsatadi.

DAX formulasi

[Whatsapp Unsent] / [Whatsapp Planned]

Hisoblash logikasi

Yuborilmagan WhatsApp xabarlari sonini rejalashtirilgan WhatsApp xabarlari soniga bo‘ladi.

Reason Undelivered

KPI tavsifi

Yetkazilmaslik sababi mavjud WhatsApp yozuvlari sonini ko‘rsatadi. Bu o‘lchov Reasons for undelivered messages diagrammasida WhatsApp xabarlari nima sababdan yetkazilmaganini tahlil qilish uchun ishlatiladi.

DAX formulasi

CALCULATE(
    COUNT('Distribution Status'[Reason_Undelivered_Emails_Flag]),
    'Distribution'[Communication_channel] = "whatsapp"
)

Hisoblash logikasi

whatsapp kommunikatsiya kanali uchun yetkazilmaslik sababi flagi mavjud bo‘lgan yozuvlarni sanaydi.

WhatsApp Devices

KPI tavsifi

WhatsApp kommunikatsiyalari uchun qurilma bo‘yicha havolaga tashrif yozuvlari sonini ko‘rsatadi. Bu o‘lchov Type of devices from which the link was visited diagrammasida ishlatiladi.

DAX formulasi

CALCULATE(
    COUNT('Devices'[ID_Linkstats]),
    'Distribution'[Communication_channel] = "whatsapp"
)

Hisoblash logikasi

Kommunikatsiya kanali whatsapp bo‘lgan Devices jadvalidagi yozuvlarni sanaydi.

WhatsApp Delivered to Read

KPI tavsifi

Yetkazishdan o‘qishgacha bo‘lgan vaqt mavjud WhatsApp xabarlari sonini ko‘rsatadi. Bu o‘lchov Delivered vs Read vizualizatsiyasida ishlatiladi.

DAX formulasi

CALCULATE(
    COUNT('Distribution Status'[Time from delivered to read]),
    'Distribution'[Communication_channel] = "whatsapp"
)

Hisoblash logikasi

Time from delivered to read maydonida qiymat mavjud WhatsApp yozuvlarini sanaydi.

WhatsApp AVG Delivered to Read

KPI tavsifi

WhatsApp xabari yetkazilishi va o‘qilishi orasidagi o‘rtacha vaqtni ko‘rsatadi. Natija HH:MM:SS formatida ko‘rsatiladi.

DAX formulasi

VAR TotalSeconds =
    AVERAGEX(
        FILTER(
            'Distribution Status',
            CALCULATE(
                COUNT('Distribution'[ID_Distribution]),
                'Distribution'[Communication_channel] = "whatsapp"
            ) > 0
            && NOT(ISBLANK('Distribution Status'[Difference in seconds 1]))
        ),
        'Distribution Status'[Difference in seconds 1]
    )
VAR Hours = INT(TotalSeconds / 3600)
VAR Minutes = INT(MOD(TotalSeconds, 3600) / 60)
VAR Seconds = MOD(TotalSeconds, 60)
RETURN
    FORMAT(Hours, "00") & ":" &
    FORMAT(Minutes, "00") & ":" &
    FORMAT(Seconds, "00")

Hisoblash logikasi

WhatsApp yozuvlari uchun Difference in seconds 1 o‘rtacha qiymatini hisoblaydi, so‘ng natijani soat, daqiqa va soniyalarga aylantiradi.

WhatsApp Delivered to Visited

KPI tavsifi

Yetkazishdan havolaga tashrifgacha bo‘lgan vaqt mavjud WhatsApp xabarlari sonini ko‘rsatadi. Bu o‘lchov Delivered vs Visited vizualizatsiyasida ishlatiladi.

DAX formulasi

CALCULATE(
    COUNT('Distribution Status'[Time from delivered to visited]),
    'Distribution'[Communication_channel] = "whatsapp"
)

Hisoblash logikasi

Time from delivered to visited maydonida qiymat mavjud WhatsApp yozuvlarini sanaydi.

WhatsApp AVG Delivered to Visited

KPI tavsifi

WhatsApp xabari yetkazilishi va havolaga tashrif orasidagi o‘rtacha vaqtni ko‘rsatadi. Natija HH:MM:SS formatida ko‘rsatiladi.

DAX formulasi

VAR TotalSeconds =
    AVERAGEX(
        FILTER(
            'Distribution Status',
            CALCULATE(
                COUNT('Distribution'[ID_Distribution]),
                'Distribution'[Communication_channel] = "whatsapp"
            ) > 0
            && NOT(ISBLANK('Distribution Status'[Difference in seconds 2]))
        ),
        'Distribution Status'[Difference in seconds 2]
    )
VAR Hours = INT(TotalSeconds / 3600)
VAR Minutes = INT(MOD(TotalSeconds, 3600) / 60)
VAR Seconds = MOD(TotalSeconds, 60)
RETURN
    FORMAT(Hours, "00") & ":" &
    FORMAT(Minutes, "00") & ":" &
    FORMAT(Seconds, "00")

Hisoblash logikasi

WhatsApp yozuvlari uchun Difference in seconds 2 o‘rtacha qiymatini hisoblaydi, so‘ng natijani soat, daqiqa va soniyalarga aylantiradi.

WhatsApp Delivered Dynamic

KPI tavsifi

Message Delivery & Engagement Trends diagrammasida tanlangan kun yoki oy diapazoni uchun yetkazilgan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

VAR N = [DaysToShow Whatsapp]
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] = "whatsapp"),
    REMOVEFILTERS('Calendar'),
    REMOVEFILTERS('PeriodsFilter')
)

Hisoblash logikasi

Tanlangan dinamik sana diapazonida yetkazilgan WhatsApp xabarlarini hisoblaydi. Diapazon tanlangan davr rejimiga bog‘liq: Day yoki Month.

WhatsApp Read Dynamic

KPI tavsifi

Message Delivery & Engagement Trends diagrammasida tanlangan kun yoki oy diapazoni uchun o‘qilgan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

VAR N = [DaysToShow whatsapp]
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] = "whatsapp"),
    REMOVEFILTERS('Calendar'),
    REMOVEFILTERS('PeriodsFilter')
)

Hisoblash logikasi

Tanlangan dinamik sana diapazonida o‘qilgan WhatsApp xabarlarini hisoblaydi. VISITED yoki SEEN kabi keyingi engagement statuslariga ega xabarlar ham kiritiladi.

WhatsApp Visited Dynamic

KPI tavsifi

Message Delivery & Engagement Trends diagrammasida tanlangan kun yoki oy diapazoni uchun havolaga tashrif bo‘lgan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

VAR N = [DaysToShow Whatsapp]
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] = "whatsapp"),
    REMOVEFILTERS('Calendar'),
    REMOVEFILTERS('PeriodsFilter')
)

Hisoblash logikasi

Tanlangan dinamik sana diapazonida WhatsApp havolalariga tashriflarni hisoblaydi.

WhatsApp Undelivered Dynamic

KPI tavsifi

Message Delivery & Engagement Trends diagrammasida tanlangan kun yoki oy diapazoni uchun yetkazilmagan WhatsApp xabarlari sonini ko‘rsatadi.

DAX formulasi

VAR N = [DaysToShow Whatsapp]
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] = "whatsapp"),
    REMOVEFILTERS('Calendar'),
    REMOVEFILTERS('PeriodsFilter')
)

Hisoblash logikasi

Tanlangan dinamik sana diapazonida yetkazilmagan WhatsApp xabarlarini hisoblaydi. Manba faylida o‘lchov nomi Whatsapp Undelivred Dynamic deb yozilgan.