Do you understand...

=if(LEFT(a2,5)=LEFT(b2,5),(if(LEFT(a3,5)=LEFT(b3,5),2,1),0)

Or...

SELECT County_Name, Count(Voters) FROM voters INNER JOIN ...

The task:    Ensure that voter lists are merged, split, and utilized in the most effective manner possible.

The result:  Political Synapse works directly with Maverick Strategies staff by building and querying voter lists to help their clients' fundraising and messaging via direct mail services.

Synthesizing a list from previous campaigns, other political candidates, and other affiliated organizations is difficult. Utilizing SQL and advanced Excel programming techniques, Political Synapse merges these disparate lists into one, eliminating duplicates based upon name and address matching in a quick and efficient manner.

Whether the job is merging and synthesizing a direct mail list for a statewide Democratic candidate or microtargeting voters based upon age, gender, and other demographic information, Maverick Strategies turns to the data expertise of Political Synapse to help their clients target voters in the most cost effective manner possible.