Free creator analyzer

See which posts brought paying users.

Upload two exports. In about a minute you'll know which creators to book again, which to pause and what each paying user cost. No links, no sign-up.

How it works

  1. Add your sign-ups or installs export, with purchases, and your list of posts.

  2. WhichPost compares your sign-ups or installs, hour by hour, with each post's views.

  3. You get a report with a range and a decision for every creator.

Files are processed on this server. Only the report is kept, at a private link.

Rather connect your accounts? WhichPost then keeps the report up to date by itself. Connect Stripe

The analyzer runs a lighter version of our AI models. Paid plans run our most capable models on your live data, kept up to date. See plans

Your files

Uploading files needs JavaScript. Turn it on and reload this page, or download the sample files to see the format.

Sign-ups, installs and purchases One row per event: when it happened and what it was (sign-up, install, trial or paid). A RevenueCat export works as it is.
Drop a file here or choose one CSV, up to 20 MB
Posts One row per post: its ID, when it went live and its views. Add the creator and payout to see who to book again.
Drop a file here or choose one CSV, up to 20 MB
View history (Optional) Views per post counted at several times. Sharper results when you have it.
Drop a file here or choose one CSV, up to 20 MB
About your campaign (Optional)
Shown at the top of the report.
The currency your files use. Amounts are not converted.
USD
Each creator is compared with this to decide: book again, test again or pause. Leave it empty to use what a paying user earned you.

Usually under a minute.

Free install-source check

Would links have seen these installs?

Link trackers only count installs that arrive through a link. Many people who see a post search the App Store instead. Upload App Store Connect's installs by source to see how much of the lift links could see.

How to export it from App Store Connect
  1. In App Store Connect, open Analytics, then Sources.
  2. Show installs by day, from at least two weeks before the campaign until it ended.
  3. Export installs by source as CSV.
Installs by source, daily One row per day and source, with the number of installs. Columns named downloads or units work too.
Drop a file here or choose one CSV, up to 20 MB

We compare installs per day during the campaign with the two weeks before it.

File formats

What your files need

Column names are matched without caring about capital letters, and other columns are ignored, so most exports work with little or no editing.

Sign-ups, installs and purchases

Needs

  • timestamp

    When it happened. Any common date format; times without a time zone count as UTC.

    Also accepted: ts, time, event_time, event_timestamp, event_timestamp_ms, created_at, date, purchased_at, purchased_at_ms

  • event

    What happened: sign-up, install, trial or paid. RevenueCat event names such as initial_purchase work too.

    Also accepted: type, event_type, kind

Also used when present

user_id, country, revenue, code

Download a sample

Posts

Needs

  • clip_id

    Any ID that is different for each post.

    Also accepted: id, post_id, video_id, submission_id

  • posted_at

    When the post went live.

    Also accepted: published_at, created_at, timestamp, time

  • views

    Its views now, or when the campaign ended.

    Also accepted: view_count, verified_views, plays

Also used when present

creator, payout, url, platform, likes, comments, shares, code

Download a sample

View history

Needs

  • clip_id

    The same ID as in your posts file.

    Also accepted: id, post_id, video_id

  • captured_at

    When the views were counted.

    Also accepted: timestamp, time, ts

  • views

    Total views at that moment.

    Also accepted: view_count, cumulative_views

Download a sample

Installs by source, daily

Needs

  • date

    The day.

  • source

    Where the installs came from, as App Store Connect names it (App Store Search, App Store Browse, App Referrer, Web Referrer).

  • installs

    Installs that day from that source.

    Also accepted: first-time downloads, downloads, units, count

Download a sample

Feedback

Help shape WhichPost

We read every message, in any language.

What's it about?
Only if you'd like a reply.

Sent with this page's address, your language and the app version. Nothing else. Please don't paste API keys or passwords.