Skip to main content
KCS_Integration
Level 2
Jan 2, 2018 3:32 PM UTC

Google AdWords and Revenue Tracking through Marketo

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
Jan 2, 2018 3:32 PM UTC

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?

Translate
Bailly_Coons
Level 1
Jan 2, 2018 6:24 PM UTC

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

Translate
Adam_Glasser1
Level 2
Jan 2, 2018 9:10 PM UTC

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.

Translate
Adam_Glasser1
Level 2
Jan 2, 2018 9:10 PM UTC

Hi Bailly,

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

Translate
Nina_Gonzalez1
Level 3
Mar 19, 2018 7:51 PM UTC

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.

Translate
Adam_Glasser1
Level 2
Mar 20, 2018 2:20 PM UTC

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

Translate
Emily_Best
Level 1
Sep 28, 2018 3:05 PM UTC

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

Thanks,

Emily

Translate
Oct 26, 2018 5:46 PM UTC

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.

Translate
Madeline_Trott1
Level 2
Jan 22, 2019 9:53 PM UTC

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?

Translate
Ashley_Bland
Level 2
Dec 20, 2019 4:48 PM UTC

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

Translate