Newer Version Available
Large-Sized Partners
| 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 Type | How to Get Started | How to Schedule Catch-Up Queries |
|---|---|---|
| Subscriber Snapshots | One daily query per package. |
|
| Package Usage Summaries | One daily query per package. |
|
| Package Usage Logs |
|
Create two levels of catch-up queries per day.
|
Example
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
1sf data create record data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-30T00:00:00 4EndTime=2021-03-30T12:00:00 5DataType=PackageUsageLog 6PackageIds=0336XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-30T12:00:00 4EndTime=2021-03-31T00:00:00 5DataType=PackageUsageLog 6PackageIds=0336XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"Package 2
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-30T00:00:00 4EndTime=2021-03-30T12:00:00 5DataType=PackageUsageLog 6PackageIds=0337XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-30T12:00:00 4EndTime=2021-03-31T00:00:00 5DataType=PackageUsageLog 6PackageIds=0337XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy" - On April 1 at 18:00 UTC, run your regular and catch-up
package usage log queries.

A. Package Usage Log Regular Queries
Package 1
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-31T00:00:00Z 4EndTime=2021-03-31T12:00:00Z 5DataType=PackageUsageLog 6PackageIds=0336XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-31T12:00:00Z 4EndTime=2021-04-01T00:00:00Z 5DataType=PackageUsageLog 6PackageIds=0336XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"Package 2
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-31T00:00:00Z 4EndTime=2021-03-31T12:00:00Z 5DataType=PackageUsageLog 6PackageIds=0337XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-31T12:00:00Z 4EndTime=2021-04-01T00:00:00Z 5DataType=PackageUsageLog 6PackageIds=0337XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"B. Package Usage Log 2 Days Ago Catch-Up Queries
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=parquet 8FileCompression=snappy 9AvailableSince=2020-03-31T18:00:00Z"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=parquet 8FileCompression=snappy 9AvailableSince=2020-03-31T18:00:00Z"C. Package Usage Log From 3 to 30 Days Ago Catch-Up Queries
Package 1
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-01T00:00:00Z 4EndTime=2021-03-30T00:00:00Z 5DataType=PackageUsageLog 6PackageIds=0336XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy 9AvailableSince=2020-03-31T18:00:00Z"Package 2
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-01T00:00:00Z 4EndTime=2021-03-30T00:00:00Z 5DataType=PackageUsageLog 6PackageIds=0337XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy 9AvailableSince=2020-03-31T18:00:00Z" - On April 2 onwards, run your regular and your catch-up package usage log queries, advancing
the dates by 1 day.

A. Package Usage Log Regular Queries
Package 1
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-04-01T00:00:00Z 4EndTime=2021-04-01T12:00:00Z 5DataType=PackageUsageLog 6PackageIds=0336XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-04-01T12:00:00Z 4EndTime=2021-04-02T00:00:00Z 5DataType=PackageUsageLog 6PackageIds=0336XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"Package 2
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-04-01T00:00:00Z 4EndTime=2021-04-01T12:00:00Z 5DataType=PackageUsageLog 6PackageIds=0337XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-04-01T12:00:00Z 4EndTime=2021-04-02T00:00:00Z 5DataType=PackageUsageLog 6PackageIds=0337XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy"B. Package Usage Log 2 Days Ago Catch-Up 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=parquet 8FileCompression=snappy 9AvailableSince=2020-04-01T18:00:00Z”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=parquet 8FileCompression=snappy 9AvailableSince=2020-04-01T18:00:00Z"C. Package Usage Log From 3 to 30 Days Ago Catch-Up Queries
Package 1
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-02T00:00:00Z 4EndTime=2021-03-31T00:00:00Z 5DataType=PackageUsageLog 6PackageIds=0336XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy 9AvailableSince=2020-04-01T18:00:00Z"Package 2
1sf data create record 2--sobjecttype AppAnalyticsQueryRequest 3--values "StartTime=2021-03-02T00:00:00Z 4EndTime=2021-03-31T00:00:00Z 5DataType=PackageUsageLog 6PackageIds=0337XXXXXXXXXX 7FileType=parquet 8FileCompression=snappy 9AvailableSince=2020-04-01T18:00:00Z"