Returns empty stream when I add date to the select section

[Roi Yad Shalom]

Hey 

I try to get the performance of an ad group and a source placement per day. 

When I select the data and only filter by date it works but when I select date it returns an empty strem 

Besides, Is it possible to get the metrics by the ad group ad level with the source website the ad was presented in?

[Roi Yad Shalom]

 SELECT ad_group.id, ad_group_criterion.display_name, ad_group_criterion.placement.url,
                              metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions, segments.date
                       FROM managed_placement_view where segments.date >= '2023-03-27'
                       and segments.date <= '2023-03-28'  

this is the query I use. with date it returns empty but without date returns the data