MDW GA Table Spec: fact_vendor_cost_ga
fact_vendor_cost_ga
Why is it important? The table holds the vendor reported feed from google analytics.
Term | Definition | Datatype |
date | date | Date |
users | users | Number |
transactions | transactions | Number |
revenue | transactionRevenue | Amount |
unique_purchases | uniquePurchases | Number |
item_quantity | itemQuantity | Number |
tax | transactionTax | Number |
shipping | transactionShipping | Number |
goal1_completions | goal1Completions | Number |
goal2_completions | goal2Completions | Number |
goal3_completions | goal3Completions | Number |
goal4_completions | goal4Completions | Number |
goal5_completions | goal5Completions | Number |
goal6_completions | goal6Completions | Number |
goal7_completions | goal7Completions | Number |
goal8_completions | goal8Completions | Number |
goal9_completions | goal9Completions | Number |
goal10_completions | goal10Completions | Number |
goal11_completions | goal11Completions | Number |
goal12_completions | goal12Completions | Number |
goal13_completions | goal13Completions | Number |
goal14_completions | goal14Completions | Number |
goal15_completions | goal15Completions | Number |
goal16_completions | goal16Completions | Number |
goal17_completions | goal17Completions | Number |
goal18_completions | goal18Completions | Number |
goal19_completions | goal19Completions | Number |
goal20_completions | goal20Completions | Number |
goalcompletionsall | goalCompletionsAll | Number |
batch_id | ${this.batchID} | String(1000) |
view_id | viewID | String(1000) |
