banboo-data/r4googleads

Cannot Download Data

Closed this issue · 0 comments

Hi,

First of all, thank you for your work!

I went through the authentication process and I tried this code:

`google_auth_2 <- r4googleads::authenticate()

sql_query = "SELECT campaign.name, metrics.clicks FROM campaign WHERE segments.date BETWEEN '2023-01-01' AND '2023-03-31'AND metrics.impressions > 0"

query_service = googleAdsSearch(
aid = '522-013-xxxx', # Google Ads Accountr ID
query = sql_query,
api_version = 'v9'
)

data = query_google_ads(
mcc_id = "535-480-xxxx", # Google Ads My Client Center ID
google_auth = google_auth_2,
service = query_service
)`

But for some reason I get this error:

Error: lexical error: invalid char in json text.

(right here) ------^

What am I doing wrong?

My Client Id is a Desktop App:

Screenshot 2023-11-11 at 18 46 40