Skip to content

Instantly share code, notes, and snippets.

@psrinuhp

psrinuhp/bq_schema.json

Created March 9, 2020 16:11
Show Gist options
  • Save psrinuhp/a9e51999b0e9b6223d37f3b0bafdbe70 to your computer and use it in GitHub Desktop.
Save psrinuhp/a9e51999b0e9b6223d37f3b0bafdbe70 to your computer and use it in GitHub Desktop.
Download ZIP
Big Query Schema
Raw
bq_schema.json
[
{
"mode": "NULLABLE",
"name": "visitorId",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "visitNumber",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "visitId",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "visitStartTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "date",
"type": "STRING"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "visits",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "hits",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "pageviews",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "timeOnSite",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "bounces",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "transactions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "transactionRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "newVisits",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "screenviews",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "uniqueScreenviews",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "timeOnScreen",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "totalTransactionRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "sessionQualityDim",
"type": "INTEGER"
}
],
"mode": "NULLABLE",
"name": "totals",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "referralPath",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "campaign",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "source",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "medium",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "keyword",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "adContent",
"type": "STRING"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "campaignId",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adGroupId",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "creativeId",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "criteriaId",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "page",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "slot",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "criteriaParameters",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "gclId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "customerId",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adNetworkType",
"type": "STRING"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "boomUserlistId",
"type": "INTEGER"
}
],
"mode": "NULLABLE",
"name": "targetingCriteria",
"type": "RECORD"
},
{
"mode": "NULLABLE",
"name": "isVideoAd",
"type": "BOOLEAN"
}
],
"mode": "NULLABLE",
"name": "adwordsClickInfo",
"type": "RECORD"
},
{
"mode": "NULLABLE",
"name": "isTrueDirect",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "campaignCode",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "trafficSource",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "browser",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "browserVersion",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "browserSize",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "operatingSystem",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "operatingSystemVersion",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "isMobile",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "mobileDeviceBranding",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "mobileDeviceModel",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "mobileInputSelector",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "mobileDeviceInfo",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "mobileDeviceMarketingName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "flashVersion",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "javaEnabled",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "language",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "screenColors",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "screenResolution",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "deviceCategory",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "device",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "continent",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "subContinent",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "country",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "region",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "metro",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "city",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "cityId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "networkDomain",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "latitude",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "longitude",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "networkLocation",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "geoNetwork",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "index",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "value",
"type": "STRING"
}
],
"mode": "REPEATED",
"name": "customDimensions",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "hitNumber",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "time",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "hour",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "minute",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "isSecure",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "isInteraction",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "isEntrance",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "isExit",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "referer",
"type": "STRING"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "pagePath",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "hostname",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "pageTitle",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "searchKeyword",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "searchCategory",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "pagePathLevel1",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "pagePathLevel2",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "pagePathLevel3",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "pagePathLevel4",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "page",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "transactionId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "transactionRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "transactionTax",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "transactionShipping",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "affiliation",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "currencyCode",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "localTransactionRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "localTransactionTax",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "localTransactionShipping",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "transactionCoupon",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "transaction",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "transactionId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "productName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "productCategory",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "productSku",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "itemQuantity",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "itemRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "currencyCode",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "localItemRevenue",
"type": "INTEGER"
}
],
"mode": "NULLABLE",
"name": "item",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "contentDescription",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "contentInfo",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "name",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "version",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "id",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "installerId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "appInstallerId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "appName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "appVersion",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "appId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "screenName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "landingScreenName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "exitScreenName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "screenDepth",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "appInfo",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "description",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "isFatal",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "exceptions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "fatalExceptions",
"type": "INTEGER"
}
],
"mode": "NULLABLE",
"name": "exceptionInfo",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "eventCategory",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "eventAction",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "eventLabel",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "eventValue",
"type": "INTEGER"
}
],
"mode": "NULLABLE",
"name": "eventInfo",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "productSKU",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "v2ProductName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "v2ProductCategory",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "productVariant",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "productBrand",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "productRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "localProductRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "productPrice",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "localProductPrice",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "productQuantity",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "productRefundAmount",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "localProductRefundAmount",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "isImpression",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "isClick",
"type": "BOOLEAN"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "index",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "value",
"type": "STRING"
}
],
"mode": "REPEATED",
"name": "customDimensions",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "index",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "value",
"type": "INTEGER"
}
],
"mode": "REPEATED",
"name": "customMetrics",
"type": "RECORD"
},
{
"mode": "NULLABLE",
"name": "productListName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "productListPosition",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "productCouponCode",
"type": "STRING"
}
],
"mode": "REPEATED",
"name": "product",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "promoId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "promoName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "promoCreative",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "promoPosition",
"type": "STRING"
}
],
"mode": "REPEATED",
"name": "promotion",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "promoIsView",
"type": "BOOLEAN"
},
{
"mode": "NULLABLE",
"name": "promoIsClick",
"type": "BOOLEAN"
}
],
"mode": "NULLABLE",
"name": "promotionActionInfo",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "refundAmount",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "localRefundAmount",
"type": "INTEGER"
}
],
"mode": "NULLABLE",
"name": "refund",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "action_type",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "step",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "option",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "eCommerceAction",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "experimentId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "experimentVariant",
"type": "STRING"
}
],
"mode": "REPEATED",
"name": "experiment",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "dfpClicks",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpMatchedQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpMeasurableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpRevenueCpm",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpRevenueCpc",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpViewableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpClicks",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpMatchedQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpMeasurableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpRevenueCpm",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpRevenueCpc",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpViewableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpClicks",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpMatchedQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpMeasurableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpRevenueCpm",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpRevenueCpc",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpViewableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxClicks",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxMatchedQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxMeasurableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxViewableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsUnitsViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsUnitsMatched",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "viewableAdsViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "measurableAdsViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsClicked",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpAdGroup",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "dfpAdUnits",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "dfpNetworkId",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "publisher",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "index",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "customVarName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "customVarValue",
"type": "STRING"
}
],
"mode": "REPEATED",
"name": "customVariables",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "index",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "value",
"type": "STRING"
}
],
"mode": "REPEATED",
"name": "customDimensions",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "index",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "value",
"type": "INTEGER"
}
],
"mode": "REPEATED",
"name": "customMetrics",
"type": "RECORD"
},
{
"mode": "NULLABLE",
"name": "type",
"type": "STRING"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "socialInteractionNetwork",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "socialInteractionAction",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "socialInteractions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "socialInteractionTarget",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "socialNetwork",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "uniqueSocialInteractions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "hasSocialSourceReferral",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "socialInteractionNetworkAction",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "social",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "pageLoadSample",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "pageLoadTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "pageDownloadTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "redirectionTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "speedMetricsSample",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "domainLookupTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "serverConnectionTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "serverResponseTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "domLatencyMetricsSample",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "domInteractiveTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "domContentLoadedTime",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "userTimingValue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "userTimingSample",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "userTimingVariable",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "userTimingCategory",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "userTimingLabel",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "latencyTracking",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "sourcePropertyDisplayName",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "sourcePropertyTrackingId",
"type": "STRING"
}
],
"mode": "NULLABLE",
"name": "sourcePropertyInfo",
"type": "RECORD"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "contentGroup1",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "contentGroup2",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "contentGroup3",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "contentGroup4",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "contentGroup5",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "previousContentGroup1",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "previousContentGroup2",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "previousContentGroup3",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "previousContentGroup4",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "previousContentGroup5",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "contentGroupUniqueViews1",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "contentGroupUniqueViews2",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "contentGroupUniqueViews3",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "contentGroupUniqueViews4",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "contentGroupUniqueViews5",
"type": "INTEGER"
}
],
"mode": "NULLABLE",
"name": "contentGroup",
"type": "RECORD"
},
{
"mode": "NULLABLE",
"name": "dataSource",
"type": "STRING"
},
{
"fields": [
{
"mode": "NULLABLE",
"name": "dfpClicks",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpMatchedQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpMeasurableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpRevenueCpm",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpRevenueCpc",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpViewableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpClicks",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpMatchedQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpMeasurableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpRevenueCpm",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpRevenueCpc",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpViewableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsenseBackfillDfpPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpClicks",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpMatchedQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpMeasurableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpRevenueCpm",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpRevenueCpc",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpViewableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxBackfillDfpPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxClicks",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxMatchedQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxMeasurableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxQueries",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxViewableImpressions",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adxPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsUnitsViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsUnitsMatched",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "viewableAdsViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "measurableAdsViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsPagesViewed",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsClicked",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "adsRevenue",
"type": "INTEGER"
},
{
"mode": "NULLABLE",
"name": "dfpAdGroup",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "dfpAdUnits",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "dfpNetworkId",
"type": "STRING"
}
],
"mode": "REPEATED",
"name": "publisher_infos",
"type": "RECORD"
}
],
"mode": "REPEATED",
"name": "hits",
"type": "RECORD"
},
{
"mode": "NULLABLE",
"name": "fullVisitorId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "userId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "clientId",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "channelGrouping",
"type": "STRING"
},
{
"mode": "NULLABLE",
"name": "socialEngagementType",
"type": "STRING"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment