Missing data in blended table (Google ads with Google sheets)

[Kateryna4556]

Hello everyone, 

Really hope for your help. I blended Google Ads with Google sheets (left -outer, Google Ads is main table). Blended keys are campaign name, week and month. Week and month are date format in both tables matched by starting date of week.  Visualization is pivot table grouped by week and month.

Everything was successful, until i noticed that I am missing data in column (# of Leads) from google sheets, i am missing data only for campaigns that are paused in google ads and I have no impressions, clicks, etc, but have data for same week for specific metric in google sheets. It is weird, because for other active campaigns everything is correct.

Also, if i remove "Week", "Month", any date from dimensions in google ads - missed metric (# of Leads) is appearing back.

But if i keep Week from google ads table removed in blend, grouped by week data for google ads will be not correct.

What to do? Has anyone had similar problems?