Performance Horizon

The table below gives information about all the data fields that you can import from Performance Horizon.

To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.

Field UI name

Field API name

Data Type

Description

Use in Adverity

Docs

The date when the terms were created e.g.

string

The id of the advertiser terms

dimension

account_name

string

Unique advertiser account name

dimension

active

string

y n

dimension

active

string

y n

dimension

address1

string

1st line of the address

dimension

address2

string

2nd line of the address

dimension

address3

string

3rd line of the address

dimension

address4

string

4th line of the address

dimension

advertiser_id

string

ID of the advertiser

dimension

advertiser_id

string

ID of the advertiser the campaign should belong to

dimension

advertiser_reference

string

Advertiser reference

dimension

alert_alert_group_id

string

ID of the alert group

dimension

alert_group_user_type

string

The user's alert group subscriptions for email and slack notififers.

dimension

alert_notifier_id

string

ID of a Notifier

dimension

alert_user_extra_field_id

string

Alert user extra field id

dimension

allow_deep_linking

string

y n

dimension

allow_third_party_pixel

string

y = yes n = no

dimension

append_url_parameters

string

Append url parameters

dimension

area_sq_km

long

Area in sq km

metric

associated_campaigns

string

Associated campaigns

dimension

auto_approve_publisher

string

y n

dimension

auto_approve_publishers

string

Auto approve publishers

dimension

auto_rejected_ips

string

Auto rejected ips

dimension

available_to_invoice

string

y n

dimension

available_to_selfbill

string

y n

dimension

average_conversion_age

long

Average conversion age

metric

budget_summary_interval

string

Budget summary interval

dimension

budget_summary_interval

long

Budget summary interval

budget_summary_start_time

date

Budget summary start time

dimension

budget_summary_start_time

date

Budget summary start time

dimension

campaign_currency_conversions

json[array]

Campaign currencu conversions

campaign_extra_field_id

long

The id of the extra field

dimension

campaign_id

string

ID of the campaign

dimension

campaign_languages

string

Campaign languages

dimension

campaign_logo

string

Campaign logo

dimension

campaign_notes

string

Campaign notes

dimension

campaign_overloads

json[array]

Campaign overloads

capital

string

Capital

dimension

category

string

Category

dimension

cm_client_id

string

cm client id

dimension

code

string

The iso code of the locale

dimension

commission_by_meta

string

Comission by meta

dimension

commission_by_meta_label

string

Comission by meta label

dimension

commission_group_id

string

ID of the commission group

dimension

commission_groups

json[array]

Comission groups

dimension

commission_id

string

ID of the commission

dimension

commission_rate

currency

Comission rate

metric

commission_value

currency

Comission value

metric

commission_value_cpc

currency

Comission value CPC

metric

commissions

json[array]

Comissions

company_name

string

Company name

dimension

contact_email

string

Contact email

dimension

continent_iso

string

Continent ISO

dimension

continent_name

string

Continent name

dimension

conversion_hiatus_period

long

Conversion hiatus period

metric

conversion_type

string

Conversion type

dimension

conversion_type

long

Conversion type

conversion_type

string

Conversion type

dimension

conversion_type_id

long

The id of the conversion type

dimension

cookie_period

long

Cookie period

metric

cookie_status

string

Cookie status

dimension

country

string

Country of the address

dimension

created

datetime

The date when the terms were created

dimension

creation_date

datetime

Creation date

dimension

creative_name

string

The name of the creative type

dimension

creative_type_id

long

The id of the creative type

dimension

currency_id

long

The id of the currency

dimension

currency_iso

string

The ISO of the currency

dimension

current_balance

currency

Current_balance

metric

customer_reference

string

Customer reference

dimension

customer_type

string

new existing

dimension

default_campaign_id

string

Default campaign id

dimension

default_commission

boolean

Default comission

dimension

default_commission_rate

currency

Default comission rate

metric

default_commission_value

currency

Default comission value

metric

default_currency

string

Default currency

dimension

default_override

long

Default override

deferred_lead_submission

string

Deffered lead submission

dimension

description

string

Description

dimension

description

string

Description of the promo method

dimension

destination_url

string

Destination url

dimension

dont_consolidate

string

y n

dimension

dont_invoice

string

y n

dimension

download

string

URL for PDF download

dimension

east

string

Coordinates

dimension

email_address

string

Email address registered to the user

dimension

end_date_time

datetime

e.g. 2013-09-30 15:00:00

dimension

exclude_from_override_rules

string

y n

dimension

extra_restricted_deep_linking

string

Extra restricted deep linking

dimension

fax

long

Fax number

dimension

field_comment

json[array]

Field comment

dimension

field_comment

string

Field comment

dimension

field_default_value

string

The value assigned if no value is passed in

dimension

field_name

string

The name of the extra field

dimension

field_name: is_affiliate_user

string

The name of the extra field

dimension

field_required

string

y n

dimension

field_value

string

Value for the setting, relative to the type

dimension

fips_code

string

dimension

firstname

string

First name of the user

dimension

force_approve_period

long

Force approved period

dimension

geoname_id

long

Geoname ID

dimension

hidden_campaign

string

y = yes n = no

dimension

invoice_address_1

string

1st line of the invoice address

dimension

invoice_address_2

string

1st line of the invoice address

dimension

invoice_address_3

string

1st line of the invoice address

dimension

invoice_address_4

string

1st line of the invoice address

dimension

invoice_address_country

string

Country of the invoice address

dimension

invoice_address_postcode

string

Postcode of the invoice address

dimension

invoice_company

string

Invoice company

dimension

invoice_contact

string

Invoice contact

dimension

invoice_id

string

ID of the invoice

dimension

invoice_net_value

currency

Invoice net value

metric

invoice_only

string

Invoice only

dimension

invoice_reference

string

Invoice reference

dimension

invoice_total_value

currency

Invoice total value

metric

invoice_vat_value

currency

Invoice VAT value

metric

invoiced

string

Invoiced

dimension

ip_tracking_time

long

IP tracking time

metric

is_cpc

string

y n

dimension

iso

string

The ISO code

dimension

iso

string

The ISO code

dimension

iso3

string

ISO3

dimension

iso_numeric

string

ISO Numeric

dimension

item_download

string

URL for CSV item download

dimension

items_in_bill

long

Items in bill

metric

languages

string

languages

dimension

last_modified

datetime

e.g. 2015-04-10 01:59:54

dimension

lastname

string

Surname of the user

dimension

lead_confirmation_url_fail

string

Lead confirmation url fail

dimension

lead_confirmation_url_success

string

Lead confirmation url success

dimension

legal_entity

string

Legal entity

dimension

local_time

string

Local time

dimension

locale

string

Locale

dimension

majority_received_currency

string

Majority received currency

dimension

merchant_invoice_id

string

Optional merchant reference

dimension

minor_unit

string

The number of decimal places

dimension

multiple_conversions_per_click

long

Multiple conversions per click

metric

name

string

Name

dimension

name

string

Name

dimension

net_value

currency

Net value

metric

network_application_id

string

Network application id

dimension

network_contact_email

string

Network contact email

dimension

network_description

string

Description of the network

dimension

network_fee

currency

Network fee

metric

network_id

string

Network ID

dimension

network_id

string

ID of the network

dimension

network_locale

string

Network locale

dimension

network_name

string

Network name

dimension

network_name

string

Name of the network

dimension

network_notes

string

Any additional notes for the network

dimension

north

string

Coordinates

dimension

on_expiry

string

On expiry

dimension

on_invalid_user

string

On invalid user

dimension

output_method

string

Output method

dimension

override

string

Override

dimension

override_type

string

Override type

dimension

paid_currency

string

Paid currency

dimension

pay_publisher_directly

string

y n

dimension

payment_batch_id

string

Payment batch ID

dimension

payment_currency

string

Payment currency

dimension

payment_date

date

Payment date

dimension

payment_detail_set_id

long

Payment details set ID

dimension

payment_due_by_date

date

Payment due by date

dimension

payment_method_code

string

The code of the payment method

dimension

payment_method_id

long

The id of the payment method

dimension

payment_reference

string

Payment reference

dimension

payment_type_code

string

Payment type code

dimension

phone

string

Primary contact telephone number

dimension

phone_area

string

Phone prefix to declare country or region

dimension

population

long

Population

dimension

postcode

string

Postcode/Zipcode attached to the address

dimension

pre_payment

string

Pre payment

dimension

prepend_url_string

string

Prepend url string

dimension

printable_name

string

The dictionary word for the locale

dimension

promotion

string

y n

dimension

promotional_method_id

long

The id of the promo method

dimension

publisher_commission

currency

Publisher comission

metric

publisher_extra_field_id

long

The id of the extra field

dimension

publisher_id

string

ID of the publisher

dimension

publisher_override

float

Publisher override

metric

publisher_payment_detail_set_id

string

Publisher payment detail set ID

dimension

publisher_self_bill_id

string

Publisher self bill ID

dimension

publisher_self_bill_reference

string

Publisher self bill reference

dimension

publishers

json[array]

IDs of the publishers to be associated with the group

dimension

recurring_payment_setup

string

y n

dimension

ref_country_id

long

ID of the country

dimension

ref_timezone_id

string

Ref timezone ID

dimension

reference_id

string

Reference ID

dimension

reference_type

string

campaign participation voucher group

dimension

report_meta_purge_period

long

The number of days that Meta Reports will be stored before being purged

metric

reporting_timezone

string

Reporting timezone

dimension

restricted_deep_linking

string

y n

dimension

sale_type

string

Sale type

dimension

secure_tracking

string

y n

dimension

self_bill_reference

string

Self bill reference

dimension

selfbill_currency

string

Selfbill currency

dimension

signup_ip

string

Signup IP

dimension

sku

string

sku

dimension

south

string

Coordinates

dimension

start_date_time

datetime

e.g. 2013-08-31 15:00:00

dimension

status

string

a Approved p Pending r Rejected n

dimension

terms

string

The actual terms text

dimension

test_mode

string

y = yes n = no

dimension

timestamp

datetime

Timestamp

dimension

title

string

Title

dimension

title

string

The title of the payment method

dimension

total_value

currency

Total value

metric

tq_auto_approve

long

metric

tq_enabled

string

y n

dimension

tq_enabled_publishers

string

tq_enabled_publishers

dimension

tracked_currency

string

Tracked currency

dimension

tracked_net_value

currency

Tracked net value

metric

tracking_method

string

Tracking method

dimension

tracking_subdomain

string

Tracking subdomain

dimension

type

string

The type of field value expected

dimension

unique_conversion_refs

string

y n ignore

dimension

update_description

string

e.g. Promotional Period

dimension

user_api_key

string

User API key

dimension

user_id

string

ID of the user

dimension

user_name

string

Unique user account name

dimension

vat_number

string

VAT number

dimension

vat_rate

long

VAT rate

metric

vat_rate

long

VAT rate

metric

vat_value

long

VAT value

metric

vertical_id

long

Vertical ID

dimension

vertical_id

long

Vertical ID

dimension

vertical_name

string

Verical name

dimension

vertical_name

string

Vertical name

dimension

voucher_code

string

Voudher code

dimension

voucher_code_id

string

Voucher code ID

dimension

website_id

string

The id of the website type

dimension

week_start

string

Week start e.g. Monday

dimension

west

string

Coordinates

dimension

withheld_tax

currency

Withheld tax

metric

zone

string

Zone

dimension