With the Supermetrics function (in older versions called "getData"), you can fetch large data sets with a single formula using the 'dimensions' parameter (for example, splitting visits by traffic source). Note that if you add dimensions to the query, the function has to be entered as an array formula, which covers a range of cells (as the results split by a dimension won't fit into a single cell).


To input an array formula in Excel: 

  1. Select a range of cells.
  2. Type the function to the formula bar.
  3. Press CTRL, SHIFT and ENTER simultaneously.


Note that Google Sheets does this automatically, these instructions are only needed when using the functions in Excel.