ReturnOnAdSpendInsights

Spend and revenue metrics over time for users who installed on a given day.\n\nNOTE: Return on ad spend metrics are only reported in the 1st UTC hour of every day. When using a granularity of HOURLY, only the hour representing 00:00:00 UTC - 00:59:59 UTC will have a value other than 0.

Fields

day0Roas ([Money!]!)

Total return on ad spend 0 days from install. This is calculated as day_0_roas_revenue divided by day_0_roas_spend. If day_0_roas_revenue is 0, this field will also be 0

day0RoasAdRevenue ([Money!]!)

Total user ad revenue 0 days from install

day0RoasEngagements ([Money!]!)

Total user engagements 0 days from install

day0RoasIapRevenue ([Money!]!)

Total user IAP revenue 0 days from install

day0RoasRevenue ([Money!]!)

Total user revenue 0 days from install. This is calculated as day_0_roas_iap_revenue plus day_0_roas_ad_revenue

day0RoasSpend ([Money!]!)

Total advertiser spend 0 days from install

day14Roas ([Money!]!)

Total return on ad spend 14 days from install. This is calculated as day_14_roas_revenue divided by day_14_roas_spend. If day_14_roas_revenue is 0, this field will also be 0

day14RoasAdRevenue ([Money!]!)

Total user ad revenue 14 days from install

day14RoasEngagements ([Money!]!)

Total user engagements 14 days from install

day14RoasIapRevenue ([Money!]!)

Total user IAP revenue 14 days from install

day14RoasRevenue ([Money!]!)

Total user revenue 14 days from install. This is calculated as day_14_roas_iap_revenue plus day_14_roas_ad_revenue

day14RoasSpend ([Money!]!)

Total advertiser spend 14 days from install

day1Roas ([Money!]!)

Total return on ad spend 1 days from install. This is calculated as day_1_roas_revenue divided by day_1_roas_spend. If day_1_roas_revenue is 0, this field will also be 0

day1RoasAdRevenue ([Money!]!)

Total user ad revenue 1 days from install

day1RoasEngagements ([Money!]!)

Total user engagements 1 days from install

day1RoasIapRevenue ([Money!]!)

Total user IAP revenue 1 days from install

day1RoasRevenue ([Money!]!)

Total user revenue 1 days from install. This is calculated as day_1_roas_iap_revenue plus day_1_roas_ad_revenue

day1RoasSpend ([Money!]!)

Total advertiser spend 1 days from install

day2Roas ([Money!]!)

Total return on ad spend 2 days from install. This is calculated as day_2_roas_revenue divided by day_2_roas_spend. If day_2_roas_revenue is 0, this field will also be 0

day2RoasAdRevenue ([Money!]!)

Total user ad revenue 2 days from install

day2RoasEngagements ([Money!]!)

Total user engagements 2 days from install

day2RoasIapRevenue ([Money!]!)

Total user IAP revenue 2 days from install

day2RoasRevenue ([Money!]!)

Total user revenue 2 days from install. This is calculated as day_2_roas_iap_revenue plus day_2_roas_ad_revenue

day2RoasSpend ([Money!]!)

Total advertiser spend 2 days from install

day30Roas ([Money!]!)

Total return on ad spend 30 days from install. This is calculated as day_30_roas_revenue divided by day_30_roas_spend. If day_30_roas_revenue is 0, this field will also be 0

day30RoasAdRevenue ([Money!]!)

Total user ad revenue 30 days from install

day30RoasEngagements ([Money!]!)

Total user engagements 30 days from install

day30RoasIapRevenue ([Money!]!)

Total user IAP revenue 30 days from install

day30RoasRevenue ([Money!]!)

Total user revenue 30 days from install. This is calculated as day_30_roas_iap_revenue plus day_30_roas_ad_revenue

day30RoasSpend ([Money!]!)

Total advertiser spend 30 days from install

day3Roas ([Money!]!)

Total return on ad spend 3 days from install. This is calculated as day_3_roas_revenue divided by day_3_roas_spend. If day_3_roas_revenue is 0, this field will also be 0

day3RoasAdRevenue ([Money!]!)

Total user ad revenue 3 days from install

day3RoasEngagements ([Money!]!)

Total user engagements 3 days from install

day3RoasIapRevenue ([Money!]!)

Total user IAP revenue 3 days from install

day3RoasRevenue ([Money!]!)

Total user revenue 3 days from install. This is calculated as day_3_roas_iap_revenue plus day_3_roas_ad_revenue

day3RoasSpend ([Money!]!)

Total advertiser spend 3 days from install

day4Roas ([Money!]!)

Total return on ad spend 4 days from install. This is calculated as day_4_roas_revenue divided by day_4_roas_spend. If day_4_roas_revenue is 0, this field will also be 0

day4RoasAdRevenue ([Money!]!)

Total user ad revenue 4 days from install

day4RoasEngagements ([Money!]!)

Total user engagements 4 days from install

day4RoasIapRevenue ([Money!]!)

Total user IAP revenue 4 days from install

day4RoasRevenue ([Money!]!)

Total user revenue 4 days from install. This is calculated as day_4_roas_iap_revenue plus day_4_roas_ad_revenue

day4RoasSpend ([Money!]!)

Total advertiser spend 4 days from install

day5Roas ([Money!]!)

Total return on ad spend 5 days from install. This is calculated as day_5_roas_revenue divided by day_5_roas_spend. If day_5_roas_revenue is 0, this field will also be 0

day5RoasAdRevenue ([Money!]!)

Total user ad revenue 5 days from install

day5RoasEngagements ([Money!]!)

Total user engagements 5 days from install

day5RoasIapRevenue ([Money!]!)

Total user IAP revenue 5 days from install

day5RoasRevenue ([Money!]!)

Total user revenue 5 days from install. This is calculated as day_5_roas_iap_revenue plus day_5_roas_ad_revenue

day5RoasSpend ([Money!]!)

Total advertiser spend 5 days from install

day60Roas ([Money!]!)

Total return on ad spend 60 days from install. This is calculated as day_60_roas_revenue divided by day_60_roas_spend. If day_60_roas_revenue is 0, this field will also be 0

day60RoasAdRevenue ([Money!]!)

Total user ad revenue 60 days from install

day60RoasEngagements ([Money!]!)

Total user engagements 60 days from install

day60RoasIapRevenue ([Money!]!)

Total user IAP revenue 60 days from install

day60RoasRevenue ([Money!]!)

Total user revenue 60 days from install. This is calculated as day_60_roas_iap_revenue plus day_60_roas_ad_revenue

day60RoasSpend ([Money!]!)

Total advertiser spend 60 days from install

day6Roas ([Money!]!)

Total return on ad spend 6 days from install. This is calculated as day_6_roas_revenue divided by day_6_roas_spend. If day_6_roas_revenue is 0, this field will also be 0

day6RoasAdRevenue ([Money!]!)

Total user ad revenue 6 days from install

day6RoasEngagements ([Money!]!)

Total user engagements 6 days from install

day6RoasIapRevenue ([Money!]!)

Total user IAP revenue 6 days from install

day6RoasRevenue ([Money!]!)

Total user revenue 6 days from install. This is calculated as day_6_roas_iap_revenue plus day_6_roas_ad_revenue

day6RoasSpend ([Money!]!)

Total advertiser spend 6 days from install

day7Roas ([Money!]!)

Total return on ad spend 7 days from install. This is calculated as day_7_roas_revenue divided by day_7_roas_spend. If day_7_roas_revenue is 0, this field will also be 0

day7RoasAdRevenue ([Money!]!)

Total user ad revenue 7 days from install

day7RoasEngagements ([Money!]!)

Total user engagements 7 days from install

day7RoasIapRevenue ([Money!]!)

Total user IAP revenue 7 days from install

day7RoasRevenue ([Money!]!)

Total user revenue 7 days from install. This is calculated as day_7_roas_iap_revenue plus day_7_roas_ad_revenue

day7RoasSpend ([Money!]!)

Total advertiser spend 7 days from install

day90Roas ([Money!]!)

Total return on ad spend 90 days from install. This is calculated as day_90_roas_revenue divided by day_90_roas_spend. If day_90_roas_revenue is 0, this field will also be 0

day90RoasAdRevenue ([Money!]!)

Total user ad revenue 90 days from install

day90RoasEngagements ([Money!]!)

Total user engagements 90 days from install

day90RoasIapRevenue ([Money!]!)

Total user IAP revenue 90 days from install

day90RoasRevenue ([Money!]!)

Total user revenue 90 days from install. This is calculated as day_90_roas_iap_revenue plus day_90_roas_ad_revenue

day90RoasSpend ([Money!]!)

Total advertiser spend 90 days from install