MonetizationPublisherAdsAdSourceReport
A predefined view that retrieves publisher ads ad source data.
n
Select
The 本製品 uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- PropertyId supports the following operator: =
- AdSourceName supports the following operator: =
- Date supports the following operators: =,>=,<=,<,>
For example, the following queries are processed server-side:
SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE PropertyId = 342020667 SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE AdSourceName = 'test' SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE Date = '01/05/2023' SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE PropertyId = 342020667 AND AdSourceName = 'test' AND Date = '01/05/2023' SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE Date >= '01/01/2022' AND <= '01/05/2023' SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE Date >= '01/01/2022' SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE Date <= '01/01/2022' SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE Date > '01/01/2022' SELECT * FROM MonetizationPublisherAdsAdSourceReport WHERE Date < '01/01/2022'The rest of the filter is executed client-side in the 本製品.
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
AdSourceName | String | True | True | Demand source that provided the ad. | |
Date | Date | True | True | The date of the session formatted as YYYYMMDD. | |
PublisherAdImpressions | Integer | False | True | The number of times an ad was displayed on the publishers site. | |
adUnitExposure | Integer | False | True | The amount of time the ad unit was exposed to the user. | |
PublisherAdClicks | Integer | False | True | The number of times an ad was clicked on the publishers site. | |
TotalAdRevenue | Integer | False | True | Sum of all advertising revenue. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
PropertyId | String | The Property Id value to be used when querying this table. |