Supermetrics Support Forum

Solved

Google Sheets - Merge Adwords & Bing?

We are testing the Google Sheets add-on and I'm wondering if it's possible to create a file that merges data from Adwords & Bing? I'd like to be able to report on ppc advertising in total instead of separating Google & Bing.


Any ideas? Thanks!

  • Note - this info is feeding into a Data Studio report.

  • Hi Will,


    If you mean merging data by pulling data from multiple data sources in one Google sheet file, Yes that is possible. And then you can add the common metrics and calculations that you need for your PPC reports.


    Best regards,

    - Supermetrics Team

  • Use Google Scripts to merge 2 sheets to a single output one.

  • Is Google Sheets Scripts the only way to merge data?


  • I am merging Google and Bing metrics using exact match VLOOKUPS inside array formulas.¬† I have a single tab with Google Ads data, another tab with the corresponding Microsoft ads data, and then a third tab where they are combined.¬† A fourth tab is used for reporting and visualization of the combined data.

Login to post a comment