PageAndPostInsightsByIsFromAds
Returns POST_MEDIA_VIEW and PAGE_MEDIA_VIEW insights broken down by is_from_ads, separating paid from organic media views. The IsFromAds column indicates whether each row represents ad-driven ('1') or organic ('0') media views.
Columns
| Name | Type | Description |
| RowNumber [KEY] | Int | The row number of the result. |
| EndTime | Date | The most recent date this insight data is relevant for. |
| Value | Long | Insight column for a singular value response. |
| Target | String | The target of the insight. This must always be specified. |
| InsightName | String | The name of the insight. Supported values are POST_MEDIA_VIEW and PAGE_MEDIA_VIEW, which are the metrics that support the is_from_ads breakdown.
The allowed values are POST_MEDIA_VIEW, PAGE_MEDIA_VIEW. |
| Period | String | The period for the insight. This controls how rows will be broken up (by day, week, 28 days, or lifetime). This must always be specified.
The allowed values are day, week, days_28, lifetime. |
| IsFromAds | String | Whether the media view originated from an ad. Values: '1' (paid/from ad) or '0' (organic). |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| FromDateTime | String | The earliest time for insight data to have been collected. |
| ToDateTime | String | The latest time for insight data to have been collected. |