Creating a Google Analytics Offline Data Export
To start, navigate to the project you wish to create the export in. Once there, select the 'Exports' tab in the top bar.
From here, press the "New Export" button.
Enter a name for the source and select the type "Google Analytics Offline Data", then press continue in the bottom right of the popup.
You will then be redirected to the export configuration page. Which consists of three different sections that must be completed.
In the first section, select the connection you would like to use to link with Google Analytics. Then select the account and the data source where you would like to export the data to.
In the second section, choose the source/query that you wish to export to Google Analytics.
In the final section, you must select the columns that will be export, and map them by setting an alias. All fields that are marked red must be mapped. Only one of the orange fields is needed to continue
After selecting the columns, you have the option to apply filters to further limit the date that will be exported.