App Store Connect

Version 0.0.3

πŸ“˜

Checkout theΒ docs here for more information

Prerequisites


To generate keys, you must have an Admin account in App Store Connect. You may generate multiple API keys with any roles you choose.

Set up


To get set up with the App Store Connect Source you will need the following:

  • App Store KID
  • Issuer
  • Private Key

App Store KID

Your private key ID from App Store Connect; for example 2X9R4HXF34.

Issuer

Your issuer ID from the API Keys page in App Store Connect; for example, 57246542-96fe-1a63-e053-0824d011072a.

Private Key

You can see instructions to download your private key here.


Features


FeatureSupportNotes
Backfillβœ…Backfill will start from the selected report date
Incrementalβœ…Sales and Trends Reports - SALES(new version); Sales and Trends Reports - SUBSCRIBER; Sales and Trends Reports - SUBSCRIPTION ;Sales and Trends Reports - SUBSCRIPTION EVENT
Custom backfillβœ…Sales and Trends Reports - SALES(new version); Sales and Trends Reports - SUBSCRIBER; Sales and Trends Reports - SUBSCRIPTION ;Sales and Trends Reports - SUBSCRIPTION EVENT
API reliability🟒Reliable

Reports detail


⬇️ ReportπŸ”‘ Incremental keyπŸ”‘Primary keyπŸ“„ Link to API endpoint
Sales and Trends Reports - SALESEND_DATEN/ASales and trends report
Sales and Trends Reports - SALES (new version)END_DATEN/ASales and trends report
ReviewsN/AIDReviews report
Sales and Trends Reports - SUBSCRIBERREPORT_DATEN/ASales and trends report
Sales and Trends Reports - SUBSCRIPTIONREPORT_DATEN/ASales and trends report
Sales and Trends Reports - SUBSCRIPTION EVENTREPORT_DATEN/ASales and trends report

Limitations


πŸ“˜

Sales and Trends Reports - SALES (new version)

The report will allow you to backfill in custom periods to a maximum of 1 year back (with DAILY frequency). It then can incrementally get new data from the last END_DATE in the table to 2 days before the run day (on the day of the run last date will be 2 days before today). You will need to de-duplicate, which you can do using the KLEENE_EXTRACT_DATE

πŸ“˜

Sales and Trends Reports - SUBSCRIBER / SUBSCRIPTION / SUBSCRIPTION EVENT reports

The reports will allow you to backfill in custom period to a maximum of 1 year back. It then can incrementally get new data from the last REPORT_DATE in the table to 2 days before the run day (on the day of the run last date will be 2 days before today). You will need to de-duplicate which you can do using the KLEENE_EXTRACT_DATE

πŸ“˜

Sales and Trends Reports - SALES

The older report allows you to pull yearly, monthly and daily data for the sales report (with frequencies longer than DAILY, allowing you to go further back than 1 year).

Daily reports are available for 365 days, weekly reports for 52 weeks, monthly reports for 12 months, and yearly reports indefinitely.

Depending of the date you select on the Report Date setting on the Extract, the report will pull date for that year/month/week/day. Further runs on append will extract the following period of the same frequency.