Schema Information of Tune Connector
This topic provides a structured reference to assist you in working with Daton's Tune connector and the associated fields and tables.
Schema Information of Tune Connector
This topic provides a structured reference to assist you in working with Daton's Tune connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Tune connector:
- ManagerCommissionsReport
- ConversionsReport
- ReferralsReport
- StatsReport
- Affliate
- Conversions
- Offers
- SummaryLogsReport
- ManuallyUpdatedConversions
Tune Data
ManagerCommissionsReport
Purpose: Get affiliate manager commission report.
Source API Documentation https://developers.tune.com/network/report-getmanagercommissions/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
Stat |
RECORD |
AffiliateManager |
RECORD |
ConversionsReport
Purpose: Get a conversion report.
Source API Documentation https://developers.tune.com/network/report-getconversions/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
Stat |
RECORD |
RevenueGroup |
RECORD |
Region |
RECORD |
PayoutGroup |
RECORD |
OfferUrl |
RECORD |
Offer |
RECORD |
Goal |
RECORD |
Customer |
RECORD |
Country |
RECORD |
ConversionsMobile |
RECORD |
ConversionMeta |
RECORD |
Browser |
RECORD |
AffiliateManager |
RECORD |
Affiliate |
RECORD |
AdvertiserManager |
RECORD |
Advertiser |
RECORD |
ReferralsReport
Purpose: Get traffic referrals report.
Source API Documentation https://developers.tune.com/network/report-getreferrals/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
Stat |
RECORD |
Offer |
RECORD |
AffiliateManager |
RECORD |
AdvertiserManager |
RECORD |
Advertiser |
RECORD |
Affiliate |
RECORD |
StatsReport
Purpose: Retrieve a stats report that contains aggregated stats for clicks, conversions, and other data points.
Source API Documentation https://developers.tune.com/network/report-getstats/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
Stat |
RECORD |
Region |
RECORD |
OfferVertical |
RECORD |
OfferUrl |
RECORD |
OfferTag |
RECORD |
OfferOperatingSystem |
RECORD |
OfferMediaPlacement |
RECORD |
OfferIncentive |
RECORD |
OfferFile |
RECORD |
OfferConversionType |
RECORD |
OfferChannel |
RECORD |
Offer |
RECORD |
Goal |
RECORD |
Country |
RECORD |
Category |
RECORD |
Browser |
RECORD |
AffiliateTag |
RECORD |
AffiliateManager |
RECORD |
Affiliate |
RECORD |
AdvertiserTag |
RECORD |
AdvertiserManager |
RECORD |
Advertiser |
RECORD |
AdCampaign |
RECORD |
Affliate
Purpose: Returns one or more affiliates, optionally filtered and sorted by specified parameters.
Source API Documentation https://developers.tune.com/network/affiliate-findall/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
id |
NUMERIC |
account_manager_id |
NUMERIC |
company |
STRING |
address1 |
STRING |
address2 |
STRING |
city |
STRING |
region |
STRING |
country |
STRING |
other |
STRING |
zipcode |
NUMERIC |
phone |
STRING |
fax |
STRING |
website |
STRING |
signup_ip |
STRING |
date_added |
TIMESTAMP |
status |
STRING |
wants_alerts |
NUMERIC |
payment_method |
STRING |
method_data |
STRING |
payment_terms |
STRING |
w9_filed |
NUMERIC |
referral_id |
STRING |
affiliate_tier_id |
STRING |
fraud_activity_score |
STRING |
fraud_activity_alert_threshold |
STRING |
fraud_activity_block_threshold |
STRING |
fraud_profile_alert_threshold |
STRING |
fraud_profile_block_threshold |
STRING |
fraud_risk_tier |
STRING |
scrub_offer_pixels |
NUMERIC |
ref_id |
STRING |
modified |
TIMESTAMP |
Conversions
Purpose: List of Conversion model objects
.
Source API Documentation https://developers.tune.com/network/conversion-findall/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
Conversion |
RECORD |
Offer |
RECORD |
Country |
RECORD |
ConversionMeta |
STRING |
Browser |
STRING |
AffiliateManager |
RECORD |
Affiliate |
RECORD |
AdvertiserManager |
RECORD |
Advertiser |
RECORD |
Offers
Purpose: Returns one or more offers, optionally filtered and sorted by specified parameters.
Source API Documentation https://developers.tune.com/network/offer-findall/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
id |
NUMERIC |
display_advertiser |
NUMERIC |
advertiser_id |
NUMERIC |
name |
STRING |
description |
STRING |
require_approval |
NUMERIC |
require_terms_and_conditions |
NUMERIC |
terms_and_conditions |
STRING |
preview_url |
STRING |
offer_url |
STRING |
currency |
STRING |
default_payout |
NUMERIC |
max_payout |
NUMERIC |
protocol |
STRING |
status |
STRING |
expiration_date |
TIMESTAMP |
is_private |
NUMERIC |
payout_type |
STRING |
tiered_payout |
NUMERIC |
tiered_revenue |
NUMERIC |
percent_payout |
STRING |
revenue_type |
STRING |
max_percent_payout |
STRING |
redirect_offer_id |
NUMERIC |
converted_offer_type |
STRING |
converted_offer_id |
STRING |
converted_offer_url |
STRING |
conversion_ratio_threshold |
STRING |
featured |
STRING |
is_subscription |
NUMERIC |
subscription_duration |
STRING |
subscription_frequency |
STRING |
customer_list_id |
NUMERIC |
ref_id |
STRING |
rating |
NUMERIC |
disable_click_macro |
NUMERIC |
click_macro_url |
STRING |
conversion_cap |
NUMERIC |
monthly_conversion_cap |
NUMERIC |
payout_cap |
NUMERIC |
monthly_payout_cap |
NUMERIC |
revenue_cap |
NUMERIC |
monthly_revenue_cap |
NUMERIC |
target_browsers |
NUMERIC |
approve_conversions |
NUMERIC |
allow_multiple_conversions |
NUMERIC |
allow_website_links |
NUMERIC |
allow_direct_links |
NUMERIC |
show_custom_variables |
NUMERIC |
session_hours |
NUMERIC |
session_impression_hours |
NUMERIC |
set_session_on_impression |
NUMERIC |
is_seo_friendly_301 |
NUMERIC |
show_mail_list |
NUMERIC |
dne_list_id |
NUMERIC |
email_instructions |
NUMERIC |
email_instructions_from |
STRING |
email_instructions_subject |
STRING |
enforce_geo_targeting |
NUMERIC |
enforce_secure_tracking_link |
NUMERIC |
hostname_id |
STRING |
has_goals_enabled |
NUMERIC |
default_goal_name |
STRING |
enforce_encrypt_tracking_pixels |
NUMERIC |
modified |
NUMERIC |
enable_offer_whitelist |
NUMERIC |
note |
STRING |
use_target_rules |
NUMERIC |
use_payout_groups |
NUMERIC |
use_revenue_groups |
NUMERIC |
website_links_copy_static_params |
NUMERIC |
create_date_utc |
TIMESTAMP |
lifetime_revenue_cap |
NUMERIC |
lifetime_conversion_cap |
NUMERIC |
lifetime_payout_cap |
NUMERIC |
proactive_click_fraud_prevention |
STRING |
non_unique_click_attribution |
STRING |
is_expired |
NUMERIC |
dne_download_url |
STRING |
dne_unsubscribe_url |
STRING |
dne_third_party_list |
BOOLEAN |
SummaryLogsReport
Purpose: Get mod summary logs report.
Source API Documentation https://developers.tune.com/network/report-getmodsummarylogs/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
Offer |
RECORD |
ModSummaryLog |
RECORD |
Affiliate |
RECORD |
ManuallyUpdatedConversions
Purpose: Find Conversions which were manually updated within a specific date range.
Source API Documentation https://developers.tune.com/network/conversion-findupdatedconversions/
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name |
Target Datatype |
startDate |
DATE |
endDate |
DATE |
id |
NUMERIC |
affiliate_id |
NUMERIC |
offer_id |
NUMERIC |
datetime |
TIMESTAMP |
batch_date_utc |
DATE |
batch_timestamp |
TIMESTAMP |
payout |
NUMERIC |
revenue |
NUMERIC |
ad_id |
STRING |
tune_event_id |
STRING |
advertiser_manager_id |
NUMERIC |
advertiser_id |
NUMERIC |
affiliate_manager_id |
NUMERIC |
goal_id |
NUMERIC |
creative_url_id |
NUMERIC |
customer_id |
NUMERIC |
source |
STRING |
affiliate_info1 |
STRING |
affiliate_info2 |
STRING |
affiliate_info3 |
STRING |
affiliate_info4 |
STRING |
affiliate_info5 |
STRING |
advertiser_info |
STRING |
session_datetime |
TIMESTAMP |
refer |
STRING |
pixel_refer |
STRING |
ip |
STRING |
session_ip |
STRING |
status |
STRING |
status_code |
NUMERIC |
sale_amount |
NUMERIC |
user_agent |
STRING |
country_code |
STRING |
event_city |
STRING |
event_region |
STRING |
browser_id |
NUMERIC |
is_adjustment |
NUMERIC |
ad_campaign_id |
NUMERIC |
ad_campaign_creative_id |
NUMERIC |
offer_file_id |
NUMERIC |
payout_type |
STRING |
revenue_type |
STRING |
currency |
STRING |
promo_code |
STRING |
adv_unique1 |
STRING |
adv_unique2 |
STRING |
adv_unique3 |
STRING |
adv_unique4 |
STRING |
adv_unique5 |
STRING |
order_id |
STRING |
sku_id |
STRING |
product_category |
STRING |
app_version |
STRING |
