Impact Brand
Explore the interactive ERD
Table & Field Reference
routing_rule_condition_value
| Column | Type | Keys |
|---|---|---|
value | Unknown | PK |
routing_rule_condition_routing_rule_id | Unknown | PKFK |
routing_rule_condition_variable | Unknown | PKFK |
routing_rule_condition
| Column | Type | Keys |
|---|---|---|
variable | Unknown | PK |
routing_rule_id | Unknown | PKFK |
operator | Unknown |
routing_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
action | Unknown | |
created_by | Unknown | |
date_created | Unknown | |
date_last_updated | Unknown | |
last_updated_by | Unknown | |
name | Unknown | |
rank | Unknown | |
redirect_url | Unknown | |
source | Unknown | |
state | Unknown |
promo_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assigned_partner_id | Unknown | FK |
campaign_id | Unknown | FK |
deal_id | Unknown | FK |
assigned_partner_name | Unknown | |
bogo_buy_image_url | Unknown | |
bogo_buy_name | Unknown | |
bogo_buy_quantity | Unknown | |
bogo_buy_scope | Unknown | |
bogo_get_discount_amount | Unknown | |
bogo_get_discount_currency | Unknown | |
bogo_get_discount_percent | Unknown | |
bogo_get_discount_type | Unknown | |
bogo_get_image_url | Unknown | |
bogo_get_name | Unknown | |
bogo_get_quantity | Unknown | |
bogo_get_scope | Unknown | |
campaign_name | Unknown | |
code | Unknown | |
created_date | Unknown | |
credit_policy | Unknown | |
deal_categories | Unknown | |
deal_default_promo_code | Unknown | |
deal_description | Unknown | |
deal_end_date | Unknown | |
deal_name | Unknown | |
deal_products | Json | |
deal_restricted_media_partner_groups | Json | |
deal_restricted_media_partners | Json | |
deal_scope | Unknown | |
deal_start_date | Unknown | |
deal_state | Unknown | |
deal_type | Unknown | |
discount_amount | Unknown | |
discount_currency | Unknown | |
discount_maximum_percent | Unknown | |
discount_percent | Unknown | |
discount_percent_range_end | Unknown | |
discount_percent_range_start | Unknown | |
discount_type | Unknown | |
end_date | Unknown | |
gift | Unknown | |
maximum_savings_amount | Unknown | |
maximum_savings_currency | Unknown | |
minimum_purchase_amount | Unknown | |
minimum_purchase_amount_currency | Unknown | |
purchase_limit_quantity | Unknown | |
rebate_amount | Unknown | |
rebate_currency | Unknown | |
start_date | Unknown | |
state | Unknown | |
synch_ads_promo_codes | Unknown | |
type | Unknown |
contact_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
name | Unknown |
contact_label
| Column | Type | Keys |
|---|---|---|
label | Unknown | PK |
contact_id | Unknown | PKFK |
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
cellphone_number | Unknown | |
cellphone_number_country | Unknown | |
editable | Boolean | |
email_address | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
profile_image | Unknown | |
title | Unknown | |
work_phone_number | Unknown | |
work_phone_number_country | Unknown |
contract_event_valid_referral
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
contract_event_payout_event_type_id | Unknown | FK |
type | Unknown | |
window | Unknown | |
window_unit | Unknown |
contract_payout_group_rule_value
| Column | Type | Keys |
|---|---|---|
value | Unknown | PK |
contract_payout_group_rule_contract_event_payout_group_id | Unknown | PKFK |
contract_payout_group_rule_variable | Unknown | PKFK |
contract_payout_group_rule
| Column | Type | Keys |
|---|---|---|
variable | Unknown | PK |
contract_event_payout_group_id | Unknown | PKFK |
operator | Unknown |
contract_payout_group_limit
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
contract_event_payout_group_id | Unknown | PKFK |
limit_by | Unknown | |
period | Unknown | |
type | Unknown | |
value | Unknown | |
weekend_override_value | Unknown |
contract_event_payout_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_event_payout_event_type_id | Unknown | FK |
payout_rate | Unknown | |
rank | Unknown |
contract_payout_adjustment_rule_value
| Column | Type | Keys |
|---|---|---|
value | Unknown | PK |
contract_event_payout_adjustment_id | Unknown | PKFK |
contract_payout_adjustment_rule_variable | Unknown | PKFK |
contract_payout_adjustment_rule
| Column | Type | Keys |
|---|---|---|
variable | Unknown | PK |
contract_event_payout_adjustment_id | Unknown | PKFK |
operator | Unknown |
contract_event_payout_adjustment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_event_payout_event_type_id | Unknown | FK |
direction | Unknown | |
rate | Unknown |
contract_event_payout_tier
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
contract_event_payout_event_type_id | Unknown | FK |
payout_rate | Unknown | |
revenue_threshold | Unknown |
contract_event_payout_restriction_rule_value
| Column | Type | Keys |
|---|---|---|
value | Unknown | PK |
contract_event_payout_restriction_id | Unknown | PKFK |
contract_event_payout_restriction_rule_variable | Unknown | PKFK |
contract_event_payout_restriction_rule
| Column | Type | Keys |
|---|---|---|
variable | Unknown | PK |
contract_event_payout_restriction_id | Unknown | PKFK |
operator | Unknown |
contract_event_payout_restriction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_event_payout_event_type_id | Unknown | FK |
contract_event_payout_limit
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
contract_event_payout_event_type_id | Unknown | FK |
limit_by | Unknown | |
period | Unknown | |
type | Unknown | |
value | Unknown | |
weekend_override_value | Unknown |
contract_event_payout_special_term
| Column | Type | Keys |
|---|---|---|
terms_name | Unknown | PK |
contract_event_payout_event_type_id | Unknown | PKFK |
terms_content | Unknown | |
terms_type | Unknown |
contract_event_payout
| Column | Type | Keys |
|---|---|---|
event_type_id | Unknown | PK |
contract_id | Unknown | FK |
credit_policy | Unknown | |
default_payout_rate | Unknown | |
event_category | Unknown | |
event_type_name | Unknown | |
locking_basis | Unknown | |
locking_day_offset | Unknown | |
locking_month_offset | Unknown | |
locking_period | Unknown | |
payout_level | Unknown | |
payout_schedulingbasis | Unknown | |
payout_schedulingperiod | Unknown | |
performance_bonus_basis | Unknown | |
performance_bonus_period | Unknown | |
performance_bonus_type | Unknown |
contract_label
| Column | Type | Keys |
|---|---|---|
label | Unknown | PK |
contract_id | Unknown | PKFK |
contract
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
partner_id | Unknown | FK |
brand_signatory | Unknown | |
brand_signatory_date | Unknown | |
date_created | Unknown | |
date_last_updated | Unknown | |
end_date | Unknown | |
partner_signatory | Unknown | |
partner_signatory_date | Unknown | |
partner_value_1 | Unknown | |
pdf_uri | Unknown | |
start_date | Unknown | |
status | Unknown | |
template_terms_action_limit | Unknown | |
template_terms_action_limit_period | Unknown | |
template_terms_change_notification_period | Unknown | |
template_terms_contract_start_slotting_fee | Unknown | |
template_terms_currency | Unknown | |
template_terms_custom_creative_payer | Unknown | |
template_terms_max_return_percentage | Unknown | |
template_terms_min_earning_per_click | Unknown | |
template_terms_name | Unknown | |
template_terms_return_policy | Unknown | |
template_terms_spend_limit | Unknown | |
template_terms_spend_limit_period | Unknown | |
template_terms_template_id | Unknown | |
template_terms_version_id | Unknown |
ads
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
deal_id | Unknown | FK |
ad_code_template | Unknown | |
ad_type | Unknown | |
allow_deep_linking | Unknown | |
banner_alternative_tag | Unknown | |
bogo_buy_image_url | Unknown | |
bogo_buy_name | Unknown | |
bogo_buy_quantity | Unknown | |
bogo_buy_scope | Unknown | |
bogo_get_discount_amount | Unknown | |
bogo_get_discount_currency | Unknown | |
bogo_get_discount_percent | Unknown | |
bogo_get_discount_type | Unknown | |
bogo_get_image_url | Unknown | |
bogo_get_name | Unknown | |
bogo_get_quantity | Unknown | |
bogo_get_scope | Unknown | |
campaign_name | Unknown | |
coupon_allow_custom_promo_code | Unknown | |
coupon_link_name | Unknown | |
custom_ad_serving_url | Unknown | |
customisation_charge | Unknown | |
deal_categories | Unknown | |
deal_default_promo_code | Unknown | |
deal_description | Unknown | |
deal_end_date | Unknown | |
deal_name | Unknown | |
deal_products | Json | |
deal_restricted_media_partner_groups | Json | |
deal_restricted_media_partners | Json | |
deal_scope | Unknown | |
deal_start_date | Unknown | |
deal_state | Unknown | |
deal_type | Unknown | |
description | Unknown | |
discount_amount | Unknown | |
discount_currency | Unknown | |
discount_maximum_percent | Unknown | |
discount_percent | Unknown | |
discount_percent_range_end | Unknown | |
discount_percent_range_start | Unknown | |
discount_type | Unknown | |
get_html_code_type | Unknown | |
gift | Unknown | |
iab_ad_unit | Unknown | |
labels | Unknown | |
landing_page | Unknown | |
languages | Unknown | |
limited_time_end_date | Unknown | |
limited_time_start_date | Unknown | |
link_text | Unknown | |
maximum_savings_amount | Unknown | |
maximum_savings_currency | Unknown | |
minimum_purchase_amount | Unknown | |
minimum_purchase_amount_currency | Unknown | |
mobile_fallbacks_anoride | Unknown | |
mobile_fallbacks_ios | Unknown | |
mobile_ready | Unknown | |
name | Unknown | |
phone_tracking | Unknown | |
promo_code_tracking | Unknown | |
purchase_limit_quantity | Unknown | |
rebate_amount | Unknown | |
rebate_currency | Unknown | |
restricted_media_partner_groups | Json | |
restricted_media_partners | Json | |
season | Unknown | |
synch_ads_promo_codes | Unknown | |
third_party_servable_ad_creative_height | Unknown | |
third_party_servable_ad_creative_width | Unknown | |
top_seller | Unknown |
task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
actions | Unknown | |
assignee_account | Unknown | |
assignee_user_email_address | Unknown | |
assignee_user_username | Unknown | |
attachments | Json | |
created_by_email_address | Unknown | |
created_by_username | Unknown | |
date_created | Unknown | |
date_last_updated | Unknown | |
details_description | Unknown | |
details_resolution_id | Unknown | |
details_resolution_name | Unknown | |
details_state | Unknown | |
details_subtype_id | Unknown | |
details_subtype_name | Unknown | |
details_summary | Unknown | |
details_type | Unknown | |
details_urgent | Unknown | |
due_date | Unknown | |
last_updated_by_email_address | Unknown | |
last_updated_by_username | Unknown | |
reference | Unknown | |
total_actions | Unknown | |
total_comments | Unknown |
task_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
task_id | Unknown | FK |
attachments | Json | |
comment | Unknown | |
commenter | Unknown |
campaign_primary_category
| Column | Type | Keys |
|---|---|---|
primary_sub_category | Unknown | PK |
campaign_id | Unknown | PKFK |
campaign_company_contact
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
email_address | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
phone_number | Unknown |
campaign_shipping_region
| Column | Type | Keys |
|---|---|---|
shipping_region | Unknown | PK |
campaign_id | Unknown | PKFK |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
categories_additional_category | Unknown | |
categories_additional_sub_categories | Json | |
categories_primary_category | Unknown | |
direct_tracking_settings_session_window_length | Unknown | |
direct_tracking_settings_unidentified_name | Unknown | |
display_future_ads | Unknown | |
display_servicing_agency | Unknown | |
gateway_tracking_settings_campaign_tracking_template | Unknown | |
gateway_tracking_settings_deep_link_domains | Unknown | |
gateway_tracking_settings_deep_linking | Unknown | |
gateway_tracking_settings_default_landing_page | Unknown | |
gateway_tracking_settings_media_partner_tracking_template | Unknown | |
gateway_tracking_settings_ssl_support | Unknown | |
gateway_tracking_settings_third_party_gateway_query_string_parameters | Unknown | |
gateway_tracking_settings_third_party_gateway_url | Unknown | |
gateway_tracking_settings_unique_click_window_length | Unknown | |
gateway_tracking_settings_unique_click_window_type | Unknown | |
gift_card_payouts | Unknown | |
identity_matching | Unknown | |
impression_tracking | Unknown | |
list_in_marketplace | Unknown | |
long_description | Unknown | |
mobile_ready_ads | Unknown | |
name | Unknown | |
promo_code_tracking | Unknown | |
rating | Unknown | |
resources_additional_related_links | Json | |
resources_company_homepage | Unknown | |
resources_example_landing_page | Unknown | |
resources_information_page | Unknown | |
search_keywords | Unknown | |
short_description | Unknown | |
site_definition | Unknown | |
state | Unknown | |
third_party_impression_pixel | Unknown | |
tracking_domain | Unknown | |
trademark_bidding | Unknown | |
view_through_crediting | Unknown |
exception_action_tracker
| Column | Type | Keys |
|---|---|---|
exception_list_id | Unknown | PKFK |
id | Unknown | PKFK |
name | Unknown |
exception_list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
created_date | Unknown | |
deactivation_date | Unknown | |
items_uri | Unknown | |
name | Unknown | |
number_of_items | Unknown | |
state | Unknown | |
type | Unknown |
note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
attachments | Json | |
content | Unknown | |
creation_date | Unknown | |
creator | Unknown | |
media_id | Unknown | |
media_name | Unknown | |
modification_date | Unknown | |
type | Unknown |
deal_product
| Column | Type | Keys |
|---|---|---|
product_name | Unknown | PK |
deal_id | Unknown | PKFK |
product_after_price_amount | Unknown | |
product_after_price_currency | Unknown | |
product_before_price_amount | Unknown | |
product_before_price_currency | Unknown | |
product_image_url | Unknown |
deal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
bogo_buy_image_url | Unknown | |
bogo_buy_name | Unknown | |
bogo_buy_quantity | Unknown | |
bogo_buy_scope | Unknown | |
bogo_get_discount_amount | Unknown | |
bogo_get_discount_currency | Unknown | |
bogo_get_discount_percent | Unknown | |
bogo_get_discount_type | Unknown | |
bogo_get_image_url | Unknown | |
bogo_get_name | Unknown | |
bogo_get_quantity | Unknown | |
bogo_get_scope | Unknown | |
categories | Unknown | |
default_promo_code | Unknown | |
description | Unknown | |
discount_amount | Unknown | |
discount_currency | Unknown | |
discount_maximum_percent | Unknown | |
discount_percent | Unknown | |
discount_percent_range_end | Unknown | |
discount_percent_range_start | Unknown | |
discount_type | Unknown | |
end_date | Unknown | |
gift | Unknown | |
maximum_savings_amount | Unknown | |
maximum_savings_currency | Unknown | |
minimum_purchase_amount | Unknown | |
minimum_purchase_amount_currency | Unknown | |
name | Unknown | |
purchase_limit_quantity | Unknown | |
rebate_amount | Unknown | |
rebate_currency | Unknown | |
restricted_media_partner_groups | Json | |
restricted_media_partners | Json | |
scope | Unknown | |
start_date | Unknown | |
state | Unknown | |
synch_ads_promo_codes | Unknown | |
type | Unknown |
ftp_submission
| Column | Type | Keys |
|---|---|---|
batch_id | Unknown | PK |
account_id | Unknown | |
completion_date | Unknown | |
errors_uri | Unknown | |
file_name | Unknown | |
status | Unknown | |
submission_date | Unknown | |
total_errors | Unknown | |
total_records | Unknown | |
type | Unknown |
performance_by_day
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PK |
date_display | Instant | PK |
action_cost | Unknown | |
actions | Unknown | |
calls | Unknown | |
clickc_cost | Unknown | |
clicks | Unknown | |
cpc | Unknown | |
cpc_cost | Unknown | |
date_sort | Unknown | |
impressions | Unknown | |
media_count | Unknown | |
other_cost | Unknown | |
revenue | Unknown | |
total_cost | Unknown |
tracking_value_promo_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
tracking_value_request_id | Unknown | PKFK |
tracking_value_request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
deal_id | Unknown | FK |
media_partner_id | Unknown | FK |
additional_instructions | Unknown | |
bogo_buy_image_url | Unknown | |
bogo_buy_name | Unknown | |
bogo_buy_quantity | Unknown | |
bogo_buy_scope | Unknown | |
bogo_get_discount_amount | Unknown | |
bogo_get_discount_currency | Unknown | |
bogo_get_discount_percent | Unknown | |
bogo_get_discount_type | Unknown | |
bogo_get_image_url | Unknown | |
bogo_get_name | Unknown | |
bogo_get_quantity | Unknown | |
bogo_get_scope | Unknown | |
campaign_name | Unknown | |
date_completed | Unknown | |
date_needed | Unknown | |
date_placed | Unknown | |
deal_categories | Unknown | |
deal_default_promo_code | Unknown | |
deal_description | Unknown | |
deal_end_date | Unknown | |
deal_name | Unknown | |
deal_products | Json | |
deal_restricted_media_partner_groups | Json | |
deal_restricted_media_partners | Json | |
deal_scope | Unknown | |
deal_start_date | Unknown | |
deal_state | Unknown | |
deal_type | Unknown | |
discount_amount | Unknown | |
discount_currency | Unknown | |
discount_maximum_percent | Unknown | |
discount_percent | Unknown | |
discount_percent_range_end | Unknown | |
discount_percent_range_start | Unknown | |
discount_type | Unknown | |
gift | Unknown | |
maximum_savings_amount | Unknown | |
maximum_savings_currency | Unknown | |
media_partner_name | Unknown | |
minimum_purchase_amount | Unknown | |
minimum_purchase_amount_currency | Unknown | |
number_requested | Unknown | |
phone_numbers | Json | |
processing_comments | Unknown | |
purchase_limit_quantity | Unknown | |
rebate_amount | Unknown | |
rebate_currency | Unknown | |
request_type | Unknown | |
state | Unknown | |
synch_ads_promo_codes | Unknown | |
unique_urls | Json |
partner_group_media_partner
| Column | Type | Keys |
|---|---|---|
partner_group_id | Unknown | PKFK |
partner_id | Unknown | PKFK |
partner_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
name | Unknown |
action_locking
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_id | Unknown | FK |
campaign_id | Unknown | FK |
media_partner_id | Unknown | FK |
action_tracker_id | Unknown | |
action_tracker_name | Unknown | |
amount | Unknown | |
caller_id | String | |
campaign_name | Unknown | |
cleared_date | String | |
client_cost | Unknown | |
creation_date | Unknown | |
currency | Unknown | |
customer_area | Unknown | |
customer_city | Unknown | |
customer_country | Unknown | |
customer_id | Unknown | |
customer_post_code | String | |
customer_region | Unknown | |
customer_status | String | |
delta_amount | Unknown | |
delta_payout | Unknown | |
event_code | String | |
event_date | Unknown | |
intended_amount | Unknown | |
intended_payout | Unknown | |
ip_address | Unknown | |
locking_date | Unknown | |
media_partner_name | Unknown | |
note | String | |
o_id | Unknown | |
payout | Unknown | |
promo_code | Unknown | |
referring_date | Unknown | |
referring_domain | Unknown | |
referring_type | Unknown | |
shared_id | Unknown | |
state | Unknown |
action_inquery_comment
| Column | Type | Keys |
|---|---|---|
user_name | Unknown | PK |
action_inquery_id | Unknown | PKFK |
comment | Unknown | |
date | Unknown |
action_inquery
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
action_id | Unknown | FK |
campaign_id | Unknown | FK |
media_partner_id | Unknown | FK |
action_uri | Unknown | |
auto_approval_date | Unknown | |
campaign_name | Unknown | |
creation_date | Unknown | |
expected_payout | Unknown | |
final_payout | Unknown | |
inquiry_type | Unknown | |
media_partner_name | Unknown | |
order_id | Unknown | |
reject_reason | Unknown | |
resolution_date | Unknown | |
resolution_deadline_date | Unknown | |
resolution_status | Unknown | |
tracking_link | Unknown | |
transaction_amount | Unknown | |
transaction_date | Unknown |
action_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ad_id | Unknown | FK |
campaign_id | Unknown | FK |
media_partner_id | Unknown | FK |
action_tracker_id | Unknown | |
action_tracker_name | Unknown | |
amount | Unknown | |
caller_id | String | |
campaign_name | Unknown | |
cleared_date | String | |
client_cost | Unknown | |
creation_date | Unknown | |
currency | Unknown | |
customer_area | Unknown | |
customer_city | Unknown | |
customer_country | Unknown | |
customer_id | Unknown | |
customer_post_code | String | |
customer_region | Unknown | |
customer_status | String | |
delta_amount | Unknown | |
delta_payout | Unknown | |
event_code | String | |
event_date | Unknown | |
intended_amount | Unknown | |
intended_payout | Unknown | |
ip_address | Unknown | |
locking_date | Unknown | |
media_partner_name | Unknown | |
note | String | |
o_id | Unknown | |
payout | Unknown | |
promo_code | Unknown | |
referring_date | Unknown | |
referring_domain | Unknown | |
referring_type | Unknown | |
shared_id | Unknown | |
state | Unknown |
performance_by_partner
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PK |
media | Unknown | PK |
action_cost | Unknown | |
actions | Unknown | |
calls | Unknown | |
click_cost | Unknown | |
clicks | Unknown | |
country | Unknown | |
cpc | Unknown | |
cpc_cost | Unknown | |
impressions | Unknown | |
mediatype | Unknown | |
other_cost | Unknown | |
platform | Unknown | |
relationship | Unknown | |
revenue | Unknown | |
state | Unknown | |
total_cost | Unknown |
partner_property
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
partner_id | Unknown | PKFK |
dlu | Unknown | |
doe | Unknown | |
name | Unknown | |
platform | Unknown | |
type | Unknown | |
url | Unknown |
partner_promotional_category
| Column | Type | Keys |
|---|---|---|
promotional_category | Unknown | PK |
partner_id | Unknown | PKFK |
partner_program_group
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PK |
partner_program_id | Unknown | PKFK |
group_name | Unknown |
partner_program
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
partner_id | Unknown | PKFK |
contract_id | Unknown | FK |
contract_name | Unknown | |
expiration_date | Unknown | |
join_date | Unknown | |
name | Unknown |
partner_contact_phone
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
partner_contact_email | Unknown | FK |
partner_contact_partner_id | Unknown | FK |
country | Unknown | |
number | Unknown | |
type | Unknown |
partner_contact
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
partner_id | Unknown | PKFK |
first_name | Unknown | |
is_primary | Boolean | |
labels | Json | |
last_name | Unknown |
partner_linked_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
partner_id | Unknown | PKFK |
date | Unknown | |
reason | Unknown |
partner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_manager | Unknown | |
address_address_1 | Unknown | |
address_address_2 | Unknown | |
address_city | Unknown | |
address_country | Unknown | |
address_postal_code | Unknown | |
address_state | Unknown | |
created_by | Unknown | |
currency | Unknown | |
date_created | Unknown | |
date_last_updated | Unknown | |
description | Unknown | |
indirect_tax_country | Unknown | |
indirect_tax_number | Unknown | |
last_updated_by | Unknown | |
name | Unknown | |
partner_type | Unknown | |
partner_values_value_1 | Unknown | |
partner_values_value_2 | Unknown | |
partner_values_value_3 | Unknown | |
phone_country | Unknown | |
phone_number | Unknown | |
promoting_country | Unknown | |
promotional_method | Unknown | |
state | Unknown | |
timezone | Unknown | |
website | Unknown |
invoice_line_item
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
invoice_id | Unknown | PKFK |
actions | Unknown | |
campaign_name | Unknown | |
description | Unknown | |
due_date | Unknown | |
event_month_year | Unknown | |
net_item_amount | Unknown | |
paid_date | Unknown | |
status | Unknown | |
total_item_amount | Unknown | |
vat_item_amount | Unknown |
invoice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_date | Unknown | |
currency | Unknown | |
media_id | Unknown | |
media_name | Unknown | |
pdf | Unknown | |
total_amount | Unknown | |
total_vat_amount | Unknown |
account
| Column | Type | Keys |
|---|---|---|
company_name | Unknown | PK |
billing_address_address_line_1 | Unknown | |
billing_address_address_line_2 | Unknown | |
billing_address_city | Unknown | |
billing_address_country | Unknown | |
billing_address_postal_code | Unknown | |
billing_address_state | Unknown | |
commercial_contact_cell_phone_number | Unknown | |
commercial_contact_cell_phone_number_country | Unknown | |
commercial_contact_email | Unknown | |
commercial_contact_name | Unknown | |
commercial_contact_user_id | Unknown | |
commercial_contact_work_phone_number | Unknown | |
commercial_contact_work_phone_number_country | Unknown | |
corporate_address_address_line_1 | Unknown | |
corporate_address_address_line_2 | Unknown | |
corporate_address_city | Unknown | |
corporate_address_country | Unknown | |
corporate_address_postal_code | Unknown | |
corporate_address_state | Unknown | |
currency | Unknown | |
ein_ssn_foreign_tax_id | Unknown | |
financial_contact_cell_phone_number | Unknown | |
financial_contact_cell_phone_number_country | Unknown | |
financial_contact_email | Unknown | |
financial_contact_name | Unknown | |
financial_contact_user_id | Unknown | |
financial_contact_work_phone_number | Unknown | |
financial_contact_work_phone_number_country | Unknown | |
indirect_tax_number | Unknown | |
industry_industry_id | Unknown | |
industry_industry_name | Unknown | |
minimum_contact_rating | Unknown | |
organization_type | Unknown | |
primary_phone_number | Unknown | |
primary_phone_number_country | Unknown | |
primary_promotional_method | Unknown | |
promotional_methods | Unknown | |
registered_for_indirect_tax | Unknown | |
secondary_phone_number | Unknown | |
secondary_phone_number_country | Unknown | |
technical_contact_cell_phone_number | Unknown | |
technical_contact_cell_phone_number_country | Unknown | |
technical_contact_email | Unknown | |
technical_contact_name | Unknown | |
technical_contact_user_id | Unknown | |
technical_contact_work_phone_number | Unknown | |
technical_contact_work_phone_number_country | Unknown | |
timezone | Unknown | |
website | Unknown |
adv_performance_by_ad_media_date
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
campaign_id | Unknown | FK |
actions | Unknown | |
actions_cost | Unknown | |
ad_id | Unknown | |
ad_name | Unknown | |
ad_type | Unknown | |
calls | Unknown | |
click_cost | Unknown | |
clicks | Unknown | |
client_cost | Unknown | |
cpc | Unknown | |
cpc_cost | Unknown | |
date | Unknown | |
impressions | Unknown | |
landing_page | Unknown | |
media | Unknown | |
media_id | Unknown | |
raw_impressions | Unknown | |
revenue | Unknown | |
total_cost | Unknown | |
viewable_impressions | Unknown |