Use Setup Sheet Button First From Add-on
Contact me to get a license key
Guides:
1- Sheet Guide
2 - How To Get Pixel ID & Access Token
3 - How To Create Custom Audience
Create a unique Event ID for each row.
(Every row should have its own Event ID.)
You must add at least one identifier:
Phone number OR Email (required for Meta matching).
First Name / Last Name are optional, but recommended to improve match quality.
Value and Currency are required for “Purchase” events,
but you can also add them for Lead events if you want.
make sure currency symbol is compatible with meta
Category ,it's Service or product type (important if you have different categories) to create custom audience in ads manager.
example : if you are languages e-learning business it could be (english_course, german_course...)
for a real state could be ( residential, commercial, rental..)
cosmetics ( haircare, skincare,makeup..)
Ad ID is optional, but it’s very important if you want Meta to attribute results correctly at the campaign/ad level.
so you can which creative generate conversion ,calculate cost per results and ROAS
City is optional, but it helps improve event match quality.
✅ Always write the city in small letters (example: cairo, riyadh).
If the customer was sent as Lead, then later they Purchased,
just change the Event Name to “Purchase” and change the event Id then remove 'success' from status column and click send events
example if event id "22" change it to "p_22'' then send events
The Tool will send the updated Purchase event to Meta.
If it’s the customer’s second order (another purchase),
don’t edit the old row.
Instead, create a new row with a new Event ID and send it as a new Purchase event.