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!

[Mehdi_Oudjida]

@Lpadk2 

I would advise you to:

• build a table chart with all the fields, including the metrics from each blended tables, the calculated field, and the date to confirm that the blending is configured correctly
• when the blending is ok, prefer to use the following formula: SUM(website_form_submission)+SUM(Lead_count)

Feel free to share here some screenshots if you need help about the configuration details of the data blending.

Mehdi