1 / 12

Google Analytics Reporting: How to Update Excel Templates for NTC Analytics

Learn how to update Excel templates for NTC Analytics using the latest data from Google Analytics. Follow these step-by-step instructions to download the data, update your spreadsheet, and transfer the new chart to PowerPoint for a professional report.

ethan
Download Presentation

Google Analytics Reporting: How to Update Excel Templates for NTC Analytics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Production NTCActors.com

  2. These examples use School Marketing, but apply for all sections of NTCAnalytics.com Go to NTCAnalytics.com and Download these templates

  3. Open the Excel Template

  4. Go to NTCAnalytics.com and Click this link (“Google Analytics Visitors Report”)

  5. In the page that opens, click “Export” and chose “CSV”. If prompted by your browser, click Save. This downloads the latest data from Google Analytics, which you’ll use to update your spreadsheet.

  6. Open the CSV file you just downloaded…

  7. …and your chart is updated!… …and paste it into the Excel template you opened earlier… Then select all of the data and copy….

  8. Click on your chart to select it. Press CTRL+C to copy

  9. In the first slide of this PowerPoint, click on the chart and delete it.

  10. Paste in the new chart from the Excel Template

  11. Position and resize chart so that the dates approximately match the grid below. Save this PowerPoint .

  12. End

More Related