Data Share Usage Example Q1: Los Angeles Market Daily MCI Calculation – Rolling 13 Months Calculated MCI values for the past 13 months (Note: Actual field and view names may vary from those displayed below.) SELECT * FROM .DAT.”user_view” WHERE CAL_DATE >= DATEADD(‘month’,-13,CUR
DAT’s Market Conditions Index (MCI) is a dataset built from the hundreds of millions of annual freight-matching post and search transactions taking place in the DAT One ecosystem. The calculation constitutes a powerful index for managing daily and weekly capacity strategies. Features of this dataset: – Outbound (explicit origin) and Inbound (explicit destination) calculations down to the DAT Key Market Area level – Three trailer type categories (Dry Van, Refrigerated, and Flatbed) – Daily MCI calculations at all levels – Daily history back to 2013* – A variety of historical granularities (e.g. prior 7 days) – 8-day forecast available *Note: Product launched in June 2020. MCI calculations prior to this date are what would have been calculated had the product existed at that time. Fields Include: – Type of Trailer – Origin Geography Code – Outbound MCI – Inbound MCI – Load-to-Truck Ratio – Equipment Posts – Load Posts – Equipment Searches – Load Searches