I am unable to create an auction audience campaign report with dma id as a dimension and aggregation at day.  I know this is possible because I can do it in the console.

Please see this ticket where product came to the conclusion this is possible and should become a feature request.  

https://support.fivetran.com/hc/en-us/requests/162699