> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/exports.md).

# Exports

Exports send your Roivenue data to other tools: a file, a spreadsheet, a database, cloud storage or Looker Studio. Set up an export once and Roivenue can refresh it every day.

Roivenue follows one rule: everything that comes in must also be able to get out, so your marketing data never ends up in another silo. Exports let you take the data to your BI tool, data warehouse or spreadsheet without joining tables yourself. You set up an export once, filter out what you don't need, and Roivenue can refresh it every morning.

To open the page, go to **Data → Exports** in the left navigation. The page has two parts:

1. **My Direct Data Exports:** export connectors that take data straight from a marketing platform.
2. **My Data Exports:** export queries that take data processed in Roivenue, including attribution.

***

### Which export to use

| Feature             | Data export                                                                                  | Export connector                                                                          |
| ------------------- | -------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------- |
| **What it exports** | Data processed in Roivenue: performance data with attribution, customers, orders or targets. | Raw data from one marketing platform, for example Google Ads, as the platform reports it. |
| **Attribution**     | Yes, you choose the attribution model.                                                       | No.                                                                                       |
| **Typical use**     | KPI reports, dashboards in Looker Studio, data for your data warehouse.                      | Platform data in your own storage without processing in Roivenue.                         |
| **How to create**   | **Create New Export Query**                                                                  | **Create New Export Connector**                                                           |

Each account can have up to **10 data exports**. The number of used exports is shown next to **My Data Exports**, for example "3 out of 10 available".

***

### How to create a data export

Click **Create New Export Query** and go through the steps of the wizard. Click **Next** to continue and **Previous** to go back.

1. **Name your query:** a name that tells you what the export contains. You see it in the list of exports and in your destination.
2. **Data Source:** the data set to export.
   * **Performance Data:** consolidated data from attribution, channels, marketing platforms and web tracking.
   * **Customers:** customers from your internal system with additional information.
   * **Orders:** orders from your internal system with additional information.
   * **Targets:** your targets.
3. **Global Parameters:**
   * **Type of Query:** **Source Data** exports rows without any transformation, for example a list of orders. **Aggregated** exports totals for the dimensions and metrics you choose, for example for a KPI dashboard.
   * **Currency:** one currency for all exported values.
   * **Export Periodicity:** **Once** for a one-time export, **Daily** for an export that refreshes every day.
4. **Columns:** for Source Data, the columns to export. For Aggregated, the dimensions and the measures. Each selected item becomes a column in the export.
5. **Attribution:** the attribution model for attributed metrics, for example AI Data Driven or Last Touch. One export uses one model.
6. **Filters:** keep or remove rows by the values in a column, with **contains**, **does not contain**, **equals** or **is not equal to**. You can filter by any column, also one that is not in the export. Skip this step to export all rows.
7. **Date Range:**
   * **Days Back:** a number of days back from today. For daily exports, the range moves every day.
   * **Fixed Range:** fixed dates.
   * **All Data:** all available data.
   * For Aggregated performance data, also choose the time granularity: **Daily**, **Weekly** or **Monthly**.
8. **Destination:** where Roivenue sends the data. See Destinations. Click **Save** to finish.

{% hint style="info" %}
**Tip:** Export only the columns and dates you need. Large exports take longer, and some destinations, such as Google Sheets, have size limits.
{% endhint %}

***

### Destinations

<table data-search="false"><thead><tr><th>Destination</th><th>What you get</th><th>What you need</th></tr></thead><tbody><tr><td><strong>Link to CSV File</strong></td><td>A link to download a CSV file or connect it to another tool.</td><td>Nothing.</td></tr><tr><td><strong>Link to JSON File</strong></td><td>A link to download a JSON file or connect it to another tool.</td><td>Nothing.</td></tr><tr><td><strong>Google Sheet</strong></td><td>Data in a sheet of your Google Sheet.</td><td>The sheet URL and the worksheet name.</td></tr><tr><td><strong>Microsoft SQL Server</strong></td><td>Data in a table of your database.</td><td>The connection string, or the server, database, user name, password, schema and table.</td></tr><tr><td><strong>Microsoft Azure Blob Storage</strong></td><td>A file in your Azure container.</td><td>The connection string, or the account name and access key, plus the container, path and file type.</td></tr><tr><td><strong>Amazon S3</strong></td><td>A file in your S3 bucket.</td><td>The bucket name, region code, access key, secret key, path and file type.</td></tr><tr><td><strong>Google's Looker Studio</strong></td><td>A data source for Looker Studio reports.</td><td>The Roivenue connector in Looker Studio.</td></tr><tr><td><strong>Google BigQuery</strong></td><td>Data in a table of your BigQuery project.</td><td>Saved credentials, plus the project, data set and table.</td></tr></tbody></table>

Azure Blob Storage and Amazon S3 can save the file as **.csv**, **.json** or **.parquet**.

#### Google Sheet

1. Create a Google Sheet, or click **Create New Sheet** in the wizard.
2. Click **Share** in the sheet, set **General access** to **Anyone with the link** and change the role from **Viewer** to **Editor**.
3. In the wizard, paste the sheet URL into **Enter your Google Sheet URL**.
4. Enter the **Work Sheet Name**. If the worksheet does not exist, Roivenue creates it.

{% hint style="warning" %}
Anyone with the link can edit the sheet. Share the link only with people who should see the data.
{% endhint %}

#### Microsoft Azure Blob Storage

Turn on **I have a connection string** and paste it, or turn it off and fill in the fields:

* **Account Name:** the name of the storage account, as shown in Azure Storage Explorer.
* **Access Key:** the primary key of the storage account.
* **Container Name:** the container where Roivenue saves the file. One storage account can have several containers.
* **Path including the file name:** the folder in the container followed by the file name, for example `exports/roivenue/performance`. Roivenue saves the file into this folder under this name.
* **File Type:** .csv, .json or .parquet.

Azure Blob Storage suits large exports and further data processing.

#### Microsoft SQL Server

Turn on **I have a connection string** and paste it, or fill in **Server Name**, **Database Name**, **User Name**, **Password**, **Schema** and **Table Name**.

{% hint style="warning" %}
With every export, Roivenue deletes the table, creates it again and fills it with data. Do not use a table that holds other data.
{% endhint %}

#### Amazon S3

Fill in **Bucket Name**, **Region Code**, **Access Key**, **Secret Key**, **Path including the file name** and **File Type**.

#### Google's Looker Studio

1. Create a data export with the destination **Google's Looker Studio** and save it.
2. In Looker Studio, add a data source and choose the [Roivenue connector](https://datastudio.google.com/data?search=roivenue). Select the export you created. Google explains how to add a data source in its [help](https://support.google.com/datastudio/answer/6300774).
3. Wait until Roivenue finishes the first export. Large date ranges take longer. Looker Studio then refreshes the data automatically.

{% hint style="info" %}
**Tip:** If you connect several exports to one Looker Studio report, give each a clear name, so you can tell them apart.
{% endhint %}

Using the Looker Studio connector complies with Roivenue's [terms of service](https://roivenue.com/wp-content/uploads/2020/04/ROIVENUE_Terms_and_Conditions-1.pdf) and [privacy policy](https://roivenue.com/privacy-policy/).

#### Google BigQuery

Set up the authorization in **Account Configuration → Platform Credentials** first. See [Platform Credentials](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/account-configuration/platform-credentials). Then return to the wizard and choose the account, **Project**, **Data set** and **Table**.

***

### How to manage exports

Each export in **My Data Exports** shows its data set, name, destination and the time of the last export. Click ⋮ for more actions:

* **Refresh:** run the export now.
* **Copy Link** and **Copy Encoded Link:** copy the link to the exported data.
* **Download:** download the exported file, when the export has one.
* **Edit:** change the settings in the wizard.
* **Disable:** stop the daily refresh without deleting the export.
* **Delete:** remove the export.

***

### How to create an export connector

An export connector takes data from a marketing platform and saves it to your destination, without processing in Roivenue. Click **Create New Export Connector** and go through the steps:

1. **Platform:** the platform to export from, for example Google Ads or Facebook Ads.
2. **Login:** sign in to the platform.
3. **Source:** the account or data source in the platform.
4. **Metrics & Dimensions:** the data to export.
5. **Connector Settings:** the settings of the connector.
6. **Destination:** where Roivenue saves the data, for example a Google Sheet.

Export connectors are also listed in **Data → Connectors**, on the **Export Connectors** tab.

***

#### FAQ

<details>

<summary>1. How often does Roivenue refresh an export?</summary>

Exports with **Daily** periodicity refresh automatically every morning. Exports with **Once** run only once. You can run any export again with **Refresh** in the ⋮ menu.

</details>

<details>

<summary>2. I reached the limit of 10 data exports. What can I do?</summary>

Delete or reuse exports you no longer need. One aggregated export with more dimensions can often replace several smaller ones. The limit depends on your plan. If you need more exports, contact your Customer Success Manager.

</details>

<details>

<summary>3. Why is my Google Sheet empty?</summary>

Check that the sheet is shared with **Anyone with the link** as **Editor** and that the URL in the export is correct. Then click **Refresh** in the ⋮ menu. Very large exports can exceed the size limits of Google Sheets. Narrow the date range or remove some columns.

</details>

<details>

<summary>4. Which attribution model should I export?</summary>

Use the model you report with in Roivenue, so the numbers match. To compare models, create one export per model, or use [Model Comparison](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/attribution/model-comparison).

</details>

<details>

<summary>5. Why don't the exported numbers match what I see in Roivenue?</summary>

Check that the export uses the same attribution model, currency, date range and filters as your view in Roivenue. A daily export with **Days Back** also moves its date range every day.

</details>

<details>

<summary>6. Does the export include all sites?</summary>

Yes. Data exports apply to the whole account, so they include all sites. Use **Filters** with the **Site** column to export only some of them.

</details>

<details>

<summary>7. What is the difference between a data export and an export connector?</summary>

A data export takes data processed in Roivenue, with attribution and all your sources joined together. An export connector takes raw data from one marketing platform and saves it without processing.

</details>