Access for Adwords Data

[jbarth]

Hi everyone!

Bear with me as this is my first post, and I'm a database & Access newbie. My search on the web has drawn a blank for an Access package that I can use to analyze Adwords data, so I've taken it upon myself to create one that works for my needs. I've hit my first roadblock that I haven't figured out how to get around. I'm planning to load in the data in every month, and using the first day of that month as the Date. The data in the table has columns of:

ID, Date, Search term, Ad group, Campaign, Match Type, Clicks, Impressions, Cost, Avg position, Conversions

What I want to do in a query is look at all search terms that have a certain keyword or phrase in them from different time periods within one query. I've got it working such that I can show the data for one time period at a time (that may include multiple months). What I want to find is all the search terms that have a keyword in them, and see the data over the last month, the last 3 months, and the last 6 months, but I can't figure out how to get all of these returned in one query, instead of having me alter the query to look at one month, then re-run it for 3 months, then re-run it for 6 months. So I want the columns to look like:

Search term, 1 mo clicks, 1 mo conversions, 3 mo clicks, 3 mo conversions, 6 mo clicks, 6 mo conversions

Can I do this within 1 query? Or do I have to build multiple queries and create a report that gathers data from all of them?

[June7]

No matter what, looks complicated.

One approach could be multiple queries that are joined on the search term. You can leave them as multiple saved Access queries or build one SQL statement with nested subqueries in the SQL View of query designer.

Alternative might be domain aggregate functions (DCount, DSum, etc) within one query.