-
Creating complex ranking using certain values within a dimension
Hello all! I am attempting to create a sankey diagram that shows a customers activities leading up to a certain conversion. Each customer can have multiple conversions so I want to rank each activity leading up to a conversion, and have that rank reset after the conversion happens. Having some trouble theorizing how to do…
-
Formula not summarizing in analyzer
Hello Dojo, I have a calculated field I am trying to apply to a time series chart that does not seem to want to summarize. The formula changes based on one of the variables - objective. case when `Objective` = 'CLICKS' then (case when (sum(`Clicks`) / sum(`Impressions`)) < .0082 then 0 when (sum(`Clicks`) /…
-
Is there a way to nest beast modes in another beast mode without exposing the full calculation
Looking for any advice suggestions on the following. First, I wanted to ask, if I make a change to a saved beast mode, and another calculation is using that beast mode will that calculation automatically update? Second, I would like to nest multiple beast modes in a calculation and use a case statement to select which…
-
Average of an Average of an Average
Hello, I have a project that is using an interesting methodology to score social media ads/campaigns/accounts. They first score each ad, then they average the ad level scores to get the campaign score, then they average the campaign scores to get the account scores. In the example above I score the ad based on the…
-
HTML as an image in an html table
Hello, we are trying to report on performance of certain creatives within one of our ad serving platforms: flashtalking. Within Flashtalking they have a link which takes you to a preview of the advertisement, however the creative is not in an image format, just HTML: example…
-
UTM_ID in Google Analytics Advanced connector
Anyone have experience pulling in the UTM_ID into the GA4 connector? We are implementing a UTM_ID as a unique ID for each of our UTM Campaigns and would like to pull this through. Would this show up as a custom dimension - or would it show up in the traffic sources when it is received?