Step-by-step guide to connecting your GoogleAds account and syncing campaign data seamlessly.
Authorize Connection to Google Ads
Ensure that the account you're granting access to holds admin-level permissions.
- Navigate to Data Integration -> Connectors
- Click on "Connect A new platform"
- Select GoogleAds and follow the on-screen prompts to grant Cassandra the necessary permissions to access and retrieve your data.
Upon successful connection of the Google Ads account, you will be presented with a dashboard displaying their linked Google accounts and associated clients. This dashboard will also feature four buttons located directly beneath the Google Account section:
- Add a New Account: This button enables you to link additional Google Ads accounts to the platform.
- Reauthorize: This button allows you to refresh the authorization for their Google Ads account, ensuring continued data access.
- Test Connection: This button initiates a test to verify the connectivity between the platform and the Google Ads account.
- Delete Connection: This button severs the link between the platform and the Google Ads account, removing the account and its data from the dashboard.
Extracted Data
These are the extracted data fields that we extracted from GoogleAds
|
Data Field |
Extracted Data Source |
Explanation |
|
date |
date |
The date associated with the advertising data. |
|
campaign_type |
campaign_advertising_channel_type |
The type of advertising campaign (e.g., Search, Display, Video, Shopping). |
|
campaign_name |
campaign_name |
The name of the advertising campaign. |
|
spend |
cost_micros |
The cost (in micros) associated with the advertising campaign. |
|
clicks |
clicks |
The number of clicks on the advertisement. |
|
impressions |
impressions |
The number of times the advertisement was displayed. |
|
conversions |
conversions |
The number of conversions attributed to the advertisement (e.g., purchases, sign-ups, leads). |
|
country |
location_view_resource_name |
The country where the advertisement was shown or where the user who interacted with the ad was located. |
|
revenue |
conversions_value |
The revenue generated from conversions attributed to the advertisement. |
Date Range and Data Freshness
- Data Freshness: Data is updated daily.
- Data Granularity: daily.
- Date Range: 3 years
Data Validation
The validation is done over the spend metric.