Get cohorts and LTV
get_cohortsCohort & LTV analytics. A cohort is everything that entered on the same day (or week): subject=clicks follows a traffic day — cumulative LTV/ROI per click, repeat conversions and how much of the payoff had landed by day N, with revenue attributed back to the day of the CLICK (standard reports attribute it to the day the conversion arrived); subject=registration follows sign-ups (Lead) to their deposits; subject=ftd follows first deposits (Sale) to their redeposits (Upsell) — the deposit / repeat-purchase vocabulary: summary.arpu = LTV per FTD, returns_per_entity = redeposits per FTD, active_rate = FTD→redeposit rate, summary.ladder = LTV earned inside D0 / D1-7 / D8-30 / D31-90, life_days = redeposits by day of life; subject=push follows a subscriber base; subject=pwa follows PWA installs. split_by returns a second table whose rows are one dimension value instead of a day (each row carries its own ladder, active_rate and returns_per_entity — the channel comparison). Cells a cohort has not reached yet are null.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| os | No | ||
| isp | No | ||
| pwa | No | PWA id | |
| city | No | ||
| site | No | Placement / zone id as passed by the ad network | |
| sub1 | No | Filter by sub1 | |
| sub2 | No | Filter by sub2 | |
| sub3 | No | Filter by sub3 | |
| sub4 | No | Filter by sub4 | |
| sub5 | No | Filter by sub5 | |
| sub6 | No | Filter by sub6 | |
| sub7 | No | Filter by sub7 | |
| sub8 | No | Filter by sub8 | |
| sub9 | No | Filter by sub9 | |
| user | No | Workspace member id(s), comma-separated — the campaign owner at click time (needs the "See statistics per team member" permission; ignored otherwise) | |
| offer | No | Offer id | |
| sub10 | No | Filter by sub10 | |
| sub11 | No | Filter by sub11 | |
| sub12 | No | Filter by sub12 | |
| sub13 | No | Filter by sub13 | |
| sub14 | No | Filter by sub14 | |
| sub15 | No | Filter by sub15 | |
| device | No | mobile / tablet / desktop | |
| period | No | Reporting period (default 7days). Use 'custom' with date_from/date_to. | |
| source | No | Traffic source id | |
| browser | No | ||
| country | No | Country ISO alpha-2 code, e.g. ES | |
| date_to | No | YYYY-MM-DD (with period=custom) | |
| horizon | No | Days/weeks after the cohort day to return (default 30 / 12, max 90 / 26) | |
| landing | No | Landing id | |
| subject | No | What a cohort is made of (default clicks) | |
| campaign | No | Campaign ALIAS (the short code, not the numeric id) | |
| creative | No | Creative id from the click URL | |
| language | No | ||
| pwa_tags | No | Comma-separated tag ids — pwas carrying any of them | |
| referrer | No | ||
| split_by | No | Also return a matrix whose rows are this dimension | |
| utm_term | No | Exact utm_term value from the click URL | |
| date_from | No | YYYY-MM-DD (with period=custom) | |
| pwa_group | No | Pwa group id | |
| smartlink | No | Smartlink id | |
| source_id | No | Source id as passed by the ad network | |
| offer_tags | No | Comma-separated tag ids — offers carrying any of them | |
| utm_medium | No | Exact utm_medium value from the click URL | |
| utm_source | No | Exact utm_source value from the click URL | |
| ad_campaign | No | The ad network's own campaign id (external_campaign_id) | |
| aff_network | No | Affiliate network id | |
| granularity | No | Cohort granularity (default day) | |
| offer_group | No | Offer group id | |
| source_tags | No | Comma-separated tag ids — sources carrying any of them | |
| unique_only | No | Count unique clicks only | |
| utm_content | No | Exact utm_content value from the click URL | |
| exclude_bots | No | Exclude bot traffic (bots are counted by default) | |
| landing_tags | No | Comma-separated tag ids — landings carrying any of them | |
| source_group | No | Source group id | |
| utm_campaign | No | Exact utm_campaign value from the click URL | |
| campaign_tags | No | Comma-separated tag ids — campaigns carrying any of them | |
| landing_group | No | Landing group id | |
| campaign_group | No | Campaign group id | |
| smartlink_tags | No | Comma-separated tag ids — smartlinks carrying any of them | |
| connection_type | No | ||
| smartlink_group | No | Smartlink group id |