TDV Adapter for Adobe Analytics

Build 21.0.8137

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137