Export Revenue Data

You can export revenue data from the Settings tool of the Broadsign Platform. It will help you manage your billing processes.

Note: The Import & Export section only appears to users assigned the Admin or Direct Sales Admin role. See User Permissions.

You can export a .csv file that contains the revenue data for your domain. It contains all revenue data as of your first booked line item (Content and Network Management campaign). If you have yet to book any line items, only the column headings appear.

To export your revenue data:

Guaranteed Campaigns

  1. Access the Settings section.
  2. In the Guaranteed tab of the Settings section, select Import & Export.
  3. In the Revenue section, select the targeted date range.

  4. Click Export.

    • Your system downloads a .csv file with the promoted line items that were live during the targeted date range.
    • The file name is in this format: revenue_[year]-[month]-[day]. For example: revenue_2017-02-17.

  5. Open the revenue data .csv file with your spreadsheet software.

Next, we will interpret the data contained in the file.

The following is a sample revenue file, exported into a spreadsheet software.

The file contains the following column headings, from left to right:

Column Letter Column Name Content
A

Proposal ID

The ID number of the proposal.
B

Proposal Name

The name of the proposal. The proposal name becomes the campaign name once booked. The name of the campaign will be: Proposal Name - Item Name.
C

Item Name

 Line item name.
D

Campaign ID

 The ID number of the campaign.
E Contract Number A contract number for internal tracking purposes.
F Client ID The ID number that you assigned to the campaign for internal tracking purposes. Optional.
G Owner Sales person assigned to the campaign.
H Status

The status of the line item (see Line Item Status). Will be one of:

  • Booked: Campaigns that your system has booked, and appear as campaigns in theContent and Network Management solution. Content and Network Management promotes it to a contracted campaign, ready to receive content.
  • Live: Campaigns that are live in your digital signage network.
  • Ended: Campaigns that have reached the end of the scheduled ad flight.
  • Goal Reached: Campaigns that have reached their goal, if one was created. For more information, see Campaigns - Editing - The General Section in the Content and Network Management documentation.
I Proposal Price The price of the campaign. Guaranteed Campaigns bases this figure on the price you entered in the Campaign Builder. See Create a Digital Line Item. Also, the currency is based on the one that you have set in General Settings. See Configure your Domain.
J Proposal Item Price The price of the line item.
K

Start Date

The start date of the scheduled ad flight. See Flight.

Note: Date format is "yyyy-mm-dd".
L

Completion Date

The completion date of the scheduled ad flight. See Flight.

Note: Date format is "yyyy-mm-dd".
M

Target Type

The type of buy. Will be one of:

  • Frequency: The number of times that an ad will play during the ad flight.
  • Share of Voice (SoV): A type of ad revenue model which focuses on the percentage of activities for one specific brand.
  • Average Share of Voice (SoV): A type of ad revenue model which focuses on daily average. It can be either Daily Average, Daily Average per Screen, or Campaign Average.
  • Impressions Goal: The total number of times that people are likely to notice an ad.
  • Budget Goal: The amount that the client is prepared to pay for the ad flight.
  • Play Goal: The total number of times that an ad will play.
  • Takeover: Used for "domination" campaigns that take over a set of screens for a specific point in time.
N

Target Value

Can be one of:

  • Impressions Value Expected (for the Impressions and Budget goals types of buy).
  • Repetitions Value Expected (for the Frequency, SoV and Takeover types of buy).
O Target Achieved After the Campaign has been live, represents how much it has achieved.
P Impressions Expected Total number of Impressions expected. This applies to all types of buy.
Q Impressions Achieved Total number of Impressions achieved. This applies to all types of buy.
R Booked CPM Based on the "Cost per Thousand" (CPM) information included with your screens. It is calculated as the line item price/(Impressions expected on the item/1000).