0

Data being split out by dimension when query does not ask for one


A
Anonymous

When creating a query without a dimension, the data should just be returned as one number in a cell. However, when pulling queries without a dimension split, DS still returns data split by a dimension, usually by account.

A

Activity Newest / Oldest

A

Antonio Barral

Status changed to: Closed

E

Enrique Campos

Hi, sorry for the delay
This error should be solved.
If you find any trouble let us know


E

Enrique Campos

Hi,
Can you provide us with more information (i.e. datasource, metrics, filters... )? We have checked all datasources without splitting by any dimension and we get data correctly.

Otherwise, if you select more than one account and you split by some dimension, we added manually the account dimension. Also we make a quick fix, if some of these dimensions is account, now we do not add it manually beacause of redundant information.


A

Yes, I was pulling data from adwords from multiple different accounts and this was happening. Accounts should not be added manually unless it the account dimension is in the query parameters. The reason for this is sometimes I don't want it split out by account, sometimes I want a nice quick, easy number across all my accounts without having to sum everything up.


Avatar

Will Ridley

Seems to happen because there's two links in the account list


Avatar

Will Ridley

I have also noticed that this causes doubling up of data in Adwords. See here for some reason the same accounts have been pulled in twice, each under different manager accounts (there is only one manager account in adwords so this should not be the case). See duplicated highlighted.


Avatar

Will Ridley

Also happens on Bing queries


Avatar

Will Ridley

Example screenshot - this query asks for date and account however DS still provides a redundant dimension called accounts in adwords which is not required.