Title: How to query DPL for Apple News real-time data
Author: staff
Published: July 21, 2022
Last modified: July 20, 2026

---

 1. [Data Pipeline](https://docs.parse.ly/data-pipeline/)
 2. [DPL: Frequently Asked Questions](https://docs.parse.ly/data-pipeline/data-pipeline-common-questions/)
 3. How to query DPL for Apple News real-time data

#  How to query DPL for Apple News real-time data

[Apple News Real-time data is now available in Parse.ly Data Pipeline](https://blog.parse.ly/post/8857/introducing-apple-news-analytics/?fbclid=IwAR3ICOP79VKUYy_idlzsNvl9gFTdGOB9w2dBWkhQ6eSHZ01q6EikiqylxPw)!
Contact [Parse.ly Support](https://support.parse.ly/hc/en-us) to learn more about
enabling Apple News in the Data Pipeline.

Consider filtering Apple News real-time data depending on ETL/Data Warehouse/Lambda
functions or data ingestion methods.

The Data Pipeline now includes a `channel` column that matches the channel data 
in the Parse.ly Dashboard.

When using SQL with [Parse.ly](https://parse.ly/) data, GROUP BY the `channel` field
for metric calculations. Certain metrics — like unique visitor counts — [only make sense on single channels.](https://docs.parse.ly/distributed-channels/)

To filter out or include Apple News Real-time data, use the following queries:

### Include Apple News Real-time data:

    ```lang-php
    Select <fields>
    from parsely_rawdata
    Where channel == 'apln-rta'
    ```

### Exclude Apple News Real-time data:

    ```lang-php
    Select <fields>
    From parsely_rawdata
    Where channel <> 'apln-rta'
    ```

### Apple News Real-time fields:

For Apple News events, the `extra_data` object under the `apln` key contains original
data from Apple. This is a passthrough of what Parse.ly receives from the Apple 
News API and includes fields specific to that platform. Look here for the Apple 
News section to use as a referrer source.

Expected Apple News Real-time fields are detailed below:

 1.  `is_rta`: (boolean) true if the event is from apple news real-time API and not
     available otherwise.
 2.  `dashboardId`: (string) Identifier for the Apple News specific dashboard in which
     the events will be aggregated.
 3.  `eventType`: (string) The type of event. Possible values: “ARTICLE_VIEW_EVENT”,“
     FEATURED_ARTICLE_EVENT”, or “NOTIFICATION_EVENT”.
 4.  `contentType`: (string) The type of content in the article. Possible values: “
     article”, “video”, or “slideshow”.
 5.  `sections`: (array of strings) Names of the sections in which the article appears.
 6.  `isPaywalled`: (boolean) true if the article requires payment or subscription.
     false otherwise.
 7.  `userId`:(string) UUID uniquely identifying the user. This identifier is unique
     per article, which means it can be used to track returns to this article, but 
     not to track a user’s activities across articles.
 8.  `geos`: (array of strings) An array containing one ISO 3166 country code for the
     user’s locale, if available.
 9.  `referralSource`:(string) The location from which the user was referred to the
     article, if specified.
 10. `userPaid`: (boolean) true if the user has a subscription or has otherwise paid
     for access to the article, false otherwise.
 11. `subscriberType`: (string) The subscription type of the user. Possible values 
     examples: “Apple News+ Subscriber”, “Channel Subscriber”, “iOS Subscriber”, “Authenticated
     Subscriber”, “Non-Subscriber”.
 12. `hasVideo`(boolean) true if the article has one or more videos, false otherwise.
 13. `deviceModel`: (string) The device type used when the event was created. Example:“
     iPhone”.
 14. `videoPlays`: (array of video event objects) An array containing objects that 
     represent the users interaction with video content during the article session.
     See below for more details about the contents of this array.

`videoPlays` details:

 1. `videoId`: (string) A string identifying the video in context of the article.
 2. `videoDuration`: (integer) The duration of the video in seconds.
 3. `videoTimePlayed`: (integer) The number of seconds the user played.
 4. `videoCompleted`: (boolean) `true` if the user finished the video, `false` otherwise.

Last updated: July 20, 2026