Change theme
Help
Press space for more information.
Show links for this issue (Shortcut: i, l)
Copy issue ID
Previous Issue (Shortcut: k)
Next Issue (Shortcut: j)
Sign in to use full features.
Vote: I am impacted
Notification menu
Refresh (Shortcut: Shift+r)
Go home (Shortcut: u)
Use Markdown for this comment
Set severity, which reflects how much the issue affects the use of the product
Assign issue to yourself
Pending code changes (auto-populated)
[ID: 82937]
Primary programming language affected, if applicable [ID: 82936]
[ID: 82935]
[ID: 82940]
[ID: 82941]
Set the version(s) of the product affected by this issue (comma-separated list)
Set the version(s) of the product in which the issue should be fixed (comma-separated list)
Set the version(s) of the product in which the issue fix was verified (comma-separated list)
Set if this issue occurs in production
Set Reporter
Set Type
Set priority, which reflects how soon the issue should be fixed
Set Status
Set Assignee
Set Verifier
Remove item
View or edit staffing
View issue level access limits(Press Alt + Right arrow for more information)
Description
We have Google Analytics linked to a Looker studio chart to showcase Total Ad revenue + IAP revenue.
Source = UA channel data source provided by the UA providers themselves, eg. Facebook, IG. Is a single control field in Looker Studio that allows selecting from a drop down list the applicable sources.
Total Revenue = Total Ad Revenue + IAP revenue
Date selection = We made sure that the date range is well over the versions release time and this remains static through bug case.
App Version = App version of our application. Eg 0.24.0. A simple Control field that allows selecting versions.
Problem you have encountered:
When looking at a single app version (0.24.0) that was out for a small time, there seems to be something weird with how Source interacts with the total revenue (Ad + gross revenue). The 0.24.1 exhibits similar behaviour.
Whenever all sources are selected, the total revenue is 10x what it is if a single source is excluded. It does not really matter which source it is, the Total revenue drops significantly.
The fields (source, ad revenue and iap revenue) used for total revenue are based on Google Analytics so the data is not even custom data points.
What is confusing is that this behaviour can only be seen in that version (0.24.X). If I select eg. 0.23.0 and do the same, everything seems fine and All sources combined = Single source + Single source excluded.
I double checked that this behaviour happens also with "Total ad revenue" field that is provided by Google Analytics.
What you expected to happen:
"All sources combined = Single source + Single source excluded" when looking at version 0.24.0 Total revenue.
Steps to reproduce:
I can replicate it with our data set every time.
1. Go to our Total Revenue graph
2. Select time period that is well over the versions release time
3. Observe total revenue in graph.
4. Exclude a single source from a Control Field
5. Observe total revenue in graph again
6. Total revenue dropped more than is shown by selecting that single source as the option.
7. This same behaviour is available with all the Sources
Other information (workarounds you have tried, documentation consulted, etc):
Summing up all the sources does not seem to result in the total number, no matter how approached, but only with that version.
It also seems that we have all the sources listed there, so there is not a one that is hidden by the drop down menu.
The Total revenue is in reality approximately what is shown when no sources are excluded (all sources selected) - single source revenue added up seems too low. That is how we noticed the weird behaviour in the first place.