Search
Clear search
Close search
Google apps
Main menu
true

This help center content is for DFP sales management, which might not be enabled in your network.

Create an export template

Export templates allow sales representatives to download proposal details and other information into a spreadsheet. The exported file can then be shared with advertisers or agencies with campaign details. DFP contains a default template ready for use by sales representatives. However, DFP administrators can design other templates and upload them to DFP. Export templates ensure that the information you share with advertisers or agencies has consistent formatting and information across your organization. This article describes how to create export templates, after which they can be uploaded to DFP so that sales representatives can use them.

Topics in this article include:

Formats and styles in templates

Export templates can be styled in any way desired by your company, including the use of multiple tabs, merged cells, different fonts, and date or currency formats.

Formulas may be used. However, take care in defining cell references. DFP inserts an additional row for each proposal line item or package. The final exported file may therefore have an indeterminate series of rows for proposal line items. Thus you must ensure that the formulas work correctly regardless of the number of inserted rows, or the sales representative may need to verify that cell references correspond to the desired set of cells in the final file exported file.

Good to know about export templates:

  • Pre-populated formulas in rows that will be dynamically inserted are not supported.
  • Visual Basic Scripting (macros) for export templates is also not supported.
Best practice with monetary values and currency

Ensure currency format corresponds to the currency of proposal exported.

Monetary values are exported as raw values. There is no reference to the type of currency the value represents. This allows you to apply formulas to these values in your template. You may apply a currency format to cells in an export template so that the value appears with the currency symbol (for example, "$" for USD). However, you must ensure that sales representatives use templates formatted with the currency that corresponds to the currency of proposal exported.

Alternatively, or in addition, you can use the string line_currency_code for proposal line item monetary values (or proposal_currency_code for proposal monetary values) in a cell adjacent to the cell with monetary values. This string displays the three-letter currency code for the proposal or proposal line item (for example, "USD" ). This approach ensues that monetary values are always coupled with the correct currency for the proposal.

Export templates are created in a spreadsheet offline with a series of strings that represent desired data to pull from fields in DFP. Most of the data pulled comes from the DFP Sales. However, some data is also pulled from the Companies screen under the Admin tab, such as contact details for advertisers and agencies. Once the template is created, a DFP administrator can upload export templates for use by sales representatives.

Syntax for export template code

The syntax for export template code is:

%%%[s]

where:

  • %%% is a flag for DFP that indicates a cell contains code that pulls data from a DFP field
    [s] is a string corresponding to a field in DFP

Note: You may only use one string per cell. Entering multiple strings per cell will not export proposal data.

For example:

%%%proposal_advertiser_name

This string pulls the advertisers name and inserts that name where the code appears on the spreadsheet.

Exclude proposal line items from proposal packages

If your DFP network is accustomed to selling packages to advertisers without reference to individual line items, you can set a template to exclude proposal line items from a proposal package. When sales representatives use the template, individual proposal line items in a proposal package aren't exported. Only information related to the proposal package is exported.

Excluding proposal line items may also help in managing formulas in some exported files since only cost-related values for a proposal package are exported.

You can enable this feature for an export template by selecting Exclude proposal line items from proposal packages when you upload an export template.

Best practice setting a template to "Exclude proposal line items from proposal packages"

Ensure that you name the template or add a description that indicates the exported file won't display proposal line item information in a package. Additionally, you can optionally include text in the template itself that notes individual proposal line items are not represented for packages. Sales representatives using templates may otherwise be unclear why some templates show proposal line items in a package while others do not. 

When this feature is set for an export template, code that usually exports both proposal package and proposal line item information only exports proposal package information. Other code that doesn't export proposal package information shows an empty cell. Learn more in the detailed example below. 

Detailed example of "Exclude proposal line items from proposal packages"

Suppose that you have a proposal package named "Awesome summer campaign package", with two proposal line items in that proposal package named "Homepage special 278x90" and "Travel section campaign 468x60". Also suppose that you have a standalone proposal line item called "Sports page campaign--World Series 2017 300x250".

For "line_name", if "Exclude proposal line items from proposal packages" is not enabled, DFP would export:

 

  • Sports page campaign--World Series 2017 300x250
    Awesome summer campaign package
    Awesome summer campaign package: Homepage special 278x90
    Awesome summer campaign package: Travel section campaign 468x60

If "Exclude proposal line items from proposal packages" is set for the template, then only the standalone proposal line item name and the proposal package name are exported:

  • Sports page campaign--World Series 2017 300x250
    Awesome summer campaign package

Code related to cost is summed in a single cell for the proposal package. When "Exclude proposal line items from proposal packages" is not enabled, an exported file shows the cost for each proposal line item in the proposal package along with the sum of all the proposal line items in the proposal package.

For example, suppose the proposal line items in the proposal package cost is $200 and $300, while the standalone proposal line item's cost is $400. Also suppose we used the following code in an export template:

  • %%%line_name %%%line_size %%%line_total_cost

When "Exclude proposal line items from proposal packages" is not enabled, the exported file shows:

  • Sports page campaign--World Series 2017 300x250 300x250 400
    Awesome summer campaign package   500
    Awesome summer campaign package: Homepage special 278x90 278x90 200
    Awesome summer campaign package: Travel section campaign 468x60 468x60 300

The second cell from the top all the way to the right, with the value "500", represents the proposal package cost and is the sum of the following two cells.

When "Exclude proposal line items from proposal packages" is set, the exported file shows:

  • Sports page campaign--World Series 2017 300x250 300x250 400
    Awesome summer campaign package   500

Code that doesn't export package information show an empty cell. In this example, "line_size" doesn't ever export proposal package information. So, an empty cell is inserted whether "Exclude proposal line items from proposal packages" is enabled or not.

Export template strings and meaning

There are three sets of strings:

  • Proposal strings: pulls general data about the proposal from under the proposal Settings tab and other fields in DFP
  • Proposal line item strings: pulls data specific to line items from under the proposal Line item tab of a proposal
  • Contact strings: pulls data from under the Companies page for specified advertisers or agencies of the proposal

Review the options below for strings you can use and, in particular, review the section for proposal line item strings. There is special syntax required when you insert proposal line item data and merge cells.

 

You can download a sample export template using the below link:

Sample export template

You are also encouraged to thoroughly test your export templates before sales representatives use them for your customers.

Time zones

You can choose to display time using the below code in either network time zone or the time zone set for the proposal or proposal line item. Time zones are represented using the three-letter civilian time zone abbreviation (e.g., EST for Eastern Standard Time). If there is a unique proposal or proposal line item time zone, its time will be converted when inserting code that displays network time zone.

Note that start and end times for proposals are not set in the proposal but determined by the start and end times configured for the proposal line items included in the proposal.

Learn more about time zones in Proposal and proposal line item time zones.

Proposal strings

String Description
network_name Network display name (from the Network settings page under the Admin tab)
network_name_id Network code (from the Network settings page under the Admin tab)
order_id DFP order ID associated with the proposal. This will result in a empty cell if the proposal has not yet been reserved or does not yet include any line items
proposal_advertiser_comments Proposal advertiser comments
proposal_advertiser_contact_name Advertiser contacts added to the proposal, each separated by comma
proposal_advertiser_discount_percentage Advertiser discount as the percentage entered for the proposal
proposal_advertiser_external_id Proposal advertiser external ID
proposal_advertiser_name Name of the advertiser for the proposal
proposal_agency_commission_amount Calculated agency commission as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_agency_commission_amount_local Calculated agency commission as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_agency_commission_percentage Agency commission as the percentage entered for the proposal
proposal_agency_external_id Proposal agency external ID
proposal_billing_cycle Billing cycle for proposal
proposal_billing_schedule Billing schedule for proposal
proposal_billing_source Billing source for proposal
proposal_budget Proposal budget as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_budget_local Proposal budget as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_caps_rollovers Caps and rollovers for proposal
proposal_contracted_quantity_cpc Proposal total contracted quantity of all CPC line items
proposal_contracted_quantity_cpd Proposal total contracted quantity of all CPD line items
proposal_contracted_quantity_cpm Proposal total contracted quantity of all CPM line items
proposal_contracted_quantity_cpu Proposal total contracted quantity of all CPU line items
proposal_contracted_quantity_flatfee Proposal total contracted quantity of all flat fee line items
proposal_contracted_quantity_vcpm Proposal total contracted quantity of all vCPM line items
proposal_currency_code Three-letter currency code for the proposal (for example, "USD" )
proposal_custom_field#custom field name Value in custom field
 
For custom field name, insert the name of the custom field as it appears in the Name field on the Custom fields page under the Admin tab.
proposal_discount_percentage Proposal discount as the percentage entered
proposal_end Proposal end date and time (with hour and minute) in DFP network time
proposal_end_local Proposal end date and time (with hour and minute) in the time zone set for the proposal
proposal_gross_final_total Final total gross cost as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_gross_final_total_local Final total gross cost as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_gross_total Final total gross cost as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_gross_total_cpc Proposal total cost (gross) of all CPC line items in network currency
proposal_gross_total_cpc_local Proposal total cost (gross) of all CPC line items in proposal currency
proposal_gross_total_cpd Proposal total cost (gross) of all CPD line items in network currency
proposal_gross_total_cpd_local Proposal total cost (gross) of all CPD line items in proposal currency
proposal_gross_total_cpm Proposal total cost (gross) of all CPM line items in network currency
proposal_gross_total_cpm_local Proposal total cost (gross) of all CPM line items in proposal currency
proposal_gross_total_excluding_offline_charges Proposal total cost (gross) excluding offline charges in network currency
proposal_gross_total_excluding_offline_charges_local Proposal total cost (gross) excluding offline charges in proposal currency
proposal_gross_total_flatfee Proposal total cost (gross) of all flat fee line items in network currency
proposal_gross_total_flatfee_local Proposal total cost (gross) of all flat fee line items in proposal currency
proposal_gross_total_local Final total gross cost as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_gross_total_non_ad_served Proposal total cost (gross) of all offline line items in network currency
proposal_gross_total_non_ad_served_local Proposal total cost (gross) of all offline line items in proposal currency
proposal_gross_total_vcpm Proposal total cost (gross) of all vCPM line items in network currency
proposal_gross_total_vcpm_local Proposal total cost (gross) of all vCPM line items in proposal currency
proposal_id Proposal ID
proposal_label Labels applied to the proposal, each separated by comma
proposal_name Proposal name
proposal_net_final_total Final total net cost as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_net_final_total_local Final total net cost as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_net_total Final total net cost as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_net_total_cpc Proposal total cost (net) of all CPC line items in network currency
proposal_net_total_cpc_local Proposal total cost (net) of all CPC line items in proposal currency
proposal_net_total_cpd Proposal total cost (net) of all CPD line items in network currency
proposal_net_total_cpd_local Proposal total cost (net) of all CPD line items in proposal currency
proposal_net_total_cpm Proposal total cost (net) of all CPM line items in network currency
proposal_net_total_cpm_local Proposal total cost (net) of all CPM line items in proposal currency
proposal_net_total_excluding_offline_charges Proposal total cost (net) excluding offline charges in network currency
proposal_net_total_excluding_offline_charges_local Proposal total cost (net) excluding offline charges in proposal currency
proposal_net_total_flatfee Proposal total cost (net) of all flat fee line items in network currency
proposal_net_total_flatfee_local Proposal total cost (net) of all flat fee line items in proposal currency
proposal_net_total_local Final total net cost as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_net_total_non_ad_served Proposal total cost (net) of all offline line items in network currency
proposal_net_total_non_ad_served_local Proposal total cost (net) of all offline line items in proposal currency
proposal_net_total_vcpm Proposal total cost (net) of all vCPM line items in network currency
proposal_net_total_vcpm_local Proposal total cost (net) of all vCPM line items in proposal currency
proposal_notes Proposal notes
proposal_po_number PO number for the proposal
proposal_poc Probability of close for the proposal
proposal_pricing_model Pricing model for the proposal (net or gross)
proposal_primary_agency_contact_name Primary agency contacts added to the proposal, each separated by comma
proposal_primary_agency_name Name of the primary agency for the proposal
proposal_primary_salesperson_external_id Proposal primary salesperson external ID
proposal_primary_salesperson_name Salesperson assigned to the proposal
proposal_primary_salesplanner_external_id Proposal salesplanner external ID
proposal_primary_trafficker_external_id Proposal primary trafficker external ID
proposal_primary_trafficker_name Trafficker assigned to the proposal
proposal_rate_card Name of the rate card used for the proposal
proposal_remaining_budget Calculated remaining budget as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_remaining_budget_local Calculated remaining budget as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_salesplanner_name Users assigned to the proposal as sales planners, each separated by comma
proposal_scheduled_quantity_cpc Proposal total scheduled quantity of all CPC proposal line items
proposal_scheduled_quantity_cpm Proposal total scheduled quantity of all CPM proposal line item
proposal_scheduled_quantity_vcpm Proposal total scheduled quantity of all VCPM line items
proposal_secondary_salesperson_external_id Proposal secondary salesperson external ID
proposal_secondary_salesperson_name Secondary salespeople assigned to the proposal, each separated by comma
proposal_secondary_trafficker_external_id Proposal secondary trafficker external ID
proposal_secondary_trafficker_name Secondary traffickers assigned to the proposal, each separated by comma
proposal_start

Proposal start date and time (with hour and minute) in DFP network time

proposal_start_local

Proposal start date and time (with hour and minute) in the time zone set for the proposal

proposal_state Status of the proposal (draft, awaiting approval, approved, finalized, rejected)
proposal_terms_and_conditions Proposal terms and conditions
proposal_terms_and_conditions_names Name of proposal terms and conditions
proposal_third_party_ad_server Proposal third-party ad server
proposal_time_zone Time zone set for the proposal
proposal_total_without_adjustments Proposal total cost of all line items excluding proposal adjustments in network currency
proposal_total_without_adjustments_local Proposal total cost of all line items excluding proposal adjustments in proposal currency
proposal_vat_net_final_total Final total net cost with VAT as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_vat_net_final_total_local Final total net cost with VAT as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_vat_percentage Value added tax (VAT) as the percentage entered
proposal_vat_total_amount Calculated value added tax (VAT) as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
proposal_vat_total_amount_local Calculated value added tax (VAT) as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)

Proposal line item strings

Proposals can have multiple proposal line items. For this reason, an export template should only use the proposal line item code below on a single row; DFP sales management will do the rest. Upon export, a row will be populated for every proposal line item in the proposal.

If you merge cells to display proposal line item information, DFP requires that you indicate how many cells you've merged. This also ensures that DFP displays proposal line item information correctly when multiple proposal line items are exported.

There is no need to indicate the number of cells that have been merged for either proposal or contact strings. Indicating the number of merged cells is only necessary for data that might be repeated over multiple rows, like proposal line items, so that DFP understands how many cells to merge for each row it inserts subsequent to the row you've placed in the template.

The syntax for export template code is:

%%%[s]:[n]

where:

  • %%% is a flag for DFP that indicates a cell contains code that pulls data from a DFP field
    [s] is a string corresponding to a field in DFP
    [n] is the number of cells merged in the cell where the string has been inserted

Note: You may only use one string per cell. Entering multiple strings per cell will not export proposal data.

For example:

%%%line_name:3

This pulls the proposal line item/package name and inserts it where three cells have been merged.

In an exported file, the packages and proposal line items are ordered by their sequence IDs. Also there is a separate row for each proposal package and each proposal line item in the exported file unless you've set an export template to "Exclude proposal line items from proposal packages".
String Description
line_base_rate Product rate for line item (net) as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_base_rate_local Product rate for line item (net) as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_billing_cycle Billing cycle for line item (e.g., Monthly)
line_billing_source Billing source for line item
line_buffer_percentage Buffer percentage for the line item (for DFP Standard or Non-DFP ads with a cost type of CPM or CPC only)
line_caps_rollovers Caps and rollovers setting for line item (N/A if billing source is contracted)
line_comments Line item/package comments
line_connection Lists only connection targeting
line_contracted_quantity Contracted quantity
 
This string pulls the numeric value contracted for the proposal line item if the rate type of a proposal line item is CPM, CPC, or CPD. If the proposal line item has been set as a Flat fee or Cost per unit, this string pulls the monetary value for these rate types.

Only a value is exported using this string. What the value represents based on rate type is not explicit. This string should therefore be used in conjunction with line_quantity_type in an adjacent cell to show what the value represent—either impressions, clicks or days.

line_currency_code Three-letter currency code for the proposal line item (for example, "USD" )
line_custom_criteria Lists only key-value targeting
line_custom_field#custom field name Value in custom field
 
For custom field name, insert the name of the custom field as it appears in the Name field on the Custom fields page under the Admin tab.
line_daytime Day and time (parting)
line_deliver_impressions Deliver impressions setting for master/companion line items (evenly, frontloaded, as fast as possible)
line_delivery_line_id ID of the corresponding delivery line item
line_devices Lists only device targeting
line_display_creatives Display creatives setting (one or more, only one, as many as possible, all)
line_end Proposal line item/package end date and time (with hour and minute) in DFP network time.

For packages, the end time is the latest end time from all the line items in the package.
line_end_local Proposal line item/package end date and time (with hour and minute) in the time zone set for the proposal line item

For packages, the end time is the latest end time from all the line items in the package.
line_frequency Frequency (caps)
line_geo Lists only geo targeting
line_goal_percentage Goal for line item (for Sponsorship, Network or House types only with cost type of CPD, CPM, or CPC)
line_gross_rate Gross rate for line item as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_gross_rate_local Gross rate for the line item as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_gross_total_cost Total contracted gross cost for line item or package as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_gross_total_cost_local Total contracted gross cost for line item or package as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_id Proposal line item/package ID
line_inventory_targeting Lists only inventory targeting (ad units and placements)
line_label Labels applied to the line item, each separated by comma
line_name Proposal line item/package name

If a line item belongs to a package, its name appears as:

<Package name>: <Line item name>
line_premiums Premiums amount for line item (net) as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_premiums_local Premiums amount for line item (net) as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_price_method Rate type for line item (CPM, CPC, CPD, cost per unit, flat fee)
line_product_adjustment_amount Calculated product adjustment value as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_product_adjustment_amount_local Calculated product adjustment value as a monetary value that represents the local currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_product_adjustment_percentage This proposal line item setting is calculated based on changes to the net rate. Adjusting the net rate (either plus or minus) updates the product adjustment based on the product rate minus the advertiser discount. Learn more.
line_product_custom_field#custom field name Value in custom field
 
For custom field name, insert the name of the custom field as it appears in the Name field on the Custom fields page under the Admin tab.
line_product_name Product name from which the proposal line item originated
line_product_notes Product notes
line_product_template_custom_field

Value in custom field

For custom field name, insert the name of the custom field as it appears in the Name field on the Custom fields page under the Admin tab.
line_product_template_description Description of the product template from which the proposal line item originated
line_quantity_type Either impressions, clicks, days for proposal line items if the rate type is set to CPM, CPC, or CPD.
 
Use this string in conjunction with line_contracted_quantity in an adjacent cell.
line_rate Net rate for line item as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_rate_local Net rate for the line item as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_rotate_creatives Rotate creatives setting (evenly, optimized, weighted, sequential)
line_scheduled_quantity Scheduled quantity with buffer percentage applied
line_size Inventory sizes for line item, each separated by comma. If the inventory sizes are in a master/companion relationship, the inventory sizes are grouped and labeled as either belonging to the master or companion
line_start Proposal line item/package start date and time (with hour and minute) in DFP network time

For packages, the start time is the earliest start time from all the proposal line items in the package.
line_start_local Proposal line item/package start date and time (with hour and minute) in the time zone set for the proposal line item.

For packages, the start time is the earliest start time from all the proposal line items in the package.
line_targeting Lists all line item targeting, including inventory targeting (ad units and placements), geo targeting, devices, connection, and key-value
line_third_party_ad_server Third-party ad server specified in proposal line item
line_total_cost Total contracted net cost for line item or package as a monetary value that represents network currency; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_total_cost_local Total contracted net cost for line item or package as a monetary value that represents the currency set for the proposal; note that this string does not export currency type and should be used in conjunction with the string that displays the three-letter currency code (see best practice with monetary values and currency)
line_type Product type of proposal line item

Contact strings

String Description
proposal_advertiser_address Address for advertiser added to proposal (from Companies page under the Admin tab)
proposal_advertiser_contact_name Advertiser contacts added to the proposal, each separated by comma
proposal_advertiser_email Email address for advertiser added to proposal (from Companies page under the Admin tab)
proposal_advertiser_fax Fax number for advertiser added to proposal (from Companies page under the Admin tab)
proposal_advertiser_phone Phone number for advertiser added to proposal (from Companies page under the Admin tab)
proposal_primary_agency_address Address for primary agency added to proposal (from Companies page under the Admin tab)
proposal_primary_agency_contact_name Primary agency contacts added to the proposal, each separated by comma
proposal_primary_agency_email Email address for primary agency added to proposal (from Companies page under the Admin tab)
proposal_primary_agency_fax Fax number for primary agency added to proposal (from Companies page under the Admin tab)
proposal_primary_agency_phone Phone number for primary agency added to proposal (from Companies page under the Admin tab)
proposal_primary_salesperson_email Email for salesperson assigned to the proposal
proposal_primary_trafficker_email Email for trafficker assigned to the proposal
proposal_sales_planner_email Email for sales planner assigned to the proposal
Was this article helpful?
How can we improve it?