Display Metrics from Multiple Data Sources in One Table Using Data Stories

If you want to compare the same Metrics like Impressions, Clicks, and Spent across different Data Sources such as Facebook Ads and Google Ads, you can easily do this using the Data Story visualization.

For this post, we’ll use Facebook Ads and Google Ads as the example Data Sources, and display their respective Impressions, Clicks, and Spent Metrics side-by-side.

1. Add a Data Story to your Databoard

   1. In the top left corner, click on Visualization Types and select the Data Story visualization.

2. Configure the layout of your table

   1. Use the edit bar to set the number of rows and columns you want in the table layout.

   2. You can always add or remove rows and columns later.

      

3. Customize the table content

   1. Delete any default text and label your rows and columns to reflect the Metrics and Data Sources you're using.

   2. For example:

      1. Column headers: Facebook Ads, Google Ads

      2. Row labels: Impressions, Clicks, Spent

         

4. Add Metrics to the table using Metric Elements

   1. Click on the cell where you want a Metric to appear.

   2. Click Add Data Story > Metric Elements > choose the Metric and Data Source you want.

   3. Once selected, the Metric value will appear in the chosen cell.

   4. Repeat this for each Metric across your table.
      

      

Why this is useful

• Build side-by-side comparisons of the same Metrics across platforms.

• Save space by consolidating data into a single view.

• Create a more customized reporting layout than standard visualizations offer.

Read more about the Data Story visualization.