Verified IAP Revenue giving unreliable data

Hi,

We have noticed after releasing the latest update for our game that the Verified IAP Revenue has increased significantly and we know for a fact that this is not actually the case, so it would seem that it is reporting wrong data. The only difference between releases we had regarding purchasing is updating com.unity.purchasing package from 3.0.1 to 3.2.2. Is this a known issue?

Here’s a picture of the graph in the unity dashboard

Thanks in advance,
Ruben

No known issues. What do you believe to be the correct data?

That spike doesn’t align with anything, we haven’t experienced an actual increase in revenue. So the graph should stay at the same values that we had before that update.

Yes, it should be accurate now, we are working to improve our revenue tracking.

Hey!

I see the similar wrong IAP data as Ruben. I’ve recently updated to IAP plugin to 3.2.3 from some ancient version ( 2.0 or something)

Please share the actual numbers for a day? You may be right, but we need something to compare to. Perhaps it was inaccurate previously.

June: 548 IAPs, July: 1197 IAPs. Revenue is 5 to 10 times more than Google Play console shows.

After some googling and searching on this forum, I think it has something to do with deferred purchases added in google purchase api 3. Since I haven’t changed anything in my code, deferred purchases are probably being processed as complete ones. I added a code to check for pending purchases and published the update on Google Play.

Will let you know if it fixed situation ( will probably take several days to see new data in analytics).

Thank you for the quick response!

The code added to process purchase function :

var validationResult = validator.Validate(args.purchasedProduct.receipt);

foreach (var productReceipt in validationResult)
{
    if (productReceipt is GooglePlayReceipt google)
    {
        var purchaseState = google.purchaseState;
        if ((int)purchaseState == 4)
        {
            return PurchaseProcessingResult.Pending;
        }
    }
}

Sorry, “5 to 10 times” is not actionable. Which is it? Please show comparison screenshots for a single day to show the exact difference. I have a feeling that we might be tracking subscription renewals as revenue, are you able to confirm?

I don’t have subscriptions in my game, so that’s probably not the case.

Revenue shown by Google:
7395185--903185--upload_2021-8-6_17-47-44.png

Revenue shown on Unity Dashboard:

7395185--903188--upload_2021-8-6_17-48-53.png

Sorry for the confusion, please pick a SINGLE DAY, and show the specific differences and exact numbers. Can you show sales per day by product for example?

August, 1. Google Play console:

7395236--903194--upload_2021-8-6_17-56-10.png

Total: 19 purchases, 113,51 USD

Unity Dashboard:
7395236--903212--upload_2021-8-6_18-2-7.png
Revenue: $616.86. Number of IAPs - can’t say :slight_smile:
I’m not sure how to show detailed report in Unity Dashboard for IAP’s for a single day. It only lets me choose the minimum timespan of 2 days:

7395236--903215--upload_2021-8-6_18-6-37.png

Could you a side by side comparison and report it here? To be clear, I’m not doubting your claims. I’m trying to find a possible pattern to help engineering fix any potential issue.

Aug 1

Product Google Unity

A $4 $8
B $3 $7

I do understand that you need the precise data Jeff. I just don’t know how to get the count of IAPs of a single day in Unity Dashboard.

Not the count, just the $ values. You have them in your screenshot already, the Dollar values are on the y-axis. You should be able to mouse hover over each of the bars to get their specific value, otherwise just use the y-axis.

Sure, below are values for the August, 1st

com.foxforcegames.armoredsquad.purchases.coins5kk Unity Dashboard: $134.90 GooglePlay Console: $37,05
com.foxforcegames.armoredsquad.purchases.robot4pack Unity Dashboard: $82.49 GooglePlay Console: $26,44
com.foxforcegames.armoredsquad.purchases.robot3pack Unity Dashboard: $63.68 GooglePlay Console: $13,04
com.foxforcegames.armoredsquad.purchases.robot2pack Unity Dashboard: $43.78 GooglePlay Console: -none-
com.foxforcegames.armoredsquad.purchases.beastpack Unity Dashboard: -none- GooglePlay Console: $3,40
com.foxforcegames.armoredsquad.purchases.coins1kk Unity Dashboard: -none- GooglePlay Console: $2,51
com.foxforcegames.armoredsquad.purchases.coins250k Unity Dashboard: -none- GooglePlay Console: $1,87
com.foxforcegames.armoredsquad.purchases.mech1pack Unity Dashboard: -none- GooglePlay Console: $3,50
com.foxforcegames.armoredsquad.purchases.quad4pack Unity Dashboard: -none- GooglePlay Console: $7,45
com.foxforcegames.armoredsquad.purchases.robot1pack Unity Dashboard: -none- GooglePlay Console: $8,11

You’re using both a decimal and commas, are these values in US dollars? Just checking. But one clear issue is we show sales for a product, Google shows none. That is concerning. One note, we do count test purchases as actual revenue, would this make sense in your case? It’s a known issue.

Also, free trials may play a role, an area we are looking into. We look to be possibly counting the revenue twice, once at the beginning at the free trial, and again if/when the user actually purchases. Does the increase in revenue match with an increase in DAU? Just checking.

Commas and decimal is how browser shows it to me, I believe these can be threated as equal signs in this case. Yes, both google play console and unity dashboard show values in US dollars.

I didn’t make test purchases for a long time. The game is 4 years in the stores already and purchasing hasn’t changed since, so I had nothing to test. I’m not sure what free trials are. I only use usual IAPs, both consumable and non consumable. No subscriptions too. There hasn’t been any noticeable increase in DAU recently.

Only thing that I changed that is related to IAPs is I updated the IAP plugin to version 3.2.3. Nothing else has been changed. I did it because Google Play console showed warnings that I have to update to a newer Google Play Purchasing API version 3. So I did and the issue occurred.

Thanks for taking time to look into my case Jeff!

Got it, thanks for the report. We are looking into it, hopefully get it sorted in a future release.

1 Like

Looks like I missed all the action…

Thanks Andrei for providing your data!
Jeff please let me know if you need any info from me.

Cheers!

2 Likes