MDW GA Table Spec: fact_vendor_ga_sourcemedium
fact_vendor_ga_sourcemedium
Term | Definition | Datatype |
date | date | Date |
campaign | campaign | String(1000) |
userType | userType | String(1000) |
sourceMedium | sourceMedium | String(1000) |
users | users | Amount |
newUsers | newUsers | Amount |
sessions | sessions | Amount |
bounceRate | bounceRate | Amount |
pageviewsPerSession | pageviewPerSession | Amount |
avgSessionDuration | avgSessionDuration | Amount |
transactions | transactions | Amount |
goal1Completions | goal1Completions | Amount |
goal2Completions | goal2Completions | Amount |
goal3Completions | goal3Completions | Amount |
goal4Completions | goal4Completions | Amount |
goal5Completions | goal5Completions | Amount |
goal6Completions | goal6Completions | Amount |
goal7Completions | goal7Completions | Amount |
goal8Completions | goal8Completions | Amount |
goal9Completions | goal9Completions | Amount |
goal10Completions | goal10Completions | Amount |
goal11Completions | goal11Completions | Amount |
goal12Completions | goal12Completions | Amount |
goal13Completions | goal13Completions | Amount |
goal14Completions | goal14Completions | Amount |
goal15Completions | goal15Completions | Amount |
goal16Completions | goal16Completions | Amount |
goal17Completions | goal17Completions | Amount |
goal18Completions | goal18Completions | Amount |
goal19Completions | goal19Completions | Amount |
goal20Completions | goal20Completions | Amount |
goalCompletionsAll | goalCompletionsAll | Amount |
goal1Value | goal1Value | Amount |
goal2Value | goal2Value | Amount |
goal3Value | goal3Value | Amount |
goal4Value | goal4Value | Amount |
goal5Value | goal5Value | Amount |
goal6Value | goal6Value | Amount |
goal7Value | goal7Value | Amount |
goal8Value | goal8Value | Amount |
goal9Value | goal9Value | Amount |
goal10Value | goal10Value | Amount |
goal11Value | goal11Value | Amount |
goal12Value | goal12Value | Amount |
goal13Value | goal13Value | Amount |
goal14Value | goal14Value | Amount |
goal15Value | goal15Value | Amount |
goal16Value | goal16Value | Amount |
goal17Value | goal17Value | Amount |
goal18Value | goal18Value | Amount |
goal19Value | goal19Value | Amount |
goal20Value | goal20Value | Amount |
goalValueAll | goalValueAll | Amount |
transactionRevenue | transactionRevenue | Amount |
transactionsPerSession | transactionsPerSession | Amount |
viewid | viewID | String(1000) |
viewName | viewName | String(1000) |
batch_id | ${this.batchID} | String(255) |
