AnalysisBuild it in chat

LTV payback by campaign

Join AppsFlyer installs with your own revenue tables in BigQuery, for 30-, 90- and 180-day value and payback period per campaign.

You, in one sentence in chatMonthly

Overview

Real revenue per user lives in the company's own BigQuery tables, not in AppsFlyer. Without joining the two, nobody can say which campaign pays back and when.

Larger app businesses with a data team and a warehouse. The growth lead who has to defend payback to finance.

What it does

  1. 1Pull installs per campaign and ad from AppsFlyer.
  2. 2Join them in BigQuery with your revenue and cohort tables.
  3. 3Show 30-, 90- and 180-day revenue per user and payback period per campaign.
  4. 4Monthly, flag campaigns that won't pay back inside the target window.

What you’ll see

Payback period by campaign

Revenue per user over time

Campaigns at risk

Not in the Hub yet. Describe this job in one sentence in chat, and Hawky builds the agent with the connectors it needs, asks you for anything only you know, tests it and shows you the board.

Illustrative example

What a run looks like

A trading app pays ₹600 per install on Google and ₹450 on Meta. After 90 days, Google users have brought in ₹900 each and paid back in about two months. Meta users brought in ₹380 and haven't paid back yet. Hawky proposes moving budget to Google and keeping Meta on test budgets.

Illustrative: the brand and numbers are made up to show how the agent reasons. They are not customer results.

Before you start

What needs to be in place

Both must share a user ID, usually the AppsFlyer ID or the customer user ID the app passes to AppsFlyer.

Questions

About LTV payback by campaign

What does LTV payback by campaign need to run?

It connects to AppsFlyer and Google BigQuery. Both must share a user ID, usually the AppsFlyer ID or the customer user ID the app passes to AppsFlyer. Connect each tool once and every agent in your workspace can use it.

Does LTV payback by campaign change anything in my accounts?

Only with your approval. It proposes changing campaign budgets, and nothing changes until someone says yes.

How often does LTV payback by campaign run?

Monthly. Its workflow runs on that schedule and keeps the board current, and you can change the schedule by asking in chat.

All 31 agents

Analysis · Workflow board

Day-7 retention by campaign

Which campaigns bring users who are still doing the core action on day 7, from AppsFlyer and Mixpanel.

AppsFlyerMeta AdsMixpanel
Build it in chat·Weekly

Analysis · Workflow board

Paying user finder

Installs and purchases by Snapchat creative from AppsFlyer, so creatives are judged on paying users, not cheap installs.

Snapchat AdsAppsFlyer
Build it in chat·Weekly

Analysis · Workflow board

Repeat buyer finder

Which Meta and Google ads bring customers who come back to buy again, read from Shopify and posted to Slack.

Meta AdsGoogle AdsShopifySlack
Build it in chat·Weekly

Put Hawky’s agents on your performance marketing.

See LTV payback by campaign running on your own accounts in a live demo.