Google Analytics allows you to create subsets of your web site data; each one is known as a PROFILE. It’s quite common for companies to create a PROFILE for each operational division of their business. For example, this might mean each country unit has its own PROFILE. Alternatively, it might be something other than geographic such as certain data being filtered out such as certain landing pages or page titles, to allow for reporting on different marketing campaigns. If you incorporate custom dimensions and metrics or Goals, you could group on a wide variety of very company-specific attributes.
To get an comparative overview of the entire operation, it’s useful to have some reports which show the same data, repeated for each PROFILE, in a way that they can compare the results. NEXT distributes a free report (ga0102-google-analytics-profile-comparison.xlsx) which is a multi-profile report.
This report shows up to five profiles, putting their individual metrics side by side. Different chart types are used to how they compare to each other.
Customizing the Sample Report
The layout, and color scheme can easily be customized by any Excel user. It’s also easy to change which metrics show, and the time-frame over which the numbers of fetched from the Google Analytics Data servers.
The only step that you are REQUIRED to make is to identify your five profiles, or eliminate the extra rows if you don’t have five. The first step is knowing the profile IDs.
How do I find my Profile IDs
Assuming you’ve installed and configured access to Google Analytics, you can see your profile IDs using our software. If you are using the conventional Excel Addin, you can find this page:
Record each of the numbers you see, up to five of them, and proceed to the next section.
Put Your Profile IDs into the Sample Report
With your five profile IDs in hand, there are just a few simple steps that any Excel user can follow:
- Open the spreadsheet, which is can be obtained from our zip file of sample spreadsheets.
- Unhide the nextv54plus_actions worksheet
- Put your PROFILE ID values in cells D2 to D6, respectively.
- For each row, you can put a description of the profile in cells F2 to F6, respectively.
If you don’t have five profiles, then delete the rows which you didn’t modify i.e. Row 6 can be deleted.
Your changes are now complete. Switch to the Dashboard worksheet, save your spreadsheet, and refresh the data.
Now would be a good time to modify the appearance of the Dashboard worksheet. Using normal Excel features, you can:
1. Change the Title
2. Change the color scheme
3. Change the layout
4. Change the chart type.
5. Put your company’s brand or logo on the Dashboard worksheet.
Once you’re satisfied with your changes, you can hide the worksheets that don’t need to be shown such as Multisite_data and nextv54plus_actions.
Customize the Query (Optional)
If you would like to change some technical aspect of the report, our scripting engine lets you do that.
You can edit the cells directly, such as changing which dimensions or metrics are being used. You would need to know the technical names of the Google dimensions and metrics which you can learn by choosing them from our product and copy/pasting.
Or you can change the date-range from LastCalendar 1 Months. There’s a good article on how to do that here: