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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。day, week, days_28, lifetime |
| IsFromAds | String | Whether the media view originated from an ad. Values: '1' (paid/from ad) or '0' (organic). |
Pseudocolumns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| 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. |