Create a Workflow
First, let's set up our workflow. We'll start by pulling data from our first advertising platform. In this example, we'll use Facebook. We'll create a "Pull Data" building block and name it raw_fb.
Next, we'll pull data from our second advertising platform, which will be Google Ads for this demonstration. Similarly, we'll create a "Pull Data" building block and name it raw_ga.
Harmonize Column Names
Different advertising platforms often have different column names, so we need to harmonize them. To do this, we'll add a "Create Report" child block to each "Pull Data" block. We'll go into the column names and rename them to ensure consistency.
Merge the Datasets
Now that our column names are harmonized, we can merge the datasets. We'll use the "Union" building block for this. We'll indicate that we want to merge processed_fb and processed_ga.
With our datasets merged, it's time to build our final report. We'll add a "Create Report" building block and select the dimensions we want to report on, such as adnetwork, campaign, and Cost metrics. We'll name this final report block Aggregate_Platforms_Final.
Create the Dashboard
Finally, we'll create our dashboard. We'll indicate that Aggregate_Platforms_Final is our data source. This final step will set up our dashboard to visualize the combined data from our various advertising platforms.
And that's it! You've successfully combined data from multiple advertising platforms into a single, cohesive dashboard.