Hello,
could you please help me with the task below?
I need to find out, how much money is spent on advertising for specific landing page.
So, in first row column D of table1, there should be a value $10,50
In row 4, column d of table 1, there should be a value $15,00
The logic is this: if there is a value "cpc" in column A of table2 and if there is a value "google" in column B of table2 and the landing page in column C of table2 match with the landing page in column C of table 1, then put this value (column D of table2) to this cell..
table1
<tbody>
</tbody>
table2
<tbody>
</tbody>
Thank you very much in advance for your assistance
could you please help me with the task below?
I need to find out, how much money is spent on advertising for specific landing page.
So, in first row column D of table1, there should be a value $10,50
In row 4, column d of table 1, there should be a value $15,00
The logic is this: if there is a value "cpc" in column A of table2 and if there is a value "google" in column B of table2 and the landing page in column C of table2 match with the landing page in column C of table 1, then put this value (column D of table2) to this cell..
table1
Medium | Source | LandinPage |
cpc | /landing-page-1 | |
cpc | bing | /landing-page-1 |
organic | /landing-page-1 | |
cpc | /landing-page-2 | |
(none) | direct | /landing-page-3 |
<tbody>
</tbody>
table2
Medium | Source | LandingPage | Cost |
cpc | /landing-page-1 | $ 10,50 | |
cpc | bing | /landing-page-2 | $ 11,00 |
cpc | /landing-page-2 | $ 15,00 |
<tbody>
</tbody>
Thank you very much in advance for your assistance