See also

Tags

solution
19 Jun 2024 02:50 AM

Aggregate Information for Multiple Advertising Channels

close
In this tutorial, we'll demonstrate how to seamlessly combine data from multiple advertising platforms into a single, unified dataset.

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.
clipboard-2024-06-19-02-26-44-952Z.png

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.
clipboard-2024-06-19-02-27-25-711Z.png

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.

clipboard-2024-06-19-02-28-23-789Z.png

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.
clipboard-2024-06-19-02-28-47-532Z.png

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.
clipboard-2024-06-19-02-29-04-344Z.png

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.
clipboard-2024-06-19-02-30-01-566Z.png
And that's it! You've successfully combined data from multiple advertising platforms into a single, cohesive dashboard.