Premium Only Content

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!
-
39:30
The White House
1 hour agoPresident Trump Signs Congressional Bill, July 30, 2025
3 -
LIVE
Sean Unpaved
1 hour agoGameplan & Glam: Sanders' Reps Snub, NFC North Heatwave, MLB Deadline Surge, Sweeney's Eagle Glow
276 watching -
LIVE
Dr Disrespect
2 hours ago🔴LIVE - DR DISRESPECT - BATTLEFIELD 1 - FULL GAME
1,657 watching -
3:52
Michael Heaver
9 hours agoPanicked Labour Now Completely IMPLODING
111 -
10:50
Professor Gerdes Explains 🇺🇦
1 hour agoRUSSIAN 8.8 MAGNITUDE EARTHQUAKE LEADS TO TSUNAMI! US COASTLINE HIT
4 -
LIVE
SternAmerican
21 hours agoElection Integrity Call – Wednesday, July 30 at 2 PM EST | Hosted by Steve Stern & Raj Doraisamy
121 watching -
The Charlie Kirk Show
2 hours agoTHE CHARLIE KIRK SHOW IS LIVE 07.30.25
31.1K11 -
1:04:25
Timcast
2 hours agoTrump DOJ CAUGHT Deep State Trying To DESTROY Evidence In BURN BAGS, Trump Says TREASON
116K78 -
LIVE
Robert Gouveia
1 hour agoUNSEAL the FILES!! Backdoor Judge RIPPED by Justice! EU Censorship Files REVEALED!
730 watching -
19:25
Neil McCoy-Ward
1 hour agoTHE AI JOBS COLLAPSE HAS BEGUN! (And No One’s Ready for What’s Next…)
7.91K1