Mohamed Elghannam

Section 10 of 10

Results, indexed

10Results, indexed

Illustrative example of how I track weekly CPL and CTR per campaign. Figures are representative and anonymised — they are not the company’s actual account data. Career totals are at the end.

Illustrative · Meta lead-gen: cost per form lead by week, indexed (best week = 100, lower is better)
Campaign AW1150W2138W3128Campaign BW1125W2104W3100Campaign C · test paused, budget movedW1160W2175Campaign D · test paused, budget movedW1150W2170
Table view
CPL index
Campaign A · W1150
Campaign A · W2138
Campaign A · W3128
Campaign B · W1125
Campaign B · W2104
Campaign B · W3100
Campaign C · test paused, budget moved · W1160
Campaign C · test paused, budget moved · W2175
Campaign D · test paused, budget moved · W1150
Campaign D · test paused, budget moved · W2170
Illustrative · Meta lead-gen: click-through rate by week
Campaign AW11.10%W21.15%W31.20%Campaign BW11.30%W21.35%W31.40%Campaign C · test paused, budget movedW10.95%W20.85%Campaign D · test paused, budget movedW11.00%W20.90%
Table view
CTR
Campaign A · W11.10%
Campaign A · W21.15%
Campaign A · W31.20%
Campaign B · W11.30%
Campaign B · W21.35%
Campaign B · W31.40%
Campaign C · test paused, budget moved · W10.95%
Campaign C · test paused, budget moved · W20.85%
Campaign D · test paused, budget moved · W11.00%
Campaign D · test paused, budget moved · W20.90%
Illustrative · Raw leads to pipeline stages (share of leads)
Raw leads100%Interested+12%Qualified+6%Site visit+4%
Table view
Share of leads
Raw leads100%
Interested+12%
Qualified+6%
Site visit+4%
Illustrative · Leads vs qualified by channel (share of channel leads reaching Qualified+)
Meta (70%)6%TikTok (12%)5%Snapchat (10%)4%Direct / WhatsApp (8%)7%
Table view
Qualified+ rate
Meta (70%)6%
TikTok (12%)5%
Snapchat (10%)4%
Direct / WhatsApp (8%)7%
  • How to read it: the best week is set to 100 and every other week is shown against it, so campaigns can be compared without showing spend.
  • Campaigns C and D stand for tests that were paused once their CPL index drifted up while CTR fell; their budget moved to the stronger campaign.
  • The funnel and channel views show why verified CPL and qualified rate, not raw CPL, govern the budget.
  • All values in this block are illustrative and anonymised; they are not any company’s account or CRM data.

Campaign-level detail, earlier work

Rebuilt from the original campaign spreadsheets and lead lists. CPL is shown in AED and leads as real counts; spend appears only as a share, never in dirhams. These are campaign details that sit inside the career totals below, not additions to them.

Freelance · Falcon Island campaign, Ras Al Khaimah

1 Oct 2022 – 1 Mar 2023
3,319
leads reported, Oct 2022 – Feb 2023
AED 102
blended CPL from the campaign rows
48%
of the leads came from the Bin Amy campaigns
CPL by platform and month, AED (lower is better)
Nov 2022FacebookAED 103TikTokAED 62SnapchatAED 82Dec 2022FacebookAED 71TikTokAED 63SnapchatAED 107Jan 2023FacebookAED 90TikTokAED 115SnapchatAED 48Feb 2023FacebookAED 142TikTokAED 196SnapchatAED 140
Table view
CPL (AED)
Nov 2022 · FacebookAED 103
Nov 2022 · TikTokAED 62
Nov 2022 · SnapchatAED 82
Dec 2022 · FacebookAED 71
Dec 2022 · TikTokAED 63
Dec 2022 · SnapchatAED 107
Jan 2023 · FacebookAED 90
Jan 2023 · TikTokAED 115
Jan 2023 · SnapchatAED 48
Feb 2023 · FacebookAED 142
Feb 2023 · TikTokAED 196
Feb 2023 · SnapchatAED 140
Leads by platform and month
Nov 2022Facebook418TikTok385Snapchat444Dec 2022Facebook129TikTok244Snapchat3Jan 2023Facebook350TikTok454Snapchat92Feb 2023Facebook418TikTok180Snapchat179
Table view
Leads
Nov 2022 · Facebook418
Nov 2022 · TikTok385
Nov 2022 · Snapchat444
Dec 2022 · Facebook129
Dec 2022 · TikTok244
Dec 2022 · Snapchat3
Jan 2023 · Facebook350
Jan 2023 · TikTok454
Jan 2023 · Snapchat92
Feb 2023 · Facebook418
Feb 2023 · TikTok180
Feb 2023 · Snapchat179
Share of spend (faded) vs share of leads (solid) by platform, 1 Oct 2022 – 1 Mar 2023
Facebook · spend42.2%Facebook · leads39.6%TikTok · spend38%TikTok · leads38.7%Snapchat · spend19.8%Snapchat · leads21.6%
Table view
Share
Facebook · spend42.2%
Facebook · leads39.6%
TikTok · spend38%
TikTok · leads38.7%
Snapchat · spend19.8%
Snapchat · leads21.6%
Leads by project in the campaign names, Oct 2022 – Feb 2023
Bin Amy1,586RAK (general)956Al Marjan / Danah Bay489Al Hamra177Mina Al Arab82
Table view
Leads
Bin Amy1,586
RAK (general)956
Al Marjan / Danah Bay489
Al Hamra177
Mina Al Arab82
CPL by project, AED (lower is better)
Bin AmyAED 86RAK (general)AED 87Al HamraAED 128Al Marjan / Danah BayAED 156Mina Al ArabAED 191
Table view
CPL (AED)
Bin AmyAED 86
RAK (general)AED 87
Al HamraAED 128
Al Marjan / Danah BayAED 156
Mina Al ArabAED 191
CRM lead list: lead source, 5 Nov 2022 – 28 Mar 2023
Instagram48.8%Snapchat28.3%TikTok22.8%
Table view
Share
Instagram48.8%
Snapchat28.3%
TikTok22.8%
CRM lead list: emirate the lead lives in (1,112 leads that named one)
Abu Dhabi (335)30.1%Dubai (297)26.7%Ras Al Khaimah (235)21.1%Sharjah (149)13.4%Ajman (53)4.8%Fujairah (30)2.7%Umm Al Quwain (13)1.2%
Table view
Share
Abu Dhabi (335)30.1%
Dubai (297)26.7%
Ras Al Khaimah (235)21.1%
Sharjah (149)13.4%
Ajman (53)4.8%
Fujairah (30)2.7%
Umm Al Quwain (13)1.2%
Stated purpose, 29 Oct 2022 – 26 Feb 2023 (569 leads that answered)
To live in (339)59.6%Investment (230)40.4%
Table view
Share
To live in (339)59.6%
Investment (230)40.4%
  • Monthly CPL went from AED 83 in November to AED 66 in December, then AED 98 in January and AED 154 in February. TikTok was the cheapest platform in November and December, Snapchat in January and February.
  • Bin Amy was the largest project in the campaign names (1,586 leads at AED 86). Al Marjan / Danah Bay and Mina Al Arab cost about twice as much per lead.
  • In the CRM list, about 4 in 5 of the leads that named an emirate lived outside Ras Al Khaimah, mostly in Abu Dhabi and Dubai. About 60% of those who gave a purpose were buying to live in.

Source: freelance campaign report (two client ad accounts, combined), one row per campaign, platform and date range, 1 Oct 2022 – 1 Mar 2023. Client account names are not shown.

Cleaning: each sheet’s own total row was excluded and used as a check. Tool and service rows (CRM, landing pages, bloggers, printing) were left out, so CPL counts media only. Campaign rows plus those rows add up to the sheet totals in US dollars; one account’s total also adds 5% VAT. A 1 Oct – 4 Nov block (23 leads) and 1 Mar spend adjustments are in the totals but not in the monthly bars. The CRM charts use the RAK lead lists: source and emirate from the Nov 2022 – Mar 2023 list (2,426 leads, emirate given by 1,112; Abu Dhabi includes Al Ain), purpose from the Oct 2022 – Feb 2023 list (856 leads, purpose given by 569).

Freelance · PSI campaigns, Abu Dhabi projects

24 Sep – 30 Oct 2022
3,212
leads reported, 24 Sep – 30 Oct 2022
AED 106
blended CPL, same period
78% · 93%
of the monthly budget spent (Sep · Oct)
CPL by platform and month, AED (lower is better)
24–28 Sep 2022FacebookAED 140TikTokAED 148SnapchatAED 1221–30 Oct 2022FacebookAED 100TikTokAED 113SnapchatAED 93
Table view
CPL (AED)
24–28 Sep 2022 · FacebookAED 140
24–28 Sep 2022 · TikTokAED 148
24–28 Sep 2022 · SnapchatAED 122
1–30 Oct 2022 · FacebookAED 100
1–30 Oct 2022 · TikTokAED 113
1–30 Oct 2022 · SnapchatAED 93
Leads by platform and month
24–28 Sep 2022Facebook176TikTok162Snapchat1141–30 Oct 2022Facebook922TikTok790Snapchat1,048
Table view
Leads
24–28 Sep 2022 · Facebook176
24–28 Sep 2022 · TikTok162
24–28 Sep 2022 · Snapchat114
1–30 Oct 2022 · Facebook922
1–30 Oct 2022 · TikTok790
1–30 Oct 2022 · Snapchat1,048
Share of spend (faded) vs share of leads (solid) by platform, 24 Sep – 30 Oct 2022
Facebook · spend34.3%Facebook · leads34.2%TikTok · spend33.2%TikTok · leads29.6%Snapchat · spend32.6%Snapchat · leads36.2%
Table view
Share
Facebook · spend34.3%
Facebook · leads34.2%
TikTok · spend33.2%
TikTok · leads29.6%
Snapchat · spend32.6%
Snapchat · leads36.2%
Leads by project, 24 Sep – 30 Oct 2022
Bloom1,071Al Jurf818Multi-project ads435Yas (Acres, Park Gate)345Saadiyat Island305Reem Hills113Fay Al Reeman68Saadiyat Lagoons55
Table view
Leads
Bloom1,071
Al Jurf818
Multi-project ads435
Yas (Acres, Park Gate)345
Saadiyat Island305
Reem Hills113
Fay Al Reeman68
Saadiyat Lagoons55
CPL by project, AED, 24 Sep – 30 Oct 2022 (lower is better)
Al JurfAED 64BloomAED 77Fay Al ReemanAED 124Multi-project adsAED 130Yas (Acres, Park Gate)AED 141Saadiyat IslandAED 174Reem HillsAED 182Saadiyat LagoonsAED 318
Table view
CPL (AED)
Al JurfAED 64
BloomAED 77
Fay Al ReemanAED 124
Multi-project adsAED 130
Yas (Acres, Park Gate)AED 141
Saadiyat IslandAED 174
Reem HillsAED 182
Saadiyat LagoonsAED 318
  • Snapchat had the lowest CPL in both months and brought 36% of the leads on 33% of the spend; TikTok was the most expensive channel in both months.
  • Al Jurf and Bloom were the cheapest projects to generate leads for (AED 64 and AED 77). Saadiyat Lagoons started on 29–30 Oct, so its CPL rests on two reporting days.
  • “Multi-project ads” are the general and luxury-villa campaigns that advertised several projects at once. Parkside (2 leads) is left out of the project charts.

Source: PSI campaign daily report (September and October sheets), 24–28 Sep and 1–30 Oct 2022, one row per campaign, platform and reporting date.

Cleaning: each sheet’s own total row was excluded and used as a check. Platform rows add up to the sheet totals to the dirham in both months, and leads match in October. One 29 Sep row with 12 Facebook leads and no spend was left out, so September shows 452 leads against the sheet’s 464. A daily CPL trend is not drawn: several rows cover multi-day blocks and some dates have no rows.

Freelance · Developer campaigns, team daily report

3 Jul – 21 Sep 2022
5,311
leads reported, 3 Jul – 21 Sep 2022
AED 96
blended CPL, same period
6
developers and project groups
CPL by platform and month, AED (lower is better)
Jul 2022FacebookAED 104TikTokAED 72SnapchatAED 68GoogleAED 92Aug 2022FacebookAED 98TikTokAED 106SnapchatAED 109GoogleAED 991–21 Sep 2022FacebookAED 76TikTokAED 89SnapchatAED 81GoogleAED 209
Table view
CPL (AED)
Jul 2022 · FacebookAED 104
Jul 2022 · TikTokAED 72
Jul 2022 · SnapchatAED 68
Jul 2022 · GoogleAED 92
Aug 2022 · FacebookAED 98
Aug 2022 · TikTokAED 106
Aug 2022 · SnapchatAED 109
Aug 2022 · GoogleAED 99
1–21 Sep 2022 · FacebookAED 76
1–21 Sep 2022 · TikTokAED 89
1–21 Sep 2022 · SnapchatAED 81
1–21 Sep 2022 · GoogleAED 209
Leads by platform and month
Jul 2022Facebook571TikTok450Snapchat494Google424Aug 2022Facebook536TikTok584Snapchat253Google1841–21 Sep 2022Facebook176TikTok885Snapchat481Google273
Table view
Leads
Jul 2022 · Facebook571
Jul 2022 · TikTok450
Jul 2022 · Snapchat494
Jul 2022 · Google424
Aug 2022 · Facebook536
Aug 2022 · TikTok584
Aug 2022 · Snapchat253
Aug 2022 · Google184
1–21 Sep 2022 · Facebook176
1–21 Sep 2022 · TikTok885
1–21 Sep 2022 · Snapchat481
1–21 Sep 2022 · Google273
Share of spend (faded) vs share of leads (solid) by platform, 3 Jul – 21 Sep 2022
Facebook · spend24.5%Facebook · leads24.2%TikTok · spend33.7%TikTok · leads36.1%Snapchat · spend19.6%Snapchat · leads23.1%Google · spend22.3%Google · leads16.6%
Table view
Share
Facebook · spend24.5%
Facebook · leads24.2%
TikTok · spend33.7%
TikTok · leads36.1%
Snapchat · spend19.6%
Snapchat · leads23.1%
Google · spend22.3%
Google · leads16.6%
Leads by developer, 3 Jul – 21 Sep 2022
Azizi (Riviera)2,174Ras Al Khaimah projects1,211Dubai investment (general)907Damac409Omniyat (Anwa)296Emaar43
Table view
Leads
Azizi (Riviera)2,174
Ras Al Khaimah projects1,211
Dubai investment (general)907
Damac409
Omniyat (Anwa)296
Emaar43
CPL by developer, AED (lower is better)
Dubai investment (general)AED 80DamacAED 86Azizi (Riviera)AED 87Omniyat (Anwa)AED 107Ras Al Khaimah projectsAED 112EmaarAED 155
Table view
CPL (AED)
Dubai investment (general)AED 80
DamacAED 86
Azizi (Riviera)AED 87
Omniyat (Anwa)AED 107
Ras Al Khaimah projectsAED 112
EmaarAED 155
  • Snapchat had the lowest CPL over the period (AED 82) and Google the highest (AED 129); Google’s CPL rose to AED 209 in September.
  • Azizi Riviera campaigns brought the most leads (2,174 at AED 87). Ras Al Khaimah campaigns were the second-largest group.

Source: freelance campaign daily report (July, August and September sheets), 3 Jul – 21 Sep 2022, kept by a team of four; 47–72% of the campaign rows each month were created by me.

Cleaning: each sheet’s own total row was excluded and used as a check; the side columns with daily totals were not used. Website lines with leads but no spend (50 leads) and two Twitter rows (1 lead) were left out; with them, rows add up to the sheet totals exactly. Google Discovery and Google Search are combined.

Freelance · Nation Wide Dubai lead list

Jan – Apr 2022
Leads by month, 2022
Jan 2022240Feb 2022514Mar 20221,021Apr 2022477
Table view
Leads
Jan 2022240
Feb 2022514
Mar 20221,021
Apr 2022477
Share of leads by campaign group (2,502 leads with a campaign name)
Iraq roadshow events49.7%Damac Lagoons12.5%Ras Al Khaimah event10.2%Vincitore Benessere6.7%Aldar launch (GCC)4.4%Binghatti3.2%Bloom2.6%Emaar2%
Table view
Share
Iraq roadshow events49.7%
Damac Lagoons12.5%
Ras Al Khaimah event10.2%
Vincitore Benessere6.7%
Aldar launch (GCC)4.4%
Binghatti3.2%
Bloom2.6%
Emaar2%
  • Half of the leads came from the Iraq roadshow campaigns (Erbil and the Ellington event); March 2022 was the peak month with 1,021 leads.

Source: Nation Wide Dubai lead export. 2,297 of 2,731 leads carry a date; 2,252 fall in January–April 2022 and the rest are scattered up to November. The list has no spend, so there is no CPL.

Imkan lead list · enquiries by unit type

Share of enquiries naming each unit type
Studio (457)14.5%1 bedroom (710)22.5%2 bedrooms (1,107)35.1%3 bedrooms (102)3.2%Villa (514)16.3%Shop / retail (267)8.5%
Table view
Share of entries
Studio (457)14.5%
1 bedroom (710)22.5%
2 bedrooms (1,107)35.1%
3 bedrooms (102)3.2%
Villa (514)16.3%
Shop / retail (267)8.5%
  • Two-bedroom units were the most requested, then one-bedroom units and villas. Counts are lead entries as exported, not de-duplicated people.

Source: Imkan FZ-LLC lead export, which has no date column. 3,157 of 37,612 entries name a unit type in the free-text field; the rest are blank or give a purpose, project or ad source instead.

Across the career

AED 18M+
advertising budgets managed
205,000+
leads generated
AED 30K–150K
monthly ad budgets run
26.2–28%
lead-to-qualified conversion
AED 12M
attributed sales, IMKAN campaign 2019
AED 100M
attributed sales, Falcon Island

Career figures are cumulative across employers since 2018, reported from ad-platform and CRM data. Monthly lead volume at Salsabeel is lower and is governed by Verified CPL rather than volume. Agency and freelance (2022–2025): campaign work, including leasing, for a UAE real-estate marketing agency serving several developers and brokerages.

Want this for your projects?

The whole stack, or one piece of it. WhatsApp is fastest.