How to get the total cost per result and amount spent according to date range

[Grewin]

Hi folks,

I have two tables, 1. exported leads from Infusionsoft and the 2. data report from Facebook ads manager. 

The report from Infusionsoft will be used to count how many leads opt-in in each ads created in Facebook.

The goal is to create a report that will determine the total amount spent  and cost per lead (total amount spent per ad / lead count per ad) per Facebook base on the date range selected.

Sample Report for Infusionsoft

https://docs.google.com/spreadsheets/d/1t_Y3JlfFWCKEcBQvWwobFSCFGy6zmMepYg_XM6tTRKQ/edit?usp=sharing

sample FB report

https://docs.google.com/spreadsheets/d/1u0QYrOITjLKyCsogp-iv_PI-_4DblWyqxVFyTelTSCE/edit?usp=sharing

Goal report will look like this:

Thank you in advance for your insights

[amitchandak · Accepted solution]

@Grewin , It should be a measure  like

divide(Sum(Table[mount spent per ad]), Count(Table[Ad ID]))

for overall

=calculate(divide(Sum(Table[mount spent per ad]), Count(Table[Ad ID])) , allselected())