<\/noscript> <\/p>\nHopefully, these will get integrated into our Google Analytics connector in Google Data Studio one day. But for now, an automated Google Sheets will suffice.<\/p>\n
This is how I set up my Supermetrics query:<\/p>\n
<\/noscript> <\/p>\nSet your date range and date dimensions (under ‘split by rows’) to fit your reporting needs. Additionally, set your ‘conversionGoalNumber’ filter to return data for the goals you want to report on. I have my filter set to equal (not set) to return only transactions. Otherwise, keep everything else that’s included in my configuration.<\/p>\n
Here’s how I modify the sheet when it returns the data:<\/p>\n
<\/noscript> <\/p>\nI add two columns after the ones that are returned to include:<\/p>\n
\nLast Interaction – Assisted Conversions<\/li>\n First Interaction Assisted Conversions<\/li>\n<\/ul>\nI do this to make sure we’re not double-counting conversions as a first interaction and a last interaction. ‘Last Interaction – Assisted Conversions’ returns the difference between ‘First Interaction Conversions’ and ‘Last Interaction Conversions’. Then ‘First Interaction Assisted conversions’ returns the deduped number of first interaction conversions and otherwise returns 0.<\/p>\n
Copy the two formulas all the way down your sheet, past where your query returned data so it’ll calculate as your automatic data pulls populate the now empty cells.<\/p>\n
Lastly, set up your query to run automatically at whatever increments work best for your reporting:<\/p>\n
<\/noscript> <\/p>\n <\/noscript> <\/p>\nI still always do a quick check when the query was supposed to run to make sure the formulas exist for every new row.<\/p>\n
Then, set up your reports in Google Data Studio to look at first interaction assisted conversions alongside your last-click conversions:<\/p>\n
<\/noscript> <\/p>\nOr, report on it directly in your individual channel report slides and determine whether to incorporate it into your ROAS or CPA metrics:<\/p>\n
<\/noscript> <\/p>\nThis data can certainly warrant its own reports entirely or can be formatted to tell different stories.<\/p>\n
Final Thoughts<\/h2>\n Familiarizing yourself with attribution data in Google Analytics and understanding how to analyze assisted conversions will go a long way in helping shed more light on how your customers ultimately come to convert on your site. And while the process outlined in this post is a good place to start, I’d recommend comparing other attribution models and finding the model that properly gives credit to your efforts based on your unique sales cycle and user flow. Then, you can set up your reports accordingly.<\/p>\n<\/body><\/html>\n","protected":false},"excerpt":{"rendered":"
As analysts and stakeholders, we all know the importance of making sure we’re collecting the right data. However, I’ve found that we spend a disproportionate amount of time in data collection than we do in the analysis process. Further, not every business and especially not every marketing effort should be analyzed the same. When it […]<\/p>\n","protected":false},"author":83,"featured_media":53083,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[13],"tags":[625],"coauthors":[],"class_list":["post-53064","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","tag-attribution"],"acf":[],"yoast_head":"\n
Reporting on Assisted Conversions Through Google Analytics - Portent<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n \n \n \n \n \n\t \n\t \n\t \n","yoast_head_json":{"title":"Reporting on Assisted Conversions Through Google Analytics - Portent","description":"Understand the attribution options available in Google Analytics, and learn how to set up automatic reports to analyze assisted conversions through GDS.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm","og_locale":"en_US","og_type":"article","og_title":"Reporting on Assisted Conversions Through Google Analytics - Portent","og_description":"Understand the attribution options available in Google Analytics, and learn how to set up automatic reports to analyze assisted conversions through GDS.","og_url":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm","og_site_name":"Portent","article_publisher":"https:\/\/www.facebook.com\/portent.marketing","article_published_time":"2022-01-07T15:00:59+00:00","article_modified_time":"2022-02-01T00:53:30+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/www.eigene-homepage-erstellen.net\/wp-content\/uploads\/2020\/05\/AttributionModeling.jpg","type":"image\/jpeg"}],"author":"Oeuyown Kim","twitter_card":"summary_large_image","twitter_creator":"@portent","twitter_site":"@portent","twitter_misc":{"Written by":"Oeuyown Kim","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm#article","isPartOf":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm"},"author":{"name":"Oeuyown Kim","@id":"https:\/\/www.eigene-homepage-erstellen.net\/#\/schema\/person\/7036feac56aaad3d8ad0b01d87329d0e"},"headline":"Reporting on Assisted Conversions Through Google Analytics","datePublished":"2022-01-07T15:00:59+00:00","dateModified":"2022-02-01T00:53:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm"},"wordCount":1694,"commentCount":6,"publisher":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/#organization"},"image":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm#primaryimage"},"thumbnailUrl":"https:\/\/eigene-homepage-erstellen.net\/wp-content\/uploads\/2020\/05\/AttributionModeling.jpg","keywords":["attribution"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm","url":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm","name":"Reporting on Assisted Conversions Through Google Analytics - Portent","isPartOf":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm#primaryimage"},"image":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm#primaryimage"},"thumbnailUrl":"https:\/\/eigene-homepage-erstellen.net\/wp-content\/uploads\/2020\/05\/AttributionModeling.jpg","datePublished":"2022-01-07T15:00:59+00:00","dateModified":"2022-02-01T00:53:30+00:00","description":"Understand the attribution options available in Google Analytics, and learn how to set up automatic reports to analyze assisted conversions through GDS.","breadcrumb":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm#primaryimage","url":"https:\/\/eigene-homepage-erstellen.net\/wp-content\/uploads\/2020\/05\/AttributionModeling.jpg","contentUrl":"https:\/\/eigene-homepage-erstellen.net\/wp-content\/uploads\/2020\/05\/AttributionModeling.jpg","width":1024,"height":1024,"caption":"\"\""},{"@type":"BreadcrumbList","@id":"https:\/\/www.eigene-homepage-erstellen.net\/blog\/analytics\/reporting-on-assisted-conversions-through-google-analytics.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eigene-homepage-erstellen.net\/"},{"@type":"ListItem","position":2,"name":"Reporting on Assisted Conversions Through Google Analytics"}]},{"@type":"WebSite","@id":"https:\/\/www.eigene-homepage-erstellen.net\/#website","url":"https:\/\/www.eigene-homepage-erstellen.net\/","name":"Portent","description":"Digital Marketing Agency - Seattle, WA","publisher":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.eigene-homepage-erstellen.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.eigene-homepage-erstellen.net\/#organization","name":"Portent","url":"https:\/\/www.eigene-homepage-erstellen.net\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eigene-homepage-erstellen.net\/#\/schema\/logo\/image\/","url":"https:\/\/portent.wpenginepowered.com\/images\/2018\/08\/logo-indigo.svg","contentUrl":"https:\/\/portent.wpenginepowered.com\/images\/2018\/08\/logo-indigo.svg","width":182,"height":40,"caption":"Portent"},"image":{"@id":"https:\/\/www.eigene-homepage-erstellen.net\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/portent.marketing","https:\/\/x.com\/portent","https:\/\/www.linkedin.com\/company\/portent\/"]},{"@type":"Person","@id":"https:\/\/www.eigene-homepage-erstellen.net\/#\/schema\/person\/7036feac56aaad3d8ad0b01d87329d0e","name":"Oeuyown Kim","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.eigene-homepage-erstellen.net\/#\/schema\/person\/image\/08caf2db63ef89a41186fc78706fca1e","url":"https:\/\/secure.gravatar.com\/avatar\/e9709083eacd7af08a91b05641e5c806?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9709083eacd7af08a91b05641e5c806?s=96&d=mm&r=g","caption":"Oeuyown Kim"},"description":"Oeuyown is a senior analytics strategist with a passion for providing outside-the-box solutions to unique data challenges. With a background in SEO, she applies this knowledge to help client teams draw valuable connections between analytics data and actionable optimization strategies. Outside of analytics, Oeuyown practices yoga, attends music and art shows, and has a growing affinity for Seattle's food scene.","sameAs":["https:\/\/www.linkedin.com\/in\/oeuyownkim\/"],"url":"https:\/\/eigene-homepage-erstellen.net\/blog\/author\/okim"}]}},"author_meta":{"display_name":"Oeuyown Kim","author_link":"https:\/\/eigene-homepage-erstellen.net\/blog\/author\/okim"},"featured_img":"https:\/\/eigene-homepage-erstellen.net\/wp-content\/uploads\/2020\/05\/AttributionModeling-300x300.jpg","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/eigene-homepage-erstellen.net\/wp-content\/uploads\/2020\/05\/AttributionModeling.jpg","tax_additional":{"categories":{"linked":["Analytics<\/a>"],"unlinked":["Analytics<\/span>"]},"tags":{"linked":["attribution<\/a>"],"unlinked":["attribution<\/span>"]}},"comment_count":"6","relative_dates":{"created":"Posted 3 years ago","modified":"Updated 3 years ago"},"absolute_dates":{"created":"Posted on January 7, 2022","modified":"Updated on January 31, 2022"},"absolute_dates_time":{"created":"Posted on January 7, 2022 7:00 am","modified":"Updated on January 31, 2022 4:53 pm"},"featured_img_caption":"","series_order":"","category_info":[{"taxonomy":"category","name":"Analytics","slug":"analytics","permalink":"https:\/\/eigene-homepage-erstellen.net\/blog\/analytics","icon":"https:\/\/eigene-homepage-erstellen.net\/wp-content\/uploads\/2021\/10\/analytics-category-icon.png","theme":"analytics"}],"author_info":{"first":"Oeuyown","last":"Kim","url":"https:\/\/eigene-homepage-erstellen.net\/blog\/author\/okim"},"_links":{"self":[{"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/posts\/53064"}],"collection":[{"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/comments?post=53064"}],"version-history":[{"count":0,"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/posts\/53064\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/media\/53083"}],"wp:attachment":[{"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/media?parent=53064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/categories?post=53064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/tags?post=53064"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/eigene-homepage-erstellen.net\/wp-json\/wp\/v2\/coauthors?post=53064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}