Skip to main content

Data transformations

Share your best tips and tricks about data transformation, such as data blending and custom fields, and ask the community for help.

  • 4 Topics
  • 5 Replies
4 Topics
xuchen1987
xuchen1987Newbie
asked in Data transformations
GA4 to BQ backfill schema

the ga4 product does not offer a native bq backfill, therefore, i'd want to understand the exact schema of the data this is offering since supermetrics is doing some "magic" to backfill the data. if it's 100% the same as the native ga4 bq export.

20
xuchen1987
18 hours ago
David
DavidNewbie
posted in Data transformations
Filters for transfers to BQ

Hi fellow data crunchers,I believe we are not the only team that misses Universal Analytics, with its filter options and views that made reporting easier. A very common issue we are facing is that we work with a team that manages only a certain vertical of their organisation (certain countries, sub-domains etc.) and we want to pull data for only this vertical from GA4. The option we have right now is to add an extra dimension to the data transfers in Supermetrics then filter the relevant vertical in Big Query to show performance on only that.This makes the data crazy fragmented and in some cases cardinality issues could arise. Any of you have similar issues that a filter for transfers could solve? 

885
Otto
21 days ago
Mick
MickSupermetrics Team
posted in Data transformations
Early access to data blending features and more in the Data Management group!

Are you reporting cross-channel attribution? If so, our latest update to data blending will make your life easier.Today, Supermetrics supports blending similar sources like paid media channels using union operations. But we know how tricky it can be to include conversion data from platforms like Google Analytics or Shopify. That’s why we’re introducing join operations—so you can get conversion data from platforms such as Google Analytics 4, Shopify, and Salesforce.Join the data management group to learn more and get early access to the feature.

130
Mick
1 month ago
tea.korpi
tea.korpiCommunity Moderator
posted in Data transformations
Join Data Management Community Group! 👋🏼

Want to level up your reporting and get more out of our data management features? We’ve got a place just for you! We now have a Data Management Group in the Supermetrics Community where you can learn more and share best practices about:Custom fields Data blending Account taggingAnd here’s the best part—as a group member, you’ll get a chance to test early access features as soon as they are released! Upcoming early access releases include Joins in Data Blending, which allows you to report ROAS easier than before, Data Blending templates, and so much more! 👀Connect with others, swap tips, and get inspired! Join us and be part of the conversation!  

90
tea.korpi
2 months ago
Terms & ConditionsCookie settings