In a document on Marketo and Google Adwords Overview (https://nation.marketo.com/docs/DOC-1122), it says that all the followingreports are possible in Marketo. However, I'm not sure how to create them.
Anyone has any advice on how to create these reports? Are there any templates available or overview on how to implement them?
Solved! Go to Solution.
Did you check Analytics for these reports? They may be possible with Lead Performance reports and I bet some are not out of the box - you'd have to build it.
Thank you for your answer. All right, I guess I'll find a way to create them based on the campaigns I've created. I'll play around in Analytics
Hi Emmanuelle - Did you have success in building the reports you listed above in Marketo? If so, please share!
Unfortunately, I was not able to create all the reports I listed in my first post, like the top 10 keywords, top 10 campaigns, etc. But I was still able to create a few reports that are helpful.
First, you need to create a smart list to get all your Adwords traffic into one membership list. This is what I created on my end:
Trigger - Visits Web Page
Web Page is any
Querystring contains in (6) ‘gclid’; ‘aclk’; ‘utm_medium=PaidSearch’; ...
Referrer contains ‘google.’
Filter 1 - Is Anonymous
Is Anonymous is true
Filter 2 - initialWebSource
initialWebSource is empty
Step 1 - Change Data Value :
Choice 1: If ‘initialWebSource’ is empty then:Attribute: ‘initialWebSource’
New Value: ‘PaidSearchAdwords’
-- Do Nothing --
Once you have created your smart list campaign, then you will need to create a Program. This is where you will be able to add period costs and get all members (leads).
Finally, create a Program Performance so that you can create your report and see how many members you've gained.
In Analytics, you'll be able to use that smart list to create different reports to see how many leads you gained, the overall cost you've spent on Adwords, etc.
Hope this helps you a bit. I think it would be much easier to create overview reports if you have RCE.
Thanks, Emma! This is helpful!