Large-Sized Partners

Large partners have large subscriber bases and many managed packages. A large partner’s total daily data usage is more than 20 GB. Sometimes a large partner’s data from just one managed package is larger than the 20-GB daily limit. Also, large partners often must create a smaller time range for each query to complete in 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

Large partners frequently create one query per managed package per 12, 6, or 1-hour increments throughout a 24-hour period. How frequently you schedule your queries really depends on your data volume.

We recommend that you use a combination of queries and multiple catch-up queries for all data types

Data TypeHow to Get StartedHow to Schedule Catch-Up Queries
Subscriber SnapshotsOne daily query per package.
  • One daily query per package.
  • 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 SummariesOne daily query per package.
  • One daily catch-up query per package.
  • 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 Logs
  • To retrieve all your data, create multiple segmented daily, automated App Analytics queries spread throughout the day.
  • Break up your requests by managed package and by time increments throughout the day.
Create two levels of catch-up queries per day.
  • Create one catch-up query per package that sweeps data from 2 days ago.
  • Create a second catch-up query that sweeps data from 3 to 30 days ago.
  • Each day advance StartTime, EndTime, and AvailableSince by 1 day.

Your customers use your package on all Salesforce instances around the world, and your managed packages produce significant amounts of data. You schedule queries to run at the same time, each covering a 12-hour period, and you create a layered catch-up query plan to capture data from all instances.

In this example, we show two of your dozens of managed packages.

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

    Package 1

    Package 2

  • On April 1 at 18:00 UTC, run your regular and catch-up package usage log queries.

    Package log file regular and catch-up queries timeline on April 1.

    A. Package Usage Log Regular Queries

    Package 1

    Package 2

    B. Package Usage Log 2 Days Ago Catch-Up Queries

    Package 1

    Package 2

    C. Package Usage Log From 3 to 30 Days Ago Catch-Up Queries

    Package 1

    Package 2

  • On April 2 onwards, run your regular and your catch-up package usage log queries, advancing the dates by 1 day.

    Package log file regular and catch-up queries timeline on April 2.

    A. Package Usage Log Regular Queries

    Package 1

    Package 2

    B. Package Usage Log 2 Days Ago Catch-Up Queries

    Package 1

    Package 2

    C. Package Usage Log From 3 to 30 Days Ago Catch-Up Queries

    Package 1

    Package 2