-
Beast Mode Scale Markers?
I have a chart showing a performance metric across various ads. What I'd like to do is add a threshold scale marker, so that when things fall below we can take action. However, the scale marker calculation is different from my beast mode. IFNULL(SUM(CASE WHEN `Objective` LIKE '%BRAND%' THEN (`EARL`) ELSE 0 END) / SUM(CASE…
-
Pulling Facebook Breakdowns Through the Connector
We've started running dynamic ads on Facebook, and with how things are set up in Facebook means that in order to distinguish between my two ads (English and Spanish) I need to look at dynamic asset breakdowns. Through the advanced version of the Facebook connector I pull data with a placement breakout. For this, I want to…
-
Updating Brand New SQL Table
What I'm trying to do with this sql data flow is to add to my data two additional columns based on one of the metrics in the origial input. Specifically, take DMA data and get a state and region column. But I'm running into issues. I planned to do this by editing the original data, create a new table with the desired…
-
Append Issues (Not matching & not appending)
We have two Append issues which cropped up this week that I'm wondering if other people have run into. It's worth noting that WoW, our process and dataflow *didn't change* which makes this especially baffling. Not Matching Columns We upload an excel sheet via the file upload connector using the append method. This week,…
