05 - Reporting API - Tables

Aggregation criteria

Output field Computation field Type Direct
campaigns
(non-RTB+)

RTB+
AdBreakId AdBreakId INTEGER Yes No
AdId AdId STRING No Yes
AdPositionId AdPositionId STRING No Yes
AdPositionName AdPositionId STRING No Yes
AdvertiserBarter AdvertiserId BOOLEAN Yes Yes
AdvertiserDescription AdvertiserId STRING Yes Yes
AdvertiserExternalId AdvertiserId STRING Yes Yes
AdvertiserName AdvertiserId STRING Yes Yes
AdvertiserSalesPersonId AdvertiserId INTEGER Yes Yes
AdvertiserTrafficManagerId AdvertiserId INTEGER Yes Yes
AuctionTypeName AuctionTypeId STRING No Yes
BidStatusId BidStatusId INTEGER No Yes
BidStatusName BidStatusId STRING No Yes
BrowserId BrowserId INTEGER Yes Yes
BrowserName BrowserId STRING Yes Yes
BuyerId BuyerId INTEGER No Yes
BuyerName BuyerId STRING No Yes
AgencyId CampaignId INTEGER Yes Yes
CampaignBookingStatusId CampaignId INTEGER Yes Yes
CampaignEndDate CampaignId LONG Yes Yes
CampaignExternalId CampaignId STRING Yes Yes
CampaignName CampaignId STRING Yes Yes
CampaignSalesPersonId CampaignId INTEGER Yes Yes
CampaignStartDate CampaignId LONG Yes Yes
CampaignTrafficManagerId CampaignId INTEGER Yes Yes
CityId CityId INTEGER Yes Yes
CityName CityId STRING Yes Yes
ContentTypeId ContentTypeId STRING No Yes
ContentTypeName ContentTypeId STRING No Yes
CountryId CountryId INTEGER Yes Yes
CountryName CountryId STRING Yes Yes
CreativeHashcode CreativeHashcode LONG No Yes
CreativeHeight CreativeHeight INTEGER No Yes
CreativeId CreativeId STRING No Yes
CreativeSize CreativeSize SIZE No Yes
CreativeWidth CreativeWidth INTEGER No Yes
Day Day INTEGER Yes Yes
DealId DealId INTEGER No Yes
AuctionTypeId AuctionTypeId INTEGER No Yes
DealExternalId DealId STRING No Yes
DealName DealId STRING No Yes
DspCampaignId DspCampaignId STRING No Yes
DspId DspId INTEGER No Yes
DspName DspId STRING No Yes
EngineResponseStatus EngineResponseStatus INTEGER No Yes
FormatId FormatId INTEGER Yes Yes
FormatExternalId FormatId STRING Yes Yes
FormatHeight FormatId INTEGER Yes Yes
FormatName FormatId STRING Yes Yes
FormatType FormatId STRING Yes Yes
FormatWidth FormatId INTEGER Yes Yes
Geo Geo STRING No Yes
HasBuyerUid HasBuyerUid BOOLEAN No Yes
Hour Hour INTEGER Yes Yes
ImageId ImageId INTEGER Yes No
ImageClickUrl ImageId STRING Yes No
ImageFileName ImageId STRING Yes No
ImageHeight ImageId INTEGER Yes No
ImageName ImageId STRING Yes No
ImageWeight ImageId INTEGER Yes No
ImageWidth ImageId INTEGER Yes No
IndexImage ImageId INTEGER Yes No
ImpressionType ImpressionType INTEGER No Yes
InsertionId InsertionId INTEGER Yes Yes
AdvertiserId AdvertiserId INTEGER Yes Yes
CampaignId CampaignId INTEGER Yes Yes
CpcNet InsertionId DOUBLE Yes No
CpmNet InsertionId DOUBLE Yes No
InsertionEndDate InsertionId LONG Yes Yes
InsertionEndDateTimezone InsertionId LONG Yes Yes
InsertionExternalDescription InsertionId STRING Yes Yes
InsertionExternalId InsertionId INTEGER Yes Yes
InsertionName InsertionId STRING Yes Yes
InsertionPriorityId InsertionId INTEGER Yes Yes
InsertionScriptId InsertionId INTEGER Yes Yes
InsertionScriptName InsertionId STRING Yes Yes
InsertionStartDate InsertionId LONG Yes Yes
InsertionStartDateTimezone InsertionId LONG Yes Yes
InsertionTimezone InsertionId STRING Yes Yes
InsertionTypeId InsertionId INTEGER Yes Yes
InsertionTypeName InsertionId STRING Yes Yes
Inventory Inventory INTEGER No Yes
IspId IspId INTEGER Yes Yes
IspName IspId STRING Yes Yes
Keyword Keyword STRING_LIST Yes Yes
LineSpeedId LineSpeedId INTEGER Yes Yes
MobileModelId MobileModelId INTEGER Yes No
MobileSdkVersionId MobileSdkVersionId INTEGER Yes No
MobileVendorId MobileVendorId INTEGER Yes No
Month Month INTEGER Yes Yes
NetworkId NetworkId INTEGER Yes Yes
NetworkCurrentRate NetworkId DOUBLE Yes Yes
NetworkCurrentSymbol NetworkId STRING Yes Yes
NetworkTimezone NetworkId STRING Yes Yes
OfferedPriceRange OfferedPriceRange DOUBLE No Yes
OfferedPriceRange
NetworkCurrency
OfferedPriceRange
NetworkCurrency
DOUBLE No Yes
OsId OsId INTEGER Yes Yes
OsName OsId STRING Yes Yes
PackName PackId STRING Yes No
PageId PageId INTEGER Yes Yes
PackId PackId INTEGER Yes No
PageContentCategories PageId STRING Yes Yes
PageExternalId PageId STRING Yes Yes
PageGroupName PageId STRING Yes Yes
PageName PageId STRING Yes Yes
PageUrl PageId STRING Yes Yes
ParentId ParentId INTEGER Yes No
SiteId SiteId INTEGER Yes Yes
PageParentName ParentId STRING Yes Yes
PartnerId PartnerId INTEGER No Yes
PlatformId PlatformId INTEGER Yes Yes
PlatformName PlatformId STRING Yes Yes
PostRuleId PostRuleId INTEGER No Yes
PostalCode PostalCode STRING Yes No
PreRuleId PreRuleId INTEGER No Yes
Referrer Referrer STRING Yes Yes
RtbAdvertiserId RtbAdvertiserId INTEGER No Yes
RtbAdvertiserName RtbAdvertiserId STRING No Yes
ScreenHeight ScreenHeight INTEGER Yes Yes
ScreenSize ScreenSize SIZE Yes Yes
ScreenWidth ScreenWidth INTEGER Yes Yes
SiteContentCategories SiteId STRING Yes Yes
SiteExternalId SiteId STRING Yes Yes
SiteIsMobile SiteId BOOLEAN Yes Yes
SiteName SiteId STRING Yes Yes
SiteUrl SiteId STRING Yes Yes
StateId StateId INTEGER Yes Yes
StateName StateId STRING Yes Yes
TestingStrategyMask TestingStrategyMask LONG No Yes
TransmitBidFloor TransmitBidFloor BOOLEAN No Yes
VideoCmsId VideoCmsId STRING Yes No
VideoContentCategory VideoContentCategory STRING Yes No
VideoContentDistributorId VideoContentDistributorId STRING Yes No
VideoContentDistributorName VideoContentDistributorName STRING Yes No
VideoContentDuration VideoContentDuration INTEGER Yes No
VideoContentId VideoContentId STRING Yes No
VideoContentProviderId VideoContentProviderId STRING Yes No
VideoContentProviderName VideoContentProviderName STRING Yes No
VideoContentRating VideoContentRating STRING Yes No
VideoContentTags VideoContentTags STRING_LIST Yes No
VideoContentTitle VideoContentTitle STRING Yes No
VideoContentType VideoContentType STRING Yes No
VideoEpisodeNumber VideoEpisodeNumber INTEGER Yes No
VideoExternalContentId VideoExternalContentId STRING Yes No
VideoSeasonNumber VideoSeasonNumber INTEGER Yes No
Week Week INTEGER Yes Yes
Year Year INTEGER Yes Yes

Operators

Operator
Works on
integers
Works on
strings
Works on sizes
(width x height)
Description
contains no yes no keep only values contained in an element of the given list
eq no yes yes keep only values in the given list
gt yes no no keep only values greater than the unique given value (giving multiple values raise a warning)
in yes no no keep only values in the given list
lt yes no no keep only values lesser than the unique given value (giving multiple values raise a warning)
neq no yes yes filter only values in the given list
not in yes no no filter only values in the given list
starts with no yes no keep only values that are the beginning of an element of the given list

Filter criteria


Filter criterion
Type Direct
campaigns
(non RTB+)
RTB+
ActionReference STRING Yes No
AdBreakId INTEGER Yes No
AdId STRING No Yes
AdPositionId STRING No Yes
AdPositionName STRING No Yes
AdvertiserBarter BOOLEAN Yes Yes
AdvertiserDescription STRING Yes Yes
AdvertiserExternalId STRING Yes Yes
AdvertiserName STRING Yes Yes
AdvertiserSalesPersonId INTEGER Yes Yes
AdvertiserTrafficManagerId INTEGER Yes Yes
AuctionTypeName STRING No Yes
BidStatusId INTEGER No Yes
BidStatusName STRING No Yes
BrowserId INTEGER Yes Yes
BrowserName STRING Yes Yes
BuyerId INTEGER No Yes
BuyerName STRING No Yes
AgencyId INTEGER Yes Yes
CampaignBookingStatusId INTEGER Yes Yes
CampaignEndDate LONG Yes Yes
CampaignExternalId STRING Yes Yes
CampaignName STRING Yes Yes
CampaignSalesPersonId INTEGER Yes Yes
CampaignStartDate LONG Yes Yes
CampaignTrafficManagerId INTEGER Yes Yes
CityId INTEGER Yes Yes
CityName STRING Yes Yes
ContentTypeId STRING No Yes
ContentTypeName STRING No Yes
CountryId INTEGER Yes Yes
CountryName STRING Yes Yes
CreativeHashcode LONG No Yes
CreativeHeight INTEGER No Yes
CreativeId STRING No Yes
CreativeSize SIZE No Yes
CreativeWidth INTEGER No Yes
CustomActionKey STRING Yes No
Day INTEGER Yes Yes
DealId INTEGER No Yes
AuctionTypeId INTEGER No Yes
DealExternalId STRING No Yes
DealName STRING No Yes
DspCampaignId STRING No Yes
DspId INTEGER No Yes
DspName STRING No Yes
EngineResponseStatus INTEGER No Yes
FormatId INTEGER Yes Yes
FormatExternalId STRING Yes Yes
FormatHeight INTEGER Yes Yes
FormatName STRING Yes Yes
FormatType STRING Yes Yes
FormatWidth INTEGER Yes Yes
Geo STRING No Yes
HasBuyerUid BOOLEAN No Yes
Hour INTEGER Yes Yes
ImageId INTEGER Yes No
ImageClickUrl STRING Yes No
ImageFileName STRING Yes No
ImageHeight INTEGER Yes No
ImageName STRING Yes No
ImageWeight INTEGER Yes No
ImageWidth INTEGER Yes No
IndexImage INTEGER Yes No
ImpressionType INTEGER No Yes
InsertionId INTEGER Yes Yes
AdvertiserId INTEGER Yes Yes
CampaignId INTEGER Yes Yes
InsertionEndDate LONG Yes Yes
InsertionEndDateTimezone LONG Yes Yes
InsertionExternalDescription STRING Yes Yes
InsertionExternalId INTEGER Yes Yes
InsertionName STRING Yes Yes
InsertionPriorityId INTEGER Yes Yes
InsertionScriptId INTEGER Yes Yes
InsertionScriptName STRING Yes Yes
InsertionStartDate LONG Yes Yes
InsertionStartDateTimezone LONG Yes Yes
InsertionTimezone STRING Yes Yes
InsertionTypeId INTEGER Yes Yes
InsertionTypeName STRING Yes Yes
Inventory INTEGER No Yes
IspId INTEGER Yes Yes
IspName STRING Yes Yes
Keyword STRING_LIST Yes Yes
LineSpeedId INTEGER Yes Yes
LogType INTEGER Yes No
LogTypeDetails INTEGER Yes No
LogTypeOutput INTEGER Yes No
LogTypePlatform INTEGER Yes No
LogTypeType INTEGER Yes No
MobileModelId INTEGER Yes No
MobileSdkVersionId INTEGER Yes No
MobileVendorId INTEGER Yes No
Month INTEGER Yes Yes
NetworkId INTEGER Yes Yes
NetworkCurrentRate DOUBLE Yes Yes
NetworkCurrentSymbol STRING Yes Yes
NetworkTimezone STRING Yes Yes
OfferedPriceRange DOUBLE No Yes
OfferedPriceRangeNetworkCurrency DOUBLE No Yes
OsId INTEGER Yes Yes
OsName STRING Yes Yes
PageId INTEGER Yes Yes
PageContentCategories STRING Yes Yes
PageExternalId STRING Yes Yes
PageGroupName STRING Yes Yes
PageName STRING Yes Yes
PageUrl STRING Yes Yes
SiteId INTEGER Yes Yes
PartnerId INTEGER No Yes
PlatformId INTEGER Yes Yes
PlatformName STRING Yes Yes
PostRuleId INTEGER No Yes
PostalCode STRING Yes No
PreRuleId INTEGER No Yes
Referrer STRING Yes Yes
RtbAdvertiserId INTEGER No Yes
RtbAdvertiserName STRING No Yes
ScreenHeight INTEGER Yes Yes
ScreenSize SIZE Yes Yes
ScreenWidth INTEGER Yes Yes
SiteContentCategories STRING Yes Yes
SiteExternalId STRING Yes Yes
SiteIsMobile BOOLEAN Yes Yes
SiteName STRING Yes Yes
SiteUrl STRING Yes Yes
StateId INTEGER Yes Yes
StateName STRING Yes Yes
TestingStrategyMask LONG No Yes
TransmitBidFloor BOOLEAN No Yes
VideoCmsId STRING Yes No
VideoContentCategory STRING Yes No
VideoContentDistributorId STRING Yes No
VideoContentDistributorName STRING Yes No
VideoContentDuration INTEGER Yes No
VideoContentId STRING Yes No
VideoContentProviderId STRING Yes No
VideoContentProviderName STRING Yes No
VideoContentRating STRING Yes No
VideoContentTags STRING_LIST Yes No
VideoContentTitle STRING Yes No
VideoContentType STRING Yes No
VideoEpisodeNumber INTEGER Yes No
VideoExternalContentId STRING Yes No
VideoSeasonNumber INTEGER Yes No
Week INTEGER Yes Yes
Year INTEGER Yes Yes

Metrics

Metric Type Direct campaigns
(non-RTB+)
RTB+
AdNetworkRevenue DOUBLE Yes No
Auctions LONG No Yes
AuctionsDeal LONG No Yes
AuctionsDefault LONG No Yes
AverageClearingCpm DOUBLE No Yes
AverageOfferedCpm DOUBLE No Yes
AverageVideoDuration DOUBLE Yes No
AverageVideoPercentageViewedArea DOUBLE Yes No
Banners LONG Yes No
Barters LONG Yes No
BidRequests LONG No Yes
BidRequestsDsp LONG No Yes
BidRequestsPartner LONG No Yes
BidResponseDsp LONG No Yes
BidResponsePartner LONG No Yes
Bids LONG No Yes
Calls LONG No Yes
ClickBots LONG Yes No
ClickRate DOUBLE Yes No
Clicks LONG Yes No
CustomActionCount LONG Yes No
CustomActionKey STRING Yes No
CustomActionValueSum LONG Yes No
DefaultPixels LONG Yes No
DeliveryRate DOUBLE No Yes
DirectImpressions LONG No Yes
Ecpm DOUBLE Yes No
FillRate DOUBLE No Yes
Impressions LONG Yes No
ImpressionsTrueCount LONG No Yes
LogMaxTimestamp LONG Yes Yes
MasterAuctions LONG No Yes
PageViews LONG Yes No
Pixels LONG Yes No
PostClickConversion LONG Yes No
PostClickConversionTracerHour LONG Yes No
PostClickCount LONG Yes No
PostClickCountTracerHour LONG Yes No
PostClickRateConversion DOUBLE Yes No
PostClickRateConversionTracerHour DOUBLE Yes No
PostImpressionConversion LONG Yes No
PostImpressionConversionTracerHour LONG Yes No
PostImpressionCount LONG Yes No
PostImpressionCountTracerHour LONG Yes No
PostImpressionRateConversion DOUBLE Yes No
PostImpressionRateConversionTracerHour DOUBLE Yes No
PostTotalConversion LONG Yes No
PostTotalConversionTracerHour LONG Yes No
PostTotalCount LONG Yes No
PostTotalCountTracerHour LONG Yes No
ResponseTime DOUBLE No Yes
ResponseTimeSquared DOUBLE No Yes
Revenue DOUBLE Yes No
RtbAverageVideoDuration DOUBLE No Yes
RtbAverageVideoPercentageViewedArea DOUBLE No Yes
RtbEcpm DOUBLE No Yes
RtbImpressions LONG No Yes
RtbVideoCount LONG No Yes
RtbVideoCountPerImpression DOUBLE No Yes
RtbVideoDuration LONG No Yes
RtbVideoPercentageViewedArea LONG No Yes
TotalOfferedPrice LONG No Yes
TotalOfferedPriceNetworkCurrency LONG No Yes
TotalPaidPriceNetworkCurrencyTrueCount LONG No Yes
TotalWinnerOfferedPriceNetworkCurrencyTrueCount LONG No Yes
UniqueClick HYPERLOGLOG Yes No
UniquePages HYPERLOGLOG Yes No
UniqueVisitors HYPERLOGLOG Yes No
UnlinkedClicks LONG Yes No
VideoCount LONG Yes No
VideoCountPerBanner DOUBLE Yes No
VideoDuration LONG Yes No
VideoPercentageViewedArea LONG Yes No
Visits LONG Yes No
WinnerCpm DOUBLE No Yes
WinnerOfferedPrice LONG No Yes
WinnerOfferedPriceTrueCount LONG No Yes
WinnerOfferedPriceTrueCount LONG No Yes
Was this article helpful?
0 out of 0 found this helpful
Powered by Zendesk