knitr::opts_chunk$set( collapse = TRUE, eval = FALSE, comment = "#>" )
The problem is that the
RAdwords package is used to work with Google AdWords API v201809. This API has not been updated for a long time and will stop working on 27 April 2022.
In this vignette, I want to share some information on a new package, rgoogleads, which I started working on in June 2021. The package currently has all the functions needed to request the function data. Next, we will go through the details of how to switch from RAdwords to rgoogleads, so that from April 2022, your scripts will still correctly collect the necessary data from your Google Ads accounts.
The rgoogleads package currently includes all the functions needed to fetch data from the Google Ads API:
Now let's look at the benefits of switching to the new rgoogleads package:
rgoogleadsis used to work with Google Ads API v8 (released on 09.06.2021);
RAdwordsis used to work with Google AdWords API v201809. Google AdWords API will sunset on 27.04.2022;
rgoogleadsuses the gargle package for authorization, which gives much more flexibility than the
rgoogleadshas an embedded Google Ads developer token and an OAuth client for authorization. This will save most users from having to request basic access to the Google Ads API from Google support and wasting time creating a project and OAuth client in the Google Cloud Console;
rgoogleadsfunctions have a cl argument, which allows for multi-threaded data import;
rgoogleadshas a list and account hierarchy import function;
rgoogleadshas separate functions to import the main objects of the advertising accounts, such as advertising campaigns, ad groups, keywords, and ads;
rgoogleadsis more straightforward and concise. In
RAdwords, you had to initially create
statement()function and then use it to request the data in the
rgoogleadshas no problem importing names containing Cyrillic characters;
rgoogleadspackage will automatically pause for 100 seconds and try to request data again. This makes this package more stable and resilient to Google Ads API server failures;
rgoogleadsdisplays a detailed error message. In comparison,
RAdwordswill not display a message if the user has made a request error;
rgoogleadsallows you to request data from the Keyword Planner.
Fortunately, there are few key differences between the old and new APIs, and the migration process isn’t that difficult. Let me enumerate the key points of the migration below.
migrate_table <- data.frame( operation = c("Authorization", "Metadata request", "Report request"), radwords = c("doAuth()", "reports(), metrics()", "statement() + getData()"), rgoogleads = c("gads_auth_configure() + gads_auth()", "gads_get_metadata(), gads_get_fields()", "gads_get_report()") ) DT::datatable( migrate_table, colnames = c("Operation", "RAdwords", "rgoogleads"), options = list(pageLength = 5, dom = 'tip'))
The former report types in Google AdWords have become resources in Google Ads. See the comparison table from the official help guide:
library(magrittr) library(rvest) # reports_table <- data.frame( # adwords = c("ACCOUNT_PERFORMANCE_REPORT", "AD_PERFORMANCE_REPORT", "ADGROUP_PERFORMANCE_REPORT", "AGE_RANGE_PERFORMANCE_REPORT", # "AUDIENCE_PERFORMANCE_REPORT", "AUTOMATIC_PLACEMENTS_PERFORMANCE_REPORT", "BID_GOAL_PERFORMANCE_REPORT", "BUDGET_PERFORMANCE_REPORT", # "CALL_METRICS_CALL_DETAILS_REPORT", "CAMPAIGN_AD_SCHEDULE_TARGET_REPORT", "CAMPAIGN_CRITERIA_REPORT", "CAMPAIGN_PERFORMANCE_REPORT", # "CAMPAIGN_SHARED_SET_REPORT", "CAMPAIGN_LOCATION_TARGET_REPORT", "CLICK_PERFORMANCE_REPORT", "DISPLAY_KEYWORD_PERFORMANCE_REPORT"), # ads = c("customer", "ad_group_ad", "ad_group", "age_range_view", # "campaign_audience_view, ad_group_audience_view", "group_placement_view", "bidding_strategy", "campaign_budget", # "call_view", "ad_schedule_view", "campaign_criterion", "campaign", # "campaign_shared_set", "location_view", "click_view", "display_keyword_view")) reports <- read_html("https://developers.google.com/google-ads/api/docs/migration/mapping") %>% html_element(css = ".responsive") %>% html_table(header = TRUE) DT::datatable( reports, colnames = c("Тип отчёта в Google AdWords API", "Ресурс в Google Ads API"), options = list(pageLength = 20) )
See the official help guide for the correspondence between the "Report" and the resource fields. The table is large, so there’s no need to duplicate it here.
See the example of requesting a campaign performance report with the same set of fields, using the
RAdwords package and
library(RAdwords) # auth adwords_auth <- doAuth() # create request query <- statement( select = c('CampaignName', 'Date', 'Clicks'), report = 'CAMPAIGN_PERFORMANCE_REPORT', start = '2021-06-01', end = '2021-06-30' ) # data import data1 <- getData( clientCustomerId = 'xxx-xxx-xxxx', statement = query, google_auth = adwords_auth )
library(rgoogleads) # auth gads_auth_configure(path = 'D:/ga_auth/app.json') gads_auth(email = 'email@example.com') # data import data2 <- gads_get_report( resource = 'campaign', fields = c('campaign.name', 'segments.date', 'metrics.clicks'), date_from = '2021-06-01', date_to = '2021-06-30', customer_id = 'xxx-xxx-xxxx', login_customer_id = 'xxx-xxx-xxxx' )
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.