Can we get cohort LTV and ROAS by campaign without building it in a BI tool?
Every week someone exports installs and revenue into a spreadsheet to work out D7 and D30 ROAS per campaign. Does the attribution tool usually handle this, or is BI the normal route?
Answer from the Linkrunner team
Often the attribution tool can, but check five things before you retire the spreadsheet. Cohorts should group by campaign, creative and channel, not only install date. Confirm what starts the cohort: install, sign-up or first purchase give different answers. Later windows such as D30 and beyond should be readable in the dashboard, since subscription and finance payback runs longer than D7. Cost should be pulled from the ad networks so ROAS is calculated, not typed in. And there should be an export or API for the questions no dashboard covers. Linkrunner shows cohort revenue and ROAS up to D180 beside spend, with CSV, API and webhook exports and no export fees. Test two tools against your spreadsheet on one real campaign for a week. Cohort vs calendar ROAS, which trips people up: https://linkrunner.io/glossary/what-is-cohort-vs-calendar-roas
More on this: linkrunner.io/blog/mmps-with-cohort-ltv-roas-reports