<\/p>\n\n\n\n
The Importance of Saving Your Historical Data<\/strong> <\/h2>\n\n\n\nWhen Google announced the sunsetting of Universal Analytics, the company gave users a year to export historical data after the version stopped collecting new data. Time is almost up with the June 30th deadline nearing\u2014meaning UA will shut down permanently on July 1st, and all its data will be unavailable. <\/p>\n\n\n\n
After the announcement, we recommended<\/a> exporting your historical data housed there so your team can have historical references for strategy development. That\u2019s because comparisons in Google Analytics 4 can only go as far back as its installation\u2014to see past performance growth, improvement opportunities, or to look back at the results of specific tactics, you’ll need the exported UA data. <\/p>\n\n\n\nFor TopSpot partners, we have your monthly reports from the beginning of our partnership, which include the GA data our strategies utilize. However, pending when you began with TopSpot or your business needs, this may not cover all the historical data you need. If you have yet to export, TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations. <\/p>\n\n\n\n
UA Exporting Set Up Steps and Considerations<\/strong> <\/h2>\n\n\n\nWhere to get your UA historical data<\/strong> <\/h3>\n\n\n\nTo get started, we recommend going to https:\/\/analytics.google.com\/analytics\/web\/<\/a>. If you\u2019re a TopSpot Client, go to the “Detailed Keyword Data” view. If not, go to the view that has the most accurate data, keeping in mind any views that help filter out internal and bot traffic. <\/p>\n\n\n\n![\"\"](\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/UAaccess-700x442.png\")
For TopSpot Clients, access UA and go to Detailed Keyword Data.<\/em><\/figcaption><\/figure>\n\n\n\nTimeframes to Consider<\/strong><\/h3>\n\n\n\nYou can adjust your date range at the top right of the tool. TopSpot recommends the last two years aligning to the change from UA to GA4 and the end of UA data collection. However, other considerations include: <\/p>\n\n\n\n
\n- When you launched your website <\/li>\n\n\n\n
- When you started an SEO\/PPC program <\/li>\n\n\n\n
- When you started with a new vendor <\/li>\n\n\n\n
- When GA4 was installed <\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/UAtimeline-700x363.png\")
How to set your data timeline.<\/em><\/figcaption><\/figure>\n\n\n\nSettings to Adjust Before Exporting<\/strong><\/h3>\n\n\n\nWhat you see is what you get in your exported report, so make sure your selections reflect what you are looking to save. Most users opt to use either \u201cUsers\u201d or \u201cSessions\u201d metrics and then select the scope by month, but you can export by day or week for a more granular look. <\/p>\n\n\n\n![\"\"](\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/UAusers-700x268.png\")
How to set your summary metrics.<\/em><\/figcaption><\/figure>\n\n\n\nAdditionally, adjust conversions to \u201cAll Goals\u201d for a total count of conversions versus the source GA defaults to (this source varies per account). You’ll want to see data for all your forms and for E-Commerce users, ensure \u201cTransactions\u201d are included. You can add a secondary dimension if desired. An example of a secondary dimension would be the source country or region. <\/p>\n\n\n\n![\"\"](\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/UAgoals-700x352.png\")
How to set your goals for export.<\/em><\/figcaption><\/figure>\n\n\n\nYou can adjust the rows from 10 to 5000 to see more data pending the size of your site. For large data sets, you may need to export for each additional page in the report. Be sure to set aside ample time for this effort as it may take some experimentation and multiple downloads to gather all the data you need. Overall, think about your key business goals when making selections. <\/p>\n\n\n\n![\"\"](\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/UArows.png\")
How to set rows for exporting.<\/em><\/figcaption><\/figure>\n\n\n\nHow to Export from Universal Analytics<\/strong> <\/h2>\n\n\n\nOnce your report view is set, click the export icon, and then select the file format you\u2019d like your export in. You can choose between four different file types: PDF, Google Sheets, Excel, or CSV. <\/p>\n\n\n\n![\"\"](\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/UAExport.png\")
Selecting file for final export.<\/em> <\/figcaption><\/figure>\n\n\n\nTopSpot\u2019s Recommended Reports to Export<\/strong> <\/h2>\n\n\n\nCovered in our earlier blog<\/a>, TopSpot recommends the following reports be exported from UA for future reference using the set-up instructions above. <\/p>\n\n\n\nGo to Acquisition > All Traffic for the following reports: <\/strong><\/h3>\n\n\n\n\n- Channels<\/span>: Breaks down the sources of your traffic at a broad range and includes paid, direct, organic, and social. <\/li>\n\n\n\n
- Source\/Medium<\/span>: Provides more detail about your traffic sources and includes search engines and social platforms used to find your site. <\/li>\n\n\n\n
- Google Ads<\/span> (if running PPC): Get information on Campaigns, keywords, and search queries \n
\n- Campaigns: Breaks down the performance of each campaign <\/li>\n\n\n\n
- Keywords: Breaks down the performance of keywords <\/li>\n\n\n\n
- Search Queries: Shows which terms entered by users lead to impressions and stopped recording new data in 2022. <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
Go to Conversions > Multi-Channel Funnels, for the following reports: <\/strong> <\/h3>\n\n\n\n\n- Assisted Conversion<\/span>: Shows you what channels are within conversion paths but did not result in the end conversion event. <\/li>\n\n\n\n
- Top Conversion Paths<\/span>: Shows frequently used paths leading to conversion and provides the total and percentage of each. <\/li>\n<\/ul>\n\n\n\n
Go to Behavior > Site Content for the following reports: <\/strong> <\/h3>\n\n\n\n\n- All Pages<\/span>: Reveals pages users visited, listed by URL. <\/li>\n\n\n\n
- Landing Pages<\/span>: Tracks the pages users land on when entering your site. <\/li>\n<\/ul>\n\n\n\n
For other reports under Behavior, we recommend<\/strong>:<\/h3>\n\n\n\n\n- Events > Top Events<\/span>: Shows downloads, click-to-calls, video views, and other actions made on your website. <\/li>\n\n\n\n
- Site Search> Search Terms<\/span>: For those with an internal site search functionality, this tracks the search terms used by visitors to search your site. <\/li>\n<\/ul>\n\n\n\n
For those with E-commerce websites, consider downloading the following reports located under Conversions > E-commerce:<\/strong> <\/h3>\n\n\n\n\n- Transactions<\/span>: Tracks all transactions made on your site. <\/li>\n\n\n\n
- Product Performance<\/span>: Tracks transactions by product. <\/li>\n<\/ul>\n\n\n\n
If you are a TopSpot Client and have questions regarding your historical data, please contact your Account Team for help. If you are not a TopSpot Client and have questions, contact our Team<\/a> for more information about using data and analytics<\/a> and how we can help. <\/p>\n","protected":false},"excerpt":{"rendered":"Haven’t exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations. ","protected":false},"author":61,"featured_media":14383,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[1264,1255],"coauthors":[1314],"acf":[],"cp_meta_data":{"_edit_lock":["1718306629:61"],"_edit_last":["61"],"_yoast_wpseo_primary_category":["13"],"_yoast_wpseo_focuskw":["historical data"],"_yoast_wpseo_metadesc":["Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations."],"_yoast_wpseo_linkdex":["69"],"_yoast_wpseo_content_score":["60"],"_yoast_wpseo_focuskeywords":["[{\"keyword\":\"Google Universal Analytics\",\"score\":49},{\"keyword\":\"Google Analytics\",\"score\":52}]"],"_yoast_wpseo_keywordsynonyms":["[\"UA historical data\",\"UA\",\"GA4\"]"],"_yoast_wpseo_estimated-reading-time-minutes":["6"],"_yoast_wpseo_wordproof_timestamp":[""],"_thumbnail_id":["14383"],"_yoast_indexnow_last_ping":["1711652273"]},"yoast_head":"\nHow to Export Historical Data from Google Universal Analytics\u00a0\u00a0 - TopSpot Internet Marketing<\/title>\n<meta name=\"description\" content=\"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0\" \/>\n<meta property=\"og:description\" content=\"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\" \/>\n<meta property=\"og:site_name\" content=\"TopSpot Internet Marketing\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/topspotims\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-28T17:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T18:57:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1708\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Stefanie Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@topspotims\" \/>\n<meta name=\"twitter:site\" content=\"@topspotims\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stefanie Thompson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\"},\"author\":{\"name\":\"Stefanie Thompson\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/6b0a30f1b645793516d389d0a160029b\"},\"headline\":\"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0\",\"datePublished\":\"2024-03-28T17:07:00+00:00\",\"dateModified\":\"2024-03-28T18:57:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\"},\"wordCount\":989,\"publisher\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\",\"keywords\":[\"analytics\",\"google analytics\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\",\"url\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\",\"name\":\"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0 - TopSpot Internet Marketing\",\"isPartOf\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\",\"datePublished\":\"2024-03-28T17:07:00+00:00\",\"dateModified\":\"2024-03-28T18:57:51+00:00\",\"description\":\"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage\",\"url\":\"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\",\"contentUrl\":\"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\",\"width\":2560,\"height\":1708},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"TopSpot Blog\",\"item\":\"https:\/\/www.topspot.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics\",\"item\":\"https:\/\/www.topspot.com\/blog\/tags\/analytics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#website\",\"url\":\"https:\/\/www.topspot.com\/blog\/\",\"name\":\"TopSpot Internet Marketing\",\"description\":\"Internet Marketing Trends & Articles - Houston Search Marketing News\",\"publisher\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.topspot.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#organization\",\"name\":\"TopSpot Internet Marketing\",\"url\":\"https:\/\/www.topspot.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/06\/TopSpot-Internet-Marketing-OBx.png\",\"contentUrl\":\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/06\/TopSpot-Internet-Marketing-OBx.png\",\"width\":250,\"height\":250,\"caption\":\"TopSpot Internet Marketing\"},\"image\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/topspotims\",\"https:\/\/x.com\/topspotims\",\"https:\/\/www.instagram.com\/topspotims\/\",\"https:\/\/www.linkedin.com\/company\/topspot-internet-marketing\/\",\"https:\/\/www.youtube.com\/user\/gotopspotims\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/6b0a30f1b645793516d389d0a160029b\",\"name\":\"Stefanie Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/image\/23c10346373cfc1d68b79c82fa758558\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a25e3312ccf7b0e7a03afa8045f7500?s=96&r=pg\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a25e3312ccf7b0e7a03afa8045f7500?s=96&r=pg\",\"caption\":\"Stefanie Thompson\"},\"url\":\"https:\/\/www.topspotims.com\/blog\/author\/sthompsontopspot-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0 - TopSpot Internet Marketing","description":"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0","og_description":"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.","og_url":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/","og_site_name":"TopSpot Internet Marketing","article_publisher":"https:\/\/www.facebook.com\/topspotims","article_published_time":"2024-03-28T17:07:00+00:00","article_modified_time":"2024-03-28T18:57:51+00:00","og_image":[{"width":2560,"height":1708,"url":"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","type":"image\/jpeg"}],"author":"Stefanie Thompson","twitter_card":"summary_large_image","twitter_creator":"@topspotims","twitter_site":"@topspotims","twitter_misc":{"Written by":"Stefanie Thompson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#article","isPartOf":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/"},"author":{"name":"Stefanie Thompson","@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/6b0a30f1b645793516d389d0a160029b"},"headline":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0","datePublished":"2024-03-28T17:07:00+00:00","dateModified":"2024-03-28T18:57:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/"},"wordCount":989,"publisher":{"@id":"https:\/\/www.topspot.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","keywords":["analytics","google analytics"],"articleSection":["Analytics"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/","url":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/","name":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0 - TopSpot Internet Marketing","isPartOf":{"@id":"https:\/\/www.topspot.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage"},"image":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","datePublished":"2024-03-28T17:07:00+00:00","dateModified":"2024-03-28T18:57:51+00:00","description":"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.","breadcrumb":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage","url":"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","contentUrl":"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","width":2560,"height":1708},{"@type":"BreadcrumbList","@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"TopSpot Blog","item":"https:\/\/www.topspot.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics","item":"https:\/\/www.topspot.com\/blog\/tags\/analytics\/"},{"@type":"ListItem","position":3,"name":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/www.topspot.com\/blog\/#website","url":"https:\/\/www.topspot.com\/blog\/","name":"TopSpot Internet Marketing","description":"Internet Marketing Trends & Articles - Houston Search Marketing News","publisher":{"@id":"https:\/\/www.topspot.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.topspot.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.topspot.com\/blog\/#organization","name":"TopSpot Internet Marketing","url":"https:\/\/www.topspot.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/06\/TopSpot-Internet-Marketing-OBx.png","contentUrl":"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/06\/TopSpot-Internet-Marketing-OBx.png","width":250,"height":250,"caption":"TopSpot Internet Marketing"},"image":{"@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/topspotims","https:\/\/x.com\/topspotims","https:\/\/www.instagram.com\/topspotims\/","https:\/\/www.linkedin.com\/company\/topspot-internet-marketing\/","https:\/\/www.youtube.com\/user\/gotopspotims"]},{"@type":"Person","@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/6b0a30f1b645793516d389d0a160029b","name":"Stefanie Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/image\/23c10346373cfc1d68b79c82fa758558","url":"https:\/\/secure.gravatar.com\/avatar\/8a25e3312ccf7b0e7a03afa8045f7500?s=96&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a25e3312ccf7b0e7a03afa8045f7500?s=96&r=pg","caption":"Stefanie Thompson"},"url":"https:\/\/www.topspotims.com\/blog\/author\/sthompsontopspot-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/posts\/14367"}],"collection":[{"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/users\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/comments?post=14367"}],"version-history":[{"count":8,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/posts\/14367\/revisions"}],"predecessor-version":[{"id":14385,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/posts\/14367\/revisions\/14385"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/media\/14383"}],"wp:attachment":[{"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/media?parent=14367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/categories?post=14367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/tags?post=14367"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/coauthors?post=14367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
For TopSpot partners, we have your monthly reports from the beginning of our partnership, which include the GA data our strategies utilize. However, pending when you began with TopSpot or your business needs, this may not cover all the historical data you need. If you have yet to export, TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations. <\/p>\n\n\n\n
UA Exporting Set Up Steps and Considerations<\/strong> <\/h2>\n\n\n\nWhere to get your UA historical data<\/strong> <\/h3>\n\n\n\nTo get started, we recommend going to https:\/\/analytics.google.com\/analytics\/web\/<\/a>. If you\u2019re a TopSpot Client, go to the “Detailed Keyword Data” view. If not, go to the view that has the most accurate data, keeping in mind any views that help filter out internal and bot traffic. <\/p>\n\n\n\nFor TopSpot Clients, access UA and go to Detailed Keyword Data.<\/em><\/figcaption><\/figure>\n\n\n\nTimeframes to Consider<\/strong><\/h3>\n\n\n\nYou can adjust your date range at the top right of the tool. TopSpot recommends the last two years aligning to the change from UA to GA4 and the end of UA data collection. However, other considerations include: <\/p>\n\n\n\n
\n- When you launched your website <\/li>\n\n\n\n
- When you started an SEO\/PPC program <\/li>\n\n\n\n
- When you started with a new vendor <\/li>\n\n\n\n
- When GA4 was installed <\/li>\n<\/ul>\n\n\n\n
How to set your data timeline.<\/em><\/figcaption><\/figure>\n\n\n\nSettings to Adjust Before Exporting<\/strong><\/h3>\n\n\n\nWhat you see is what you get in your exported report, so make sure your selections reflect what you are looking to save. Most users opt to use either \u201cUsers\u201d or \u201cSessions\u201d metrics and then select the scope by month, but you can export by day or week for a more granular look. <\/p>\n\n\n\nHow to set your summary metrics.<\/em><\/figcaption><\/figure>\n\n\n\nAdditionally, adjust conversions to \u201cAll Goals\u201d for a total count of conversions versus the source GA defaults to (this source varies per account). You’ll want to see data for all your forms and for E-Commerce users, ensure \u201cTransactions\u201d are included. You can add a secondary dimension if desired. An example of a secondary dimension would be the source country or region. <\/p>\n\n\n\nHow to set your goals for export.<\/em><\/figcaption><\/figure>\n\n\n\nYou can adjust the rows from 10 to 5000 to see more data pending the size of your site. For large data sets, you may need to export for each additional page in the report. Be sure to set aside ample time for this effort as it may take some experimentation and multiple downloads to gather all the data you need. Overall, think about your key business goals when making selections. <\/p>\n\n\n\nHow to set rows for exporting.<\/em><\/figcaption><\/figure>\n\n\n\nHow to Export from Universal Analytics<\/strong> <\/h2>\n\n\n\nOnce your report view is set, click the export icon, and then select the file format you\u2019d like your export in. You can choose between four different file types: PDF, Google Sheets, Excel, or CSV. <\/p>\n\n\n\nSelecting file for final export.<\/em> <\/figcaption><\/figure>\n\n\n\nTopSpot\u2019s Recommended Reports to Export<\/strong> <\/h2>\n\n\n\nCovered in our earlier blog<\/a>, TopSpot recommends the following reports be exported from UA for future reference using the set-up instructions above. <\/p>\n\n\n\nGo to Acquisition > All Traffic for the following reports: <\/strong><\/h3>\n\n\n\n\n- Channels<\/span>: Breaks down the sources of your traffic at a broad range and includes paid, direct, organic, and social. <\/li>\n\n\n\n
- Source\/Medium<\/span>: Provides more detail about your traffic sources and includes search engines and social platforms used to find your site. <\/li>\n\n\n\n
- Google Ads<\/span> (if running PPC): Get information on Campaigns, keywords, and search queries \n
\n- Campaigns: Breaks down the performance of each campaign <\/li>\n\n\n\n
- Keywords: Breaks down the performance of keywords <\/li>\n\n\n\n
- Search Queries: Shows which terms entered by users lead to impressions and stopped recording new data in 2022. <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
Go to Conversions > Multi-Channel Funnels, for the following reports: <\/strong> <\/h3>\n\n\n\n\n- Assisted Conversion<\/span>: Shows you what channels are within conversion paths but did not result in the end conversion event. <\/li>\n\n\n\n
- Top Conversion Paths<\/span>: Shows frequently used paths leading to conversion and provides the total and percentage of each. <\/li>\n<\/ul>\n\n\n\n
Go to Behavior > Site Content for the following reports: <\/strong> <\/h3>\n\n\n\n\n- All Pages<\/span>: Reveals pages users visited, listed by URL. <\/li>\n\n\n\n
- Landing Pages<\/span>: Tracks the pages users land on when entering your site. <\/li>\n<\/ul>\n\n\n\n
For other reports under Behavior, we recommend<\/strong>:<\/h3>\n\n\n\n\n- Events > Top Events<\/span>: Shows downloads, click-to-calls, video views, and other actions made on your website. <\/li>\n\n\n\n
- Site Search> Search Terms<\/span>: For those with an internal site search functionality, this tracks the search terms used by visitors to search your site. <\/li>\n<\/ul>\n\n\n\n
For those with E-commerce websites, consider downloading the following reports located under Conversions > E-commerce:<\/strong> <\/h3>\n\n\n\n\n- Transactions<\/span>: Tracks all transactions made on your site. <\/li>\n\n\n\n
- Product Performance<\/span>: Tracks transactions by product. <\/li>\n<\/ul>\n\n\n\n
If you are a TopSpot Client and have questions regarding your historical data, please contact your Account Team for help. If you are not a TopSpot Client and have questions, contact our Team<\/a> for more information about using data and analytics<\/a> and how we can help. <\/p>\n","protected":false},"excerpt":{"rendered":"Haven’t exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations. ","protected":false},"author":61,"featured_media":14383,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[1264,1255],"coauthors":[1314],"acf":[],"cp_meta_data":{"_edit_lock":["1718306629:61"],"_edit_last":["61"],"_yoast_wpseo_primary_category":["13"],"_yoast_wpseo_focuskw":["historical data"],"_yoast_wpseo_metadesc":["Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations."],"_yoast_wpseo_linkdex":["69"],"_yoast_wpseo_content_score":["60"],"_yoast_wpseo_focuskeywords":["[{\"keyword\":\"Google Universal Analytics\",\"score\":49},{\"keyword\":\"Google Analytics\",\"score\":52}]"],"_yoast_wpseo_keywordsynonyms":["[\"UA historical data\",\"UA\",\"GA4\"]"],"_yoast_wpseo_estimated-reading-time-minutes":["6"],"_yoast_wpseo_wordproof_timestamp":[""],"_thumbnail_id":["14383"],"_yoast_indexnow_last_ping":["1711652273"]},"yoast_head":"\nHow to Export Historical Data from Google Universal Analytics\u00a0\u00a0 - TopSpot Internet Marketing<\/title>\n<meta name=\"description\" content=\"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0\" \/>\n<meta property=\"og:description\" content=\"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\" \/>\n<meta property=\"og:site_name\" content=\"TopSpot Internet Marketing\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/topspotims\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-28T17:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T18:57:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1708\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Stefanie Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@topspotims\" \/>\n<meta name=\"twitter:site\" content=\"@topspotims\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stefanie Thompson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\"},\"author\":{\"name\":\"Stefanie Thompson\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/6b0a30f1b645793516d389d0a160029b\"},\"headline\":\"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0\",\"datePublished\":\"2024-03-28T17:07:00+00:00\",\"dateModified\":\"2024-03-28T18:57:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\"},\"wordCount\":989,\"publisher\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\",\"keywords\":[\"analytics\",\"google analytics\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\",\"url\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\",\"name\":\"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0 - TopSpot Internet Marketing\",\"isPartOf\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\",\"datePublished\":\"2024-03-28T17:07:00+00:00\",\"dateModified\":\"2024-03-28T18:57:51+00:00\",\"description\":\"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage\",\"url\":\"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\",\"contentUrl\":\"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg\",\"width\":2560,\"height\":1708},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"TopSpot Blog\",\"item\":\"https:\/\/www.topspot.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics\",\"item\":\"https:\/\/www.topspot.com\/blog\/tags\/analytics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#website\",\"url\":\"https:\/\/www.topspot.com\/blog\/\",\"name\":\"TopSpot Internet Marketing\",\"description\":\"Internet Marketing Trends & Articles - Houston Search Marketing News\",\"publisher\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.topspot.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#organization\",\"name\":\"TopSpot Internet Marketing\",\"url\":\"https:\/\/www.topspot.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/06\/TopSpot-Internet-Marketing-OBx.png\",\"contentUrl\":\"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/06\/TopSpot-Internet-Marketing-OBx.png\",\"width\":250,\"height\":250,\"caption\":\"TopSpot Internet Marketing\"},\"image\":{\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/topspotims\",\"https:\/\/x.com\/topspotims\",\"https:\/\/www.instagram.com\/topspotims\/\",\"https:\/\/www.linkedin.com\/company\/topspot-internet-marketing\/\",\"https:\/\/www.youtube.com\/user\/gotopspotims\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/6b0a30f1b645793516d389d0a160029b\",\"name\":\"Stefanie Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/image\/23c10346373cfc1d68b79c82fa758558\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a25e3312ccf7b0e7a03afa8045f7500?s=96&r=pg\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a25e3312ccf7b0e7a03afa8045f7500?s=96&r=pg\",\"caption\":\"Stefanie Thompson\"},\"url\":\"https:\/\/www.topspotims.com\/blog\/author\/sthompsontopspot-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0 - TopSpot Internet Marketing","description":"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0","og_description":"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.","og_url":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/","og_site_name":"TopSpot Internet Marketing","article_publisher":"https:\/\/www.facebook.com\/topspotims","article_published_time":"2024-03-28T17:07:00+00:00","article_modified_time":"2024-03-28T18:57:51+00:00","og_image":[{"width":2560,"height":1708,"url":"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","type":"image\/jpeg"}],"author":"Stefanie Thompson","twitter_card":"summary_large_image","twitter_creator":"@topspotims","twitter_site":"@topspotims","twitter_misc":{"Written by":"Stefanie Thompson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#article","isPartOf":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/"},"author":{"name":"Stefanie Thompson","@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/6b0a30f1b645793516d389d0a160029b"},"headline":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0","datePublished":"2024-03-28T17:07:00+00:00","dateModified":"2024-03-28T18:57:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/"},"wordCount":989,"publisher":{"@id":"https:\/\/www.topspot.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","keywords":["analytics","google analytics"],"articleSection":["Analytics"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/","url":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/","name":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0 - TopSpot Internet Marketing","isPartOf":{"@id":"https:\/\/www.topspot.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage"},"image":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","datePublished":"2024-03-28T17:07:00+00:00","dateModified":"2024-03-28T18:57:51+00:00","description":"Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations.","breadcrumb":{"@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#primaryimage","url":"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","contentUrl":"https:\/\/www.topspotims.com\/blog\/wp-content\/uploads\/2024\/03\/ga-universal-scaled.jpg","width":2560,"height":1708},{"@type":"BreadcrumbList","@id":"https:\/\/www.topspot.com\/blog\/2024\/03\/how-to-export-historical-data-from-google-universal-analytics-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"TopSpot Blog","item":"https:\/\/www.topspot.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics","item":"https:\/\/www.topspot.com\/blog\/tags\/analytics\/"},{"@type":"ListItem","position":3,"name":"How to Export Historical Data from Google Universal Analytics\u00a0\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/www.topspot.com\/blog\/#website","url":"https:\/\/www.topspot.com\/blog\/","name":"TopSpot Internet Marketing","description":"Internet Marketing Trends & Articles - Houston Search Marketing News","publisher":{"@id":"https:\/\/www.topspot.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.topspot.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.topspot.com\/blog\/#organization","name":"TopSpot Internet Marketing","url":"https:\/\/www.topspot.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/06\/TopSpot-Internet-Marketing-OBx.png","contentUrl":"https:\/\/www.topspot.com\/blog\/wp-content\/uploads\/2024\/06\/TopSpot-Internet-Marketing-OBx.png","width":250,"height":250,"caption":"TopSpot Internet Marketing"},"image":{"@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/topspotims","https:\/\/x.com\/topspotims","https:\/\/www.instagram.com\/topspotims\/","https:\/\/www.linkedin.com\/company\/topspot-internet-marketing\/","https:\/\/www.youtube.com\/user\/gotopspotims"]},{"@type":"Person","@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/6b0a30f1b645793516d389d0a160029b","name":"Stefanie Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.topspot.com\/blog\/#\/schema\/person\/image\/23c10346373cfc1d68b79c82fa758558","url":"https:\/\/secure.gravatar.com\/avatar\/8a25e3312ccf7b0e7a03afa8045f7500?s=96&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a25e3312ccf7b0e7a03afa8045f7500?s=96&r=pg","caption":"Stefanie Thompson"},"url":"https:\/\/www.topspotims.com\/blog\/author\/sthompsontopspot-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/posts\/14367"}],"collection":[{"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/users\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/comments?post=14367"}],"version-history":[{"count":8,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/posts\/14367\/revisions"}],"predecessor-version":[{"id":14385,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/posts\/14367\/revisions\/14385"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/media\/14383"}],"wp:attachment":[{"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/media?parent=14367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/categories?post=14367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/tags?post=14367"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.topspotims.com\/blog\/wp-json\/wp\/v2\/coauthors?post=14367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
To get started, we recommend going to https:\/\/analytics.google.com\/analytics\/web\/<\/a>. If you\u2019re a TopSpot Client, go to the “Detailed Keyword Data” view. If not, go to the view that has the most accurate data, keeping in mind any views that help filter out internal and bot traffic. <\/p>\n\n\n\n You can adjust your date range at the top right of the tool. TopSpot recommends the last two years aligning to the change from UA to GA4 and the end of UA data collection. However, other considerations include: <\/p>\n\n\n\n What you see is what you get in your exported report, so make sure your selections reflect what you are looking to save. Most users opt to use either \u201cUsers\u201d or \u201cSessions\u201d metrics and then select the scope by month, but you can export by day or week for a more granular look. <\/p>\n\n\n\n Additionally, adjust conversions to \u201cAll Goals\u201d for a total count of conversions versus the source GA defaults to (this source varies per account). You’ll want to see data for all your forms and for E-Commerce users, ensure \u201cTransactions\u201d are included. You can add a secondary dimension if desired. An example of a secondary dimension would be the source country or region. <\/p>\n\n\n\n You can adjust the rows from 10 to 5000 to see more data pending the size of your site. For large data sets, you may need to export for each additional page in the report. Be sure to set aside ample time for this effort as it may take some experimentation and multiple downloads to gather all the data you need. Overall, think about your key business goals when making selections. <\/p>\n\n\n\n Once your report view is set, click the export icon, and then select the file format you\u2019d like your export in. You can choose between four different file types: PDF, Google Sheets, Excel, or CSV. <\/p>\n\n\n\n Covered in our earlier blog<\/a>, TopSpot recommends the following reports be exported from UA for future reference using the set-up instructions above. <\/p>\n\n\n\n If you are a TopSpot Client and have questions regarding your historical data, please contact your Account Team for help. If you are not a TopSpot Client and have questions, contact our Team<\/a> for more information about using data and analytics<\/a> and how we can help. <\/p>\n","protected":false},"excerpt":{"rendered":"Haven’t exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations. ","protected":false},"author":61,"featured_media":14383,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[1264,1255],"coauthors":[1314],"acf":[],"cp_meta_data":{"_edit_lock":["1718306629:61"],"_edit_last":["61"],"_yoast_wpseo_primary_category":["13"],"_yoast_wpseo_focuskw":["historical data"],"_yoast_wpseo_metadesc":["Haven't exported your historical data in Google Universal Analytics yet? TopSpot has you covered with a step-by-step guide on exporting and storing your historical data, plus considerations and TopSpot recommendations."],"_yoast_wpseo_linkdex":["69"],"_yoast_wpseo_content_score":["60"],"_yoast_wpseo_focuskeywords":["[{\"keyword\":\"Google Universal Analytics\",\"score\":49},{\"keyword\":\"Google Analytics\",\"score\":52}]"],"_yoast_wpseo_keywordsynonyms":["[\"UA historical data\",\"UA\",\"GA4\"]"],"_yoast_wpseo_estimated-reading-time-minutes":["6"],"_yoast_wpseo_wordproof_timestamp":[""],"_thumbnail_id":["14383"],"_yoast_indexnow_last_ping":["1711652273"]},"yoast_head":"\nTimeframes to Consider<\/strong><\/h3>\n\n\n\n
\n
Settings to Adjust Before Exporting<\/strong><\/h3>\n\n\n\n
How to Export from Universal Analytics<\/strong> <\/h2>\n\n\n\n
TopSpot\u2019s Recommended Reports to Export<\/strong> <\/h2>\n\n\n\n
Go to Acquisition > All Traffic for the following reports: <\/strong><\/h3>\n\n\n\n
\n
\n
Go to Conversions > Multi-Channel Funnels, for the following reports: <\/strong> <\/h3>\n\n\n\n
\n
Go to Behavior > Site Content for the following reports: <\/strong> <\/h3>\n\n\n\n
\n
For other reports under Behavior, we recommend<\/strong>:<\/h3>\n\n\n\n
\n
For those with E-commerce websites, consider downloading the following reports located under Conversions > E-commerce:<\/strong> <\/h3>\n\n\n\n
\n