Visitor and conversion tracking

When you create a calculating web page from an Excel spreadsheet, we can include scripts for visitor tracking. For conversion tracking you use a thank-you page with an embedded tracking script.  

SpreadsheetConverter has built-in support for visitor tracking using Google Analytics. If you provide your Google Analytics Tracking ID, a standard tracking script will be inserted into each converted web page. Every subsequent visit to the calculator or web form will be tracked in Google Analytics.

Conversion tracking is used to register special “success” events. With SpreadsheetConverter, such an event may be a validated form submission. Insert the conversion tracking script into the thank-you page for the event. Activate the thank-you page for the web form. That’s it! After each submit, the thank-you page will be opened in the user’s web browser, and the tracking script in the thank-you page will track the conversion.

Google Analytics visitor tracking

When you convert a spreadsheet for the web with SpreadsheetConverter, you can automatically insert a Google Analytics tracking script. To do this, enter your Google Analytics Tracking ID in the SpreadsheetConverter ribbon > Options > Advanced settings.

Screenshot of the Google Analytics Tracking ID in the Advanced Settings

For each subsequent conversion, a Google Analytics standard tracking script for the provided tracking ID will be inserted into the converted web pages.

Screenshot of a ga.js tracking script for Google Analytics

All visits to your calculating web pages and forms will be tracked in Google Analytics just like any other page on your website. You will find all visits to the page under Analytics > Behavior > Site content > All pages. In the example below we filtered the list for “/calculate/” since this is the folder where we store all our example calculators.

Screenshot of Google Analytics showing visitor statistics for converted web pages

If your Google Analytics Tracking ID changes, or if you need to use more than one tracking ID, you must change the setting before you convert the affected web pages. The tracking ID for any web page you have already converted will remain the same as it was when the corresponding spreadsheet was last converted.

Other visitor tracking systems

If you use another visitor tracking system, you need to manually insert a visitor tracking script for your tracking system into the HTML source for each converted web page.

If you intend to show the calculator in an iframe, or cut-and-paste the HTML source for the calculator into the source for an existing web page that already has visitor tracking enabled for it, there is no need to add a separate tracking script for the calculator.

Conversion tracking

When your website receives visitors from advertising or external marketing partners, you may want to track a predefined “success” event, i.e. a confirmed sale, a new user registration or a validated survey response. In web marketing, this event is called a conversion.

The conversions count may be used for several different things. To improve the quality of pay-per-click advertising in search engines, you may want to study the conversion report from the search engine. The below example is from Google Adwords and shows you the number of successful conversions per search term, and the average advertising cost to achieve a conversion for each search term. This information allows you to add more and more profitable search terms, and remove the unprofitable ones.

Screenshot of conversion tracking in Google Adwords

If you receive web visitors from other external sources, you can use an affiliate marketing system to track conversions and calculate the commission to pay each affiliate at the end of the month. In this case the conversion tracking code would be provided by the affiliate marketing system.

Validate the form before submission

With SpreadsheetConverter, a conversion is often a validated form submission. It is an obvious event that can easily be identified and counted.

SpreadsheetConverter makes it easy for you to secure that qualifying form submissions are valid and complete, by providing tools in the spreadsheet such as:

  • Data entry widgets like dropdown menus force the user to select only between approved responses.
  • Required fields force the user to provide mandatory information.
  • Ordinary Excel formulas can be used to validate any data entered into the form.

Using these tools, it is easy to create a web form that cannot be submitted until it is valid and complete. You can even hide the Submit action button completely until you approve all the contents of the form.

Create the thank-you page

A conversion event is normally tracked using a special “thank-you” page for the form. The thank-you page usually informs the website visitor that the web form has been received for processing. As an example, have a look at our own default Success page.

When you have created the thank-you page, insert the conversion tracking script into its HTML source. The conversion tracking script is provided by the software that will track your conversions, typically a search engine advertising service or an affiliate marketing system.

Configure the submit operation

Open the spreadsheet and navigate to SpreadsheetConverter task pane > Workbook > Configure Submit. Enter the link to the thank-you page into the After successful submit field.

When a visitor arrives at the website, a cookie is usually created to link the new session to the source – often a search engine advertisement or an affiliate link. When the tracking script in the thank-you page is run, it will verify the cookie, count the event and provide conversion statistics for your reports just like in the Google Adwords report above. If you open the thank-you page without having set the session cookie first, most tracking systems will correctly ignore this and not register a conversion.