Rise of email marketing for ecommerce in Pakistan | Kanza Akhwand
Ecommerce in Pakistan continues to grow at a steady pace. According to the sources, Revenue in the eCommerce market is projected to reach US$5,409m in 2021. Pakistan is one of…
What is Conversion Rate Optimization? | Kanza Akhwand
Conversion Rate Optimization is the process of increasing the percentage of users on your website who perform a specific task. This task can be anything from filling out a form…
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…