Google Ads

The Lyftron Provider for Google Ads offers the most natural way to access Google Ads data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Google Ads data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Google Ads data provider and automatically build your data migration pipelines in minutes, not months

The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

• Comprehensive Delta load mechanism.
• Real-time access to Google Ads.
• Comprehensive full support of ANSI Sql to query data with ease.
• Collaborative query processing.

Prerequisites

The user must have credentials for Google Ads, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron

Follow the steps below to authenticate with Google Ads and obtain the OAuthVerifier connection property:

1. Click the following link to open the Google Ads OAuth endpoint in your browser.
2. Log in and grant permissions to the provider. You are then redirected to the callback URL, which contains the verifier code.
3. Save the value of the verifier code. You will set this in the OAuthVerifier connection property.

On the headless machine, set the following connection properties to obtain the OAuth authentication values.

• DeveloperToken: Set this to the developer token of the AdWords account. You can get a developer token by signing up for the AdWords API. To do this, log in to the AdWords site with your MMC account and navigate to Settings -> Account Settings -> AdWords API Center. Apply for API access and wait for Google to contact you via email with more instructions. You should receive a token with a pending status. This token is only for testing and does not allow you to connect to live data. Google should contact you to fill out a questionnaire and once this has been received and approved by Google, you will receive your active developer token.
• ClientCustomerId: Set this to the client customer Id of the AdWords account. You can find this value in your AdWords account. This value is not the same as the Id of the MCC account. You need to provide the lowest-level Ids to retrieve data.
• OAuthVerifier: Set this to the verifier code.
• InitiateOAuth: Set this to REFRESH.
• OAuthSettingsLocation: Set this to persist the encrypted OAuth authentication values to the specified file.

After the OAuth settings file is generated, set the following properties to connect to data:

• DeveloperToken: Set this to the developer token of the AdWords account. You can get a developer token by signing up for the AdWords API. To do this, log in to the AdWords site with your MMC account and navigate to Settings -> Account Settings -> AdWords API Center. Apply for API access and wait for Google to contact you via email with more instructions. You should receive a token with a pending status. This token is only for testing and does not allow you to connect to live data. Google should contact you to fill out a questionnaire and once this has been received and approved by Google, you will receive your active developer token.
• ClientCustomerId: Set this to the client customer Id of the AdWords account. You can find this value in your AdWords account. This value is not the same as the Id of the MCC account. You need to provide the lowest-level Ids to retrieve data.
• OAuthSettingsLocation: Set this to the file containing the encrypted OAuth authentication values. Make sure this file gives read and write permissions to the provider to enable the automatic refreshing of the access token.
• InitiateOAuth: Set this to REFRESH.

For more detailed information on service and user account connectivity click Google Ads Advanced Settings

Establishing a Connection with Lyftron's Quickstart Steps

Create your Google Ads connection with Lyftron by following the 5 easy steps show below:

Step1. Add your connection

Click on Connect section on the left panel →  Click on Add Connection button

Step2. Select your connector

In the connector selection panel, search and click Google Ads for your connection 

Step3. Enter your connection details

In the Connection String section enter the values of the below parameters. The following connection string is required to establish Google Ads connection with Lyftron.

"InitiateOAuth=GETANDREFRESH;DeveloperToken=myDeveloperToken;ClientCustomerId=myClientCustomerId;"

Key	Value	Field
Connection Name	Enter your connection details	Required
InitiateOAuth	GETANDREFRESH	Required
DeveloperToken	Your Google Ads DeveloperToken	Required
ClientCustomerId	Your Google Ads ClientCustomerId	Required
Logfile**	Use the logfile option to debug your job and provide your connection name to generate the log file.  [ConnectionConfigurationPath]\Connection_name_log.tx	Optional
Verbosity**	Choose verbosity 1-5 based on the severity of debugging	Optional

** For more information, check the Lyftron logging and debugging section.

If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.

Step4. Test your connection

Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.

 Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftron Google Ads connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Name	Type	Description
AccountPerformance	Views	The Account Performance report includes all statistics aggregated by default at the account level, one row per account.
AdCustomizersFeedItem	Views	The Ad Customizers Feed Item report provides statistics for feed items used in Ad Customizers. Statistics are aggregated at the feed item level, one row per feed item.
AdGroupBidLandscape	Views	Represents data about a bidlandscape for an adgroup.
AdgroupPerformance	Views	The Ad Group Performance report includes all statistics aggregated by default at the ad group level, one row per ad group.
AdGroups	Views	Service to access details about any ad groups.
AdPerformance	Views	The Ad Performance report includes all statistics aggregated at the ad level, one row per ad.
AgeRangePerformance	Views	The Age Range Performance report includes all display network statistics aggregated by age range. It also includes automatic audience performance.
AudiencePerformance	Views	The Audience Performance report includes performance data from interests and remarketing lists for display ads, and remarketing lists for search ads (RLSA), aggregated at the audience level�one row per audience.
AutomaticPlacementsPerformance	Views	The Automatic Placements Performance report includes all statistics aggregated at the placement level, one row per placement.
BidGoalPerformance	Views	The Bid Goal Performance report includes statistics for your bid strategies.
BudgetPerformance	Views	The Budget Performance report includes all statistics aggregated by default at the budget level, one row per budget.
CallMetricsCallDetails	Views	The Call Metrics Call Details report includes call details for your call extension including call duration and the caller's area code.
CampaignAdScheduleTarget	Views	The Campaign Ad Schedule Target report summarizes the performance of campaigns by AdSchedule criteria.
CampaignCriteria	Views	The Campaign Criteria report is a structure report that allows you to efficiently retrieve campaign-level criteria.
CampaignCriterionBidLandscape	Views	The bid landscape for a criterion. A bid landscape estimates how a a criterion will perform based on different bid amounts.
CampaignGroupPerformance	Views	The Campaign Group Performance report includes the overall performance statistics of campaigns that you have included in campaign groups. Statistics are aggregated by default at the campaign group level.
CampaignLocationTarget	Views	The Campaign Location Target Report summarizes the performance of campaigns by location-based CampaignCriterion.
CampaignNegativeKeywordsPerformance	Views	Although negative keywords do not hold statistics, you can use this structured report to efficiently retrieve attributes of keyword-based NegativeCampaignCriterion objects.
CampaignNegativeLocations	Views	Although negative locations do not hold statistics, you can use this structured report to efficiently retrieve attributes of location-based NegativeCampaignCriterion objects.
CampaignNegativePlacementsPerformance	Views	Although negative placements do not hold statistics, you can use this structured report to efficiently retrieve attributes of placement-based NegativeCampaignCriterion objects.
CampaignPerformance	Views	The Campaigns Performance report includes all statistics aggregated by default at the campaign level, one row per campaign.
Campaigns	Views	Service to access details about any campaign.
CampaignSharedSet	Views	The Campaign Shared Set report includes all relationships between SharedSets and campaigns.
ClickPerformance	Views	The Click Performance report includes stats aggregated at each click level, and includes both valid and invalid clicks. The KeywordId field will return any criteria that triggered the click, not just keywords.
ConversionTrackers	Views	Service to access details about any conversion tracker.
CreativeConversion	Views	Free clicks are interactions that take place before a clickthrough for video ads, display ads, product extensions and location extensions, interactions like a Video play or a Get directions.
CriteriaPerformance	Views	The Criteria Performance report includes statistics aggregated at the ad group criteria level, one row per ad group and criteria combination.
CriterionBidLandscape	Views	The bid landscape for a criterion. A bid landscape estimates how a a criterion will perform based on different bid amounts.
Customers	Views	Service to access basic details about any customer.
DisplayKeywordPerformance	Views	The Display Keyword Performance report includes all display network statistics aggregated at the keyword level, one row per keyword.
DisplayTopicsPerformance	Views	The Display Topics Performance report includes all display network statistics aggregated at the topic level, one row per topic.
FinalUrl	Views	The Final URL report includes all statistics aggregated at the final URL level, one row per final URL. If other segment fields are used, you may get more than one row per final URL.
GenderPerformance	Views	The Gender Performance report includes all statistics aggregated by gender. It also includes automatic audience performance.
GeoPerformance	Views	The Geo Performance report includes all statistics aggregated at the country/territory level, one row per country/territory.
KeywordlessCategory	Views	The Keywordless Category Performance report includes keywordless ads (dynamic search ads) statistics aggregated by category.
KeywordlessQuery	Views	The Keywordless Query report includes keywordless ads (dynamic search ads) statistics based on search terms.
KeywordsPerformance	Views	The Keywords Performance report includes all statistics aggregated at the keyword level, one row per keyword.
Label	Views	The Label report is a structure report that lists all labels for your account.
LandingPage	Views	The Landing Page report includes all statistics aggregated by default by the UnexpandedFinalUrlString, one row per the URL string.
LocationCriterion	Views	Represents data that encapsulates a location criterion.
ManagedCustomers	Views	Service to access basic details about any customer.
ManagedCustomersLinks	Views	Service to access basic details about any customer links.
MarketplacePerformance	Views	The Marketplace Performance report includes all statistics of ads displayed on the Marketplace, aggregated by default at the account level.
PaidOrganicQuery	Views	The Paid and Organic Query report provides a holistic view of your search stats across ads and organic listings at the query level. This lets you analyze strengths and gaps in your overall search presence, and gives insight into how your paid and organic search listings work together to connect your business with people searching on Google.
ParentalStatusPerformance	Views	The Parental Status Performance report includes statistics aggregated at the parental status level, one row per parental status
Placeholder	Views	The Placeholder Report provides statistics for feed-based ad extensions, one row per placeholder type.
PlaceholderFeedItem	Views	The Placeholder Feed Item report includes all statistics at the feed-item level (e.g., a single sitelink).
PlacementPerformance	Views	The Placements Performance report includes all statistics aggregated at the placement level, one row per placement.
ProductPartition	Views	The Product Partition report provides shopping campaign statistics aggregated at the product partition (Id field) level.
SearchQueryPerformance	Views	The Search Terms report includes all statistics aggregated at the search terms level, one row per combination of search terms.
SharedSet	Views	The Shared Set report includes all SharedSets that can be shareable across campaigns.
SharedSetCriteria	Views	The Shared Set Criteria report includes criteria for each SharedSet.
ShoppingPerformance	Views	The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level.
TopContentPerformance	Views	Retrieves TopContentPerformance report data.
UrlPerformance	Views	The URL Performance report includes all statistics aggregated at the URL and criterion level.
UserAdDistance	Views	The User Ad Distance Report provides statistics aggregated by the user's distance from your location extensions.
VideoPerformance	Views	The Video Performance report includes statistics for your account's upgraded AdWords for Video campaigns.