Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

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.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pulse

    • Daton

      Need help with something?

      Talk to data expert

      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
      tune details music data

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Essential Attributes and Supported Tables
      • How to Integrate Tune with Daton

      Table of Contents

      Tables/APIs Tune Data

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand