Brand promotion: this article introduces Guangsuan's Google Ads management services for Shopify merchants.
A Shopify merchant pulls last month for review. Ads shows one spend total. Shopify and the CRM show another set of orders. Neither file is necessarily broken. In most month-end checks, the join was decided before download: which rows were unique, which calendar rule applied, and which conversions were summed.
Direct answer with conditions: When you compare one closed month to decide on bids or pages, write the customer number and campaign number plus each split that defines a row on the file, write the range together with the account zone and whether conversion time or click time was used, keep the main total limited to primary actions, and convert micro cost to currency once in a noted place. Use CSV or XLSX for checking and Sheets for shared checking. This routine is for spend or pipeline checks, not for a quick screenshot.
Start from the question, then set range and columns
Write one question first, such as which campaigns drove qualified checkout starts in October. That question selects the view, the period, and the action to carry forward. A campaign total shows how much was spent. A campaign split by day and device shows when and where it was spent. Those two shapes need different keys.
On the Campaigns, Ad groups, Keywords, Search terms or Ads page, set the date range and columns, then use the download icon at the top right of the table (or the three-dot menu) to download a file. When day, device, location, or conversion splits must appear together, build the view in the Reports section instead, using a predefined view or a custom table.
Choosing an unsuitable range is a frequent error. A monthly rollup can hide one weak week. A daily pull across a long span becomes hard to scan. Export the grain you will actually analyse, and use the segment control to divide by day, week, or month rather than stitching several separate pulls together later.
Give every row a stable identity
Display names are edited, numbers persist. Keep the customer number in the file. Keep the numeric campaign number next to the campaign name. Keep each field that separates one row from another, such as date, device, network part, and conversion action where it applies.
For work beyond spend and clicks, carry search terms next to the keywords you bid on so shopper wording stays apart from the bought term. Add device, network, location, or hour only when the opening question calls for them. Avoid one giant file with every column turned on.
Name the file with account, report, range, date rule, and pull time. Keep the raw download unchanged and do the review in a copy, so a retry replaces the same slice instead of adding a second copy.
Write down zone and conversion rule on the file
Exports are dated in the account's time zone, which may not match your calendar or your CRM timestamps. An order placed late on the final evening can sit in different months on each side without an error on either side. Put the zone on the file itself and check one date row before trusting day-month order after opening CSV.
Google Ads can attribute and report conversions on more than one basis, and the default column is not the only valid view. Placement by conversion time puts the event where it happened. Placement by click time puts it where the click happened. A late-September click that becomes an early-October purchase falls in different months under those two rules. Both rules are valid until they are mixed, so use one rule on both sides of a period comparison.
Before you build a conversion view, open the conversion settings and note the basis, which actions are primary, the counting method, and the attribution model. Changing any of them moves history, so that note belongs beside the file. For background on download paths and date handling, see Guangsuan's guide to exporting Google Ads data and reading dates and conversions.
Keep primary actions apart from secondary steps
Secondary actions — often micro-conversions such as a page view or a click-to-contact — are reported separately and should be labelled as such in your export. Only primary steps feed the Conversions column used for bidding. A total that blends the two counts more than the business agreed to count.
If you rely on offline or CRM-confirmed leads, remember the export only shows what Google was able to record; sales-confirmed numbers live in your own system. That gap reflects different stages measured in different systems, not proof that either side is wrong.
Keep four tallies apart through the whole check: clicks, platform-recorded conversions, qualified enquiries, and closed revenue. Adding them together yields a number the business never defined.
Open the file and handle money consistently
Google Ads supports CSV, CSV for Excel, TSV and XLSX, and can send a file to Google Sheets or by email on a schedule. Use CSV for scripts and storage, XLSX for sheet review, and the Sheets route when several people must see the same live file.
Open CSV through Data > From Text/CSV, force UTF-8, confirm the delimiter, turn cost and clicks from text into numbers, and verify one date row first. Add the cost column and compute your own ratios in the sheet, because aggregated averages can hide the segment you need to act on.
Cost arrives in micros in the account currency, so apply the divide-by-one-million step once and record where it happened. Do not add raw totals across currencies. Keep accounts apart or note a dated rate.
For recurring, large or automated exports, query with GAQL instead of clicking through the interface. The returned rows carry only the fields named in the query, so a missing identifier cannot be rebuilt downstream.
A narrow Shopify join order before bid moves
- Select one primary action, one campaign group, and one closed period.
- Line up basis, range, and zone on both extracts.
- Hold ad-sourced records apart from organic and referral entries.
- Review counting behaviour and repeated uploads before calling a remainder unexplained.
As a hypothetical teaching illustration with invented figures, not a client outcome: a file logs 47 ad-recorded contacts in a month. Sales accepts 17 as qualified under a written definition, 12 dated inside that month and 5 in the following month, with 3 reaching order. Each total describes a separate stage, so none cancels another. When few contacts ever qualify, inspect query intent and landing-page fit before adjusting bids.
An export is only useful if the campaign structure behind it is sound — clean naming, one intent per campaign, and conversion tracking that matches how your business actually receives leads. If your reports are hard to read because the account structure is messy, or you want help turning exports into decisions, Guangsuan's Google Ads management service covers account structure, search terms, landing pages, conversion checks and reporting. Scope and fees sit in a contract, with no fixed enquiry promise. Details are on the Guangsuan Google Ads management service page.
FAQ
Click time or conversion time for month end? Use the rule that answers the question and keep it identical on both sides, with window and account zone filed with the extract.
Does a file that opens cleanly join cleanly? No. Readable layout says nothing about grain, units, date rule, or which actions were summed.
Can a quiet term be absent rather than zero? Yes. Very quiet rows can drop from a filtered view, so confirm filters and grain before saying the term never matched.