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
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |