Only 4 Email Marketing Metrics Matter: The Cheat Sheet
Email Marketing might be considered a niche marketing by some people but it’s rapidly becoming one of the fastest growing Marketing Channels. Email Marketing is the kind of one on…
3 Metrics To Track User Engagement And Increase Your Customer Base | Kanza Akhwand
User engagement is key to increasing your readership or your sales or whatever you use. For the right kind of performance Marketing you need to focus on your content and…
How to Bulk add events to calendar | Kanza Akhwand
The following is to push Events from a google sheet to google calendar script: function addEvents() {var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var lr = ss.getLastRow();var cal = CalendarApp.getCalendarById(“c_3qjs8u1i5cu0re1coi8ageo51s@group.calendar.google.com”); var data = ss.getRange(“A2:E”…
How to Pull Calendar Data to Google Sheets | Kanza Akhwand
Want to add your Google Calendar Data to Google Sheets? function getEvents() {var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();var cal = CalendarApp.getCalendarById(“kanza.akhwand@yayvo.com”); var events = cal.getEvents(new Date(“07/01/2020 12:00 AM”), new Date(“07/31/2020 11:59 PM”));…
5 Reasons why you should have Google Analytics | Kanza Akhwand
If you have a blog or a website whether they are for your private or professional use one thing you must have is Google Analytics set up on it. Why?…
How to increment Alphabets like numbers in Google Sheets | Kanza Akhwand
When you write 1 and 2 one below the other, copy them and drag it down the numbers increase calculating the difference between the first two cells. However you can’t…
Adding Custom Channel Groupings to Data Studio | Kanza Akhwand
We have been be trying to correct our channel grouping for a while now but we needed them for diagnostic purposes. I wanted my reports to be accurate in Data…
Index Match, Vlookup’s Bulkier Cousin | Kanza Akhwand
In my previous post i talked about Vlookup and how easy it is to use and learn, in this post i want to talk about Index Match. In my personal…
Introducing Vlookup: Get Started on your Excel Journey | Kanza Akhwand
This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Everyone who uses Ms Excel or Google Sheets knows…
Introducing Myself | Kanza Akhwand
Hi Guys, My name is Kanza Akhwand and i am kind of a data nerd. I love Google Sheets, Dashboards and having data sets that make sense. Why do this?…