-
Recommendations for connecting to GA4 data through the BigQuery cloud connector?
We're attempting to access our GA4 data through the BigQuery cloud connector and are running into two problems. Has anyone come across the same and solved for them? 1. If I use Domo to directly connect to a table in BigQuery, it's only one single day's data. I'd have to set up a different dataset/connection for each new…
-
GA4 Connector Settings Best Practices
Those of us who work with Google Analytics 4 data understand getting the data to accurately pull into Domo is at best tricky and really does take closely studying the settings and creating ETLs. I thought it would be a good idea to collect our best practices in one place. For example, if you want to get an accurate user…
-
Previous Month Last Year
I'm trying to make some companion comparison cards so that I can display, for example, on one card the top 10 PDFs downloaded last month this year versus another card with the same month last year. I have the data by month already, and I need to have this for each month, moving forward. Is there an easy way to set some…
-
Find and append a value to a field
I'm trying to align some inconsistencies with our data. What I'd like to do is find any value that does not end with a '/' and append it with that character. Is there a case statement where we can look for a field that does or does not end in a character? I assume if I can do that, I can just append those without with the…
-
Prioritize one set of data over a duplicate set of data, when available.
I have similar data coming in from two different sources. I need to make sure that when dataset A is available, it is used, and when A is not available, B is used. I want to end up with one row of data per day per website, but I either end up with only one day's worth of data per website (Hostname in my data), or I end up…
-
I need to make a bar chart that combines multiple columns based on date
Simply put, I want to display how many users completed each program in Q4 2023, and I want to later be able to select a different date (so later, for example, I can see how many people completed programs in Q1 2024). I want my users to see the most popular progams during a given time period. I think a bar graph will…
-
Caps and not caps in Beast Mode
Hi! I'm trying to pull data into a card where the data varies, but what I want always has the text 'thd' in it. I was fine until my stakeholder wanted us to change the data that is getting sent to a capitalized version, so now I have to account for both caps and not caps. Because all of the Event Labels contain a code, I…
-
GA4 Weekly and Monthly data - should I schedule a better import or make an ETL?
I'm not sure which direction to take - has anyone dealt with GA4 weekly, monthly, and yearly datasets before? I've realized that if I need to get a summary number of users over a certain time period in GA4, the only true way to make sure they are not double counted is to make separate datasets that pull in users by day, by…
