Viewing Sample Cohort Values (LTV) Request & Response | TUNE Docs (Legacy)

TUNE Reporting API endpoint Reporting Cohort Values (LTV) section presents how to create a service request and provides a listing of all available fields including which are recommended for best coverage of results.

This information was taken from Platform Reporting of Cohort Values (LTV):

platform_reporting_cohort_values

Servicing TUNE Reporting API Requests and Responses

Count Records in Report: /advertiser/stats/ltv/count.json

tune_reporting_api_action_count

URL Request

https://api.mobileapptracking.com/v2/advertiser/stats/ltv/count.jsonp?
callback=jQuery18309657427254132926_1423183548739
&api_key=YOUR_API_KEY_HERE
&filter=((publisher_id > 0) 
  AND (test_profile_id=0 OR test_profile_id IS NULL))
&timestamp=
&group[]=publisher_id
&start_date=2015-01-29
&end_date=2015-02-05
&response_timezone=America/Los_Angeles
&interval=year_day
&cohort_type=install
&aggregation_type=cumulative
&_=[Cache refresh Timestamp]

JSON Response

Stream Report: /advertiser/stats/ltv/find.json

tune_reporting_api_action_find

URL Request

https://api.mobileapptracking.com/v2/advertiser/stats/ltv/find.jsonp?
callback=jQuery18306392995368223637_1422810089197
&api_key=YOUR_API_KEY_HERE
&fields[]=publisher_id
&fields[]=publisher.name
&fields[]=rpi
&filter=((publisher_id > 0) 
  AND (test_profile_id=0 OR test_profile_id IS NULL))
&sort=rpi desc
&timestamp=
&group[]=publisher_id
&start_date=2015-01-25
&end_date=2015-02-01
&response_timezone=America/Los_Angeles
&page=1
&limit=2
&interval=year_day
&cohort_type=install
&aggregation_type=cumulative
&_=[Cache refresh Timestamp]

JSON Response

jQuery18306392995368223637_1422810089197(
{  
   status_code:200,
   response_size:"12493",
   data:[  
      {  
         data:[  
            {  
               rpi:0.36
            },
            {  
               rpi:0.44
            },
            {  
               rpi:0.46
            },
            {  
               rpi:0.79
            },
            {  
               rpi:0.79
            },
            {  
               rpi:0.79
            },
            {  
               rpi:0.79
            },
            {  
               rpi:0.79
            }
         ],
         meta:{  
            publisher_id:####,
            rpi:0.79,
            publisher:{  
               name:"####"
            }
         }
      },
      {  
         data:[  
            {  
               rpi:0.19
            },
            {  
               rpi:0.31
            },
            {  
               rpi:0.46
            },
            {  
               rpi:0.48
            },
            {  
               rpi:0.48
            },
            {  
               rpi:0.48
            },
            {  
               rpi:0.48
            },
            {  
               rpi:0.48
            }
         ],
         meta:{  
            publisher_id:####,
            rpi:0.48,
            publisher:{  
               name:"####"
            }
         }
      }
   ]
}
)

Export Report to Queue: /advertiser/stats/ltv/export.json

tune_reporting_api_action_export

URL Request

https://api.mobileapptracking.com/v2/advertiser/stats/ltv/export.jsonp?
callback=jQuery18306083544725552201_1423159766900
&api_key=YOUR_API_KEY_HERE
&fields[]=publisher_id
&fields[]=publisher.name
&fields[]=rpi
&filter=((publisher_id > 0) AND (test_profile_id=0 OR test_profile_id IS NULL))
&sort=rpi desc
&group[]=publisher_id
&start_date=2015-01-29
&end_date=2015-02-05
&response_timezone=America/Los_Angeles
&interval=year_day
&cohort_type=install
&aggregation_type=cumulative
&format=csv
&_=[Cache refresh Timestamp]

JSON Response

{  
   status_code:200,
   response_size:"98",
   data:{  
      job_id:"dummyb86-2d47-42d9-b776-d6f7062dummy"
   }
}
)

Report Export Status and Download from Queue: /advertiser/stats/ltv/status.json

tune_reporting_api_action_status

URL Request

https://api.mobileapptracking.com/v2/advertiser/stats/ltv/status.jsonp?
callback=jQuery18302778368766885251_1423265320859
&api_key=YOUR_API_KEY_HERE
&job_id=dummy149-fa25-4be2-ae55-b599c9ddummy
&_=1423265323044

JSON Response

jQuery18302778368766885251_1423265320859(
{  
   status_code:200,
   response_size:"382",
   data:{  
      status:"complete",
      percent_complete:100,
      url:"https://s3.amazonaws.com/########/########-####-####-####-########.csv?response-content-disposition=attachment%3B%20filename%3D%########-####-####-####-########.csv%22&AWSAccessKeyId=########&Expires=########&Signature=########%3D"
   }
}
}

Servicing TUNE Reporting API Requests and Responses

This is a complete listing of all available data points, also referred to as the fields, provided by Reporting\Report_Ltv, which endpointTUNE Reporting API’s Cohort Values (LTV) is bounded

Group By

Include at least one of these identifiers in parameter fields, and use one or more for parameter group.

cohort_api_group_by

Reporting Cohort Values LTV Group By Fields
Label	Field Name
Attribution Method	match_type
Campaign ID	campaign_id
Campaign	campaign.name
Country Code	country_code
Country	country.name
Destination URL ID	campaign_url_id
Destination URL	campaign_url.name
Device Brand	wurfl_brand_name
Device Model	wurfl_model_name
Device OS	wurfl_device_os
Device Type	device_type
Event ID	site_event_id
Event	site_event.name
Is View-Through	is_view_through
Mobile App ID	site_id
Mobile App	site.name
My Ad	advertiser_sub_ad
My Adgroup	advertiser_sub_adgroup
My Campaign Reference	advertiser_sub_campaign.ref
My Campaign	advertiser_sub_campaign
My Keyword	advertiser_sub_keyword
My Placement	advertiser_sub_placement
My Site	advertiser_sub_site
OS Jailbroke	os_jailbroke
Partner Ad Group	publisher_sub_adgroup
Partner Ad	publisher_sub_ad
Partner Campaign	publisher_sub_campaign
Partner ID	publisher_id
Partner Keyword	publisher_sub_keyword
Partner Placement	publisher_sub_placement
Partner Publisher	publisher_sub_publisher
Partner Site	publisher_sub_site
Partner	publisher.name
Purchase Validation Status	purchase_validation_status
Region Code	region_code
Region	region.name
Test Profile ID	test_profile_id
Test Profile	test_profile.name

Show

cohort_api_show

Reporting Cohort Values LTV Show Fields
Label	Field Name
1st Purchase	purchase_1st
2nd Opens	open_2nd
2nd Purchase	purchase_2nd
Average Time To 1st Purchase	purchase_1st_avg_sec
Average Time To 2nd Open	open_2nd_avg_sec
Average Time To 2nd Purchase	purchase_2nd_avg_sec
Events	events
Installs	installs
Opens	opens
Payouts	payouts
Purchases	purchases
Revenues USD	revenues_usd

Calculate

Reporting Cohort Values LTV Show Calculate
Label	Field Name
% To Paycheck	payback
CPI	cpi
EPI	epi
OPI	opi
RPI	rpi