Setup

CoolaData provides a predefined connection that uses the Google AdWords API to enable you to upload the Google AdWords reports into CoolaData. This type of integration is typically used to enrich your CoolaData project with AdWords data, such as CTRs (Click Through Rates) versus keywords and costs, in order to link your marketing efforts to your CoolaData project data.

CoolaData automatically uploads the latest Google AdWords reports from your account once a day and fetches yesterday’s data. New data is appended to the tables stored in CoolaData.

To upload Google AdWords data into CoolaData:

  1. Follow the instructions in Integrating with Predefined Data Sources and then select Google AdWords.
    7-22
  2. Fill in the following:
    1. Integration Name – The name of this integration.
    2. [Optional] You can use the Google Project ID and Google Dataset fields to define that CoolaData uploads data from your Google AdWords report into your own Google project instead of into your CoolaData project. Contact your CoolaData customer success representative for more information.
  3. Click the Connect button. The following displays:
    7-23

    1. Enter the Google AdWords account credentials to be monitored by CoolaData. If you are already logged into your Google AdWords account in a different window on the same computer, then there is no need to enter your Gmail account credentials.
    2. Click the Allow button.

The first import process should take place within a few minutes.
The Status column of the Integrations list changes to show Data Fetched.
If the integration process fails for any reason, then an indication appears in the Status column of the Integration List.

Once a day CoolaData will then integrate data from the following three Google AdWords reports into your project:

  • adwords_geo
  • adwords_clicks
  • adwords_campaigns

The table names will be the same, appended by the integration ID as displayed in the integration title, in brackets:

7-24

For example: adwords_geo_4202

Data can now be queried using the following syntax:

 

Table Schemas

adwords_geo

date TIMESTAMP
country STRING
source STRING
type STRING
impressions FLOAT
clicks FLOAT
cost FLOAT
integrationtime TIMESTAMP

 

 adwords_clicks

ad_type STRING
ad_group_id FLOAT
ad_group STRING
network STRING
network_with_search_partners STRING
campaign_id FLOAT
campaign STRING
click_type STRING
ad_id FLOAT
keyword_id FLOAT
keyword__placement STRING

 

adwords_campaigns

currency STRING
account STRING
time_zone STRING
active_view_avg_cpm FLOAT
active_view_viewable_ctr STRING
active_view_viewable_impressions FLOAT
active_view_measurable_impr__impr STRING
active_view_measurable_cost FLOAT
active_view_measurable_impr FLOAT
active_view_viewable_impr__measurable_impr STRING
network STRING
network_with_search_partners STRING
advertising_sub_channel STRING
advertising_channel STRING
all_conv_rate STRING
all_conv FLOAT
all_conv_value FLOAT
budget FLOAT
avg_cost FLOAT
avg_cpc FLOAT
avg_cpe FLOAT
avg_cpm FLOAT
avg_cpv FLOAT
pages__session FLOAT
avg_position FLOAT
avg_session_duration_seconds FLOAT
base_campaign_id FLOAT
bid_strategy_id FLOAT
bid_strategy_name STRING
bid_strategy_type STRING
conversion_optimizer_bid_type STRING
bounce_rate STRING
budget_id FLOAT
campaign_id FLOAT
mobile_bid_adj STRING
campaign STRING
campaign_state STRING
campaign_trial_type STRING
click_assisted_conv FLOAT
click_assisted_conv__last_click_conv FLOAT
click_assisted_conv_value FLOAT
all_conv_value FLOAT
budget FLOAT
avg_cost FLOAT
avg_cpc FLOAT
avg_cpe FLOAT
avg_cpm FLOAT
avg_cpv FLOAT
pages__session FLOAT
avg_position FLOAT
avg_session_duration_seconds FLOAT
base_campaign_id FLOAT
bid_strategy_id FLOAT
bid_strategy_name STRING
bid_strategy_type STRING
conversion_optimizer_bid_type STRING
bounce_rate STRING
budget_id FLOAT
campaign_id FLOAT
mobile_bid_adj STRING
campaign STRING
campaign_state STRING
campaign_trial_type STRING
click_assisted_conv FLOAT
click_assisted_conv__last_click_conv FLOAT
click_assisted_conv_value FLOAT
clicks FLOAT
content_lost_is_budget STRING
content_impr_share STRING
content_lost_is_rank STRING
conv_rate STRING
conversions FLOAT
total_conv_value FLOAT
cost FLOAT
cost__all_conv FLOAT
cost__conv FLOAT
crossdevice_conv FLOAT
ctr STRING
client_name STRING
day TIMESTAMP
end_date STRING
engagement_rate STRING
engagements FLOAT
enhanced_cpc_enabled STRING
enhanced_cpv_enabled STRING
customer_id FLOAT
gmail_forwards FLOAT
gmail_saves FLOAT
gmail_clicks_to_website FLOAT
impr_assisted_conv FLOAT
impr_assisted_conv__last_click_conv FLOAT
impr_assisted_conv_value FLOAT
unique_cookies STRING
impressions FLOAT
interaction_rate STRING
interactions FLOAT
interaction_types STRING
invalid_click_rate STRING
invalid_clicks STRING
budget_explicitly_shared STRING
label_ids STRING
labels STRING
month TIMESTAMP
month_of_year STRING
phone_impressions FLOAT
phone_calls FLOAT
ptr STRING
_new_sessions STRING
budget_period STRING
company_name STRING
relative_ctr STRING
search_lost_is_budget STRING
search_exact_match_is STRING
search_impr_share STRING
search_lost_is_rank STRING
campaign_serving_status STRING
start_date TIMESTAMP
tracking_template STRING
custom_parameter STRING
value__all_conv FLOAT
value__conv FLOAT
video_played_to_100 STRING
video_played_to_25 STRING
video_played_to_50 STRING
video_played_to_75 STRING
view_rate STRING
views FLOAT
viewthrough_conv FLOAT
week TIMESTAMP
integrationtime TIMESTAMP
Print Friendly, PDF & Email