Does anyone have experienced pulling AppExchange App Analytics data for their managed package using AppAnalyticsQueryRequest? This was released in Summer 2019. If you have experience with this can you please tell me:
- Did you use SOAP UI?
- Which WSDL did you generate to reference in SOAP UI? Enterprise? Partner?
I am looking for step by step guide that is more then what SF has right now: https://developer.salesforce.com/docs/atlas.en-us.packagingGuide.meta/packagingGuide/app_analytics_download_mp_logs.htm
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
Salesforce just released this package for a much more friendly interface to pull AppAnalytics data.
https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000G0nUXUAZ
Method 2
Essentially there are two options, depending on what you need the data for:
1) Do it yourself: request data via the Salesforce API
The flow is roughly:
- Insert an app analytics query request which specifies:
- the timeframe you need the data for
- the package IDs you need the data for (all of the requested packages need to be enabled for AppAnalytics through the partner portal case)
- Wait until the request state is complete (through polling the request by its ID)
- Fetch the CSV data which is provided as download URL in the request. The download URL expires after a certain time (15 minutes as of today).
Then there are two types of data points you can retrieve through the process above: a) detailed log events and b) monthly summaries which rollup CRUD operations on a monthly basis. The amount of data for a) can be significant, depending on the number of subscriber orgs, users and activity in the packages.
The setup also requires a bit of fine-tuning, in order to keep the CSV size below 2GB, which is the APIs upper limit for one given request.
2) Use a plug-and-play solution
The data files described above contain usage data on a very granular level. If you’re not willing or able to build the data fetching, storage, aggregation and evaluation yourself, you can use a plug-and-play solution like ISVapp. You connect it via OAuth to your partner business org and it does the heavy lifting + provides insights from the data (charts, dashboards, forecasts etc.).
Method 3
the best way to access this object is using Workbench. Salesforce should update their documentation to say this instead of suggesting SOAP.
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0