LogUpdates Model

NameTypeDescription
_idIntegerID
ad_network_idStringAd Network ID
advertiser_file_idStringAdvertiser File ID
advertiser_idString Advertiser ID
advertiser_opt_outBooleanAdvertiser Opt Out, 1= Opted Out 0= Not Opted Out
advertiser_ref_idStringAdvertiser Ref ID
advertiser_sub_ad_idStringAdvertiser Sub Ad ID
advertiser_sub_adgroup_idStringAdvertiser Sub Adgroup ID
advertiser_sub_campaign_idStringAdvertiser Sub Campaign ID
advertiser_sub_keyword_idStringAdvertiser Sub Keyword ID
advertiser_sub_placement_idStringAdvertiser Sub Placement ID
advertiser_sub_publisher_idStringAdvertiser Sub Partner Id
advertiser_sub_site_idStringAdvertiser Sub Site ID
ageIntegerAge
agency_idStringAgency ID
altitudeFloatAltitude
app_nameStringApp Name
app_versionStringApp Version
campaign_ad_idStringCampaign Ad ID
campaign_idStringCampaign ID
campaign_payout_idStringCampaign Payout ID
campaign_url_idStringCampaign URL ID
city_codeIntegerCity Code
click_gross_countIntegerClick Gross Count
click_publishers_countIntegerClick Partners Count
click_unique_countIntegerClick Unique Count
country_idStringCountry ID
createdStringCreated
currency_codeStringCurrency Code
debug_modeBooleanDebug Mode, 1= On 0= Off
device_brandStringDevice Brand
device_carrierStringDevice Carrier
device_idStringDevice ID
device_id_md5StringDevice ID Md5
device_id_sha1StringDevice ID Sha1
device_id_sha256StringDevice ID Sha256
device_ipStringDevice IP
device_modelStringDevice Model
device_typeStringDevice Type
existing_userBooleanExisting User, 1= Yes 0= No
fb_user_idStringFacebook User ID
genderIntegerGender
google_aidStringGoogle Aid
google_aid_md5StringGoogle Aid Md5
google_aid_sha1StringGoogle Aid Sha1
google_aid_sha256StringGoogle Aid Sha256
google_user_idStringGoogle User ID
idStringLog ID
impression_createdStringImpression Datetime
impression_gross_countIntegerImpression Gross Count
impression_publishers_countIntegerImpression Partners Count
impression_unique_countStringImpression Unique Count
install_createdStringInstall Datetime
install_dateStringInstall Datetime
install_publisher_idStringInstall Partner ID
install_stat_click_idStringInstall Click ID
ios_ad_trackingBooleaniOS Ad Tracking; 1=Enabled 0=Disabled
ios_ifaStringiOS IFA
ios_ifa_md5StringiOS IFA md5
ios_ifa_sha1StringiOS IFA sha1
ios_ifa_sha256StringiOS IFA sha256
ios_ifvStringiOS IFV
ios_ifv_md5StringiOS IFV md5
ios_ifv_sha1StringiOS IFV sha1
ipStringClick IP
is_assistBooleanIs Assist, 1= Yes 0= No
is_reengagementBooleanIs Reengagement; 1= Yes 0= No
is_uniqueNullable BooleanIs Unique, 1= Yes 0= No
is_viewthroughBooleanIs View Through; 1= Yes 0= No
languageStringLanguage
latitudeFloatLatitude
longitudeFloatLongitude
mac_addressStringMac Address
mac_address_md5StringMac Address Md5
mac_address_sha1StringMac Address Sha1
mat_idStringMAT ID
match_typeStringMatch Type; possible values
  • referrer
  • fingerprint
  • identifier
  • identifier_post
  • iad_integration
  • inline
  • NULL
  • Not Available
metro_codeStringMetro Code
odinStringODIN
os_idStringDevice OS ID
os_id_md5StringDevice OS ID Md5
os_id_sha1StringDevice OS ID Sha1
os_id_sha256StringDevice OS ID Sha256
os_jailbrokeBooleanDevice jailbroken; 1= Yes 0=No
os_versionStringDevice OS Version
package_nameStringPackage Name
payoutIntegerPayout Amount
postal_codeStringPostal Code
publisher_adgroup_idStringPartner Adgroup Id
publisher_click_idStringPartner Click ID
publisher_idStringPartner Id
publisher_ref_idStringPartner Ref Id
publisher_sub1StringPartner Sub 1
publisher_sub2StringPartner Sub 2
publisher_sub3StringPartner Sub 3
publisher_sub4StringPartner Sub 4
publisher_sub5StringPartner Sub 5
publisher_sub_ad_idStringPartner Sub Ad Id
publisher_sub_adgroup_idStringPartner Sub Adgroup Id
publisher_sub_campaign_idStringPartner Sub Campaign Id
publisher_sub_keyword_idStringPartner Sub Keyword Id
publisher_sub_placement_idStringPartner Sub Placement Id
publisher_sub_publisher_idStringPartner Sub Partner Id
publisher_sub_site_idStringPartner Sub Site Id
referral_sourceStringReferral Source
referral_urlStringConversion Referrer
region_idStringRegion ID
request_urlStringRequest URL
revenueStringRevenue
revenue_usdStringRevenue Usd
sdkStringSDK Platform
sdk_versionStringSDK Version
session_datetimeStringClick Datetime
session_ipStringClick IP
site_event_idStringSite Event ID
site_event_items_countStringSite Event Items Count
site_event_offsetIntegerIncrement of logs per specific event by user; starts at 0 and increases by ones.
site_idStringSite ID
site__offsetIntegerIncrement of logs per specific app by user; starts at 0 and increases by ones.
stat_click_idStringClick ID
stat_impression_idStringImpression ID
stat_install_idStringInstall ID
statusStringStatusShow Supported Values
status_codeStringStatus CodeShow Supported Values
test_profile_idStringTest Profile ID
tracking_idStringTracking ID
transaction_idStringTransaction ID
twitter_user_idStringTwitter User ID
unidStringUNID
unique_partnerBooleanUnique Partner, 1= Yes 0= No
user_agentStringUser Agent
user_emailStringUser Email
user_email_md5StringUser Email Md5
user_email_sha1StringUser Email Sha1
user_idStringUser ID
user_id_md5StringUser ID Md5
user_id_sha1StringUser ID Sha1
user_phone_md5StringUser Phone Md5
user_phone_sha1StringUser Phone Sha1
user_phone_sha256StringUser Phone Sha256
usernameStringUsername
username_md5StringUsername Md5
username_sha1StringUsername Sha1
windows_aidStringWindows Aid
windows_aid_md5StringWindows Aid Md5
windows_aid_sha1StringWindows Aid Sha1
windows_aid_sha256StringWindows Aid Sha256
wurfl_brand_nameStringDevice Brand Name
wurfl_device_osStringDevice OS
wurfl_device_os_versionStringDevice OS Version
wurfl_model_nameStringDevice Model Name
Have a Question? Please contact support@tune.com for technical support.