Google AdWords and Revenue Tracking through Marketo | Community
Skip to main content
KCS_Integration
Level 2
January 2, 2018

Google AdWords and Revenue Tracking through Marketo

  • January 2, 2018
  • 10 replies
  • 7431 views

Issue

Depending on the marketing strategy, Google AdWords can be a significant portion of the marketing mix.  With any significant expense, your marketing team will be asked to display a return on investment.  Additionally, to help manage the spend, marketers want to compare keyword and ad display with success metrics and revenue results.

 

 


Solution

Keyword Capture Program - Setup Process

The Marketo - Google AdWords integration provides deep insights into revenue generated by keyword and can help marketing teams get a much more granular view of revenue results than they would otherwise have without Marketo. Google AdWords spend can be tracked as its own Program Channel and leveraged within the Program Analyzer to make detailed assessments of performance. It provides very granular insight into performance through multiple dimensions and unique reports. Initial setup of Keyword tracking programs is straight-forward and simple to duplicate for each new Keyword.

In addition, Marketo automatically connects to Google AdWords to report Customer-specific funnel conversion information by keyword and display ad.

 

Template Program Setup:

  1. Add a field named PPC Source to the Lead Database – set field to write only if empty.
  2. Setup a Default AdWords Program in Marketo that contains a Keyword Token – this program will be cloned for future AdWords so that the steps below do not have to be repeated.
  3. Create a Program Token for Keyword.
  4. Configure the Smart List to Look for PPC Source containing the Keyword Token.
  5. Set the default flow to Update the Program Stages based on Activity
    • Clicked AdWord (Default)
    • Visited Site
    • Filled Out Form
    • Has Opportunity
  6. Set up a Smart Campaign within the Program to look for Closed/Won Opportunities and Activate the Campaign

 

 

 

Cloning Process:

Once the Default AdWords Program is setup it will only take a few minutes to add new PPC AdWords to Marketo.

  1. Clone the default AdWords Program.
  2. Update the Token to include the new PPC Keyword.
  3. Activate the Closed/Won Opportunity Smart Campaign.
  4. Capture Monthly Spend by Keyword Program within Marketo.


Example Reports

Once setup, reporting on Keywords within Marketo is now simple, easy, and more robust than other platforms.  Here are five reports that will help you manage AdWords:

 

A. Basic Keyword – Program Results Report

 

 

B. Basic Keyword - Opportunity Results Report

 

Fields include:

 

Total LeadsCount w/ No OpportunityDays No OpportunityHas Opportunity
Has Opportunity %Days Until OpportunityTotal Opportunity AmountAvg. Opportunity Amount
Total OpportunityWon% WonTotal Won Amount
Days to CloseDays in Sales Stage  

 

 

C. Program Analyzer

 

Program CostCost per New NameCost per SuccessFirst-touch Revenue Expected
Multi-touch Revenue ExpectedMembersNew NamesFirst-touch Pipeline Created
Multi-touch Pipeline CreatedSuccess (New Names)Success (Total)% New Names

 

 

D. RCE - Advanced Reporting on Keywords

 

 

E. Funnel Conversion Data in Google AdWords - By Keyword & Display Ad

 

The information displayed below is passed directly from Marketo into Google AdWords baed on the pre-configured Marketo-to-AdWords connector.  Marketo does not currently pass along any information through the connector beyond what is shown in the screen below (Funnel Conversion Information).

 

 


10 replies

Nina_Gonzalez1
Level 3
January 2, 2018

This is extremely helpful. Any chance you can fix the images in this post. We likely have hundreds of Campaigns, Ad Groups, Ads and Keywords. Perhaps hundreds. Have you used this at that scale?

Bailly_Coons
Level 1
January 2, 2018

Images corrected in this post would be extremely helpful. Great information though!

Adam_Glasser1
Level 2
January 2, 2018

Hi Nina,
I have updated this post with the correct images, my apologies. I have seen one customer try this with hundreds of keywords, and it became a little complicated. I will DM you my email address in case you would like to discuss specifics.

Adam_Glasser1
Level 2
January 2, 2018

Hi Bailly,

I have updated this post with the correct images, my apologies.

Nina_Gonzalez1
Level 3
March 19, 2018

We are not getting keyword attribute in Marketo. Any idea why and how to fix it?

After creating the token, what do you do with it? Does it get added to the AdWord campaign.

Adam_Glasser1
Level 2
March 20, 2018

Hi Nina,


After you create your token, you will modify it in your cloned programs. You can see further details under the "cloning process" header above.

As for the first issue, I would suggest that you create a support ticket so that a TSE can help you resolve this.

Best,
Adam

Emily_Best
Level 1
September 28, 2018

What is the recommended approach if you have too many keywords to manually clone programs? I have almost 1500 keywords.

Thanks,

Emily

October 26, 2018

Hey Emily,

There is no way to accomplish this through the GUI. A brief skim of the developer's documentation makes me think it could be accomplished if you have access to crafty developers. http://developers.marketo.com/rest-api/assets/programs/

You can group long tail keywords together using "contains" operator. I created smart lists that look for groups of keywords "families" and reference them in my smart campaign, but someone is going to have to hand bomb your keywords in to do that.

Madeline_Trott1
Level 2
January 22, 2019

Can someone help me understand how you are getting leads to flow through these smart campaigns if Adwords does not send actual lead data to Marketo? Is it anonymous activity that is recorded in Marketo?


And how are you populating the PPC Source field?

Ashley_Bland
Level 2
December 20, 2019

Hi @Madeline Trotter‌, did you ever get clarification on this? I am wondering if this method has to have the Google Ads Launchpoint integration...