Google Analytics

[Anonymous]

Hello,

I ran into an issue and I'm hoping someone here can help. I pulled some data from GA in PBI and the numbers aren't lining up. When I pull sessions per day I get an accurate number, when I pull sessions per gender, device category, age, and browser the numbers are severely reduced. Can anyone explain this? Can anyone help me get around this?

When I look at the GA platform, I'm able to validate that the metric per day is correct.

Date	Sessions			Age	Gender	Browser	Device Category	Date	Sessions	Organic Searches	New Users	Users
Wednesday, June 13, 2018	20779			45-54	female	Chrome	desktop	Wednesday, June 13, 2018	618	168	196	281
				45-54	male	Chrome	desktop	Wednesday, June 13, 2018	505	196	281	365
				35-44	female	Chrome	desktop	Wednesday, June 13, 2018	393	168	168	337
				25-34	female	Chrome	mobile	Wednesday, June 13, 2018	337	140	253	281
				25-34	female	Chrome	desktop	Wednesday, June 13, 2018	1404	421	589	982
				25-34	male	Chrome	desktop	Wednesday, June 13, 2018	421	112	196	309

[v-easonf-msft]

Hi,  @Anonymous 

Please recheck  whether there are other unknown age groups, browser, device category data is not included.

Best Regards,
Community Support Team _ Eason

[Anonymous]

From my investigation. GA does not report "unknown" or "no data" resulting in diminished metrics when measuring across dimensions that have no data. With that said, my bst practice has been to bring in data strategically:

• Bring in 1 table per demographic data:
  • Daily Users, sessions, etc. by Gender 
  • Daily users, sessions, etc. by age
  • Daily users, sessions, etc. by geography
• Bring in 1 table for device data
  • Daily users, sessions, etc. by device category and browser