Viewing Sample Cohort Values (LTV) Request & Response

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

cohort_api_calculate

Reporting Cohort Values LTV Show Calculate
Label Field Name
% To Paycheck payback
CPI cpi
EPI epi
OPI opi
RPI rpi
Have a Question? Please contact support@tune.com for technical support.