dublicate number of columns

[mmadmar]

I see a strange behaviour when I do the following query:

sql_query <- "SELECT segments.date, campaign.name, segments.device, metrics.cost_micros, metrics.impressions, metrics.clicks, metrics.all_conversions
FROM campaign
WHERE segments.date BETWEEN '2021-03-17' AND '2022-06-07'
AND metrics.impressions > 0
PARAMETERS include_drafts=FALSE"

query_service <- googleAdsSearch(
aid = '--****', # Google Ads Accountnr ID
query = sql_query,
api_version = 'v9'
)

data <- query_google_ads(
mcc_id = '--****',
google_auth = google_auth,
service = query_service,
raw_data = F
)

This is what I get for names(data) and nrow(data):

names(data)
[1] "campaign.resourceName" "campaign.name" "metrics.clicks" "metrics.costMicros" "metrics.allConversions" "metrics.impressions" "segments.device"
[8] "segments.date" "campaign.resourceName" "campaign.name" "metrics.clicks" "metrics.costMicros" "metrics.allConversions" "metrics.impressions"
[15] "segments.device" "segments.date"

nrow(data)
[1] 10000

The columns are dublicated. The values in the column are not dublicated. Instead of 8 columns I get 16 columns.
Please see image below

This issue might have something to do with the amount of data, that I am trying to pull vom Google Ads.

This issue might also be related to #43.
When I extend the data range by one day in the above query to "BETWEEN '2021-03-16' AND '2022-06-07'" I also get the error "arguments imply differing number of rows: 10000, 28".