Using our Zapier application with Google Sheet, you can import historical custom clicks for offline or historical events quickly and easily.

The first step is to setup the Google Sheet. I referenced the help document Create Custom "Clicks" with HTTP Post in deciding what fields I needed to include for my example. 

You will need to create a new spreadsheet. In my example I created the following columns:
  1. Email
  2. Date_Time - Date/Time Format (mm/dd/yyyy hh:mm am/pm)
  3. Timezone - This would be the timezone your CRM is using, NOT the Timezone of the Contact.  (EST Timezone="UTC-5", CST Timezone="UTC-6", etc)
  4. Source
  5. Campaign
  6. Term
  7. Medium
  8. Content

Here's what my example looks like:

The next step is to setup your Zap.

The first step is to create a trigger. For this example, the trigger will be adding a new row to the Google Sheet we created. For the example this is being done manually, but it could be a step in an automation or workflow that already exists in your business.

To setup the trigger, create a new Zap and choose the Google Sheets Trigger App.

The trigger will be New Spreadsheet Row

Establish and test the connection to your Google Docs account.

Specify the name of the Google Sheet and which tab will be used to load the custom click event data.

Then you can test your connection and pull in sample data for step 2.

Now you're ready to set up the part of the Zap that will send data to Wicked Reports.

For your Action step, choose the Wicked Reports Action App (currently available here).

Choose the Track a Click action

Establish and test your connection to Wicked Reports

Set the Template options (using the mappings specified in your help doc on HTTP Post submissions) to correspond to the fields we setup in the spreadsheet.

Test your final step and turn on your Zap.

Within 24 hours you should be able to see your custom click events in your Wicked Reports.