AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Analytics
4.8K members online now
4.8K members online now
Dive into multiple domain (Cross/Sub) tracking, implementing Ecommerce and Enhanced Ecommerce, setting up Event tracking, and Universal Analytics code.
 
Guide Me
star_border
Reply

Google BigQuery Dimensions / Metric Export Overview

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hi All,

 

Currently looking for a complete overview of the available dimensions and metrics that we can export using Google BigQuery. I found this (https://support.google.com/analytics/answer/3437719?hl=nl) list, but it seems rather limited. Is there a more complete list of available data or is this it? 

 

Best regards,

Joost

Re: Google BigQuery Dimensions / Metric Export Overview

Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆
Hi joost,
the list if the one that you shared.
remember that On Big Query you find the Atomic data of Google Analytics you need to get a lot of the metrics that you find on normal reporting from GA by yourself.

Can you do an example of what you think is missed?

Fil

Re: Google BigQuery Dimensions / Metric Export Overview

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Hi Fil,

We are looking for a specific set of dimensions and metrics to export attribution data (e.g. position-based modeling, data driven modeling, etc.).

Regards,
Joost

Re: Google BigQuery Dimensions / Metric Export Overview

Explorer ✭ ☆ ☆
# 4
Explorer ✭ ☆ ☆
Hi Joost,
this are the kind of data that you have to calculate by your self using the atom data of GA on big Query.

As you can see there is no goal data to into the BigQuery you have to obtain it.

Fil

Re: Google BigQuery Dimensions / Metric Export Overview

Follower ✭ ☆ ☆
# 5
Follower ✭ ☆ ☆
Hi Fil,

Would you mind elaborating a little bit more on your last reply. for instance, saywe would like to obtain data based on the following metrics:
- Data-Driven Conversions
- Data-Driven Conversion Value

Which fields would we need to query to obtain this data? If Data-Driven attribution is not obtainable, could we obtain position-based metrics or custom attribution model metrics?

Regards,
Joost

Re: Google BigQuery Dimensions / Metric Export Overview

Explorer ✭ ☆ ☆
# 6
Explorer ✭ ☆ ☆
Hi Joost,

none of them can be obtained from Big Query directly, no Data Driven, no position based metric, no custom attribution model.

But on big Query you have all the data to obtain them writing your code.

Re: Google BigQuery Dimensions / Metric Export Overview

Follower ✭ ☆ ☆
# 7
Follower ✭ ☆ ☆
Hi Fil,

Thank you! Would you perhaps know a source that can tell me a little bit more about extracting Attribution Data from Big Query?

Regards,
Joost

Re: Google BigQuery Dimensions / Metric Export Overview

Explorer ✭ ☆ ☆
# 8
Explorer ✭ ☆ ☆
There is not a guide unfortunately, their are complex algorithm that use the hit level data that you find into BigQuery to analyze user behaviour.

Re: Google BigQuery Dimensions / Metric Export Overview

Follower ✭ ☆ ☆
# 9
Follower ✭ ☆ ☆
Hi Fil,

Thank you for all your replies. Time to work with a code specialist i guess.

Regards,
Joost