# Exports Overview

ROIVENUE allows you to do exactly this and even more.

1. **Get all the data in one place** - no more connecting different tables in your data model.
2. **Apply filters** and get rid of unnecessary data.
3. Use 7 **standardized export methods (Sheets, MSSQL, Azure etc.)** to get marketing data anywhere you need it.&#x20;
4. **Have it fresh, every day** - no more waiting for the data set to be generated. If you save your report, it will regenerate automatically and be ready for you each morning.&#x20;
5. Create up to **ten Export files** with daily refresh for every ROIVENUE™ plan.

## Export Data from ROIVENUE

Head to the “My Data Export” section in ROIVENUE and follow the seven steps in the wizard:

1\. Click “Create New Data Export ”

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FUtwtxpp2jjeNdcZXbOfS%2Fimage.png?alt=media&#x26;token=38ed3875-0e13-42f8-abe7-adcc43035aef" alt=""><figcaption></figcaption></figure>

2\. Name your query and choose your data set (Performance Data, Customers, Orders or Targets)

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FcN5eLqUqp90Mc14UrzaR%2Fimage.png?alt=media&#x26;token=2b199424-6561-4ba6-b3a1-5c5c0e564de1" alt=""><figcaption></figcaption></figure>

3\. Choose between aggregated or raw source data, select currency and periodicity.

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2F4v4cRzv5OuDYxPyzfE0R%2Fimage.png?alt=media&#x26;token=256acfaf-ec00-4329-a321-041a7c9a9014" alt=""><figcaption></figcaption></figure>

4.a) For Source Data: select columns directly from a set of more than three dozen of the most commonly used metrics.&#x20;

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FIiHciz9PSIoc5xfR7LFn%2Fimage.png?alt=media&#x26;token=7fa45368-9adb-4e2d-a11a-6c1c43d58cfc" alt=""><figcaption></figcaption></figure>

4.b) For Aggregated: choose dimensions and metrics (columns in your future reports).&#x20;

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FqoZdN2n2CPYIxFCSCpfC%2Fimage.png?alt=media&#x26;token=60a9bf7f-7b5b-49d2-bb2d-629a9e13ab4a" alt=""><figcaption></figcaption></figure>

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FiOJzeoqe2uIRy3dhOXpR%2Fimage.png?alt=media&#x26;token=d679f47c-b976-4c6b-bc0b-82a82517432c" alt=""><figcaption></figcaption></figure>

5\. Pick the attribution model of your choice.

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FQdJMmrvwm0Ub5QjgY8OD%2Fimage.png?alt=media&#x26;token=4f815776-1f90-4953-8872-7b4edbac065c" alt=""><figcaption></figcaption></figure>

6\. Apply filters to select or exclude rows based on particular column values or skip this step to receive all of the data.

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2F2GvuwgEWlr4fzFehoN2G%2Fimage.png?alt=media&#x26;token=c435f27b-9ee7-4a59-bf5d-22e63071f34a" alt=""><figcaption></figcaption></figure>

7\. Select your desired data range - choose between number of days back, fixed date range or all data.

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2F0345ZhvyTNB3Ip98kJZs%2Fimage.png?alt=media&#x26;token=8115f4f5-1e2e-462a-8e8a-eb4ff6bfae21" alt=""><figcaption></figcaption></figure>

8\. Choose your output destination from five options.&#x20;

<figure><img src="https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MGvvrlVUvq4TNL0oYP6%2Fuploads%2FH9Le08OMBJSsDsP3Nq01%2Fimage.png?alt=media&#x26;token=683f78dd-0bd3-4f32-959a-6d5159e458fd" alt=""><figcaption></figcaption></figure>

<br>
