Google Analytics Bulk URL Builder Spreadsheet Add-on

Google Analytics Bulk URL Builder Spreadsheet Add-on is 1st tool published by me and hope it helps marketers in saving their time and effort. Install Add-On from chrome store

Why?

I have used several URL builders and the it always felt counterproductive to tag one URL at a time when a typical web campaign needs several URLs to be tagged with changes in landing page, creative, audience, etc. I have been using a macro in excel to get over this challenge but Google Spreadsheet Add-On gave me a way to share the same functionality with others.

How?


There are 7 columns in this tool, column 1 to 6 are input columns and column 7 is output column.

 

URl builder

Landing Page / Application ID: In this column landing page of your webiste (e.g. http://theniks.com/contact) or if you are running app install campaigns your application id. (e.g com.myntra.android) should be provided. 

Source: In this column source of the campaign should be provided (e.g. Google, Facebook, email, etc).

Medium: In this column medium of the campaign should be provided (e.g. CPC, CPM, CPI, email, etc).

Campaign: In this column name of the campaign should be provided (e.g. Brand Campaign, xmas campaign, Deewali campaign, etc).

Content: In this column banner theme of the creative should be provided (e.g. beach, snow, discount, headline of text ad, etc).

Term: In this column keyword which triggered the click should be provided (e.g. {keyword} for AdWords).

Although only Source is mandatory its recommended to have at least Source . medium and campaign.

Destination URL: This is output which you can use in your campaigns as landing page. 

 

Last modified onTuesday, 19 July 2016 04:41
  • Rate this item
    (2 votes)
  • Published in Tools
  • Read 3126 times
Nikhil Parachure

Nikhil is nothing short of "Swiss Knife of Digital Marketing". Over  the course of last 10 years he has been involved in practically every facet of Digital Marketing and Analytics.

Starting career with paid search, Nikhil has built and managed award winning digital campaigns, has been Google Adwords Top Contributor, Planned and implemented several complex and large scale web and mobile analytics implementations. Currently working for Myntra as Manager Analytics Nikhil is also conducts trainings on Web Analytics, Mobile Analytics and Digital Marketing.

 

Website: www.theniks.com/
More in this category: Google Analytics Heatmap Calendar »

1 comment

  • frank

    frank

    Comment Link Saturday, 23 July 2016 08:03

    Things to consider to make this useful.

    Create a template worksheet such as the one that has an image(delete the campaign column). Keep the sheet locked so others don't edit it.

    Create an AdWords MCC script to find all urls within a campaign, de duplicate urls and then based on the template where the users should have prevoulsy entered info your script would then generate utms but it could also apply them in the campaigns for you.

    Report

Leave a comment

back to top