Supermetrics Support Forum

Solved

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

  • We're having an issue with this connector where it's not accurately calculating Bing/Adwords combined CPC, CPA and at times, conversion rate. It is however, pulling all the other data correctly. Any insight into why this might be the case? See screenshot below. The top line is manually entered and correct - the bottom line is what is being pulled with this connector.

  • Hi Sara,


    Can you submit a private ticket for this issue? We will need to request data/report access to troubleshoot this which you probably don't want to post on the public forum.

    https://support.supermetrics.com/support/tickets/new


    Please fill in the form in Team Management to grant us permission to your file and query data? Directions for how to do this are here: Granting Permission for Data Access to Support (If you have done this before, please let us know)


    After filling the form, give support@supermetrics.com a temporary edit access to the file and send us a link to it in the private ticket so we can check into it.


    -Thank you

    Supermetrics Support