hi! I don't think we explicitly say or expect that the export from the Dashboard and the report from the Reports API are exactly equivalent in terms of columns, they're not really designed together.
So to answer your question I suppose it's "trial-and-error" yes
sand warren
winter surge