Blending data with 2 data sources

Looker Q&A Looker Studio
,
1

Now i have 2 data source

  1. Google sheet with following
Media channels Impression Click Cost
A 111 111 111
B 222 222 222
  1. DV360 source (I have already created a custom field for categorizing DV360 source to show Media Channels - Dv360)
Impression Click Cost
333 333 333

On the looker studio, these are metrics i need, blending data from 2 sources

Media channels Impression Click Cost
A 111 111 111
B 222 222 222
DV360 333 333 333
Total 666 666 666

In this case,

  1. what will be the Join configuration to select?

  2. Join condition will be only Media Channel?

  3. Any other steps to complete ?

  4. For next setup it has to be blended with CM360 source to show conversion metrics. Does it works ?

Appreciated for any assistance. Thank you !

2

A join requires a match from both tables. Unless your Google Sheet has a Media Channel for DV360, there would be nothing to join on. I suppose you could create a row for DV360 in your google sheet just for the join? Then you would do a left join from the Google Sheet → DV360 source, with the join condition as Media Channel.

Blending with CM360 would have the same limitations: there must be matching field values in order for a join to work.