If you would like to generate and send a report at a regular interval, you can set up an automatic delivery schedule.
The report, in CSV format, can be sent to an email or server address.

To learn how to create a report, see Creating a New Report (Owned Media) or Creating a New Report (Paid Media).


To schedule a report:

1.

On the Home Page, click Analytics in the sidebar.

Click_analytics_120.png

2.

Click the Reports tab.

 

Click_reports.png

3.

Locate the report that you want to schedule.

4.

Use either of the following methods to access the scheduling options:

A B
In the report's row, hover over the Enabled schedules column and then click the pencil icon.

Click_pencil_icon_120_percent.jpg

The Schedule Report dialog is displayed:

schedule_report.jpg

5.

In Send report via, configure the method by which you want to send the report to your company:

Email

▶ Sends the report to email recipients

Enter one or more email addresses, separated by a comma.

send_report_via_email.jpg

SFTP (username, password)
Sends the report to an SFTP server using a username and password

Notes:

1. You will need to set up this delivery method with your IT Manager before continuing.

2. Work with your IT department to create an SFTP directory for the reports to be delivered to.

3. Create authentication credentials that the SundaySky reporting system will use during connection to the SFTP directory. Once your IT department provides these credentials, follow the steps below.

4. (Optional) If you would like to whitelist the server IP addresses, they are as follows:
34.237.61.9
34.232.253.185
Note that these IP addresses are subject to change. For any questions, contact SundaySky Support.
1.

Enter the server path using the following format:
sftp://<server name>/<folder name>

2.

Enter the server username.

3.

Enter the server password.

4.

Click Test Connection to verify that the connection succeeded.

If the connection is successful, the following message is displayed:
Connection_tested_and_confirmed.jpg

If the connection fails, the following message is displayed:
Connection_failed.jpg

SFTP_username_password_new.jpg
SFTP (SSH Key)
Sends the report to an SFTP server using a public and private key

Notes:

1. The set-up for this method includes the following steps:
  a. Request the public key from your SundaySky Project Manager.
  b. Provide the public key to your IT Manager in order to create a username for SundaySky on your server.
  c. Use this username when accessing the SFTP server (step 2 below).

2. If you would like to whitelist the server IP addresses, they are as follows:
34.237.61.9
34.232.253.185
Note that these IP addresses are subject to change. For any questions, contact SundaySky Support.
1.

Enter the server path using the following format:
sftp://<server name>:<port>/<folder name>

2.

Enter the server username.

3.

Click Test Connection to verify that the connection succeeded.

If the connection is successful, the following message is displayed:
Connection_tested_and_confirmed.jpg

If the connection fails, the following message is displayed:
Connection_failed.jpg

SFTP_SSH_key.jpg
Amazon S3 (SundaySky)
▶ Sends the report to SundaySky's Amazon Storage Service

Note:
You will need to set up this delivery method with your IT Manager or SundaySky Project Manager before continuing.

Enter the S3 bucket folder path using the following format: s3://<full folder path>

send_report_via_amazon.jpg

6.

In Run report, open the drop-down list and select how often you want to receive the report: daily, weekly, or monthly.
▶ At daily frequency, the report is sent every day, by the end of day.
▶ At weekly frequency, the report is sent every Monday, by the end of day.
▶ At monthly frequency, the report is sent on the first day of the month, by the end of day.

7.

In Calculate data through the end of the previous day starting from, define the report range.
a. For owned media, select either of the following options:
▶ Previous [day, week, month], depending on what you selected in the previous step (Run report). With this option, the data generated will be since the last scheduled report was sent to you.
Specific date. With this option, data from a specific date will be included in all subsequent reports (accumulative).

calculate_data.jpg

b. For paid media, select one of the following options: Previous day, Past 7 days, Past 30 days, Past 60 days, Past 90 days

8.

(Optional for owned media only) Click Advanced settings to configure the following optional settings:

Include sessions from File name
Select the type of session that you want to report on: production, test, or both.
▶ By default, Production is selected.

include_sessions_from.jpg
9.

In Schedule Status, change the status from Disabled to Enabled if you want to begin generating reports.
▶ Alternatively, the report delivery can be enabled at a later time.

10.

(Optional) Click + SCHEDULE to define another schedule for this report.

11.

Click Apply.
▶ Depending on how you accessed the scheduling option, a prompt to save may be displayed.

click_apply.jpg

12.

Click Save on the column selection page.

click_save_new.jpg

13.

Click Close at the top right of the page.

The schedule is added to the report.

Enabled_schedules.jpg

Was this article helpful?
0 out of 0 found this helpful

Still Have Questions?

SundaySky Support is here for you

contact support