Log in
  1. OWOX Help Center
  2. Data sources → Google BigQuery
  3. Google Analytics Universal API → Google BigQuery
🔗 Copy link

How to import Custom Reports from Google Analytics Universal

With OWOX BI you are able to import different kinds of custom Reports in GAUA→GBQ By Request Pipeline. All metrics can be taken here.

 

E-commerce Product Performance Report

Dimensions Metrics
  1. Product - ga:productName
  1. Quantity - ga:itemQuantity
  2. Unique Purchases - ga:uniquePurchases
  3. Avg. Price - ga:revenuePerItem
  4. Product Revenue - ga:itemRevenue
  5. Avg. QTY - ga:itemsPerPurchase
  6. Buy-to-Detail Rate - ga:buyToDetailRate
  7. Cart-to-Detail Rate - ga:cartToDetailRate
  8. Product Refund Amount - ga:productRefundAmount

 

E-commerce Sales Performance Report

Dimensions Metrics
  1. Transaction ID - ga:transactionId
  1. Revenue - ga:transactionRevenue
  2. Tax - ga:transactionTax
  3. Quantity - ga:itemQuantity
  4. Refund Amount - ga:refundAmount

 

Goals Report

Dimensions Metrics
  1. Goal Completion Location - ga:goalCompletionLocation
  2. Goal Previous Step 1 - ga:goalPreviousStep1
  3. Goal Previous Step 2 - ga:goalPreviousStep2
  4. Goal Previous Step 3 - ga:goalPreviousStep3
  1. Goal Completions - ga:goalCompletionsAll
  2. Goal Value - ga:goalValueAll
  3. Goal Conversion Rate - ga:goalConversionRateAll
  4. Total Abandonment Rate - ga:goalAbandonRateAll

 

Campaign Report

Dimensions Metrics
  1. Campaign - ga:campaign
  1. Users - ga:users
  2. New Users - ga:newUsers
  3. Sessions - ga:sessions
  4. Bounce Rate - ga:bounceRate
  5. Avg. Session Duration - ga:avgSessionDuration
  6. Pages / Session - ga:pageviewsPerSession
  7. Transactions - ga:transactions
  8. E-commerce Conversion Rate - ga:transactionsPerSession
  9. Revenue - ga:transactionRevenue

 

Referral Report

Dimensions Metrics
  1. Source - ga:source
  1. Users - ga:users
  2. New Users - ga:newUsers
  3. Sessions - ga:sessions
  4. Bounce Rate - ga:bounceRate
  5. Avg. Session Duration - ga:avgSessionDuration
  6. Pages / Session - ga:pageviewsPerSession
  7. Transactions - ga:transactions
  8. E-commerce Conversion Rate - ga:transactionsPerSession
  9. Revenue - ga:transactionRevenue

 

Events Report

Dimensions Metrics
  1. Event Category - ga:eventCategory
  2. Event Action - ga:eventAction
  3. Event Label - ga:eventLabel
  1. Total Events - ga:totalEvents
  2. Unique Events - ga:uniqueEvents
  3. Event Value - ga:eventValue
  4. Avg. Value - ga:avgEventValue

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.

Related articles