Small-Sized Partners
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. |
|
Package Usage Summaries | An initial query to retrieve data from when App Analytics was enabled for your managed package. |
|
Package Usage Logs | An initial query to retrieve data from when App Analytics was enabled for your managed package. |
|
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
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=SubscriberSnapshot FileType=csv FileCompression=gzip StartTime=2020-03-30T00:00:00Z EndTime=2020-03-31T00:00:00Z"
Package Usage Summary
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=PackageUsageSummary FileType=csv FileCompression=gzip StartTime=2020-02-01T00:00:00Z EndTime=2020-03-01T00:00:00Z"
Package Usage Log
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=PackageUsageLog FileType=csv FileCompression=gzip StartTime=2020-03-30T00:00:00Z EndTime=2020-03-31T00:00:00Z"
- On April 1 at 18:00 UTC run these three catch-up
queries.
Subscriber Snapshot Catch-Up Query
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=SubscriberSnapshot FileType=csv FileCompression=gzip StartTime=2020-03-02T00:00:00Z AvailableSince=2020-03-31T18:00:00Z"
Package Usage Summary Catch-Up Query
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=PackageUsageSummary FileType=csv FileCompression=gzip StartTime=2020-03-01T00:00:00Z AvailableSince=2020-03-31T18:00:00Z"
Package Usage Log Catch-Up Query
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=PackageUsageLog FileType=csv FileCompression=gzip StartTime=2020-03-02T00:00:00Z AvailableSince=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
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=SubscriberSnapshot FileType=csv FileCompression=gzip StartTime=2020-03-03T00:00:00Z AvailableSince=2020-04-01T18:00:00Z"
Package Usage Summary Catch-Up Query
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=PackageUsageSummary FileType=csv FileCompression=gzip StartTime=2020-03-01T00:00:00Z AvailableSince=2020-04-01T18:00:00Z"
Package Usage Log Catch-Up Query
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "DataType=PackageUsageLog FileType=csv FileCompression=gzip StartTime=2020-03-03T00:00:00Z AvailableSince=2020-04-01T18:00:00Z"