Opportunity Analysis - Amount Differs between SFDC and MKTO.

Mark_Farnell
Level 5

Opportunity Analysis - Amount Differs between SFDC and MKTO.

I understand that MKTO uses the SFDC "Amount" field for revenue.  I also understand that RCE is a day behind SFDC, so is not always up to date.  What I don't understand is why for a fixed period in the past, why the Amount MKTO reports is different from SFDC.

An example:

I run a report in SFDC on Opportunities Closed Won Feb'13 to Apr'13.  The figure is, for the sake of argument £1,000,000, with say 100 records

I run an Opportunity Analysis report in MKTO with Closed Month = Feb'13 to Apr'13, Closed = Yes, Won = Yes.  The figure is different, in this case LESS, e.g. £800,000 and fewer records, say 80.

When I check each individual month they are all out.

It seems apparent that MKTO is not picking up all the records that exist - how can this happen?  This week, i.e. 2 days ago we updated all our Opportunties to make sure they had Contact Roles.  Does MKTO only include the opportunity after the Contact Role is added, therefore if the opp is already closed when I add the contact role I can't back date any analysis?
4 REPLIES 4
Anonymous
Not applicable

Re: Opportunity Analysis - Amount Differs between SFDC and MKTO.

Hi Mark,

The Opportunity Analysis report should include all opportunities, regardless if there is a contact role or not.

Based on your example, I don't see anything wrong with the set up of the report.  We'd need to look at your data to do further investigation.  Can you please email support@marketo.com with a couple examples of opportunities that are in your SFDC report, but not in Marketo?

TJ
Anonymous
Not applicable

Re: Opportunity Analysis - Amount Differs between SFDC and MKTO.

Hi TJ,

I'm havng the same problem.

When I run the lead report: Leads By Source for any given period the Total Won Amount (Total) does not match the amount in SFDC when I run a report on Oppotunites Won and look at the Amount field.

Thanks
Chris.
Anonymous
Not applicable

Re: Opportunity Analysis - Amount Differs between SFDC and MKTO.

Hi Chris,

We would need to look at your data to troubleshoot this.  Can you please email support@marketo.com?  Thanks.

TJ
Edward_Masson
Level 10

Re: Opportunity Analysis - Amount Differs between SFDC and MKTO.

What was the out come of these use cases?