How to blend aggregate data from ga4 and sum it from a Google spreadsheet?

[Lpadk2]

Hello,

I am trying to create scorecards that measures data from a certain time frame and measure it against a past time frame.

the data I have is lead data and I wanted to combine 2 lead sources to understand my SEO impact.

I have successfully blended data by date (ga4) and event date (google spreadsheet)

I’ve created a custom field - (keyevent:website_form_submission + Lead_count)

the results - no data populated. 

please help!