Comments
-
@ColemenWilson I realize now my blunder in replicating your perfect solution. Apologies for the extra work there. I made a copy of the ETL from scratch using your solution, and it worked. I went back to the original and realized I had messed up the Rank and Window, by Ordering the function on Quarter instead of MonthYear .…
-
I believe the issue lies in joining on the year. However, if we do not join on the year, we get duplicate rows.
-
I am so thankful for people like @ColemenWilson in this community! Your solution gets me so close to my end goal, and lets me think through the data in new [for me], enlightened way. There is one hiccup I am trying to wrap my head around. The dataset [shown below] has 5 unique quarterly values. The fifth value is for our…
-
Hi, @MichelleH. Happy New Year! I worked way too long on a few projects, and found a solution on this project. Unfortunately, I forgot to check this thread, as the solution came to me a few hours later. I used a Group by tile like you suggested. Again, apologies for not replying sooner. The excitement of finishing the work…
-
I can't recommend @DashboardDude enough!! Thank you for going above and beyond in helping me. I am signing up as I type this!
-
@DashboardDude Wow! Thank you!! Apologies for not checking this sooner, yesterday was my in-office day, including 4 hours on the road . I just booked time with you tomorrow. Yes, I used the constants key [provided by Google API documentation] to map Zip Code constants in MagicETL, and create a Criteria ID field —>…
-
Even if I do a pull on the Country-Level, total clicks and total impressions do not match up; the UI numbers are higher by about 10%.
