Creating a New Report (Paid Media)

Introduction

Once your campaign has been launched, you can generate reports to analyze your marketing efforts. These reports can include information about how your ads are performing as well as about your audience.

Using the reporting module, you can create a fully customized report based on the metrics and dimensions that you choose. You can also merge the SundaySky report data with your business data to analyze the impact of the video on your business KPIs.

Reports can be generated ad hoc on an as-needed basis or be scheduled to run automatically at regular intervals.


Report Format

All reports are generated in CSV format. The CSV file that is created is sent to email recipients (zipped) or to a server address. Depending on your needs, the CSV file can be analyzed manually by an individual or be automatically ingested into a database.

The column headers and values in the CSV file are all enclosed by quotes, in order to avoid any potential issues relating to commas.


Creating a New Report

1.

On the Home Page, click Analytics in the sidebar.

Click_analytics_120.png

2.

Click the Reports tab.

 

Click_reports.png

3.

Click the plus sign on the left side of the Reports page.

Plus_sign.png

4.

Select Programmatic Ads.

The new report is created with a default name and columns as described below.

a.

This is the default name for the report. The syntax is [Account Name] Campaigns Detailed Report
▶ If you'd like, you can edit this name.

b.

These are the default columns (fields) in the report: date, campaign name, impressions, and Return to Site 1 day.

Default_new_report_110_percent.jpg

5.

Click Campaigns to define which campaigns to include in this report.

Click_campaigns.jpg

By default, all your active campaigns are included in the report.

Active_campaigns.jpg

6.

Select the campaign (one or more) that you want to report on and then click Apply.
▶ If All is selected, any new campaigns added to your account after this report is created will also be included.

Select_campaign.jpg

7.a.

(Optional) If you want to change the default time zone, click the pencil icon and then select the time zone that you want to use for this report.
▶ The time zone you select determines:
     a. When a day starts and ends for reporting purposes
     b. The value transformation for date and time columns (fields)

Change_time_zone.jpg

7.b.

Click Save.

 

Changed_time_zone.jpg

8.

(Optional) If you'd like, you can add or remove report columns following the steps below. See Descriptions of Report Columns (Paid Media) for detailed information regarding all the columns that can be included in your report.

Add Column Remove Column
Select (by clicking) the column that you want to include in the report.
▶ Before selecting, you can hover over the column name to read a description of the data that is pulled for the report.

Column_example.jpg
9.a.

(Optional) If you want to edit the name of a column, click the pencil icon by the column name.

Change_column_name.jpg

9.b.

Edit the column name.

Edit_column_name.jpg

9.c.

Click Apply.

10.

(Optional) Reorder the columns by dragging and dropping the column headers.

Reordering.gif

11.

Click Save to save the new report.

Click_save.jpg

12.

Click Close at the top right of the page.

The report is added to your account.

Report saved_new.jpg

13.

Send or schedule the report.

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

Still Have Questions?

SundaySky Support is here for you

contact support