Best Practices

Recommended setup

Join Ratings and Stat reviews

These two entities complement each other — ratings show scores and distributions, while stat reviews capture sentiment and volume. Join them on App ID for a complete picture of app reputation in one table.

Use Append for multi-app tracking

If you track apps across separate App lists, add each list as a source in the same data flow and use the Append transformation. This gives you a unified dataset across your entire portfolio without managing multiple data flows.

Send review stats to AI destinations

Pipe Stat reviews into ChatGPT, Claude, or Gemini to auto-generate weekly sentiment summaries or identify recurring themes in negative reviews — no manual analysis needed.

Data refresh and scheduling

Match refresh frequency to your release cadence

If you ship app updates weekly, daily rating syncs make sense to catch post-release feedback quickly. For stable apps with infrequent updates, a weekly refresh is usually sufficient.

Always run a manual sync first

Before setting a schedule, complete a successful manual run to confirm your API key, entity selection, and destination are all working correctly.

Performance optimization

Separate organizational and analytical entities

Users, App collections, and App lists change infrequently — sync these separately and less often. Keep Stat reviews and Ratings in their own data flow with a tighter schedule so you're not re-pulling static data unnecessarily.

Aggregate before sending to dashboards

If you're reporting to Looker Studio or BigQuery, use Coupler.io's Aggregate transformation to pre-summarize review counts or average ratings. This keeps your destination cleaner and dashboards faster.

Common pitfalls

Don't mix App Store and Google Play data in the same row without filtering by the Store field. Rating scales and review volumes differ significantly between stores, and blended averages can be misleading.

Do

• Filter by store when comparing ratings across regions

• Use App ID as the join key when combining Ratings and Stat reviews

• Track the Updated at field from App lists to know when your tracked set changed

Don't

• Run multiple Appfollow data flows simultaneously — you risk hitting API rate limits

• Rely solely on rating deltas without checking absolute counts; a small app can show large swings with just a few new ratings

• Assume Users entity reflects your app's end users — it only contains Appfollow workspace members