AdsReport
Generate data reports regarding the ads of your website.
View Specific Information
Refer to the explanation in the "Data Model" section to learn how to build optimal queries. The following are some use cases for this report:
SELECT Country, City, AdClicks, AdImpressions, ClickThroughs FROM AdsReport SELECT Page, AdClicks, AdImpressions, ClickThroughs FROM AdsReport SELECT Date, Revenue FROM AdsReport
Columns
| Name | Type | IsDimension | IsMetric | DefaultDimension | Description |
| Country | String | True | Name of the country. | ||
| City | String | True | Name of the city. | ||
| Page | String | True | Name of the page the ad was on. | ||
| Date | Date | True | True | The datetime of the given data. | |
| PageViews | Int | True | Number of pageviews. | ||
| AdClicks | Int | True | Number of adclicks. | ||
| AdImpressions | Int | True | Number of adimpressions. | ||
| ClickThroughs | Int | True | Number of clickthroughs. | ||
| Revenue | Decimal | True | Revenue made from the ads. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| StartDate | Datetime | Use this to filter reports by the start date of the report. |
| EndDate | Datetime | Use this to filter reports by the end date of the report. |
| SegmentId | String | Use this to filter reports by a particular segment. |