user046467

Discussions

ETL Addition empty fields
I am using addition to calculate 2 columns into a calculated column "Total 3". Example: Total 1 | Total 2 | Total 3 1 | 2 | 3 2 | 2 | 4 1 | | 4 | 1 | 5 Problem is I don't have data in every row. So as you can see the third one here results nothing instead of 1. 1 + "blank" is still 1. But it returns an empty field. Any…
Automatically add new Facebook ads campaigns to dataset and filters within cards
Hi, Is there a way to automatically add new Facebook campaigns to my datasets? I saw a topic from 2019 stating it isn't possible but maybe there is a workaround by now. Situation: I run ads for multiple products, which have multiple campaigns. I want to see the total amount of clicks/spend/etc. For example: I have campaign…