Table columns in the client reports (Documents tab)
This page describes the table columns of the Adhese client reports from the Documents tab.
Invoice report
The Invoice report contains information about the cost price of a campaign and, if applicable, about the rate card. The Invoice report includes the following figures for each booking:
Column name
Description
FromStart date of the bookingTillThe end date of the bookingPrice typeChosen tariff type, e.g. CPC or CPMImpressionsNumber of booked impressionsRateTariff of the pricing model of the rate cardValueThe financial value of the bookingDiscountApplied discount or surplusTotal budgetThe total financial value of the booking that takes the discount or surplus into accountWave idThe ID of the rate (.xls file only)The Invoice report summarises all bookings and includes the total campaign cost price, including VAT.
Campaign report
The Campaign report contains the following figures about the campaign and its bookings:
Column name
Description
BookingName of the bookingFromStart date of the bookingTillThe end date of the bookingBookedThe to reach volumeContact/DayThe total number of contactsImpressionsThe total number of impressionsClicks The number of clicksClick rateThe click-through rateCampaign profiling report (deprecated)
The Campaign profiling report contains campaign performance data for each individual booking and its profile targets. The data is divided by the device type the visitor uses to access the publication: desktop, tablet, or phone.
The Campaign profiling report has been deprecated and will be removed.
The Campaign profiling report contains the following figures for each booking and its profile targets:
Column name
Description
PublicationName of the publicationProductName of the locationFormatName of the formatCreative nameName of the creativeLanguageThe value of the language targeting variableCountryThe value of the country targeting variableRegionThe value of the region targeting variableAgeThe value of the age targeting variableGenderThe value of the gender targeting variableSexual orientationThe value of the sexual orientation targeting variableRelationshipThe value of the relationship targeting variableEducationThe value of the education targeting variableCityThe value of the city targeting variableCityGroupThe value of the city group targeting variableBrandThe value of the brand targeting variableInterestThe value of the interest targeting variablePlatformThe value of the platform targeting variable, for example, phone, tablet, or desktopContactsTotal number of contacts or unique visitorsImpressionsTotal number of impressionsClicksTotal number of clicksFromStart dateTillEnd dateCampaign report per position
Column name
Description
BookingThe ID of the bookingNetto price PublicationName of the publicationProductName of the locationFormatName of the formatFromStart dateTillEnd dateBookedThe to reach volume of the bookingContacts/DayThe number of contacts for the positionImpressionsThe number of impressions for the positionClicksThe number of clicks for the positionClick rateThe click-through rate of the positionWave IDThe ID of the wavePublisherName of the publisherCampaign actions report per position (optional)
Column name
Description
PublicationName of the publicationPosition IdThe ID of the positionPosition nameName of the positionLocation NameName of the locationFormat NameName of the formatBooked Position IdThe ID of the booked positionBooked PublicationName of the booked publicationBooked Position NameName of the booked positionBooked Location NameName of the booked locationBooked Format NameName of the booked formatDateThe date of the day the events were measuredTraffic IdThe ID that denotes the connection between a creative and a bookingCreative IdThe ID of the creativeBooking IdThe ID of the bookingEventThe type of event: log (request) or track (impression measurement, additional data ). For more information, refer to Impression measurement
ActionThe (optional) label of the track eventValueThe (optional) value of the (optional) label of the track eventImpressionsThe number of impressionsContactsThe number of contacts or unique visitorsVideo report spreadsheet
Global-View
Column Name
Description
CampaignName of the campaignBookingName of the booking(s) CreativeName of the creative(s)FromBegin dateTillEnd dateStartNumber of impressionsFirstQuartilePercentage of first quartile viewsMidPointPercentage of midpoint viewsThirdQuartilePercentage of third quartile viewsCompletePercentage of completed views ClicksThe number of ad clicksDetail view
Column Name
Description
DateAll dates in the campaignCreative IdThe ID of the creativeCreativeName of the creativeBooking IdThe ID of the bookingBookingName of the bookingStartNumber of started impressionsFirstQuartileNumber of impressions first quartileMidPointNumber of impressions at the midpointThirdQuartileNumber of impressions third quartileCompleteNumber of impressions completeClicksThe number of ad clicks