MonetizationPublisherAdsAdFormatReport
A predefined view that retrieves publisher ads page ad format data.
n
Select
The provider uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- PropertyId supports the following operator: =
- AdFormat supports the following operator: =
- Date supports the following operators: =,>=,<=,<,>
- CurrencyCode supports the following operator: =
For example, the following queries are processed server-side:
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE PropertyId = 342020667
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE AdFormat = 'image'
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE Date = '01/05/2023'
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE PropertyId = 342020667 AND AdFormat = 'image' AND Date = '01/05/2023'
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE Date >= '01/01/2022' AND Date <= '01/05/2023'
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE Date >= '01/01/2022'
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE Date <= '01/01/2022'
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE Date > '01/01/2022'
SELECT * FROM MonetizationPublisherAdsAdFormatReport WHERE Date < '01/01/2022'
The rest of the filter is executed client-side in the provider.
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| AdFormat | String | True | True | Format of the ad(e.g., text, image, video). | |
| 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 publisherss site. | |
| TotalAdRevenue | Decimal | False | True | Sum of all advertising revenue. |
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 |
| PropertyId | String | Property ID value to be used when querying this table. |
| CurrencyCode | String | A currency code in ISO4217 format, such as AED, USD, JPY. If the field is empty, the report uses the property's default currency. |