-
Notifications
You must be signed in to change notification settings - Fork 4
Analytics Templates & Instructions
If you have a DAP account, you can use these links to import our blog reports. Select DOI Agency Profile when prompted for a profile during the import process.
Report: https://analytics.google.com/analytics/web/template?uid=BJa63TM_SGGihympzm8w2Q
User segment: https://analytics.google.com/analytics/web/template?uid=-Q32ho7FSF-PJ_wHzo5G9g
Data is in the Blog Usage tab in the blog report. Apply the NRRD Blog Users Segment.
Chart is updated in the Pageviews and Formatted Pageviews worksheets in this spreadsheet (limited access).
Add a new column for page views for the month to the Pageviews tab. If there are any new blog posts, they need to be added as a row and you need to figure out what the first week and 2-4th week numbers are based on the post date of the post. Then make sure the chart is updated.
Take a screenshot of the chart and save the file as BlogPageviews.png and upload it to the Analytics folder in the research repo. That will update the chart on the analytics page.
Then copy and past the numbers into the Formatted Pageviews tab. You will need to copy the 1st week and weeks 2-4 numbers for any posts newer than 4 weeks and the entire after 1st 4 weeks column. Then copy the whole table into a markdown table maker and then copy the code from that over the old markdown table.
Data is in the Referrers tab in the blog report. Apply the NRRD Blog Users Segment. Add Landing Page as a secondary dimension.
Chart is updated in the Referrers, Referrers Pivot and Referrers Chart worksheets in this spreadsheet (limited access).
Download the referrers report for the month.
Clean the data by removing any rows that don't have our blog posts or the blog homepage as the landing page. Also remove any referrers that are from ONRR websites.
Add a new column for referrals for the month to the Referrers tab. Sort by the referrer and move the new month numbers to the old row for referrers that were already in the spreadsheet. Add the Referrer Type to any new referrers.
Refresh the pivot table in the Referrers Pivot tab to include the latest data. You will have to make sure all the rows that are now in the Referrers tab are being pulled into the pivot table.
Copy and paste content into the Referrers Chart sheet to get it in the right format and update the chart. This involves making sure the data is in the order in this sheet.
Take a screenshot of the chart and save the file as BlogReferrers.png and upload it to the Analytics folder in the research repo. That will update the chart on the analytics page.
Then copy and past the numbers into the Referrers Chart tab and copy that into a markdown table maker and then copy the code from that over the old markdown table.