Comments
-
@seth_fuller I'm hitting the same problem - we want to look a a specific 3-week period, or by quarter, and GA4 won't export that data in a way that allows us to show that as a number. I'm invented a bit of a workaround: I show monthly data for that time period:
-
@seth_fuller I always use the Custom Report on the data pull, and each one uses a different Time setting: Year, Year month, Week, or Date. This is one that I have set up to pull by month.
-
@ryanbreneman I'm not sure you ever got an answer on this. Users is always a problem. Period. Unfortunately, it's a Google data export API problem, and not a Domo problem.. which means it likely won't be solved. As you probably already know, you can export data from Google summarized by time frame - hour, day, week, month,…
-
Okay, I'm getting closer. That formula isn't quite working, so what I've done is this: DATE_SUB(Date, INTERVAL 12 MONTH) I'm getting this as my filter: Which would be fine if I were just running this for March, because the way I've done Date is to simply use the first day of the month each month. However I'm trying to…
-
Thank you both! This was really helpful. I ended up using a modification: CASE WHEN RIGHT(Page Path,1) = '/' THEN Page Path ELSE CONCAT(Page Path,'/') END
-
No it's in a date format, it just looks like the date format in the formula is different than the format in my dataset. Which, I think, make the formula much simpler. I just need to tell it to take the date we selected in the card and subtract 13 months.
-
Thank you. Unfortunately I really needed an append here. I was finally able to solve it by making the Priority column the ranked value, and the date column making up the partition.
-
I'm still a little stuck. The date format is actually already calculated in the dataset to the first day of every month, and is in format like Jan 1, 2023.
-
Where, then do I use that Beast Mode? In the Date Range field?
-
@DataMaven I'm so glad a I found another person deep in the weeds with me on GA4! I was looking at recursive dataflows in another thread. How does that benefit me more than just making an ETL with a new dataset? Does it eliminate the additional rows of data?
-
This would be really, really helpful, as we like to send our clients monthly updates and they like to store them. Outlooks seems to not be consistent in its ability to add the chart images to the PDFs.
