Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

[Download] - To download the file (.csv) to your computer

Campaign Publisher

This section will walk you through how to leverage dashboards and query building tools within the Campaign reports section.

Only publishers who advertise with Verve have access to the Campaign Dashboard, Report, and API

Dashboard

 A quick, visual way to see how your Campaigns perform on a daily basis.

Overview

Image Removed

 

...

There are seven filters available on the dashboard: 

  • Advertiser Category
  • Advertiser
  • Order 
  • Advertiser IO
  • Flights
  • Creative
  • Property

2) Date Range

There are two options for selecting a date range: Dynamic range (Last 7, 14, 30 days, This Month or Last Month) or Custom range.

3) Plot

Plot allows you to view trend data and gives you the option to display a variety of metrics based on what you select from the Plot drop-down menus.

The available metrics are: 

    • Advertiser eCPM

    • Advertiser Cost
    • CTR
    • Clicks
    • Impressions

To see daily statistics, hover over the graph.  A vertical line will appear circling the two points on the graph.  Next to it a box will appear with detailed information about the two plots you are currently viewing.

4) Summary 

Displays the daily average for three metrics: Total Impressions, Total Clicks, and Advertiser Cost. These averages will change based on the selected date range.

5) Totals

Displays the totals for the five metrics: Total Impressions, Total Clicks, Total CTR, Advertiser Cost and Advertiser eCPM. These totals will change based on the selected date range.

6) Table

The table shows a breakdown of totals by Day or Month

Day or Month

This drop down defaults to By Day, which will show you data aggregated at the daily level.  You can also select to view data By Month which will roll up the data by month.

 Show Columns  

  By default all columns are shown. Remove certain columns by clicking on the X of the field to be removed

7) Export

Export the data from this table in three different formats: CSV, JSON, and Excel.

Advertisers

Image Removed

1) Filters

There are two filters available on the dashboard: Advertiser Category & Advertiser

2) Date Range

There are two options for selecting a date range: Dynamic range (Last 7, 14, 30 days, This Month or Last Month) or Custom range.

3) Plot

Plot allows you to view trend data and gives you the option to display a variety of metrics based on what you select from the Plots drop-down menus. 

The available metrics are:  

    • Advertiser eCPM

    • Advertiser Cost
    • CTR
    • Clicks
    • Impressions

To see daily statistics, hover over the graph.  A vertical line will appear circling the two points on the graph.  Next to it a box will appear with detailed information about the two plots you are currently viewing.

4) Summary 

Displays the daily average for three metrics: Total Impressions, Total Clicks, and Advertiser Cost. These averages will change based on the selected date range.

5) Totals

Displays the totals for the five metrics: Total Impressions, Total Clicks, Total CTR, Advertiser Cost and Advertiser eCPM. These totals will change based on the selected date range.

6) Table

The table shows a breakdown of totals by Advertiser 

Show Columns  

By default, all columns are shown Remove certain columns by clicking on the X of the field to be removed. 

7) Export

Export the data from this table in three different formats: CSV, JSON, and Excel.

Orders

Image Removed

1) Filters

There are three filters available on the dashboard: 

  • Advertiser
  • Order 
  • Advertiser IO

2) Date Range

There are two options for selecting a date range: Dynamic range (Last 7, 14, 30 days, This Month or Last Month) or Custom range.

3) Plot

Plot allows you to view trend data and gives you the option to display a variety of metrics based on what you select from the Plots drop down menus.

The available metrics are: 

    • Advertiser eCPM

    • Advertiser Cost
    • CTR
    • Clicks
    • Impressions

To see daily statistics, hover over the graph.  A vertical line will appear circling the two points on the graph.  Next to it a box will appear with detailed information about the two plots you are currently viewing.

4) Summary 

Displays the daily average for three metrics: Total Impressions, Total Clicks, and Advertiser Cost. These averages will change based on the selected date range.

5) Totals

Displays the totals for the five metrics: Total Impressions, Total Clicks, Total CTR, Advertiser Cost and Advertiser eCPM. These totals will change based on the selected date range.

6) Table

The table shows a breakdown of totals by Order

 Show Columns  

 By default, all columns are shown. Remove certain columns by clicking on the X of the field to be removed.

7) Export

You can export the data from this table in three different formats: CSV, JSON, and Excel.

Flights

Image Removed

1) Filters 

There are four filters available on the dashboard 

  • Advertiser
  • Order 
  • Advertiser IO
  • Flight

2) Date Range 

There are two options for selecting a date range: Dynamic range (Last 7, 14, 30 days, This Month or Last Month) or Custom range.

3) Plot

Plot allows you to view trend data and gives you the option to display a variety of metrics based on what you select from the Plots drop down menus.

The available metrics are: 

    • Advertiser eCPM

    • Advertiser Cost
    • CTR
    • Clicks
    • Impressions

To see daily statistics, hover over the graph. A vertical line will appear circling the two points on the graph. Next to it a box will appear with detailed information about the two plots you are currently viewing.

4) Summary 

Displays the daily average for three metrics: Total Impressions, Total Clicks, and Advertiser Cost. These averages will change based on the selected date range.

5) Totals

Displays the totals for the five metrics: Total Impressions, Total Clicks, Total CTR, Advertiser Cost and Advertiser eCPM. These totals will change based on the selected date range.

6) Table

The table shows a breakdown of totals by Flight

 Show Columns  

 By default, all columns are shown. Remove certain columns by clicking on the X of the field to be removed.

7) Export

Export the data from this table in three different formats: CSV, JSON, and Excel.

Creatives

Image Removed

1) Filters 

There are four filters available on the dashboard 

  • Advertiser
  • Order 
  • Advertiser IO
  • Flight

2) Date Range 

There are two options for selecting a date range: Dynamic range (Last 7, 14, 30 days, This Month or Last Month) or Custom range.

3) Plot 

Plot allows you to view trend data and gives you the option to display a variety of metrics based on what you select from the Plots drop down menus.

The available metrics are: 

    • Advertiser eCPM

    • Advertiser Cost
    • CTR
    • Clicks
    • Impressions

To see daily statistics, hover over the graph. A vertical line will appear circling the two points on the graph. Next to it a box will appear with detailed information about the two plots you are currently viewing.

4) Summary 

Displays the daily average for three metrics: Total Impressions, Total Clicks, and Advertiser Cost. These averages will change based on the selected date range.

5) Totals

Displays the totals for the five metrics: Total Impressions, Total Clicks, Total CTR, Advertiser Cost and Advertiser eCPM. These totals will change based on the selected date range.

6) Table

The table shows a breakdown of totals by Flight

 Show Columns  

 By default, all columns are shown. Remove certain columns by clicking on the X of the field to be removed.

7) Export

You can export the data from this table in three different formats: CSV, JSON, and Excel.

Queries

When you need information that you can not get from a dashboard, build a custom query. Queries are the best option when you want to build multi-dimensional reports, recurring reports, or reports with over 1,000 rows data. To create a new query, click "All Queries" from the left menu, then click "New Query" on the right. 

Image Removed

1) Query Name

Required. The default displayed is the date and time (YYYY-MM-DD HH:MM)

2) Query Description

Optional.  Describes the contents of the query. When looking at a list of Queries, the description can be helpful to find the right one. 

3) Report Type

There are four options for Report Types: Daily, Monthly, Lifetime, and Reach and Frequency

Daily - Breakdown report by Day. Revenue numbers are estimated. 

Monthly - Breakdown report by Month. Revenue numbers are not estimated and become the actual billed amount.

Lifetime - Breakdown without Date for the entirety of a campaign. Revenue numbers are estimated for campaigns still running.

Reach and Frequency - A report to see unique devices and the number of times an ad reached those devices. The date and flight ID are required in this report because that is the necessary level of granularity. 

  • Reach is defined as the number of unique devices that were delivered ads over a given amount of time.
  • Frequency is the number of ads delivered to each unique device over a given amount of time.

4) Date Range

Allows the users to chose a Dynamic range or a Fixed Date range

Dynamic - Includes: Yesterday, Last 7 Days, Last 14 Days, Last 30 Days, Last 6 Months, Last Week, Last Month, Week to Date, Month to Date, Quarter to Date, Year to Date

Fixed - A custom date range

Info

Note: Date ranges larger than a month will take time to run. If possible, filter the data down

5) Filters 

Allows the user to filter by Advertiser, Order, Flight, Creative and Property

6) Dimensions

At least one dimension must be selected in your query. If you select more than one, you can re-arrange the order in which they appear in your report on the right-hand side where the dimensions are listed.

  • Date
  • Advertiser
  • Order
  • Flight
  • Flight Targeting
  • Creative
  • Inventory

7) Metrics

At least one metric must be selected in your query. If you select more than one, you can re-arrange the order in which they appear in your report on the right hand side where the metrics are listed.

  • Advertiser eCPM

  • Advertiser Cost
  • CTR
  • Clicks
  • Estimated Publisher Revenue 
  • Impressions

7) Schedule

A query can be scheduled to run daily, weekly or monthly, allowing users to get reports automatically via the Publisher Analytics Dashboard or email. 

8) Email

A query can also be emailed or shared out to other people. 

Send email when report runs - This will allow the user to step away from their computer and receive an email notification when the report has completed. When this is selected, another option will appear to attach the report to the email. 

Also notify shared to users - Selecting this option will notify the shared user, if you have shared your query with other emails. 

Share report to emails - Allows the user to enter one or more email addresses to send  the report too. These emails can be internal or external emails.

Download report when finished automatically - Selecting this option will download the report automatically to your computer. 

9) Actions

Multiple actions can be taken when running a query. 

Save: Allows you to save the query for later without running it. The Saved Query will be found on the left menu under "Owned by Me"

Run: Allows you to run the query without saving it. This would be used for one off reports that you will not need to run again.

Save and Run: Allows you to save the query for later used and run the query right then.

Existing Query - Save as and Run: When editing an existing query, you will have the option to save the new query as a different name to differentiate the two. Otherwise, be sure to "Save and Run" your query so that your changes are updated

 

Once you have Saved your query you will see it in the All Queries section. 

Image Removed

All Queries - Keeps all of the queries you have saved and queries shared with you.

Owned by me - All of the queries you have created

Shared with me - All of the queries another person shared with you

Starred - 

Hovering over a query name will display the query description, date range, dimensions, metrics, filters, and sort options selected on your query. 

Tools:

[Run Now] will allow a user to run the query again if no changes need to be made

[X] will delete the query 

[->] shares the query

[Copy] duplicates the query

All Reports

When a query runs, it generates a report to show the results. You can find the reports by clicking on "Reports" then "All Reports" from the left menu. 

Image Removed

The  All Reports section allows user to open a unsaved report for up to 1 week, and a saved report forever. This report is cached and will generate very quickly. If a report is under 1000 rows it will display in the browser. Otherwise the browser will prompt you to download the report. 

Status

Success - The report has successfully ran, you can go directly to the cached report by clicking on the report name or click the download button in tools

Processing - The report is taking a longer time to process, save your report and come back to the UI in a few minutes

Unsaved - Save the report if you will want to come back to the pre-generated report after 7 days

Error - An issue arose while processing the report. Try refreshing your browser, adding in a filter, or contact Publisher Support.

Tools

[X] - To delete the report

[Save] - Allows the user to come back to the pre-generated report after 7 days

[Share] - If the report is saved, the share option is available. A user can either share the hyperlink or send the report to emails. 

[Download] - To download the .csv to your computer

HideElements
labelstrue
likestrue
sidebartrue
favoritetrue
metastrue
commentstrue