ReturnOnAdSpendInsights

Spend and revenue metrics over time for users who installed on a given day.

NOTE: 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_spend divided by day_0_roas_revenue. If day_0_roas_revenue is 0, this field will also be 0

day0RoasRevenue ([Money!]!)

Total user revenue 0 days from install

day0RoasSpend ([Money!]!)

Total user spend 0 days from install

day14Roas ([Money!]!)

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

day14RoasRevenue ([Money!]!)

Total user revenue 14 days from install

day14RoasSpend ([Money!]!)

Total user spend 14 days from install

day1Roas ([Money!]!)

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

day1RoasRevenue ([Money!]!)

Total user revenue 1 days from install

day1RoasSpend ([Money!]!)

Total user spend 1 days from install

day2Roas ([Money!]!)

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

day2RoasRevenue ([Money!]!)

Total user revenue 2 days from install

day2RoasSpend ([Money!]!)

Total user spend 2 days from install

day30Roas ([Money!]!)

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

day30RoasRevenue ([Money!]!)

Total user revenue 30 days from install

day30RoasSpend ([Money!]!)

Total user spend 30 days from install

day3Roas ([Money!]!)

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

day3RoasRevenue ([Money!]!)

Total user revenue 3 days from install

day3RoasSpend ([Money!]!)

Total user spend 3 days from install

day4Roas ([Money!]!)

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

day4RoasRevenue ([Money!]!)

Total user revenue 4 days from install

day4RoasSpend ([Money!]!)

Total user spend 4 days from install

day5Roas ([Money!]!)

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

day5RoasRevenue ([Money!]!)

Total user revenue 5 days from install

day5RoasSpend ([Money!]!)

Total user spend 5 days from install

day60Roas ([Money!]!)

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

day60RoasRevenue ([Money!]!)

Total user revenue 60 days from install

day60RoasSpend ([Money!]!)

Total user spend 60 days from install

day6Roas ([Money!]!)

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

day6RoasRevenue ([Money!]!)

Total user revenue 6 days from install

day6RoasSpend ([Money!]!)

Total user spend 6 days from install

day7Roas ([Money!]!)

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

day7RoasRevenue ([Money!]!)

Total user revenue 7 days from install

day7RoasSpend ([Money!]!)

Total user spend 7 days from install

day90Roas ([Money!]!)

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

day90RoasRevenue ([Money!]!)

Total user revenue 90 days from install

day90RoasSpend ([Money!]!)

Total user spend 90 days from install