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. | <ul><li>One daily query.</li><li>Set AvailableSince to the day and time your last regular query ran.</li><li>Set StartTime to 30 days ago.</li><li>Omit EndTime.</li><li>Each day advance StartTime and AvailableSince by 1 day.</li></ul> |
| Package Usage Summaries | An initial query to retrieve data from when App Analytics was enabled for your managed packages. | <ul><li>One daily catch-up query.</li><li>Set AvailableSince to the day and time your last regular query ran.</li><li>Set StartTime to the first of the previous month.</li><li>Omit EndTime.</li><li>Each day advance AvailableSince by 1 day.</li><li>Each month advance StartTime to the first of the previous month.</li></ul> |
| Package Usage Logs | One regular daily query per package. | <ul><li>One daily catch-up query per package.</li><li>Set AvailableSince to the day and time your last regular query ran.</li><li>Set StartTime to 30 days ago.</li><li>Set EndTime equal to the StartTime of your regular query.</li><li>Each day advance StartTime, EndTime, and AvailableSince by 1 day.</li></ul> |
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
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-30T00:00:00Z EndTime=2021-03-31T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=csv FileCompression=gzip"Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-30T00:00:00Z EndTime=2021-03-31T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=csv FileCompression=gzip" -
On April 1 at
18:00 UTConwards, run regular and catch-up package usage log queries.
A. Regular Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-31T00:00:00Z EndTime=2021-04-01T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=csv FileCompression=gzip"Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-31T00:00:00Z EndTime=2021-04-01T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=csv FileCompression=gzip"B. Catch-Up Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-01T00:00:00Z EndTime=2021-03-31T00:00:00Z AvailableSince=2021-03-31T18:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=csv FileCompression=gzip"Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=021-03-01T00:00:00Z EndTime=2021-03-31T00:00:00Z AvailableSince=2021-03-31T18:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=csv FileCompression=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
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-04-01T00:00:00Z EndTime=2021-04-02T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=csv FileCompression=gzip"Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-04-01T00:00:00Z EndTime=2021-04-02T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=csv FileCompression=gzip"B. Catch-Up Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-02T00:00:00Z EndTime=2021-04-01T00:00:00Z AvailableSince=2021-04-01T18:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=csv FileCompression=gzip"Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2020-03-02T00:00:00Z EndTime=2021-04-01T00:00:00Z AvailableSince=2021-04-01T18:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=csv FileCompression=gzip"