{"id":934,"date":"2022-04-07T13:02:24","date_gmt":"2022-04-07T07:32:24","guid":{"rendered":"https:\/\/easyinsights.ai\/?p=934"},"modified":"2025-04-16T17:24:39","modified_gmt":"2025-04-16T11:54:39","slug":"steps-to-stitch-e-commerce-data-on-google-sheet","status":"publish","type":"post","link":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/","title":{"rendered":"A Complete Guide to Stitch E-Commerce Data on Google Sheet"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading Time: <\/span> <span class=\"rt-time\"> 6<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span>\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png\" alt=\"\"\/><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>What is Data Stitching?<\/strong><\/h1>\n\n\n\n<p>Today, data is the nucleus of all business decisions. Deriving meaningful information, insights from varied data sets help a business take actions based on concrete know-how about their customers.<\/p>\n\n\n\n<p>In a digital world, your customers are everywhere and so is the data trail. Data stitching is the process of bringing data from different platforms, devices, and sources to a commonplace. The e-commerce data thus can be consolidated into a uniform template for easy consumption and analysis.<\/p>\n\n\n\n<p><a href=\"https:\/\/easyinsights.ai\/blog\/data-stitching-explained-3-powerful-use-cases-of-stitching-data-at-the-user-level\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">Click here<\/span><\/strong><\/a> to learn about &#8220;Data Stitching Explained: 3 Powerful Use Cases of Stitching Data at the User-Level&#8221;.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2023\/09\/VJrhCT0fYmrw4NTm-qL5TfG6V5pX-3GDlPq8A-nJuHeS4OA9W3Kj3SHky673fmLqzbynNFwrYTZOS6ZG3yiUkTSpRNziTDwm2uFki5ohbTM9enTxx-S5ceD0pMO5RweWBwbsyKm7.png\" alt=\"ETL - Extraction, Collection, Transformation and Load of Data using EasyInsights\"\/><figcaption><em>Grouping and cleaning data from multiple data source<\/em>s<\/figcaption><\/figure><\/div>\n\n\n\n<p>Data stitching helps marketing teams understand their customers\u2019 persona, needs and engagement patterns better. With these tools, marketers can design meaningful campaigns based on solid insights and not just assumptions or theories.<\/p>\n\n\n\n<p>Data stitching saves time and effort in combing through multiple data sets that lead to half-baked conclusions and ineffective marketing strategies.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Jump ahead to:<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Multiple_data_sources_can_be_stitched_on_common_columns\" >Multiple data sources can be stitched on common columns<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Method_1_%E2%80%93_Let_us_look_at_steps_to_Get_Raw_Data_from_the_individual_analytics_panels\" >Method 1 &#8211; Let us look at steps to Get Raw Data from the individual analytics panels:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#_Phase_11_%E2%80%93_Fetching_Raw_data_from_Facebook_Ads_panel\" >&nbsp;Phase 1.1 \u2013 Fetching Raw data from Facebook Ads panel.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Phase_12_%E2%80%93_Fetching_Raw_data_from_Google_Ads_panel\" >Phase 1.2 \u2013 Fetching Raw data from Google Ads panel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Phase_13_%E2%80%93_Getting_Raw_data_from_Shopify_panel\" >Phase 1.3 \u2013 Getting Raw data from Shopify panel&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Phase_2_%E2%80%93_How_to_Clean_and_Group_data\" >Phase 2 \u2013 How to Clean and Group data&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Phase_3_%E2%80%93_Stitch_data_on_a_common_column\" >Phase 3 &#8211; Stitch data on a common column&nbsp;<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Method_2_%E2%80%93_Google_sheet_add-on\" >Method 2 &#8211; Google sheet add-on<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#_Phase_1_%E2%80%93_Create_cross-platform_dimension\" >&nbsp;Phase 1 &#8211; Create cross-platform dimension<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Phase_2_%E2%80%93_Include_all_the_base_metrics\" >Phase 2 &#8211; Include all the base metrics&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"#\" data-href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#Phase_3_%E2%80%93_Getting_the_final_report_view\" >Phase 3 &#8211; Getting the final report view<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Multiple_data_sources_can_be_stitched_on_common_columns\"><\/span><strong>Multiple data sources can be stitched on common columns<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are two ways to do the same.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Method_1_%E2%80%93_Let_us_look_at_steps_to_Get_Raw_Data_from_the_individual_analytics_panels\"><\/span><strong>Method 1 &#8211; <\/strong>Let us look at steps to Get Raw Data from the individual analytics panels:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Step 1:<\/strong> First map the desired column with available e-commerce data sources, for example:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-1024x783.png\" alt=\"Raw Data from the individual analytics panels\" class=\"wp-image-936\" width=\"768\" height=\"587\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-1024x783.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-300x229.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-768x587.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-667x510.png 667w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-245x187.png 245w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-372x284.png 372w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-510x390.png 510w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-444x339.png 444w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-204x156.png 204w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-311x238.png 311w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-428x327.png 428w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-348x266.png 348w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-523x400.png 523w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-406x310.png 406w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-302x231.png 302w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-260x199.png 260w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-267x205.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-195x149.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-345x264.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-50x38.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM-60x46.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.04.46-AM.png 1374w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><figcaption><em>Representation of the base &amp; derived columns mapped to data sources.<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"_Phase_11_%E2%80%93_Fetching_Raw_data_from_Facebook_Ads_panel\"><\/span><strong>&nbsp;<\/strong><strong>Phase 1.1 \u2013 Fetching Raw data from Facebook Ads panel.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 2:<\/strong> Open Reports \u2192 Create a custom report.&nbsp;<\/li><li><strong>Step 3:<\/strong> Select Campaign name and Amount Spent from the data panel.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"540\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-1024x540.png\" alt=\"Fetching Raw data from Facebook Ads panel.\" class=\"wp-image-937\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-1024x540.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-300x158.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-768x405.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-940x495.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-345x182.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-525x277.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-720x379.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-626x330.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-296x156.png 296w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-452x238.png 452w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-621x327.png 621w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-505x266.png 505w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-759x400.png 759w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-455x240.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-340x179.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-293x154.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-267x141.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-195x103.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-50x26.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM-60x32.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.26-AM.png 1374w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Custom column selection interface &#8211; Facebook Ads manage<\/em>r<\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 4 <\/strong> Select the date range.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"504\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-1024x504.png\" alt=\"Select the date range in the Facebook platform interface\" class=\"wp-image-938\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-1024x504.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-300x148.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-768x378.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-940x463.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-345x170.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-525x258.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-720x354.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-626x308.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-317x156.png 317w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-484x238.png 484w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-664x327.png 664w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-541x266.png 541w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-813x400.png 813w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-455x224.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-340x167.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-293x144.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-267x131.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-195x96.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-50x25.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM-60x30.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.10.50-AM.png 1394w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Selecting the date range from Facebook Ads manager panel<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 5:<\/strong> Export as a .xls file.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"419\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-1024x419.png\" alt=\"Exporting data from the Facebook platform\" class=\"wp-image-939\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-1024x419.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-300x123.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-768x315.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-940x385.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-345x141.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-525x215.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-720x295.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-626x256.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-586x240.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-880x360.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-455x186.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-340x139.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-293x120.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-267x109.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-195x80.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-50x20.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM-60x25.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.11.04-AM.png 1338w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Selecting the download format from Facebook Ads manager panel<\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 6:<\/strong> Keep the downloaded raw data in a separate Google sheet tab.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"681\" height=\"800\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel.png\" alt=\"downloaded raw data in a separate Google sheet tab\" class=\"wp-image-940\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel.png 681w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-255x300.png 255w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-434x510.png 434w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-159x187.png 159w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-242x284.png 242w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-332x390.png 332w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-289x339.png 289w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-133x156.png 133w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-203x238.png 203w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-278x327.png 278w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-226x266.png 226w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-341x400.png 341w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-264x310.png 264w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-197x231.png 197w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-169x199.png 169w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-175x205.png 175w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-127x149.png 127w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-225x264.png 225w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-43x50.png 43w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-adsFull_raw-data_data-panel-51x60.png 51w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><figcaption><em>Seperate tab for Facebook Ads raw data<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Phase_12_%E2%80%93_Fetching_Raw_data_from_Google_Ads_panel\"><\/span><strong>Phase 1.2 \u2013 Fetching Raw data from Google Ads panel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 7:<\/strong> Open Report \u2192 Predefined reports \u2192 Basic \u2192 Campaign.<\/li><li><strong>Step 8:<\/strong> You may unselect irrelevant columns while keeping <strong>Campaign<\/strong> and <strong>Cost<\/strong> columns from the interface.<\/li><li><strong>Step 9:<\/strong> Select the date range.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"500\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-1024x500.png\" alt=\"Fetching Raw data from Google Ads panel\" class=\"wp-image-941\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-1024x500.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-300x146.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-768x375.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-940x459.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-345x168.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-525x256.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-720x351.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-626x306.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-320x156.png 320w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-488x238.png 488w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-670x327.png 670w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-545x266.png 545w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-819x400.png 819w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-455x222.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-340x166.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-293x143.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-267x130.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-195x95.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-50x24.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel-60x29.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_blurred-and-highlighted_data-panel.png 1223w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Google Ads reporting panel &#8211; Column and date selectio<\/em>n<\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 10:<\/strong> Download data to Google sheets and keep it in the second tab.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"929\" height=\"680\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets.png\" alt=\"Download data to Google sheets from Google ads\" class=\"wp-image-942\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets.png 929w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-300x220.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-768x562.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-697x510.png 697w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-255x187.png 255w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-388x284.png 388w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-533x390.png 533w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-463x339.png 463w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-213x156.png 213w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-325x238.png 325w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-447x327.png 447w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-363x266.png 363w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-546x400.png 546w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-424x310.png 424w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-316x231.png 316w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-272x199.png 272w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-267x195.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-195x143.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-345x253.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-50x37.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/GAds_Download-to-Google-sheets-60x44.png 60w\" sizes=\"(max-width: 929px) 100vw, 929px\" \/><figcaption><em>Google Ads reporting panel &#8211; Download to Google Sheet<\/em>s<\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"889\" height=\"641\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab.png\" alt=\"Downloaded Google Ads raw data in a separate sheet\" class=\"wp-image-943\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab.png 889w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-300x216.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-768x554.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-707x510.png 707w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-259x187.png 259w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-394x284.png 394w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-541x390.png 541w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-470x339.png 470w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-216x156.png 216w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-330x238.png 330w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-454x327.png 454w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-369x266.png 369w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-555x400.png 555w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-430x310.png 430w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-320x231.png 320w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-276x199.png 276w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-267x193.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-195x141.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-345x249.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-50x36.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Google-Ads-downloaded-data_2nd-tab-60x43.png 60w\" sizes=\"(max-width: 889px) 100vw, 889px\" \/><figcaption><em>Downloaded Google Ads raw data in a separate sheet<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Phase_13_%E2%80%93_Getting_Raw_data_from_Shopify_panel\"><\/span><strong>Phase 1.3 \u2013 Getting Raw data from Shopify panel&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 11:<\/strong> From the reports interface, select the following columns: UTM Campaign name, Orders, Total Sales, Returns.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"622\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-1024x622.png\" alt=\"Selecting the columns from Shopify panel\" class=\"wp-image-944\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-1024x622.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-300x182.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-768x467.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-839x510.png 839w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-308x187.png 308w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-467x284.png 467w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-642x390.png 642w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-558x339.png 558w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-257x156.png 257w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-392x238.png 392w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-538x327.png 538w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-438x266.png 438w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-658x400.png 658w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-455x276.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-340x207.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-293x178.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-267x162.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-195x118.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-345x210.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-50x30.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface-60x36.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_edit-columns-interface.png 1516w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Selecting the columns from Shopify panel<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 12:<\/strong> Select the date range.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-1024x576.png\" alt=\"Shopify Custom report interface desired columns 1\" class=\"wp-image-946\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-1024x576.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-300x169.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-768x432.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-1536x864.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-907x510.png 907w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-332x187.png 332w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-505x284.png 505w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-693x390.png 693w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-603x339.png 603w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-277x156.png 277w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-423x238.png 423w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-581x327.png 581w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-473x266.png 473w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-711x400.png 711w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-455x256.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-340x191.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-293x165.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-267x150.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-195x110.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-345x194.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-50x28.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1-60x34.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_Custom-report-interface-desired-columns-1.png 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 13:<\/strong> Export as .xls file and keep the data on the third tab of the Google sheet.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"436\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-1024x436.png\" alt=\"Selecting the download format from Shopify panel\" class=\"wp-image-947\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-1024x436.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-300x128.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-768x327.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-1536x655.png 1536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-940x401.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-345x147.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-525x224.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-720x307.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-626x267.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-586x250.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-880x375.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-455x194.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-340x145.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-293x125.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-267x114.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-195x83.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-50x21.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab-60x26.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Shopify_export-data-tab.png 1814w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Selecting the download format from Shopify panel<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"625\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-1024x625.png\" alt=\"Downloaded Shopify raw data in the third sheet\" class=\"wp-image-948\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-1024x625.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-300x183.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-768x469.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-835x510.png 835w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-306x187.png 306w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-465x284.png 465w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-639x390.png 639w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-555x339.png 555w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-255x156.png 255w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-390x238.png 390w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-536x327.png 536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-436x266.png 436w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-655x400.png 655w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-455x278.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-340x208.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-293x179.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-267x163.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-195x119.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-345x211.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-50x31.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM-60x37.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.39.34-AM.png 1320w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Downloaded Shopify raw data in the third sheet<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Phase_2_%E2%80%93_How_to_Clean_and_Group_data\"><\/span><strong>Phase 2 \u2013 How to Clean and Group data&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 14:<\/strong> <strong>Acquisitions<\/strong> mean when the column Customer type = first-time. So to get <strong>#Acquisitions<\/strong> column:<br>&#8211; for <strong>First-time <\/strong>customers in <strong>customer_type<\/strong>, Acquisition value = <strong>#Orders<\/strong>, and <br>&#8211; for <strong>Returning<\/strong> customers in <strong>customer_type<\/strong>, Acquisition value = <strong>Zero.<\/strong><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"456\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-1024x456.png\" alt=\"Shopify data cleaning\" class=\"wp-image-949\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-1024x456.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-300x134.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-768x342.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-940x419.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-345x154.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-525x234.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-720x321.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-626x279.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-586x261.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-880x392.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-455x203.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-340x152.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-293x131.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-267x119.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-195x87.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-50x22.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM-60x27.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.46.32-AM.png 1342w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Shopify data cleaning<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 15:<\/strong> Group the data for Acquisitions, Orders, Net Sales and Returns on the basis of <strong>utm_campaign name + utm campaign source<\/strong> using ()PIVOT<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-1024x543.png\" alt=\"Group Shopify cleaned data using PIVOT table\" class=\"wp-image-951\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-1024x543.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-300x159.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-768x407.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-940x499.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-345x183.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-525x279.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-720x382.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-626x332.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-294x156.png 294w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-449x238.png 449w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-616x327.png 616w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-501x266.png 501w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-754x400.png 754w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-455x241.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-340x180.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-293x155.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-267x142.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-195x103.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-50x27.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM-60x32.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.50.05-AM.png 1376w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Group Shopify cleaned data using PIVOT table<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"473\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-1024x473.png\" alt=\"Shopify final sheet ready for stitching\" class=\"wp-image-952\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-1024x473.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-300x138.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-768x354.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-940x434.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-345x159.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-525x242.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-720x332.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-626x289.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-338x156.png 338w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-516x238.png 516w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-709x327.png 709w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-576x266.png 576w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-867x400.png 867w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-455x210.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-340x157.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-293x135.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-267x123.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-195x90.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-50x23.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM-60x28.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.51.08-AM.png 1374w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>Shopify final sheet ready for stitching<\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Phase_3_%E2%80%93_Stitch_data_on_a_common_column\"><\/span><strong>Phase 3 &#8211; Stitch data on a common column&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>We need to stitch the data on the common column &#8211; <strong>Campaign<\/strong>. To understand data stitching further, please refer to this <a href=\"https:\/\/easyinsights.ai\/blog\/data-stitching-explained-3-powerful-use-cases-of-stitching-data-at-the-user-level\/\">article<\/a>.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 16:<\/strong> Append <strong>Facebook Ads<\/strong> and <strong>Google Ads<\/strong> data.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"810\" height=\"410\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data.png\" alt=\"Append Facebook Ads and Google Ads data\" class=\"wp-image-953\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data.png 810w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-300x152.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-768x389.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-345x175.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-525x266.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-720x364.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-626x317.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-308x156.png 308w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-470x238.png 470w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-646x327.png 646w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-526x266.png 526w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-790x400.png 790w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-455x230.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-340x172.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-293x148.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-267x135.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-195x99.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-50x25.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Facebook-and-Google-Ads-appended-data-60x30.png 60w\" sizes=\"(max-width: 810px) 100vw, 810px\" \/><figcaption><em>Append Facebook Ads and Google Ads data<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p>The \u2018stitch data\u2019 tab is where you put the last piece of the puzzle. When you\u2019re done enriching and transforming the data, you can present them in a separate tab where it\u2019s easier to monitor.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 17:<\/strong> Copy <strong>Shopify final data<\/strong> and use ()<strong>VLOOKUP<\/strong> to perform data stitching<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"475\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-1024x475.png\" alt=\"Final step of data stitching using VLOOKUP function\" class=\"wp-image-954\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-1024x475.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-300x139.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-768x356.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-940x436.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-345x160.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-525x244.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-720x334.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-626x291.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-336x156.png 336w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-513x238.png 513w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-705x327.png 705w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-573x266.png 573w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-862x400.png 862w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-455x211.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-340x158.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-293x136.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-267x124.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-195x91.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-50x23.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1-60x28.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Stitched-data-using-Vlookup_Report1.png 1435w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Final step of data stitching using VLOOKUP function<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Method_2_%E2%80%93_Google_sheet_add-on\"><\/span><strong>Method 2 &#8211; Google sheet add-on<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Create a new dimension &#8220;All campaigns&#8221; for Facebook Ads.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 1:<\/strong> Launch EasyInsights Extension.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"381\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-1024x381.png\" alt=\"Launching EasyInsights from Google sheets add-ons\" class=\"wp-image-955\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-1024x381.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-300x111.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-768x285.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-940x349.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-345x128.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-525x195.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-720x268.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-626x233.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-586x218.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-880x327.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-455x169.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-340x126.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-293x109.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-267x99.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-195x72.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-50x19.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM-60x22.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.56.11-AM.png 1340w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Launching EasyInsights from Google sheets add-ons<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"_Phase_1_%E2%80%93_Create_cross-platform_dimension\"><\/span><strong>&nbsp;Phase 1 &#8211; Create cross-platform dimension<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>&nbsp;We need the common dimension &#8220;<strong>All campaigns<\/strong> &#8221; to join <strong>3 data sources.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 2:<\/strong> Create a new dimension &#8220;All campaigns &#8221; for Facebook Ads with the base dimension as &#8220;Campaign &#8221; without any mapping.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"846\" height=\"616\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM.png\" alt=\"Create a new dimension &quot;All campaigns&quot; for Facebook Ads\" class=\"wp-image-957\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM.png 846w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-300x218.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-768x559.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-700x510.png 700w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-257x187.png 257w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-390x284.png 390w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-536x390.png 536w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-466x339.png 466w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-214x156.png 214w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-327x238.png 327w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-449x327.png 449w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-365x266.png 365w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-549x400.png 549w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-426x310.png 426w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-317x231.png 317w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-273x199.png 273w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-267x194.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-195x142.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-345x251.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-50x36.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-11.58.27-AM-60x44.png 60w\" sizes=\"(max-width: 846px) 100vw, 846px\" \/><figcaption><em>Create a new dimension &#8220;All campaigns&#8221; for Facebook Ads<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 3:<\/strong> Add <strong>Google Ads account <\/strong>and <strong>Shopify account<\/strong> to the &#8220;All campaigns &#8221; dimension with the base dimension as &#8220;Campaign &#8221; without any mapping.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"389\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-1024x389.png\" alt=\"Adding Google Ads account and Shopify account to to dimension &quot;All campaigns&quot; dimension\" class=\"wp-image-959\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-1024x389.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-300x114.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-768x292.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-940x357.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-345x131.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-525x199.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-720x273.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-626x238.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-586x223.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-880x334.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-455x173.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-340x129.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-293x111.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-267x101.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-195x74.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-50x19.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM-60x23.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.01.11-PM.png 1364w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Adding Google Ads account and Shopify account to to dimension &#8220;All campaigns&#8221; dimension<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Now, &#8220;All campaigns &#8221; have been successfully created as the common dimension, i.e. the cross-platform dimension across Facebook Ads, Google Ads and Shopify.&nbsp;<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"704\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM.png\" alt=\"&quot;All campaigns&quot; as the cross-platform dimension\" class=\"wp-image-961\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM.png 938w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-300x225.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-768x576.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-680x510.png 680w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-249x187.png 249w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-378x284.png 378w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-520x390.png 520w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-452x339.png 452w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-208x156.png 208w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-317x238.png 317w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-436x327.png 436w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-354x266.png 354w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-533x400.png 533w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-413x310.png 413w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-308x231.png 308w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-265x199.png 265w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-267x200.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-195x146.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-345x259.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-50x38.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.23.33-PM-60x45.png 60w\" sizes=\"(max-width: 938px) 100vw, 938px\" \/><figcaption><em>&#8220;All campaigns&#8221; as the cross-platform dimension<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Phase_2_%E2%80%93_Include_all_the_base_metrics\"><\/span><strong>Phase 2 &#8211; Include all the base metrics&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 5:<\/strong> Go to Analytic metrics from the hamburger menu and define the first analytic metric &#8220;<strong>Acquisitions<\/strong> &#8221; as &#8220;Orders &#8221; when (in Filter) Customer type = first-time. Similarly define other metrics, <strong>Total Sales<\/strong> and <strong>Returns<\/strong> as the same without any filter.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"658\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-1024x658.png\" alt=\"Interface to define cross platform Analytics metrics\n\" class=\"wp-image-962\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-1024x658.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-300x193.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-768x494.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-793x510.png 793w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-291x187.png 291w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-442x284.png 442w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-607x390.png 607w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-527x339.png 527w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-243x156.png 243w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-370x238.png 370w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-509x327.png 509w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-414x266.png 414w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-622x400.png 622w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-455x293.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-340x219.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-293x188.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-267x172.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-195x125.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-345x222.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-50x32.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM-60x39.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.25.38-PM.png 1204w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Interface to define cross platform <\/em><strong><em>Analytics metrics<br><\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Phase_3_%E2%80%93_Getting_the_final_report_view\"><\/span><strong>Phase 3 &#8211; Getting the final report view<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 6:<\/strong> Move to Cross-platform section then choose &#8220;All Datasources&#8221; and select these columns: All Campaigns, Spend, Acquisitions, Total Sales and Returns.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"998\" height=\"790\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1.png\" alt=\"Columns in the EasyInsights dropdown\" class=\"wp-image-964\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1.png 998w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-300x237.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-768x608.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-644x510.png 644w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-236x187.png 236w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-359x284.png 359w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-493x390.png 493w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-428x339.png 428w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-197x156.png 197w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-301x238.png 301w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-413x327.png 413w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-336x266.png 336w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-505x400.png 505w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-392x310.png 392w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-292x231.png 292w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-251x199.png 251w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-259x205.png 259w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-188x149.png 188w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-334x264.png 334w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-50x40.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.28.54-PM-1-60x47.png 60w\" sizes=\"(max-width: 998px) 100vw, 998px\" \/><figcaption><em>Columns in the dropdown<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Step 7:<\/strong> Create derived columns on the sheet as: Revenue = Total Sales &#8211; Returns. ROAS = Revenue\/Spend, CAC = Acquisitions\/Spend.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"464\" src=\"https:\/\/easyinsights.ai\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-1024x464.png\" alt=\"Cross-platform full funnel e-commerce report using EasyInsights\" class=\"wp-image-965\" srcset=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-1024x464.png 1024w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-300x136.png 300w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-768x348.png 768w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-940x426.png 940w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-345x156.png 345w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-525x238.png 525w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-720x327.png 720w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-626x284.png 626w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-586x266.png 586w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-880x400.png 880w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-455x206.png 455w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-340x154.png 340w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-293x133.png 293w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-267x121.png 267w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-195x88.png 195w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-50x23.png 50w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM-60x27.png 60w, https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/Screenshot-2022-04-07-at-12.31.22-PM.png 1376w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><em>Cross-platform full funnel e-commerce report<\/em><\/figcaption><\/figure><\/div>\n\n\n\n<p>EasyInsights does the stitching automatically once the cross-platform common dimension is defined.<\/p>\n\n\n\n<p>As you can see above, with the EasyInsights add-on, you can complete e-commerce data stitching onto Google sheets in 7 simple steps instead of 17 in the manual method. <a href=\"https:\/\/easyinsights.ai\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">Click here<\/span><\/strong><\/a> to know more about EasyInsights Data Integration.<\/p>\n\n\n\n<p>Wanna try EasyInsights? <a href=\"https:\/\/easyinsights.ai\/book-demo\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong><span style=\"text-decoration: underline;\">Request a free demo.<\/span><\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data stitching helps marketing teams understand their customers\u2019 persona, needs and engagement patterns better. With these tools, marketers can design meaningful campaigns based on solid insights and not just assumptions or theories.<\/p>\n","protected":false},"author":6,"featured_media":935,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[19,142,11],"tags":[148,176,95],"class_list":["post-934","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-digital-analytics","category-e-commerce","category-marketing","tag-e-commerce","tag-google-sheets","tag-marketing-reports"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.3.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Best Way to Stitch E-Commerce Data on GSheets - EasyInsights<\/title>\n<meta name=\"description\" content=\"Data Stitching helps marketers derive consolidated actionable insights from e-commerce data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Best Way to Stitch E-Commerce Data on GSheets - EasyInsights\" \/>\n<meta property=\"og:description\" content=\"Data Stitching helps marketers derive consolidated actionable insights from e-commerce data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"EasyInsights\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-07T07:32:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-16T11:54:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1443\" \/>\n\t<meta property=\"og:image:height\" content=\"890\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Piyush Gupta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@easy_insights\" \/>\n<meta name=\"twitter:site\" content=\"@easy_insights\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Piyush Gupta\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/\"},\"author\":{\"name\":\"Piyush Gupta\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4\"},\"headline\":\"A Complete Guide to Stitch E-Commerce Data on Google Sheet\",\"datePublished\":\"2022-04-07T07:32:24+00:00\",\"dateModified\":\"2025-04-16T11:54:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/\"},\"wordCount\":935,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png\",\"keywords\":[\"e-commerce\",\"Google Sheets\",\"marketing reports\"],\"articleSection\":[\"Digital Analytics\",\"E-Commerce\",\"Marketing\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/\",\"url\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/\",\"name\":\"The Best Way to Stitch E-Commerce Data on GSheets - EasyInsights\",\"isPartOf\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png\",\"datePublished\":\"2022-04-07T07:32:24+00:00\",\"dateModified\":\"2025-04-16T11:54:39+00:00\",\"description\":\"Data Stitching helps marketers derive consolidated actionable insights from e-commerce data.\",\"breadcrumb\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#primaryimage\",\"url\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png\",\"contentUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png\",\"width\":1443,\"height\":890,\"caption\":\"slider banner\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/easyinsights.ai\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A Complete Guide to Stitch E-Commerce Data on Google Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#website\",\"url\":\"https:\/\/easyinsights.ai\/blog\/\",\"name\":\"EasyInsights\",\"description\":\"Uncover Growth in Digital Marketing Data\",\"publisher\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/easyinsights.ai\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#organization\",\"name\":\"Easyinsights\",\"url\":\"https:\/\/easyinsights.ai\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png\",\"contentUrl\":\"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png\",\"width\":649,\"height\":117,\"caption\":\"Easyinsights\"},\"image\":{\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809\",\"https:\/\/x.com\/easy_insights\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4\",\"name\":\"Piyush Gupta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g\",\"caption\":\"Piyush Gupta\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Best Way to Stitch E-Commerce Data on GSheets - EasyInsights","description":"Data Stitching helps marketers derive consolidated actionable insights from e-commerce data.","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:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/","og_locale":"en_US","og_type":"article","og_title":"The Best Way to Stitch E-Commerce Data on GSheets - EasyInsights","og_description":"Data Stitching helps marketers derive consolidated actionable insights from e-commerce data.","og_url":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/","og_site_name":"EasyInsights","article_publisher":"https:\/\/www.facebook.com\/EasyInsightsai-522100504893809","article_published_time":"2022-04-07T07:32:24+00:00","article_modified_time":"2025-04-16T11:54:39+00:00","og_image":[{"width":1443,"height":890,"url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png","type":"image\/png"}],"author":"Piyush Gupta","twitter_card":"summary_large_image","twitter_creator":"@easy_insights","twitter_site":"@easy_insights","twitter_misc":{"Written by":"Piyush Gupta","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#article","isPartOf":{"@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/"},"author":{"name":"Piyush Gupta","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4"},"headline":"A Complete Guide to Stitch E-Commerce Data on Google Sheet","datePublished":"2022-04-07T07:32:24+00:00","dateModified":"2025-04-16T11:54:39+00:00","mainEntityOfPage":{"@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/"},"wordCount":935,"commentCount":0,"publisher":{"@id":"https:\/\/easyinsights.ai\/blog\/#organization"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png","keywords":["e-commerce","Google Sheets","marketing reports"],"articleSection":["Digital Analytics","E-Commerce","Marketing"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/","url":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/","name":"The Best Way to Stitch E-Commerce Data on GSheets - EasyInsights","isPartOf":{"@id":"https:\/\/easyinsights.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#primaryimage"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png","datePublished":"2022-04-07T07:32:24+00:00","dateModified":"2025-04-16T11:54:39+00:00","description":"Data Stitching helps marketers derive consolidated actionable insights from e-commerce data.","breadcrumb":{"@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#primaryimage","url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png","contentUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner.png","width":1443,"height":890,"caption":"slider banner"},{"@type":"BreadcrumbList","@id":"https:\/\/easyinsights.ai\/blog\/steps-to-stitch-e-commerce-data-on-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/easyinsights.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"A Complete Guide to Stitch E-Commerce Data on Google Sheet"}]},{"@type":"WebSite","@id":"https:\/\/easyinsights.ai\/blog\/#website","url":"https:\/\/easyinsights.ai\/blog\/","name":"EasyInsights","description":"Uncover Growth in Digital Marketing Data","publisher":{"@id":"https:\/\/easyinsights.ai\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/easyinsights.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/easyinsights.ai\/blog\/#organization","name":"Easyinsights","url":"https:\/\/easyinsights.ai\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png","contentUrl":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/11\/easyinisghts_logo.png","width":649,"height":117,"caption":"Easyinsights"},"image":{"@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/EasyInsightsai-522100504893809","https:\/\/x.com\/easy_insights"]},{"@type":"Person","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/dd83bf4d1b4aad23688bb459fedf62d4","name":"Piyush Gupta","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/easyinsights.ai\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7ea55084ee665a8e40648a7afe3dcac4?s=96&d=mm&r=g","caption":"Piyush Gupta"}}]}},"fimg_url":"https:\/\/easyinsights.ai\/easyinsights_wordpress\/wp-content\/uploads\/2022\/04\/slider-banner-1024x632.png","reading_time":"5 minutes","_links":{"self":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/934"}],"collection":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/comments?post=934"}],"version-history":[{"count":16,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/934\/revisions"}],"predecessor-version":[{"id":5945,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/posts\/934\/revisions\/5945"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/media\/935"}],"wp:attachment":[{"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/media?parent=934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/categories?post=934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easyinsights.ai\/blog\/wp-json\/wp\/v2\/tags?post=934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}