GoogleAnalytics_Rawdata_from_BigQuery
Sign In
- Project InformationProject NameBigQuery_data_GoogleAnalyticsDataframe NameGA_from_bigqueryCreated Bysugiaki _Created DateUpdated DateDesktop Version5.5.4.7ScheduleScheduling is not supported because:
- No Data Source to Refresh
Last Refresh Log (Schedule)Start TimeFinish TimeTime ElapsedProcessed Data SizeProcessed # of Rows
The preview data is not shown because the data was published by an older version of Exploratory Desktop.
Updated the column descriptions successfully.
Failed to connect to the server. Please contactsupport@exploratory.io.
Description
No description.
Styling with Markdown is supported
Data Dictionary
Column Name
Description
行
visitorId
visitNumber
visitId
visitStartTime
date
totals.visits
totals.hits
totals.pageviews
totals.timeOnSite
totals.bounces
totals.transactions
totals.transactionRevenue
totals.newVisits
totals.screenviews
totals.uniqueScreenviews
totals.timeOnScreen
totals.totalTransactionRevenue
totals.sessionQualityDim
trafficSource.referralPath
trafficSource.campaign
trafficSource.source
trafficSource.medium
trafficSource.keyword
trafficSource.adContent
trafficSource.adwordsClickInfo.campaignId
trafficSource.adwordsClickInfo.adGroupId
trafficSource.adwordsClickInfo.creativeId
trafficSource.adwordsClickInfo.criteriaId
trafficSource.adwordsClickInfo.page
trafficSource.adwordsClickInfo.slot
trafficSource.adwordsClickInfo.criteriaParameters
trafficSource.adwordsClickInfo.gclId
trafficSource.adwordsClickInfo.customerId
trafficSource.adwordsClickInfo.adNetworkType
trafficSource.adwordsClickInfo.targetingCriteria.boomUserlistId
trafficSource.adwordsClickInfo.isVideoAd
trafficSource.isTrueDirect
trafficSource.campaignCode
device.browser
device.browserVersion
device.browserSize
device.operatingSystem
device.operatingSystemVersion
device.isMobile
device.mobileDeviceBranding
device.mobileDeviceModel
device.mobileInputSelector
device.mobileDeviceInfo
device.mobileDeviceMarketingName
device.flashVersion
device.javaEnabled
device.language
device.screenColors
device.screenResolution
device.deviceCategory
geoNetwork.continent
geoNetwork.subContinent
geoNetwork.country
geoNetwork.region
geoNetwork.metro
geoNetwork.city
geoNetwork.cityId
geoNetwork.networkDomain
geoNetwork.latitude
geoNetwork.longitude
geoNetwork.networkLocation
customDimensions.index
customDimensions.value
hits.hitNumber
hits.time
hits.hour
hits.minute
hits.isSecure
hits.isInteraction
hits.isEntrance
hits.isExit
hits.referer
hits.page.pagePath
hits.page.hostname
hits.page.pageTitle
hits.page.searchKeyword
hits.page.searchCategory
hits.page.pagePathLevel1
hits.page.pagePathLevel2
hits.page.pagePathLevel3
hits.page.pagePathLevel4
hits.transaction.transactionId
hits.transaction.transactionRevenue
hits.transaction.transactionTax
hits.transaction.transactionShipping
hits.transaction.affiliation
hits.transaction.currencyCode
hits.transaction.localTransactionRevenue
hits.transaction.localTransactionTax
hits.transaction.localTransactionShipping
hits.transaction.transactionCoupon
hits.item.transactionId
hits.item.productName
hits.item.productCategory
hits.item.productSku
hits.item.itemQuantity
hits.item.itemRevenue
hits.item.currencyCode
hits.item.localItemRevenue
hits.contentInfo.contentDescription
hits.appInfo.name
hits.appInfo.version
hits.appInfo.id
hits.appInfo.installerId
hits.appInfo.appInstallerId
hits.appInfo.appName
hits.appInfo.appVersion
hits.appInfo.appId
hits.appInfo.screenName
hits.appInfo.landingScreenName
hits.appInfo.exitScreenName
hits.appInfo.screenDepth
hits.exceptionInfo.description
hits.exceptionInfo.isFatal
hits.exceptionInfo.exceptions
hits.exceptionInfo.fatalExceptions
hits.eventInfo.eventCategory
hits.eventInfo.eventAction
hits.eventInfo.eventLabel
hits.eventInfo.eventValue
hits.product.productSKU
hits.product.v2ProductName
hits.product.v2ProductCategory
hits.product.productVariant
hits.product.productBrand
hits.product.productRevenue
hits.product.localProductRevenue
hits.product.productPrice
hits.product.localProductPrice
hits.product.productQuantity
hits.product.productRefundAmount
hits.product.localProductRefundAmount
hits.product.isImpression
hits.product.isClick
hits.product.customDimensions.index
hits.product.customDimensions.value
hits.product.customMetrics.index
hits.product.customMetrics.value
hits.product.productListName
hits.product.productListPosition
hits.product.productCouponCode
hits.promotion.promoId
hits.promotion.promoName
hits.promotion.promoCreative
hits.promotion.promoPosition
hits.promotionActionInfo.promoIsView
hits.promotionActionInfo.promoIsClick
hits.refund.refundAmount
hits.refund.localRefundAmount
hits.eCommerceAction.action_type
hits.eCommerceAction.step
hits.eCommerceAction.option
hits.experiment.experimentId
hits.experiment.experimentVariant
hits.publisher.dfpClicks
hits.publisher.dfpImpressions
hits.publisher.dfpMatchedQueries
hits.publisher.dfpMeasurableImpressions
hits.publisher.dfpQueries
hits.publisher.dfpRevenueCpm
hits.publisher.dfpRevenueCpc
hits.publisher.dfpViewableImpressions
hits.publisher.dfpPagesViewed
hits.publisher.adsenseBackfillDfpClicks
hits.publisher.adsenseBackfillDfpImpressions
hits.publisher.adsenseBackfillDfpMatchedQueries
hits.publisher.adsenseBackfillDfpMeasurableImpressions
hits.publisher.adsenseBackfillDfpQueries
hits.publisher.adsenseBackfillDfpRevenueCpm
hits.publisher.adsenseBackfillDfpRevenueCpc
hits.publisher.adsenseBackfillDfpViewableImpressions
hits.publisher.adsenseBackfillDfpPagesViewed
hits.publisher.adxBackfillDfpClicks
hits.publisher.adxBackfillDfpImpressions
hits.publisher.adxBackfillDfpMatchedQueries
hits.publisher.adxBackfillDfpMeasurableImpressions
hits.publisher.adxBackfillDfpQueries
hits.publisher.adxBackfillDfpRevenueCpm
hits.publisher.adxBackfillDfpRevenueCpc
hits.publisher.adxBackfillDfpViewableImpressions
hits.publisher.adxBackfillDfpPagesViewed
hits.publisher.adxClicks
hits.publisher.adxImpressions
hits.publisher.adxMatchedQueries
hits.publisher.adxMeasurableImpressions
hits.publisher.adxQueries
hits.publisher.adxRevenue
hits.publisher.adxViewableImpressions
hits.publisher.adxPagesViewed
hits.publisher.adsViewed
hits.publisher.adsUnitsViewed
hits.publisher.adsUnitsMatched
hits.publisher.viewableAdsViewed
hits.publisher.measurableAdsViewed
hits.publisher.adsPagesViewed
hits.publisher.adsClicked
hits.publisher.adsRevenue
hits.publisher.dfpAdGroup
hits.publisher.dfpAdUnits
hits.publisher.dfpNetworkId
hits.customVariables.index
hits.customVariables.customVarName
hits.customVariables.customVarValue
hits.customDimensions.index
hits.customDimensions.value
hits.customMetrics.index
hits.customMetrics.value
hits.type
hits.social.socialInteractionNetwork
hits.social.socialInteractionAction
hits.social.socialInteractions
hits.social.socialInteractionTarget
hits.social.socialNetwork
hits.social.uniqueSocialInteractions
hits.social.hasSocialSourceReferral
hits.social.socialInteractionNetworkAction
hits.latencyTracking.pageLoadSample
hits.latencyTracking.pageLoadTime
hits.latencyTracking.pageDownloadTime
hits.latencyTracking.redirectionTime
hits.latencyTracking.speedMetricsSample
hits.latencyTracking.domainLookupTime
hits.latencyTracking.serverConnectionTime
hits.latencyTracking.serverResponseTime
hits.latencyTracking.domLatencyMetricsSample
hits.latencyTracking.domInteractiveTime
hits.latencyTracking.domContentLoadedTime
hits.latencyTracking.userTimingValue
hits.latencyTracking.userTimingSample
hits.latencyTracking.userTimingVariable
hits.latencyTracking.userTimingCategory
hits.latencyTracking.userTimingLabel
hits.sourcePropertyInfo.sourcePropertyDisplayName
hits.sourcePropertyInfo.sourcePropertyTrackingId
hits.contentGroup.contentGroup1
hits.contentGroup.contentGroup2
hits.contentGroup.contentGroup3
hits.contentGroup.contentGroup4
hits.contentGroup.contentGroup5
hits.contentGroup.previousContentGroup1
hits.contentGroup.previousContentGroup2
hits.contentGroup.previousContentGroup3
hits.contentGroup.previousContentGroup4
hits.contentGroup.previousContentGroup5
hits.contentGroup.contentGroupUniqueViews1
hits.contentGroup.contentGroupUniqueViews2
hits.contentGroup.contentGroupUniqueViews3
hits.contentGroup.contentGroupUniqueViews4
hits.contentGroup.contentGroupUniqueViews5
hits.dataSource
hits.publisher_infos.dfpClicks
hits.publisher_infos.dfpImpressions
hits.publisher_infos.dfpMatchedQueries
hits.publisher_infos.dfpMeasurableImpressions
hits.publisher_infos.dfpQueries
hits.publisher_infos.dfpRevenueCpm
hits.publisher_infos.dfpRevenueCpc
hits.publisher_infos.dfpViewableImpressions
hits.publisher_infos.dfpPagesViewed
hits.publisher_infos.adsenseBackfillDfpClicks
hits.publisher_infos.adsenseBackfillDfpImpressions
hits.publisher_infos.adsenseBackfillDfpMatchedQueries
hits.publisher_infos.adsenseBackfillDfpMeasurableImpressions
hits.publisher_infos.adsenseBackfillDfpQueries
hits.publisher_infos.adsenseBackfillDfpRevenueCpm
hits.publisher_infos.adsenseBackfillDfpRevenueCpc
hits.publisher_infos.adsenseBackfillDfpViewableImpressions
hits.publisher_infos.adsenseBackfillDfpPagesViewed
hits.publisher_infos.adxBackfillDfpClicks
hits.publisher_infos.adxBackfillDfpImpressions
hits.publisher_infos.adxBackfillDfpMatchedQueries
hits.publisher_infos.adxBackfillDfpMeasurableImpressions
hits.publisher_infos.adxBackfillDfpQueries
hits.publisher_infos.adxBackfillDfpRevenueCpm
hits.publisher_infos.adxBackfillDfpRevenueCpc
hits.publisher_infos.adxBackfillDfpViewableImpressions
hits.publisher_infos.adxBackfillDfpPagesViewed
hits.publisher_infos.adxClicks
hits.publisher_infos.adxImpressions
hits.publisher_infos.adxMatchedQueries
hits.publisher_infos.adxMeasurableImpressions
hits.publisher_infos.adxQueries
hits.publisher_infos.adxRevenue
hits.publisher_infos.adxViewableImpressions
hits.publisher_infos.adxPagesViewed
hits.publisher_infos.adsViewed
hits.publisher_infos.adsUnitsViewed
hits.publisher_infos.adsUnitsMatched
hits.publisher_infos.viewableAdsViewed
hits.publisher_infos.measurableAdsViewed
hits.publisher_infos.adsPagesViewed
hits.publisher_infos.adsClicked
hits.publisher_infos.adsRevenue
hits.publisher_infos.dfpAdGroup
hits.publisher_infos.dfpAdUnits
hits.publisher_infos.dfpNetworkId
fullVisitorId
userId
clientId
channelGrouping
socialEngagementType
Other Information
Size
58k bytes
Type
Details
Parameter
Value