FloodlightReport
Table for running Floodlight reports saved in DCM or ad-hoc reports.
Columns
Name | Type | Dimension | Description |
CookieReachIncrementalImpressionReach | Long | False | |
CookieReachIncrementalTotalReach | Long | False | |
CookieReachTotalReach | Long | False | |
CookieReachOverlapClickReach | Long | False | |
CookieReachOverlapClickReachPercent | Double | False | |
CookieReachOverlapImpressionReach | Long | False | |
CookieReachOverlapImpressionReachPercent | Double | False | |
CookieReachOverlapTotalReach | Long | False | |
CookieReachOverlapTotalReachPercent | Double | False | |
Activity | String | True | |
ActivityGroup | String | True | |
ActivityGroupId | Long | True | |
ActivityId | Long | True | |
ActivityTime | String | True | |
Ad | String | True | |
AdId | Long | True | |
AdType | String | True | |
Advertiser | String | True | |
AdvertiserGroup | String | True | |
AdvertiserId | Long | True | |
Asset | String | True | |
AssetCategory | String | True | |
AssetId | Long | True | |
AssetOrientation | String | True | |
BrowserPlatform | String | True | |
Campaign | String | True | |
CampaignEndDate | String | True | |
CampaignId | Long | True | |
CampaignStartDate | String | True | |
ChannelMix | String | True | |
City | String | True | |
ClickCount | Long | True | |
ClickThroughUrl | String | True | |
ConnectionType | String | True | |
ConversionReferrer | String | True | |
ConversionUrl | String | True | |
Creative | String | True | |
CreativeGroup1 | String | True | |
CreativeGroup2 | String | True | |
CreativeId | Long | True | |
CreativeSize | String | True | |
CreativeType | String | True | |
CreativeVersion | String | True | |
CustomRichMediaEventCount | Long | True | |
CustomRichMediaEventPathSummary | String | True | |
Date | String | True | |
DaysSinceAttributedInteraction | Long | True | |
DaysSinceFirstInteraction | Long | True | |
DmaRegion | String | True | |
DynamicProfile | String | True | |
DynamicProfileId | Long | True | |
Feed1 | String | True | |
Feed1ReportingDimension1 | String | True | |
Feed1ReportingDimension2 | String | True | |
Feed1ReportingDimension3 | String | True | |
Feed1ReportingLabel | String | True | |
Feed1UniqueId | String | True | |
Feed2 | String | True | |
Feed2ReportingDimension1 | String | True | |
Feed2ReportingDimension2 | String | True | |
Feed2ReportingDimension3 | String | True | |
Feed2ReportingLabel | String | True | |
Feed2UniqueId | String | True | |
Feed3 | String | True | |
Feed3ReportingDimension1 | String | True | |
Feed3ReportingDimension2 | String | True | |
Feed3ReportingDimension3 | String | True | |
Feed3ReportingLabel | String | True | |
Feed3UniqueId | String | True | |
Feed4 | String | True | |
Feed4ReportingDimension1 | String | True | |
Feed4ReportingDimension2 | String | True | |
Feed4ReportingDimension3 | String | True | |
Feed4ReportingLabel | String | True | |
Feed4UniqueId | String | True | |
Feed5 | String | True | |
Feed5ReportingDimension1 | String | True | |
Feed5ReportingDimension2 | String | True | |
Feed5ReportingDimension3 | String | True | |
Feed5ReportingLabel | String | True | |
Feed5UniqueId | String | True | |
FloodlightAttributionType | String | True | |
FloodlightConfigId | Long | True | |
FloodlightVariableDimension1 | String | True | |
FloodlightVariableDimension2 | String | True | |
FloodlightVariableDimension3 | String | True | |
FloodlightVariableDimension4 | String | True | |
FloodlightVariableDimension5 | String | True | |
FloodlightVariableDimension6 | String | True | |
FloodlightVariableDimension7 | String | True | |
FloodlightVariableDimension8 | String | True | |
FloodlightVariableDimension9 | String | True | |
FloodlightVariableDimension10 | String | True | |
FloodlightVariableDimension11 | String | True | |
FloodlightVariableDimension12 | String | True | |
FloodlightVariableDimension13 | String | True | |
FloodlightVariableDimension14 | String | True | |
FloodlightVariableDimension15 | String | True | |
FloodlightVariableDimension16 | String | True | |
FloodlightVariableDimension17 | String | True | |
FloodlightVariableDimension18 | String | True | |
FloodlightVariableDimension19 | String | True | |
FloodlightVariableDimension20 | String | True | |
FloodlightVariableDimension21 | String | True | |
FloodlightVariableDimension22 | String | True | |
FloodlightVariableDimension23 | String | True | |
FloodlightVariableDimension24 | String | True | |
FloodlightVariableDimension25 | String | True | |
FloodlightVariableDimension26 | String | True | |
FloodlightVariableDimension27 | String | True | |
FloodlightVariableDimension28 | String | True | |
FloodlightVariableDimension29 | String | True | |
FloodlightVariableDimension30 | String | True | |
FloodlightVariableDimension31 | String | True | |
FloodlightVariableDimension32 | String | True | |
FloodlightVariableDimension33 | String | True | |
FloodlightVariableDimension34 | String | True | |
FloodlightVariableDimension35 | String | True | |
FloodlightVariableDimension36 | String | True | |
FloodlightVariableDimension37 | String | True | |
FloodlightVariableDimension38 | String | True | |
FloodlightVariableDimension39 | String | True | |
FloodlightVariableDimension40 | String | True | |
FloodlightVariableDimension41 | String | True | |
FloodlightVariableDimension42 | String | True | |
FloodlightVariableDimension43 | String | True | |
FloodlightVariableDimension44 | String | True | |
FloodlightVariableDimension45 | String | True | |
FloodlightVariableDimension46 | String | True | |
FloodlightVariableDimension47 | String | True | |
FloodlightVariableDimension48 | String | True | |
FloodlightVariableDimension49 | String | True | |
FloodlightVariableDimension50 | String | True | |
FloodlightVariableDimension51 | String | True | |
FloodlightVariableDimension52 | String | True | |
FloodlightVariableDimension53 | String | True | |
FloodlightVariableDimension54 | String | True | |
FloodlightVariableDimension55 | String | True | |
FloodlightVariableDimension56 | String | True | |
FloodlightVariableDimension57 | String | True | |
FloodlightVariableDimension58 | String | True | |
FloodlightVariableDimension59 | String | True | |
FloodlightVariableDimension60 | String | True | |
FloodlightVariableDimension61 | String | True | |
FloodlightVariableDimension62 | String | True | |
FloodlightVariableDimension63 | String | True | |
FloodlightVariableDimension64 | String | True | |
FloodlightVariableDimension65 | String | True | |
FloodlightVariableDimension66 | String | True | |
FloodlightVariableDimension67 | String | True | |
FloodlightVariableDimension68 | String | True | |
FloodlightVariableDimension69 | String | True | |
FloodlightVariableDimension70 | String | True | |
FloodlightVariableDimension71 | String | True | |
FloodlightVariableDimension72 | String | True | |
FloodlightVariableDimension73 | String | True | |
FloodlightVariableDimension74 | String | True | |
FloodlightVariableDimension75 | String | True | |
FloodlightVariableDimension76 | String | True | |
FloodlightVariableDimension77 | String | True | |
FloodlightVariableDimension78 | String | True | |
FloodlightVariableDimension79 | String | True | |
FloodlightVariableDimension80 | String | True | |
FloodlightVariableDimension81 | String | True | |
FloodlightVariableDimension82 | String | True | |
FloodlightVariableDimension83 | String | True | |
FloodlightVariableDimension84 | String | True | |
FloodlightVariableDimension85 | String | True | |
FloodlightVariableDimension86 | String | True | |
FloodlightVariableDimension87 | String | True | |
FloodlightVariableDimension88 | String | True | |
FloodlightVariableDimension89 | String | True | |
FloodlightVariableDimension90 | String | True | |
FloodlightVariableDimension91 | String | True | |
FloodlightVariableDimension92 | String | True | |
FloodlightVariableDimension93 | String | True | |
FloodlightVariableDimension94 | String | True | |
FloodlightVariableDimension95 | String | True | |
FloodlightVariableDimension96 | String | True | |
FloodlightVariableDimension97 | String | True | |
FloodlightVariableDimension98 | String | True | |
FloodlightVariableDimension99 | String | True | |
FloodlightVariableDimension100 | String | True | |
HasRichMediaBackupImages | Boolean | True | |
HasRichMediaCustomCounters | Boolean | True | |
HasRichMediaCustomExits | Boolean | True | |
HasRichMediaCustomTimers | Boolean | True | |
HasRichMediaDynamicAdImpressions | Boolean | True | |
HasRichMediaExpansions | Boolean | True | |
HasRichMediaFullScreenImpressions | Boolean | True | |
HasRichMediaFullScreenVideoCompletions | Boolean | True | |
HasRichMediaFullScreenVideoPlays | Boolean | True | |
HasRichMediaFullScreenViews | Boolean | True | |
HasRichMediaHtml5Impressions | Boolean | True | |
HasRichMediaInteractiveImpressions | Boolean | True | |
HasRichMediaManualCloses | Boolean | True | |
HasRichMediaVideoCompanionClicks | Boolean | True | |
HasRichMediaVideoCompletions | Boolean | True | |
HasRichMediaVideoFirstQuartileCompletes | Boolean | True | |
HasRichMediaVideoFullScreens | Boolean | True | |
HasRichMediaVideoInteractions | Boolean | True | |
HasRichMediaVideoMidpoints | Boolean | True | |
HasRichMediaVideoMutes | Boolean | True | |
HasRichMediaVideoPauses | Boolean | True | |
HasRichMediaVideoPlays | Boolean | True | |
HasRichMediaVideoProgressEvents | Boolean | True | |
HasRichMediaVideoReplays | Boolean | True | |
HasRichMediaVideoSkips | Boolean | True | |
HasRichMediaVideoStops | Boolean | True | |
HasRichMediaVideoThirdQuartileCompletes | Boolean | True | |
HasRichMediaVideoUnmutes | Boolean | True | |
HasRichMediaVideoViews | Boolean | True | |
Hour | String | True | |
HoursSinceAttributedInteraction | Long | True | |
HoursSinceFirstInteraction | Long | True | |
ImpressionCount | Long | True | |
InteractionChannel | String | True | |
InteractionCountClickTracker | Long | True | |
InteractionCountMobileRichMedia | Long | True | |
InteractionCountMobileStaticImage | Long | True | |
InteractionCountMobileVideo | Long | True | |
InteractionCountNaturalSearch | Long | True | |
InteractionCountPaidSearch | Long | True | |
InteractionCountRichMedia | Long | True | |
InteractionCountStaticImage | Long | True | |
InteractionCountVideo | Long | True | |
InteractionType | String | True | |
MobileCarrier | String | True | |
Month | String | True | |
NaturalSearchEngineCountry | String | True | |
NaturalSearchEngineProperty | String | True | |
NaturalSearchEngineUrl | String | True | |
NaturalSearchLandingPage | String | True | |
NaturalSearchLandingPageQueryString | String | True | |
NaturalSearchProcessedLandingPage | String | True | |
NaturalSearchProcessedLandingPageQueryString | String | True | |
NaturalSearchQuery | String | True | |
NumValue | String | True | |
OperatingSystem | String | True | |
OperatingSystemVersion | String | True | |
OrdValue | String | True | |
PackageRoadblock | String | True | |
PackageRoadblockId | Long | True | |
PackageRoadblockStrategy | String | True | |
PaidSearchAd | String | True | |
PaidSearchAdGroup | String | True | |
PaidSearchAdGroupId | Long | True | |
PaidSearchAdId | Long | True | |
PaidSearchAdvertiser | String | True | |
PaidSearchAdvertiserId | Long | True | |
PaidSearchAgency | String | True | |
PaidSearchAgencyId | Long | True | |
PaidSearchBidStrategy | String | True | |
PaidSearchBidStrategyId | Long | True | |
PaidSearchCampaign | String | True | |
PaidSearchCampaignId | Long | True | |
PaidSearchEngineAccount | String | True | |
PaidSearchEngineAccountCategory | String | True | |
PaidSearchEngineAccountId | Long | True | |
PaidSearchExternalAdGroupId | Long | True | |
PaidSearchExternalAdId | Long | True | |
PaidSearchExternalCampaignId | Long | True | |
PaidSearchExternalKeywordId | Long | True | |
PaidSearchKeyword | String | True | |
PaidSearchKeywordId | Long | True | |
PaidSearchLabels | String | True | |
PaidSearchLandingPageUrl | String | True | |
PaidSearchLegacyKeywordId | Long | True | |
PaidSearchMatchType | String | True | |
PathLength | Long | True | |
PathType | String | True | |
Placement | String | True | |
PlacementEndDate | String | True | |
PlacementId | Long | True | |
PlacementSize | String | True | |
PlacementStartDate | String | True | |
PlatformType | String | True | |
RenderingId | Long | True | |
RichMediaVideoLength | String | True | |
Site | String | True | |
SiteDirectory | String | True | |
SiteDirectoryId | Long | True | |
SiteKeyname | String | True | |
StandardRichMediaEventCount | Long | True | |
StandardRichMediaEventPathSummary | String | True | |
State | String | True | |
TranValue | String | True | |
UValue | String | True | |
Week | String | True | |
ZipCode | Long | True | |
ActivityClickThroughConversions | Double | False | |
ActivityClickThroughRevenue | Double | False | |
ActivityViewThroughConversions | Double | False | |
ActivityViewThroughRevenue | Double | False | |
FloodlightImpressions | Long | False | |
FloodlightVariableMetric1 | Double | False | |
FloodlightVariableMetric2 | Double | False | |
FloodlightVariableMetric3 | Double | False | |
FloodlightVariableMetric4 | Double | False | |
FloodlightVariableMetric5 | Double | False | |
FloodlightVariableMetric6 | Double | False | |
FloodlightVariableMetric7 | Double | False | |
FloodlightVariableMetric8 | Double | False | |
FloodlightVariableMetric9 | Double | False | |
FloodlightVariableMetric10 | Double | False | |
FloodlightVariableMetric11 | Double | False | |
FloodlightVariableMetric12 | Double | False | |
FloodlightVariableMetric13 | Double | False | |
FloodlightVariableMetric14 | Double | False | |
FloodlightVariableMetric15 | Double | False | |
FloodlightVariableMetric16 | Double | False | |
FloodlightVariableMetric17 | Double | False | |
FloodlightVariableMetric18 | Double | False | |
FloodlightVariableMetric19 | Double | False | |
FloodlightVariableMetric20 | Double | False | |
FloodlightVariableMetric21 | Double | False | |
FloodlightVariableMetric22 | Double | False | |
FloodlightVariableMetric23 | Double | False | |
FloodlightVariableMetric24 | Double | False | |
FloodlightVariableMetric25 | Double | False | |
FloodlightVariableMetric26 | Double | False | |
FloodlightVariableMetric27 | Double | False | |
FloodlightVariableMetric28 | Double | False | |
FloodlightVariableMetric29 | Double | False | |
FloodlightVariableMetric30 | Double | False | |
FloodlightVariableMetric31 | Double | False | |
FloodlightVariableMetric32 | Double | False | |
FloodlightVariableMetric33 | Double | False | |
FloodlightVariableMetric34 | Double | False | |
FloodlightVariableMetric35 | Double | False | |
FloodlightVariableMetric36 | Double | False | |
FloodlightVariableMetric37 | Double | False | |
FloodlightVariableMetric38 | Double | False | |
FloodlightVariableMetric39 | Double | False | |
FloodlightVariableMetric40 | Double | False | |
FloodlightVariableMetric41 | Double | False | |
FloodlightVariableMetric42 | Double | False | |
FloodlightVariableMetric43 | Double | False | |
FloodlightVariableMetric44 | Double | False | |
FloodlightVariableMetric45 | Double | False | |
FloodlightVariableMetric46 | Double | False | |
FloodlightVariableMetric47 | Double | False | |
FloodlightVariableMetric48 | Double | False | |
FloodlightVariableMetric49 | Double | False | |
FloodlightVariableMetric50 | Double | False | |
FloodlightVariableMetric51 | Double | False | |
FloodlightVariableMetric52 | Double | False | |
FloodlightVariableMetric53 | Double | False | |
FloodlightVariableMetric54 | Double | False | |
FloodlightVariableMetric55 | Double | False | |
FloodlightVariableMetric56 | Double | False | |
FloodlightVariableMetric57 | Double | False | |
FloodlightVariableMetric58 | Double | False | |
FloodlightVariableMetric59 | Double | False | |
FloodlightVariableMetric60 | Double | False | |
FloodlightVariableMetric61 | Double | False | |
FloodlightVariableMetric62 | Double | False | |
FloodlightVariableMetric63 | Double | False | |
FloodlightVariableMetric64 | Double | False | |
FloodlightVariableMetric65 | Double | False | |
FloodlightVariableMetric66 | Double | False | |
FloodlightVariableMetric67 | Double | False | |
FloodlightVariableMetric68 | Double | False | |
FloodlightVariableMetric69 | Double | False | |
FloodlightVariableMetric70 | Double | False | |
FloodlightVariableMetric71 | Double | False | |
FloodlightVariableMetric72 | Double | False | |
FloodlightVariableMetric73 | Double | False | |
FloodlightVariableMetric74 | Double | False | |
FloodlightVariableMetric75 | Double | False | |
FloodlightVariableMetric76 | Double | False | |
FloodlightVariableMetric77 | Double | False | |
FloodlightVariableMetric78 | Double | False | |
FloodlightVariableMetric79 | Double | False | |
FloodlightVariableMetric80 | Double | False | |
FloodlightVariableMetric81 | Double | False | |
FloodlightVariableMetric82 | Double | False | |
FloodlightVariableMetric83 | Double | False | |
FloodlightVariableMetric84 | Double | False | |
FloodlightVariableMetric85 | Double | False | |
FloodlightVariableMetric86 | Double | False | |
FloodlightVariableMetric87 | Double | False | |
FloodlightVariableMetric88 | Double | False | |
FloodlightVariableMetric89 | Double | False | |
FloodlightVariableMetric90 | Double | False | |
FloodlightVariableMetric91 | Double | False | |
FloodlightVariableMetric92 | Double | False | |
FloodlightVariableMetric93 | Double | False | |
FloodlightVariableMetric94 | Double | False | |
FloodlightVariableMetric95 | Double | False | |
FloodlightVariableMetric96 | Double | False | |
FloodlightVariableMetric97 | Double | False | |
FloodlightVariableMetric98 | Double | False | |
FloodlightVariableMetric99 | Double | False | |
FloodlightVariableMetric100 | Double | False | |
LastClickAttributedTransactionCount | Double | False | |
LastImpressionAttributedTransactionCount | Double | False | |
RichMediaAverageExpansionTime | Double | False | |
RichMediaAverageFullScreenViewTime | Double | False | |
RichMediaAverageInteractionTime | Double | False | |
RichMediaAverageVideoViewTime | Double | False | |
RichMediaBackupImages | Long | False | |
RichMediaCustomAverageTime | Double | False | |
RichMediaCustomCounters | Long | False | |
RichMediaCustomExits | Long | False | |
RichMediaCustomTimers | Long | False | |
RichMediaDisplayTime | Long | False | |
RichMediaExpansionTime | Long | False | |
RichMediaExpansions | Long | False | |
RichMediaFullScreenImpressions | Long | False | |
RichMediaFullScreenVideoCompletes | Long | False | |
RichMediaFullScreenVideoPlays | Long | False | |
RichMediaHtml5Impressions | Long | False | |
RichMediaInteractionTime | Long | False | |
RichMediaInteractions | Long | False | |
RichMediaInteractiveImpressions | Long | False | |
RichMediaManualCloses | Long | False | |
RichMediaVideoCompanionClicks | Long | False | |
RichMediaVideoCompletions | Long | False | |
RichMediaVideoFirstQuartileCompletes | Long | False | |
RichMediaVideoFullScreens | Long | False | |
RichMediaVideoInteractionRate | Double | False | |
RichMediaVideoInteractions | Long | False | |
RichMediaVideoMidpoints | Long | False | |
RichMediaVideoMutes | Long | False | |
RichMediaVideoPauses | Long | False | |
RichMediaVideoPlays | Long | False | |
RichMediaVideoProgressEvents | Long | False | |
RichMediaVideoReplays | Long | False | |
RichMediaVideoSkips | Long | False | |
RichMediaVideoStops | Long | False | |
RichMediaVideoThirdQuartileCompletes | Long | False | |
RichMediaVideoUnmutes | Long | False | |
RichMediaVideoViewRate | Double | False | |
RichMediaVideoViews | Long | False | |
TotalConversions | Double | False | |
TotalConversionsRevenue | Double | False | |
TransactionCount | Long | False |
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 |
ReportID | String | Optional input to pull a specific report by ID. |
FileID | String | Optional input to pull a specific file by ID. |