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.
Required Editions
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 record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2021-03-30T00:00:00Z4EndTime=2021-03-31T00:00:00Z5DataType=PackageUsageLog6PackageIds=0336XXXXXXXXXX7FileType=csv8FileCompression=gzip"
Package 2
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2021-03-30T00:00:00Z4EndTime=2021-03-31T00:00:00Z5DataType=PackageUsageLog6PackageIds=0337XXXXXXXXXX7FileType=csv8FileCompression=gzip"
On April 1 at 18:00 UTC onwards, run regular and catch-up package usage log queries.
A. Regular Queries
Package 1
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2021-03-31T00:00:00Z4EndTime=2021-04-01T00:00:00Z5DataType=PackageUsageLog6PackageIds=0336XXXXXXXXXX7FileType=csv8FileCompression=gzip"
Package 2
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2021-03-31T00:00:00Z4EndTime=2021-04-01T00:00:00Z5DataType=PackageUsageLog6PackageIds=0337XXXXXXXXXX7FileType=csv8FileCompression=gzip"
B. Catch-Up Queries
Package 1
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2021-03-01T00:00:00Z4EndTime=2021-03-31T00:00:00Z5AvailableSince=2021-03-31T18:00:00Z6DataType=PackageUsageLog7PackageIds=0336XXXXXXXXXX8FileType=csv9FileCompression=gzip"
Package 2
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=021-03-01T00:00:00Z4EndTime=2021-03-31T00:00:00Z5AvailableSince=2021-03-31T18:00:00Z6DataType=PackageUsageLog7PackageIds=0337XXXXXXXXXX8FileType=csv9FileCompression=gzip"
On April 2, repeat the same queries that you ran on April 1, but advance the queries by a day.
A. Regular Queries
Package 1
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2021-04-01T00:00:00Z4EndTime=2021-04-02T00:00:00Z5DataType=PackageUsageLog6PackageIds=0336XXXXXXXXXX7FileType=csv8FileCompression=gzip"
Package 2
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2021-04-01T00:00:00Z4EndTime=2021-04-02T00:00:00Z5DataType=PackageUsageLog6PackageIds=0337XXXXXXXXXX7FileType=csv8FileCompression=gzip"
B. Catch-Up Queries
Package 1
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2021-03-02T00:00:00Z4EndTime=2021-04-01T00:00:00Z5AvailableSince=2021-04-01T18:00:00Z6DataType=PackageUsageLog7PackageIds=0336XXXXXXXXXX8FileType=csv9FileCompression=gzip"
Package 2
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "StartTime=2020-03-02T00:00:00Z4EndTime=2021-04-01T00:00:00Z5AvailableSince=2021-04-01T18:00:00Z6DataType=PackageUsageLog7PackageIds=0337XXXXXXXXXX8FileType=csv9FileCompression=gzip"
j