Small-sized partners have manageable subscriber bases and one or two managed packages. A small partner’s total daily usage data across all managed packages is 5 GB or less. Also, small partner’s queries complete well 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
Given how manageable smaller partners’ data is, after you run your regular queries one time, we recommend that you run a daily catch-up query as your main query. Sweep in all data for all your managed packages for the last 30 days.
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 package.
One daily catch-up 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 package.
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
An initial query to retrieve data from when App Analytics was enabled for your managed package.
One daily catch-up 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.
Example
Most of your customers use your package on an NA or EU instance, so you run your queries at 18:00 UTC. You have a couple customers 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 queries.
Subscriber Snapshot
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=SubscriberSnapshot4FileType=csv5FileCompression=gzip6StartTime=2020-03-30T00:00:00Z7EndTime=2020-03-31T00:00:00Z"
Package Usage Summary
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=PackageUsageSummary4FileType=csv5FileCompression=gzip6StartTime=2020-02-01T00:00:00Z7EndTime=2020-03-01T00:00:00Z"
Package Usage Log
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=PackageUsageLog4FileType=csv5FileCompression=gzip6StartTime=2020-03-30T00:00:00Z7EndTime=2020-03-31T00:00:00Z"
On April 1 at 18:00 UTC run these three catch-up queries.
Subscriber Snapshot Catch-Up Query
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=SubscriberSnapshot4FileType=csv5FileCompression=gzip6StartTime=2020-03-02T00:00:00Z7AvailableSince=2020-03-31T18:00:00Z"
Package Usage Summary Catch-Up Query
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=PackageUsageSummary4FileType=csv5FileCompression=gzip6StartTime=2020-03-01T00:00:00Z7AvailableSince=2020-03-31T18:00:00Z"
Package Usage Log Catch-Up Query
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=PackageUsageLog4FileType=csv5FileCompression=gzip6StartTime=2020-03-02T00:00:00Z7AvailableSince=2020-03-31T18:00:00Z"
On April 2 at 18:00 UTC, run the same catch-up queries, but advance the subscriber snapshot and package usage log AvailableSince and StartTime date by 1 day each. Advance the package usage summary AvailableSince by 1 day.
Subscriber Snapshot Catch-Up Query
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=SubscriberSnapshot4FileType=csv5FileCompression=gzip6StartTime=2020-03-03T00:00:00Z7AvailableSince=2020-04-01T18:00:00Z"
Package Usage Summary Catch-Up Query
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=PackageUsageSummary4FileType=csv5FileCompression=gzip6StartTime=2020-03-01T00:00:00Z7AvailableSince=2020-04-01T18:00:00Z"
Package Usage Log Catch-Up Query
1sf data create record2--sobjecttype AppAnalyticsQueryRequest3--values "DataType=PackageUsageLog4FileType=csv5FileCompression=gzip6StartTime=2020-03-03T00:00:00Z7AvailableSince=2020-04-01T18:00:00Z"