Supermetrics Support Forum

Combine Bing ads and Google adwords data into one table?

Hi,  I need to pull data from Bing ads, and then Google adwords, and then have the data appear combined for these two data sources.  Is that possible with your product?  Sp not side by side, but actually combined with totals together?  Do you have any sample reports of this?  Willing to buy product of yes.  Thanks.

  • Hi Kevin,

    Yes, you can do this with the "Ad Data + Google Analytics" connector we offer.

    https://datastudio.google.com/datasources/create?connectorId=AKfycbxjJ5i2ubmmKMXRLMW4-gEkm_sb-zPXHwIPGweRvaOokOUJYFiN0394


    If you only want to use Bing and AdWord, then only log into those parts of the connector so the others aren't used. Note that this connector is mostly for campaign and cost data, so it offers a very limited metric/dimension set as compared to the specific connectors for those data sources.


    There's a template for this connector specifically that shows off how it works:

    https://datastudio.google.com/u/0/reporting/0BzjchXrR5ZQcemRjN1BoQWN3MWs/page/rtPF/preview


    I hope this helps. Please let us know if you have any other questions.


    -Thank you

    Supermetrics Team

  • I checked Supermetrics for Google Sheets forum but how can you do this in Google Sheets?

  • Hi Vant,


    In Sheets there's no combination connectors, but you don't really need them as you can make many queries into the same tab to pull the metrics from the data sources you want and then combine the data from those queries using standard Sheets functions.  


    There's some examples of this in the Sheets Template Gallery, like the Paid Channel Mix Template.


    -Thank you

    Supermetrics Team

Login to post a comment