_PushTag
Tags assigned to MobilePush devices for audience segmentation and triggered sends.
Schema last reviewed 2026-06-17
Opens _PushTag in the interactive canvas with SQL Sandbox.
Tags assigned to MobilePush devices for audience segmentation and triggered sends.
Schema last reviewed 2026-06-17
Opens _PushTag in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
DeviceID |
Text(200) | PK, FK | _PushAddress.DeviceID _PushTag.DeviceID |
Device the tag is applied to. |
TagName |
Text(128) | PK | — | Tag label used in MobilePush audiences. |
CreatedDate |
Date | — | — | When the tag was assigned to the device. |
ModifiedDate |
Date | — | — | Last modification of the tag assignment. |
Source |
Text(100) | NULL | — | How the tag was applied (API, Journey, Import). |
Active |
Boolean | — | — | Whether the tag assignment is currently active. |
SELECT TOP 100
DeviceID, TagName, CreatedDate, ModifiedDate, Source, Active
FROM _PushTag
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESCValid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.