Relatively new to looker studio.
I have two sets of data, FB ad data via a connector and data from big query. On their own, they are functioning as expected and data is displaying correctly.
However, when I join the tables on the value they have in common (UTM Campaign) and try to display spend level data (havent even added any of the big query data to my table) it seems to multiple the data by an unknown amount, leading to a massively engorged spend. None of the aggregation methods or changing the join type (left, right, inner, full) seems to help in anyway.
Not really sure where to go from here.
LinkedIn
Twitter
