Google Ads Report For MCC Agency Account In Data Looker Studio Connecting CallRail

Going over a custom report that I've put together for to help find discrepancy in lead count between your call tracking platform in this case CallRail and what you have as conversion in Google Ads. This has been set up at the MCC level so you can connect all your accounts and input the data in the spreadsheet

Main Looker/Data Studio Dates: https://bit.ly/3DpTAUK
Main MCC Google Ads Data Sheet: https://bit.ly/3TSQ7Dw
Main MCC Google Ads Overview Report: https://bit.ly/3sq1zuN

Main Looker/Data Studio Dates Fields
*Dimensions Formula*

Today:
CAST(TODAY('-4')AS TEXT)

Days: DATETIME_DIFF(DATETIME_SUB(DATETIME_ADD(DATETIME_TRUNC(CURRENT_DATE(),MONTH), INTERVAL 1 MONTH), INTERVAL 1 DAY),CURRENT_DATE(),DAY)

Days Left:
SUBSTR(Today,9,2)

*Metric Formula*

Days:
COUNT_DISTINCT(Dates)

Thanks for learning with me!