How Do I Send Conversion Data To Microsoft Ads Using Zapier
You can use Zapier to send conversion data from ClickMagick Campaigns to your Microsoft Ads account instantly using Google Sheets.
To make this work you will need to follow the steps on using Audience Optimization with Microsoft Ads.
To get started with setting that up, view the article below:
What is Audience Optimization and how do I use it?
Step 1 - Create Your Google Sheet
Inside of Google Sheets, you'll want create a new Sheet.
The name of your Google Sheet can be anything you want but to keep things simple just name it Microsoft Conversions.
In your Google Sheet you want to create the following header row:
Microsoft Click ID, Conversion Name, Conversion Time and Conversion Value which is optional:
Next, you'll want to get your File URL.
To do this do the following:
Click File and select Share and Publish to the web, select CSV and click Publish.
Copy the generated link
Step 2 - Scheduling Your Imports
Inside your Microsoft Ads account click on the "Tools" menu and select "Offline Conversions" as shown below:
Select "Schedules" and paste the URL you copied from Google Sheets into the File URL input.
Select your Upload Frequency and time zone and then click on Save:
Step 3 - Integrate Your Zapier account with ClickMagick
Click here to import the Zap into your Zapier account
The steps below outline how you’d edit the Zap for your account.
Inside of Zapier, you'll create a new "Zap" with the App being "ClickMagick" and the Event being "New Campaign Project Sale"
You'll be asked to integrate your ClickMagick account with Zapier using your API Key which you can by clicking on the "Generate API Key" from the API page:
Once you have the accounts integrated, select your Campaign project and leave the Attribution Model as Last Click
Next, you'll add your first of two actions.
The first action will be "Filter by Zapier" and the filter will be used to continue the zap only if a
You can select the
option from the drop down in both options.
The final action you need will be for Google Sheets.
Create Spreadsheet Row and you'll have to select the Google Sheet you created in Step 1.
Microsoft Click ID:
Insert the name of the Conversion Action you created in Microsoft.
Once done, just click "Continue" and turn on the Zap.
When you get conversions, the conversions will be automatically sent to your Google Sheet and uploaded to Microsoft Ads
Article 774 Last updated: 06/08/2022 4:10:38 PM