Questions pertaining to integrating sales data from third party software distribution channels such as Apple App Store (iTunes), Google Play (Market/Wallet/Checkout), and Microsoft Windows Store
Questions tagged [sales-analytics]
7 questions
5
votes
0 answers
API-level difference between Google Checkout and Android Market documented?
PREAMBLE: this question is wildly obsolete. There's no more Google Checkout and no more API.
Android Market uses Google Checkout for paid app sales. Google Checkout has a fairly extensive API. The behavior of Android Market accounts is markedly…
Seva Alekseyev
- 59,826
- 25
- 160
- 281
1
vote
0 answers
Retrieve overseas order amount in USD via Google Checkout API
I have paid Android apps on Google Play. I'm using Google Checkout XML API (notification history, specifically) to retrieve order details. I'm in the USA, and some of my customers are not. For overseas orders, the Google Checkout API returns the…
Seva Alekseyev
- 59,826
- 25
- 160
- 281
0
votes
2 answers
Do in-app purchases show up in Google Checkout?
Regular Google Market purchases of one's apps show up in one's Google Checkout console. Click on Merchant Account and you'll see them.
Do in-app purchases show there as well?
If they do, how about dummy in-app purchases - the ones with dummy item ID…
Seva Alekseyev
- 59,826
- 25
- 160
- 281
0
votes
2 answers
Replacement for Google Checkout XML API
The retirement notice for Google Checkout at https://support.google.com/checkout/sell/answer/3080449?hl=en says:
If you are a user of [Google Play or Google Wallet for digital goods],
but use the Google Checkout
APIs for notifications or…
Seva Alekseyev
- 59,826
- 25
- 160
- 281
-1
votes
1 answer
SQL tables not joining correctly - Values only appear when specified in WHERE clause
This is my query:
SELECT
a.[Hierarchy Group ID],
o.[Opportunity ID],
o.[Opportunity Name],
o.[ARR],
o.[TCM],
p.[Product Group],
a.[Account Management Scope],
FROM OpportunityTable as o
LEFT JOIN AccountTable as a ON o.[Account ID]=a.[Account…
J.Sun
- 13
- 2
-1
votes
1 answer
How to create a date loop in SQL
This is my statement below:
SELECT [Opp ID], max([Record ID]) as [Record ID]
FROM Opp History Table
WHERE [Last Modified Date] < '2015-01-06'
GROUP BY [Opp ID]
I am trying to construct a table that retrieves data that shows how the forecast is…
J.Sun
- 13
- 2
-2
votes
1 answer
Windows Phone store weekly sales report
I'm looking at the in-app purchase report from the Windows Phone store at weekly aggregation level. Instead of date ranges, they're using week designations like "2015-W10" - presuming they've counted all weeks in a year.
What's the algorithm for…
Seva Alekseyev
- 59,826
- 25
- 160
- 281