Installation Guides

Google AdWords Keywords Performance

Thanks for installing and test driving Google AdWords Keywords Performance! This guide is intended to help you connect this app to your own data. The first step is to ensure that your data follows the same schema (or structure) of the sample datasets that are currently powering the app. Fortunately, Domo has created some powerful data transformation tools to help, along with the step-by-step instructions provided below.

Step 1: Prepare Your Data

This app requires creating the following custom datasets. To do this, you'll need to ensure that you have each of these fields in Domo. Then you'll need to use transforms to create datasets that follow the exact structure or schema of the datasets below. For help with Dataflows, Magic ETL, or BeastModes, please visit Domo University.

DataSet Name: SAMPLE_Google AdWords Keyword Report
Field NameData TypeReport Name / Object NameSource Description of Field
AccountSTRINGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsAccount
DayDATESAMPLE_Google AdWords Keyword ReportGoogle AdWordsDay tracked
CampaignSTRINGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsCampaign
Ad groupSTRINGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsAd group
Keyword stateSTRINGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsState keyword
KeywordSTRINGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsName of keyword
Max. CPCDOUBLESAMPLE_Google AdWords Keyword ReportGoogle AdWordsMaximum cost per click
ClicksLONGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsClicks
ImpressionsLONGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsNumber of impressions
CTRSTRINGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsCTR
Avg. CPCDOUBLESAMPLE_Google AdWords Keyword ReportGoogle AdWordsAverage cost per click
CostDOUBLESAMPLE_Google AdWords Keyword ReportGoogle AdWordsCost
Avg. positionDOUBLESAMPLE_Google AdWords Keyword ReportGoogle AdWordsAverage position of ads
Converted clicksLONGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsConverted clicks
Cost / converted clickDOUBLESAMPLE_Google AdWords Keyword ReportGoogle AdWordsCost per clicks that are converted
Click conversion rateSTRINGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsClick conversion rate
ConversionsLONGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsConversions
View-through conv.LONGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsConversion of view-through
Quality scoreLONGSAMPLE_Google AdWords Keyword ReportGoogle AdWordsQuality score

Step 2: Connect Your Data

Once you've finished preparing your data as outlined in Step 1 you're ready to connect it to your app. To do this, go to the page in Domo where the app is installed and click the "CONNECT YOUR DATA" button at the top of the page.

Screen Shot 2016-03-14 at 3.52.48 PM

Additional help

Need additional assistance? Visit the Domo Community