Assisted Goal Completions Report In Google Sheets

[James]

Hello

I have created an automated Google sheet which imports data from Google Analytics.

This contains information about each goal type including the search term from PPC which drove that goal, the user's location and the date and time of the lead.

I am currently counting goals on a last click basis in Google Analytics. However I am worried that this is blocking me from seeing whether PPC assisted in a conversion elsewhere in the journey.

For example; a user may see us through PPC but then convert through Organic Search (under-crediting PPC).

I was wondering if it is possible to set up a similar report that can show me the leads that PPC played a part in but were not via the last click?

Any insights or demonstrations would be so helpful!

Many Thanks,

James

[Jørn Reidel]

Hi,

you can query the Multi Channel Funnel API, to replicate the Assisted Conversions GA report (Conversions -> Multi-channel Funnels -> Assisted Conversions):

https://developers.google.com/analytics/devguides/reporting/mcf/dimsmets/

https://developers.google.com/analytics/devguides/reporting/mcf/v3/reference

-Jørn