Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

Medium-Sized Partners

Medium-sized partners have bigger subscriber bases and about six managed packages. A medium-sized partner’s total daily usage data across all managed packages is at or just over 20 GB. Also, this partner’s queries approach or hit the 15-minute processing time limit.
Available in: both Salesforce Classic and Lightning Experience
Available in: Enterprise, Performance, Unlimited, and Developer Editions

We recommend that after you run your regular queries one time, use catch-up queries as your main queries for subscriber snapshots and package usage summaries. Use a combination of daily queries and catch-up queries for package usage logs.

Data Type How to Get Started How to Schedule Catch-Up Queries
Subscriber Snapshots An initial query to retrieve data from when App Analytics was enabled for your managed packages.
  • One daily 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 Summaries An initial query to retrieve data from when App Analytics was enabled for your managed packages.
  • 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 Logs One regular 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 30 days ago.
  • Set EndTime equal to the StartTime of your regular query.
  • Each day advance StartTime, EndTime, and AvailableSince by 1 day.

Example

Half of your customers use your package on an NA or EU instance, so you run your regular queries at 18:00 UTC. The other half of your customers are 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 package usage log queries for each of your packages.

    Package 1

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2021-03-30T00:00:00Z
    4EndTime=2021-03-31T00:00:00Z
    5DataType=PackageUsageLog
    6PackageIds=0336XXXXXXXXXX
    7FileType=csv
    8FileCompression=gzip"

    Package 2

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2021-03-30T00:00:00Z
    4EndTime=2021-03-31T00:00:00Z
    5DataType=PackageUsageLog
    6PackageIds=0337XXXXXXXXXX
    7FileType=csv
    8FileCompression=gzip"
  • On April 1 at 18:00 UTC onwards, run regular and catch-up package usage log queries.

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

    A. Regular Queries

    Package 1

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2021-03-31T00:00:00Z
    4EndTime=2021-04-01T00:00:00Z
    5DataType=PackageUsageLog
    6PackageIds=0336XXXXXXXXXX
    7FileType=csv
    8FileCompression=gzip"

    Package 2

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2021-03-31T00:00:00Z
    4EndTime=2021-04-01T00:00:00Z
    5DataType=PackageUsageLog
    6PackageIds=0337XXXXXXXXXX
    7FileType=csv
    8FileCompression=gzip"

    B. Catch-Up Queries

    Package 1

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2021-03-01T00:00:00Z
    4EndTime=2021-03-31T00:00:00Z
    5AvailableSince=2021-03-31T18:00:00Z
    6DataType=PackageUsageLog
    7PackageIds=0336XXXXXXXXXX
    8FileType=csv
    9FileCompression=gzip"

    Package 2

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=021-03-01T00:00:00Z
    4EndTime=2021-03-31T00:00:00Z
    5AvailableSince=2021-03-31T18:00:00Z
    6DataType=PackageUsageLog
    7PackageIds=0337XXXXXXXXXX
    8FileType=csv
    9FileCompression=gzip"
  • On April 2, repeat the same queries that you ran on April 1, but advance the queries by a day. Package log file regular and catch-up queries timeline on April 2.

    A. Regular Queries

    Package 1

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2021-04-01T00:00:00Z
    4EndTime=2021-04-02T00:00:00Z
    5DataType=PackageUsageLog
    6PackageIds=0336XXXXXXXXXX
    7FileType=csv
    8FileCompression=gzip"

    Package 2

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2021-04-01T00:00:00Z
    4EndTime=2021-04-02T00:00:00Z
    5DataType=PackageUsageLog
    6PackageIds=0337XXXXXXXXXX
    7FileType=csv
    8FileCompression=gzip"

    B. Catch-Up Queries

    Package 1

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2021-03-02T00:00:00Z
    4EndTime=2021-04-01T00:00:00Z
    5AvailableSince=2021-04-01T18:00:00Z
    6DataType=PackageUsageLog
    7PackageIds=0336XXXXXXXXXX
    8FileType=csv
    9FileCompression=gzip"

    Package 2

    1sf data create record
    2--sobjecttype AppAnalyticsQueryRequest
    3--values "StartTime=2020-03-02T00:00:00Z
    4EndTime=2021-04-01T00:00:00Z
    5AvailableSince=2021-04-01T18:00:00Z
    6DataType=PackageUsageLog
    7PackageIds=0337XXXXXXXXXX
    8FileType=csv
    9FileCompression=gzip"