# \#campaign-analytics

**URL:** https://community.yellow.ai/tag/campaign-analytics/21.md

[Latest](https://community.yellow.ai/latest.md) · [Categories](https://community.yellow.ai/categories.md) · [Tags](https://community.yellow.ai/tags.md)

---

## [Please confirm the trackable metrics from the platform](https://community.yellow.ai/t/please-confirm-the-trackable-metrics-from-the-platform/4537)

<div class="topic-metadata">

**Author:** [@Shubham\_Raja](https://community.yellow.ai/u/Shubham_Raja)\
**Replies:** 0\
**Last updated:** [August 8, 2023, 12:45pm UTC](https://community.yellow.ai/t/please-confirm-the-trackable-metrics-from-the-platform/4537 "2023-08-08T12:45:15Z")

</div>

Please refer to the above flow for a WhatsApp campaign, can we track the below analytics out of the box and display them directly as a dashboard using data explorer? Sent Delivered Rates Open / Read Rate Click of Un…

---

## [Native Query to Get Open Rate within 24 Hours of Sending Message](https://community.yellow.ai/t/native-query-to-get-open-rate-within-24-hours-of-sending-message/3978)

<div class="topic-metadata">

**Author:** [@Chandrashekhar\_Bishn](https://community.yellow.ai/u/Chandrashekhar_Bishn)\
**Replies:** 0\
**Last updated:** [March 24, 2023, 12:42pm UTC](https://community.yellow.ai/t/native-query-to-get-open-rate-within-24-hours-of-sending-message/3978 "2023-03-24T12:42:59Z")

</div>

Namaskaram, I am writing SQL query to get no of message got read withing 24 hours of sending but it showing invalid sql query. Can you please help me in getting output?