Forums Forums PPC Blending Facebook Ads & Google Ads Data Source on Data Studio

  • PPC

    Blending Facebook Ads & Google Ads Data Source on Data Studio

    Posted by seohelper on October 11, 2020 at 5:16 pm

    Hi! I’d like just to know how to blend Facebook Ads and Google Ads in Data Studio. I’m using Supermetrics as my connector. I just want to blend the account name on both data sources for the drop-down menu and doesn’t need to blend on graphs since they have separate graphs. I tried to blend it with the ‘date’ field as well as ‘account name’ as my join key but I keep on getting an error on the drop-down menu.

    treasury_minister replied 5 years, 5 months ago 1 Member · 2 Replies
  • 2 Replies
  • puremensan

    Guest
    October 11, 2020 at 5:39 pm

    Im not really understanding how you describe the question.

    If they are separate graphs then you can add them separately. If you need to pull data from both places to a single element/graph, you need to blend the data in the Resources -> Blended Data menu.

  • treasury_minister

    Guest
    October 11, 2020 at 6:06 pm

    Maybe through calculated fields using CASE to match account names on one data source. No join key needed.

Log in to reply.