Small-Sized Partners

Small-sized partners have manageable subscriber bases and one or two managed packages. A small partner’s total daily usage data across all managed packages is 5 GB or less. Also, small partner’s queries complete well under the 15-minute processing time limit.

Required Editions
Available in: both Salesforce Classic and Lightning Experience
Available in: Enterprise, Performance, Unlimited, and Developer Editions

Given how manageable smaller partners’ data is, after you run your regular queries one time, we recommend that you run a daily catch-up query as your main query. Sweep in all data for all your managed packages for the last 30 days.

Data TypeHow to Get StartedHow to Schedule Catch-Up Queries
Subscriber SnapshotsAn initial query to retrieve data from when App Analytics was enabled for your managed package.
  • One daily catch-up query.
  • Set AvailableSince to the day and time your last regular query ran.
  • Set StartTime to 30 days ago.
  • Omit EndTime.
  • Each day advance StartTime and AvailableSince by 1 day.
Package Usage SummariesAn initial query to retrieve data from when App Analytics was enabled for your managed package.
  • One daily catch-up query.
  • Set AvailableSince to the day and time your last regular query ran.
  • Set StartTime to the first of the previous month.
  • Omit EndTime.
  • Each day advance AvailableSince by 1 day.
  • Each month advance StartTime to the first of the previous month.
Package Usage LogsAn initial query to retrieve data from when App Analytics was enabled for your managed package.
  • One daily catch-up query.
  • Set AvailableSince to the day and time your last regular query ran.
  • Set StartTime to 30 days ago.
  • Omit EndTime.
  • Each day advance StartTime and AvailableSince by 1 day.

Most of your customers use your package on an NA or EU instance, so you run your queries at 18:00 UTC. You have a couple customers on an AP instance, so you create catch-up queries to ensure that you capture data from around the world.

  • On March 31 at 18:00 UTC, run your regular queries.

    Subscriber Snapshot

    Package Usage Summary

    Package Usage Log

  • On April 1 at 18:00 UTC run these three catch-up queries.

    Subscriber Snapshot Catch-Up Query

    Package Usage Summary Catch-Up Query

    Package Usage Log Catch-Up Query

  • On April 2 at 18:00 UTC, run the same catch-up queries, but advance the subscriber snapshot and package usage log AvailableSince and StartTime date by 1 day each. Advance the package usage summary AvailableSince by 1 day.

    Subscriber Snapshot Catch-Up Query

    Package Usage Summary Catch-Up Query

    Package Usage Log Catch-Up Query