Skip to main content

Report Access

Vio.com offers different mechanisms to access affiliate reporting data. Each report is available in one or more of this offerings.

Live reporting​

Live reporting provides access to the latest available affiliate booking data at any moment. For this reporting Vio.com uses Snowflake's data sharing capabilities.

Every affiliate is provided with a Snowflake reader account and a user. To connect to the reader account every affiliate will be provided with the following:

  • Snowflake reader account URL with the following form https://<account_id>.snowflakecomputing.com.
  • User and password.

Snowflake login​

To login into Snowflake, go to the provided URL and use the provided user and password:

Snowfkake login

If you have set MFA (Multi-Factor Authentication) up (see instructions below), which is strongly recommended and will eventually become mandatory for all Snowflake users, Duo will ask you to confirm your identity. For more information, follow Duo's login guide.

Snowfkake duo login

This will grant you access to Snowsight, Snowflake's web interface. For more details about how to use Snowsight, please check Snowflake's documentation. Apart from Snowsight, other database clients tools can be used, including graphic clients like DBeaver, CLIs like SnowSQL and programming languages.

By default, every affiliate will get one Snowflake user. If you need more users and/or if you plan to access the live data in Snowflake programatically, please contact us explaining the specific use case so that we can create the resources that better fit your requirements.

Instructions for first time login​

The first time you login, you will be asked to reset your password:

Snowfkake password

You will also need to set MFA (Multi-Factor Authentication). For that, first open your user profile using the bottom right menu and selecting the "My profile" option:

Snowfkake profile

Then, click on "Enroll" next to Multi-factor authentication:

Snowfkake MFA enroll

And follow the steps to enroll using Duo. For more information, follow Duo's enrollment guide.

Snowfkake duo_setup

Snowflake UI and data​

Every affiliate will have one database called affiliate with a schema named after its affiliate_id. In that schema, there will be one booking view, corresponding to the booking report.

Snowfkake data

To query the data, click on "+ Create" on the top left corner and then select "SQL Worksheet":

Snowfkake create

In the newly created worksheet you can start querying the data in the available views:

Snowfkake query

Scheduled reporting​

Scheduled reporting is used to share reports that are generated on a specific frequency, usually daily or monthly. For this reporting Vio.com offers 2 types of access, FTP and email.

FTP​

Every affiliate gets access to Vio.com's FTP server. To be able to connect, every affiliate will be provided with the following:

  • FTP server URL: export.vio.com
  • User and password.

To connect to the FTP server, use the SFTP protocol and the provided URL, user and password. For example, using the FileZilla FTP client:

FTP login

Once logged in, there will be 2 directories available, invoice_item for the invoice_item report and booking_daily for the booking_daily report.

FTP dirs

The reports are available in Gzipped CSV and their names depend on the frequency in which they are generated. For daily reports (eg. booking_daily) the name will be YYYY-MM-DD.csv.gz and for monthly reports (eg. invoice_item) the name will be YYYY-MM.csv.gz.

FTP reports

Email​

Apart from the FTP access, affiliates can opt in to receive their scheduled reports via email. For that, all affiliates will be asked to provide:

  • One primary email address.
  • Zero or more secondary email addresses.

The emails will be sent to the primary email address and CC'ed to the secondary email addresses, if any. Only the delivery to the primary email address will be monitored for errors. We recommend using a generic non-personal email as the primary address.