Data Extensions
Location:Data Extensions > _themcx.app > Push >
| Name | Description |
|---|---|
| MCXPush_Subscription_<MID> | Stores subscribers who have opted in to push notifications from your website. |
| MCXPush_Event_<MID> | Captures event data for detailed analytics and reporting. |
| MCXPush_Analytics_Summary_<MID> | Provides aggregated data used in dashboards and analytics: - Total Active Subscribers - Growth Summary Query (7, 30 Days) - Campaign Performance Query (1, 7, 30 Days) - Device Distribution (All Subscribers Devices) - Geographic Distribution (All Subscribers Locations) - Message Effectiveness (30 Days) |
Automations
Location:my automations > _themcx.app > Push >
| Name | Description |
|---|---|
| Web Push App | Automates all SQL queries for SFMC/MCX push reports and analytics with the following configuration: - Trigger: Schedule - Repeats: Every 1 hour - End: Never |
SQL Queries
Location: Query > _themcx.app > Push >
| Name | Description | Details |
|---|---|---|
| MCXPush_Total_Active_Subscribers | Retrieves current total subscriber count, active subscribers, opt-out count, and active percentage. | Returns a single summary record with overall subscription health metrics. |
| MCXPush_Growth_Summary | Calculates new subscriber acquisition over 7-day and 30-day periods, including opt-in rates and opt-out counts. | Returns 2 records showing recent growth trends and subscriber engagement patterns. |
| MCXPush_Campaign_Performance | Aggregates campaign metrics across 1-day, 7-day, and 30-day timeframes including sent, delivered, click counts, and click-through rates. | Returns 3 summary records for performance trending analysis. |
| MCXPush_Device_Distribution | Consolidates subscriber counts by device operating system (Android, iOS, Windows, macOS) with active subscriber breakdowns. | Returns up to 4 records showing device-specific opt-in rates and audience composition. |
| MCXPush_Geographic_Distribution | Groups subscribers by country with active counts, opt-in percentages, and installation metrics. | Returns multiple records based on subscriber geographic spread for regional targeting insights. |
| MCXPush_Message_Effectiveness | Analyses individual campaign performance over a 30-day period including delivery rates, click-through rates, and engagement metrics by campaign type. | Returns multiple records showing campaign-specific effectiveness for optimisation purposes. |